kmalone 1/15/2014 6:25:12 PM

Inventory Transactions link to G/L transactions

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...





Version: GP 10
Section: Microsoft Access

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables