Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Reconciling Physical I...
Finance | Project Operations, Human Resources, ...
Suggested answer

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

(0) ShareShare
ReportReport
Posted on by Hendo 584

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 18 Moderator 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 

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

News and Announcements

Check out the New Agent Creator Community

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 601 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 416

#3
Adis Profile Picture

Adis 384 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans