You’re offline. This is a read only version of the page.
Hey Everyone
Is there any SQL qeury
Complete inventory movement FY 2018 with below fields extracted from database ( with query used for extraction ) for assessment
*This post is locked for comments
we are using AX 2012 R3 cu9
Everything but the Opening balance and closing balances can be retrieved from InventTable joined to InventTrans. What version of AX are you on? If you are using 2012 R2 or later, the inventory value cube will provide everything you are asking for.
Hi geeirfan,
Query in sql:
select a.ItemId,a.DatePhysical,a.COSTAMOUNTPHYSICAL,a.DATEFINANCIAL,a.COSTAMOUNTPOSTED
,a.qty,
case when b.REFERENCECATEGORY='0' then 'salesr'
when b.REFERENCECATEGORY='3' then 'purchase'
when b.REFERENCECATEGORY='6' then 'Transfer'
else 'others' end as Type
from InventTrans a
left join InventTransOrigin b on a.itemid=b.itemid and a.InventTransOrigin=b.RecId
where a.DatePhysical between '2018-01-01 00:00:00.000' and '2018-12-31 00:00:00.000'
and a.itemid='*****' and a.DATAAREAid='******'
For the balance, you can use inventory values report in system.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (