5
Hi, I am trying to generate stock level report whereby to present Item group, location(site), onhand qty and onhand value. With TSQL I have done I ma getting correct onhand qty but onhand value mismatch with AX onhand report even inventroy againg report.
In TSQL you need to remember to filter by DataAreaId, otherwise you will get data from all companies. Other than that, it could be helpful if you shared some details about your situation (code, data, output…) so that we can look into it. Thanks!
#1
André Arnaud de Cal...
293,027
Super User 2025 Season 1
#2
Martin Dráb
231,852
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
