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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Fixed Assets posting t...
Small and medium business | Business Central, N...
Suggested Answer

Fixed Assets posting to general ledger

(0) ShareShare
ReportReport
Posted on by mscalamogna 80

Hi, I am trying to configure Business Central to post depreciation entries in summary rather than in detail. Is anyone aware of a way to do that? For example, if I have 1000 assets when I run depreciation it posts an entry with 2 lines for each asset. Is there a way to summarize the posting so that it only posts one entry per FA posting group?

I have the same question (0)
  • rrrgcx Profile Picture
    rrrgcx 5 on at

    I ran into the same issue, apparently detail posting is the only way.

  • Amy Thomas Profile Picture
    Amy Thomas 10 on at

    I am also calculating depreciation to post to General Ledger, but the journal entry created for the general ledger provides depreciation for each fixed asset.  I have 43,000 fixed assets so the journal entry is too many lines of detail for the general ledger.  How do I prepare only a summarized journal entry for the general ledger.  I realize the fixed asset system needs to depreciate each asset, but the general ledger does not need all that detail. 

    Would like to summarize the journal entry for the general ledger to one journal entry line for each depreciation expense account and accumulated depreciation account that I have on the general ledger.

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

    You do have to post 43000 fixed asset entries which makes 43000 entries to accumulated depreciation. However, if you do now choose to insert the Balance Account (expense account), the journal will be created but is out of balance. Then you can filter by FA posting group and manually insert a new line to the appropriate GL account for the amount of those lines and repeat until all depreciation expense accounts have been handled. I've seen others export the journal to excel, run a pivot and enter the few depreciation expense accounts and their amounts manually. One final option is to calculate for one fa posting group, add your gl account line to the journal and repeat through all of your fa posting groups.

  • Amy Thomas Profile Picture
    Amy Thomas 10 on at

    How do I add the depreciation expense to the journal entry??  The depreciation  journal entry requires a fixed asset number and a Book.

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

    I take the journal lines to Excel, sort by FA Posting Group. Then run a Pivot table subtotal by FA Posting Group. I then have to get the Depreciation expense from the FA Posting Group setup.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,151

#2
Jainam M. Kothari Profile Picture

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

#3
YUN ZHU Profile Picture

YUN ZHU 1,092 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans