web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Inaccurate Depreciation Calculations

(0) ShareShare
ReportReport
Posted on by 3,510

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

I have the same question (0)
  • Suggested answer
    Alessandro Vannini 1 Profile Picture
    on at

    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

  • Suggested answer
    Dallefeld Profile Picture
    211 User Group Leader on at

    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....

  • john.ellis Profile Picture
    3,510 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,785

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,007 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 948 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans