News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Unable to get Correct ...

Microsoft Dynamics AX (Archived)

Unable to get Correct OnHand Inventory through x++

(0) Share

Report

Report

Posted on by Sachin Sharma

10

Hi Experts,

While trying to get OnHand inventory through X++ code, it shows historic values, not the updated value.

e.g. When we are looking for specific Item and DimID, in Form or Table Browser it shows 100, but when I am running Inventsum::Find(itemid, Dimid) it always show 99.

Any help appreciated.

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

guk1964 10,877 on at

Like (0)

Report

RE: Unable to get Correct OnHand Inventory through x++

Inventory management -> Reports -> Physical inventory -> Physical inventory by inventory dimension.

You could use this report or the code logic behind it.

You can also query with SQL
Suggested answer

Moeen Ahmed Sultan 1,402 on at

Like (1)

Report

RE: Unable to get Correct OnHand Inventory through x++

Hi,

To get on hand inventory (quantity) of an item using x++, please read this blog post: msdynamics.nevoitech.com/.../

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans