Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
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