Skip to main content
Business Central forum
Suggested answer

Inaccurate Depreciation Calculations

editSubscribe (0) ShareShare
ReportReport
Posted on by 3,476

Hi:

We were testing Calculate Depreciation for each month in the first half of 2022 and comparing with depreciation calculations in a spreadsheet that show what amounts should result.

For January and February, we thought that depreciation figures from BC "tied" with those in the spreadsheet.  But, then, we saw that one of the FA Posting Groups had been coded to an amortization account rather than a depreciation account.

So, I adjusted that Posting Group to post to the correct depreciation account.

Then, we ran Calculate Depreciation for March.  It still posted some depreciation to the wrong account (i.e., the amortization account)!!!

We closed out, came back in, and ran depreciation for April.  Then, depreciation posted to the proper account and not to amortization.

But, we then found that depreciation figures for each group were off from those of the spreadsheet.

This inaccuracy continued to get worse, when we kept running Calculate Depreciation for subsequent months.

Again, aside from finding that some depreciation in BC contained amortization due to wrong FA Posting Group coding, depreciation was accurate in the beginning.  It just somehow got worse.

Some assets have many decimal places for years of life, while others have no decimal places.

Could that be causing the wild discrepancies?  Is there a fix?

Thanks!

John

  • john.ellis Profile Picture
    john.ellis 3,476 on at
    RE: Inaccurate Depreciation Calculations

    Hi Kim:

    This is testing.  So, it's okay.

    I'm trying to figure out why depreciation got "more off" as "time went on" (i.e., as an additional month of depreciation was run).

    Any ideas?

    John

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,415 UG Leader on at
    RE: Inaccurate Depreciation Calculations

    John, the depreciation calculation is not  based on your fa posting group. What depreciation method are you using?

    I do agreed that you need to cancel the previously posted depreciation entries and redo....suggest checking the entries before you post....

  • Suggested answer
    RE: Inaccurate Depreciation Calculations

    Hello John

    you need to cancel the wrong entries and recreate again with the correct account.

    If you still have a problem with decimal, is better report a support case because we had an issue with it in the past and we have a PTE to correct wrong decimals

    Hope this helps

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Sundar…

Industry experts answer burning questions directly from our amazing Community…

Enabling Copilot Case and Conversation…

Agents can easily recap an ongoing chat, transcribe a voice conversation…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 282,978 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans