News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Reconciling Physical I...

Finance | Project Operations, Human Resources, ...

Suggested answer

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

(0) Share

Report

Report

Posted on by Hendo

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

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

nunomaia 11 Moderator on at

Like (0)

Report

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

Leaderboard

#1

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2

Martin Dráb 231,305 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans