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

Announcements

Introducing our New Video Series: Community Spotlight
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... / INVENTORY TO G/L RECON...
Small and medium business | Business Central, N...
Suggested Answer

INVENTORY TO G/L RECONCILIATION

(1) ShareShare
ReportReport
Posted on by MD-01071455-0 171
Hi community, 
I'm facing an issue while reconciling Inventory with G/L account.
When I export value entries and sum cost posted to G/L its matching to G/L account on chart of accounts. But when I Run Inventory to G/L Reconcile Report its shows a difference. Can anyone help me to overcome from this issue.
 
Please find the screenshot.
 
VALUE ENTRIES
 
2. G/L Account
 
3. Inventory G/L Reconcile Report
 
 
Thanks in advance
Categories:
Dynamics 365 Business Central
Microsoft Dynamics NAV
I have the same question (0)
  • Suggested answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 18,152 Super User 2026 Season 1 on at
    Hello,
    Based on your screenshots, I would first make sure you are comparing the same posting date, item, and location filters, then run Adjust Cost - Item Entries followed by Post Inventory Cost to G/L before rerunning the report. Also, don’t rely only on summing Cost Posted to G/L from all Value Entries, because the reconciliation report separates invoiced, expected, interim, and WIP costs and maps them to the relevant inventory-related G/L accounts. In your screenshot, the report shows 414,036.85 as invoiced value posted to G/L and 475,630.51 as expected cost still to be posted, so I would drill down from the reconciliation amount and compare those underlying entries with the G/L entries to identify the exact difference.
    Regards,
    Oussama Sabbouh
  • MD-01071455-0 Profile Picture
    MD-01071455-0 171 on at
    OussamaSabbouh, I did checked all things. Please not that we are using FIFO method. Checked all the filters and calculated expected receipt and shipments both but not matched. Is there any other report which can match to COA.

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 649 Super User 2026 Season 1

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 447 Most Valuable Professional

#3
YUN ZHU Profile Picture

YUN ZHU 388 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans