Hi Pioneers,
Actually I am making a report on Inventory for all Incoming materials(Not outgoing), strictly. Which table should I prefer ???
Hi Sudhanshu,
In order to track all the incoming materials you can use inventtrans table where status receipt is Purchasedor Received and TransType is Purch or Production.
Hi Sudhansu,
Consider Inventtrans table with status receipt as Received / Purchased…
and status issue as received/ purchased…
and consider the posting type(reference category) in Inventtransorigin table as Inventtransaction, Purch, sales, Production, etc…
based on the recid relation between inventtrans and inventtransorigin tables(In 2012)…
Inventtrans table is considered in 2009…(based on Inventtrans type)