30
Hey! I am new in Ax 2012 and I have to fulfill a task. I have to do a job where the info shows the products bought from vendor "x" using purchase order for a specific werehouse "X". Can you help me with the code please?
Hi,
You can start from the inventtrans table where all transaction are stored then you can fine-tune your request with inventtrans origin if you want to filter on specific Purchase orders. here is a simple example I hope it will help you.
Select il.INVENTLOCATIONID, it.ITEMID, it.QTY,it.STATUSRECEIPT from INVENTTRANS it
inner join INVENTDIM id on id.INVENTDIMID = it.INVENTDIMID
Inner join inventlocation il on il.INVENTLOCATIONID = id.INVENTLOCATIONID
where it.QTY > 0
Regards,
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (