Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / Discrepancy from inven...
Business Central forum
Suggested answer

Discrepancy from inventory valuation and report came from Item ledger entries

(0) ShareShare
ReportReport
Posted on by Ammar Othman 18
Hello Everyone,
I just make a report out of item ledger entries to see my quantity from different entry type I can see some discripency in the beginning balance between inventory valuation and a customize report from item ledger entries by the way we used average cost for inventory valuation and automatic cost adjustment.
Any suggestion about that
Categories:
Inventory and warehouse management
  • Suggested answer
    Yi Yong Profile Picture
    Yi Yong 275 on at
    Discrepancy from inventory valuation and report came from Item ledger entries
    Hello Ammar,
     
    You are using the wrong table.
    The Quantity and Value from Inventory Valuation are calculated from the Value Entry table instead of the Item Ledger Entry table.
     
    Item Ledger Entry table cost and quantity are not backdated, they are always up-to-date.
    For example, the 'Remaining Quantity' on the Item Ledger Entry is the current remaining quantity even with posting date filter.
     
    While the Inventory Valuation report will show you the exact remaining quantity based on the date filter.
     
  • Valentin Castravet Profile Picture
    Valentin Castravet 7,256 Super User on at
    Discrepancy from inventory valuation and report came from Item ledger entries
    If its a custom report then I would first ensure its calculating the balance correctly. Reason being that both the custom report and the inventory valuation report are getting the data from the same source. 
     

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans