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

General Ledger Post in Summary when posting from inventory

(0) ShareShare
ReportReport
Posted on by 80

Every time an item transaction is posted to the General ledger from Inventory, the system creates an entry for every item.  For example, if someone posts a receipt of 10 items, the system will assign one entry for each item (10 General Ledger) transactions instead of one summary transaction.  This makes the GL vast and unable to review the detailed trial balance.  Is there a setting that needs to be changed to have these entries posted in summary to the general ledger? 

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    133 on at

    Turn off automatic cost posting in the inventory setup. Move to using the post inventory cost to g/l report. You can group transactions by posting group. No other summary option is provided as standard.

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

    You can do as Josh suggests but understand the ramifications. You will not have cost of goods posted for sales, amounts applied to inventory for purchases, etc until you run the Adjust Cost with Post Cost turned on. And if you group transactions, you will not be able to use Find Entries to see the cost of sales, inventory applications against a specific document.

    Best practices says let the entries post for most research and detail flexibility. We also don't see Detail Trial Balances printed that much anymore....remember you could filter out COGS, Inventory, Purchases and other accounts where there are large amounts of inventory transactions when running your Detail Trial Balance.

  • Community Member Profile Picture
    on at

    Hello. Yes, today there is an acute problem with the provision of network networks. I am a teacher at the University of Michigan, and I understand this like no one else. The students and I today created the best database of essay examples here: https://studyhippo.com/. It was not an easy job, but the result will help students from all over the world. Come check out our work.

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 3,010

#2
Jainam M. Kothari Profile Picture

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

#3
YUN ZHU Profile Picture

YUN ZHU 1,085 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans