Hi,
I have come across a weird issue where for some non tracked materials are oversold in cost layers i.e. sold quantity is issue layer( table IV10201) is more than sold quantity and receipt quantity in receipt layer (table IV10200) for same receipt sequence number.
Join of tables : IV10200 - columns [ITEMNMBR], [TRXLOCTN], [RCTSEQNM] join with IV2010 columns [ITEMNMBR], [TRXLOCTN], [SRCRCTSEQNM].
Due to this, if I validate Purchase receipt inquiry screen for the item and try to calculate on hand from Total Received - total sold then it does not get matched with actual on hand on item maintenance.
Please help me what is the best way to correct this. I though of one solution - to run inventory reconcile first for the item, then make a negative adjustment with the variance generated from cost layer (Difference of total sold qty from issue layer-total receipt qty from receipt layer) for that item but doubtful to do this.
*This post is locked for comments
I have the same question (0)
