Dynamics Community Forum Thread Details

Fixed Asset -Skipped Depreciation

I have a site on GP2018 that somehow removed or deleted their February depreciation. It displays in the GL but does not show in the fixed asset module, yet somehow March depreciation is there. Per the customer any attempt to back out and recreate depreciation for the two periods.

I've been travelling, so I've not had a chance to review first hand. Any thoughts as to what may be happening? Please advise.

Categories:

Microsoft Dynamics GP

Hello LongtimeGPandSL.

My initial thought is someone entered the GL Portion of the Depreciation and why they are seeing it in the GL. However, it sounds like they have tried re-running the Depreciation but nothing happens so that makes my thought irrelevant as i would suspect it sees the Deprecation records in the FA00902.

With Fixed Assets, when you run Depreciation, it is going to look at the FA00902, to see if depreciation has been taken for this time frame you are running it for. If it hasn't, depreciation will be taken and the corresponding records will be created in the FA00902.

When you run the GL Posting Routine, this process will update the FA00902 to include the Batch Number that this was assigned to. It then creates a record in the FA00905 and FA01500 so the GL Posting Routine does not pick these records up again to push the to the General Ledger.

I would check the FA00902 for the asset in question and see if there is depreciation for that period. You can modify and use the script below.

select * from FA00902 where assetindex in (select assetindex from FA00100 where assetid = 'Enter asset id here') and fayear = 'enter fa year here' and faperiod = 'Enter Period here'

You would then want to look at the column GLINTBTCHNUM to see if this has been included in the GL Posting Routine for the period you are questioning. If it is populated, check the FA00905 and FA15000 to see if corresponding records exist.

select * from FA00905 where GLINTBTCHNUM = 'Bach NUmber from the FA00902'

select * from FA15000 where GLINTBTCHNUM = 'Bach NUmber from the FA00902'

If records exist for that period and Asset, this would be why the Depreciation process is not picking up the asset.

If you do not see any records in the FA00902, then this asset was not depreciated so there would be nothing to back out. However, it should still pick up depreciation. If its not, then you will need to investigate the Asset further to see if it has been fully depreciated.

These are hard to troubleshoot over a forum as we need to usually see the data to determine what the problem might be and how to correct it.

I hope the above is helpful.

Thank you!

Brandon Jarrett | Microsoft Support Engineer.

Quick Links

Leaderboard