Technical Tutorials on MS Dynamics Axapta 2012,D365 FnO

This video clip will show you how to Create Simple View In Ax 2012 using multiple tables. In this clip I shown  example of table inventtrans and Inventtransorigin . Mostly people face how to get all inventory transaction order wise like sales order,purchase order,production order etc . Then you can follow steps shown in clip to get all details.

If you want to get total of reserved quantity Sales line wise then you can do the following way. First you need to create view as per below picture. Then you can try below code in job to get reserved quantity for sales line item. GOD_InventTransView GOD_InventTransView; select sum(Qty) from GOD_InventTransView where GOD_InventTransView.ReferenceId==_salesline1.SalesId && GOD_InventTransView.ItemId==_salesline1.ItemId && GOD_InventTransView.InventTransId==_salesline1.InventTransId && GOD_InventTransView.StatusIssue == StatusIssue::ReservPhysical;