Skip to main content



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

  • 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 ?    


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


André Arnaud de Calavon Profile Picture

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

Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans