Hi ,
During upload of the FA Master , do i need to fill the FA remaining service life also or system will update automatically ?
Can you guide me what are all the important fields for FA opening balnces ?
Please help me.
Any guidence from pioneers ?
Hi Ameen,
This depends on the requirement. You can fill the service life at the time of import or you can edit it after import. Service life is editable field.
FA opening typically depends on the approach. Generally FA opening balance is uploaded with historical value, means at the acquisition value of FA.
When you migrate FA, the most important data to import is value model and there itself all data related to depreciation lies.
I will suggest you to migrate one FA in test environment and check whether depreciation on future dates.
Pranav…
Hi Pranav,
I am asking about the fields in the value model.
Depreciation run date
Date the depreciation when last run
Depreciation period remining.
Do i need to fill the above fields during importing the Fixed assests or system would take automatically ?
Please suggest me.
Update these values in the import sheet.
Hi Ameen
You need to specify the service life while uploading the FA. The service life should be calculated as the calendar attached to the Value model. Say, the calendar is in Days, then you have to calculate the service life in days. (make the adjustments for leap year.)
For uploading the Assets - upload master to Assettable, Value model to AssetBook, then upload 2 journals for acquisition and accumulated depreciation to LedgerjournalTable and LedgerJournalTrans. To do this, you can create excel import templates.
Regards
Priyanka
The system will not be updating these fields, but you will have to upload.
Thanks alot priyanka,
you saved me alot .
I am getting confuse about the field Depreciation period remaining ?
Can you guide how to calucate that field value during importing ?
Lets take an example -
Asset was acquired on 1 Jan 2012, asset life is defined in days, for one year. Therefore the total Depreciation period is 365. Now lets say you are uploading the asset balance as on 31st Jan 2012. Then totat depreciation period is 365. Depreciation period remaining is 334 (365-31).
I prefere taking asset calendar in days, otherwise the system calculates the depreciation as 30 days a month. In month of Feb you will have less depreciation and in Jan more, so better define it as days and calculate for month.
Thanx for your answers,
Can you suggest me the best method to define the asset service life either year or days ?
AX would stop calculating depreciation (if NBV -ve is disabled). So why update Remaining Life ?
Will just uploading the GBV & Acc. Depreciation not work.
Regards,
ST
That depends on the method of Depreciation. In case of “Straight line service life” method, you need to define the total service life and service life remaining.
Regards
Thanks Priyanka ,
My customer FA Dep Method is straight line service life only . what my question is do i need to define the service life in years or days ?
which is the best method ?
I define the service life in years; total depreciation period and depreciation period remaining in days. As already said, I was facing this issue in case of service life method, where the depreciation was calculated for 30 days if I select the calendar in months. (The asset calendar period is taken for calculating the depreciation.)
I suggest, you setup one asset in TEST > define the necessory fields for depreciation calculation (like dep periods, dep convention, Last dep date) > Run the depreciation > check the value > then upload assets.
Hi Priyanka,
What i have understood from your post is
Service life - Define in years
total depreciation period and depreciation period remaining in days.
Asset Calender also need to be define in Days .
( In AX 2012 , we have
a) Fiscal calender
b) Fiscal year , which option i need to define in days and which option i need to attach to value model.
Please correct me if i am wrong .