Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Reconciling Physical Inventory (INVENTSUM) with Inventory transactions (INVENTTRANS)

Posted on by 582

Hi.  Our inventory value report for a product reveals a Inventory Quantity of 136.00 and yet the physical inventory from the INVENTSUM table is 83.00.  After some investigation we have discovered that the difference is in fact the picked quantity as found on the Physical Inventory by inventory dimension.   We did not expect this result as the general ledger inventory table is not impacted by picking.   Is this normal behaviour for AX 2012 R3, or is it perhaps driven by a parameter about which I'm not aware?   Cheers. James

Categories:
  • Suggested answer
    nunomaia Profile Picture
    nunomaia 10,684 Super User on at
    RE: Reconciling Physical Inventory (INVENTSUM) with Inventory transactions (INVENTTRANS)

    I don't have access to AX2012 environment, bu I will answer based on D365. Behavior of report is more less the same on both version

    You have :

    Inventory: Financial Quantity – The quantity that has been financially updated.

    Inventory: Physical Quantity Posted – The quantity that has been physical updated.

    Inventory: Quantity – The total quantity of all the quantity columns on the report.

    You are comparing values from column "Inventory: Quantity". That sums previous columns. You should be getting quantity on hand inventory from invent Sum, that are not yet  Financia posted. That is the case ?    

    pastedimage1668600609592v1.png 

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 . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans