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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

Cost posted to G/L in inventory valuation report

(0) ShareShare
ReportReport
Posted on by 287

What is the difference between value and cost posted to G/L value in inventory valuation report?

pastedimage1636436971623v1.png

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,165 Moderator on at

    To calculate the inventory value in the Inventory Valuation report, the report begins by calculating the value of the item’s inventory at a given starting date. It then adds the value of inventory increases and subtracts the value of inventory decreases up to a given ending date. The end result is the inventory value on the ending date. The report calculates these values by summing the values in the Cost Amount (Actual) field in the value entries, using the posting dates as filters.

    The printed report always shows actual amounts, that is, the cost of entries that have been posted as invoiced. The report will also print the expected cost of entries that have posted as received or shipped, if you select the Include Expected Cost field on the Options FastTab

  • Verified answer
    Community Member Profile Picture
    on at

    Nirmala,

    Adding to what NorthW replied... May I suggest running the Inventory to G/L Reconcile report. This is an easier report to show you the Starting Valuation (beginning of period), Received Not Invoice, Shipped Not Invoiced, Expected Cost entries, Crossfoot Total and compared to what has posted to the G/L. I have always taught my customer User to use this report. The report also denotes if Adjust Cost needs to be run for a specific item having entries NOT posted to the G/L.

    Thanks,

    Steve

  • Ginger Ai Profile Picture
    30 on at

    Hi Steve,

    I happened to search for a similar question about inventory valuation, and read this discussion thread. My question is: posted purchase receipt had $amount value for an inventory item, but in the "Inventory to G/l Reconciliation", "Received Not Invoiced" was $0. What could break the data flow from posted purchase receipt or GL "received not invoiced"  to "Inventory to G/L Reconciliation" ?

    Thanks,

    Ginger

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,926 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,158 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans