RE: Inventory stock balance
Thank you Richard & Mahmoud,
One supplementary question how does the inventory balance get zeroed out where the historical table show a balance. Would it be due selecting options to remove historical transaction transaction during year end close ?
select itemnmbr, LOCNCODE,BINNMBR ,QTYONHND,ATYALLOC from iv00102 where itemnmbr='itemnumber'
-- Qtyonhnd is zero
select SUM(trxqty) from IV30300 where ITEMNMBR = 'itemnumber'
-- trxqty sum is not zero
Inventory inquiry screen report balance as zero
Inventory activity report report do list all activity on iv30300
And the inventory status report the extended amount is zero and extended quantity is zero.
Thanks again!
Sanjay