News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Inventory value discre...

Microsoft Dynamics AX (Archived)

Inventory value discrepancy

(0) Share

Report

Report

Posted on by sri17

340

Hi All ,

AX 2012 R3 .

Business user runs standard inventory value report for the month of Feb ,2019 as cited below .

Selected Report Id - Invdetails

From date - Blank

To date - 2/28/2019 and right side no values are selected in any filed.

Post run the report , there is some value against discrepancy field ( this is not actual output ,but similar issue in client environment)

3122.Inventory-value.JPG

Could i know how to identify exact root cause of the issue ?

Thanks for looking into this.

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Inventory value discrepancy

Hi,

The financial amount of $29050 in inventory seems to be made up of the transactions posted on accounts 140211, 140231 and 140251.

This leaves the $400 on account 140221 and the -$550 in the inventory transactions.

Can you check whether all transactions for those items are properly posted, meaning that the transactions have been transferred to the GL and are not included in the subledger voucher not yet transferred form?

In addition, check account 140221 to verify that no manual postings have been made against this account.

What you should check in addition is that there is no ledger account that you missed in the selection of the total account that summarizes the balance at the end of your report.

Best regards,

Ludwig

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans