I am trying to tie invenotry transaction to a G/L transactions to explain variances in different accounts. I want to be able to explain each entry by the items that are causing the entry. I have pulled data from IV10201 table and IV30301 table. I can link IV30301 to the G/L. But I can't seem to link IV10201 to IV30301 on a logical manner to figure out the part number for the transaction... I thought I could use ORIGINDOCID and LNSEQNBR to link IV10201 and IV30301... but I must be missing a logical piece to the puzzle...
thanks
KM