Hi
I hope to any help here.. I need to Retrieve data from 2 different table and put it in same row..
GL Code Description Qty part No Supplier
( from GL entry) GL Entry (from Payables Posted invoice line) GL Entry Payables PI Header
Hmm.. Any suggestion highly appreciated.
Date
Votes
3 comments
-
Jet Reports Historic Posts How you would do this depends on the data. Payables Posted Invoice Line is not a standard table in Nav or I could tell you more exactly. So first you need to know, are there multiple records in Payables Posted Invoice Line that you want to see for each record in the G/L Entry or is there only 1 record in Payables Posted Invoice Line for each G/L Entry? The other thing we need to know is how the 2 tables are related. For example, does the Payables Posted Invoice Line have a field such as "G/L Entry No." which is the same as the No. field on the G/L Entry table?
Regards,
Hughes -
Jet Reports Historic Posts most of my fields can be found in gl entry table except 3 fields are in Purchase Invoice Line Table.
Document No field are probably the primary key to link both table. -
Jet Reports Historic Posts You may have another way to second table but you need to verify it . Transaction number in Navision appears to be a common field between source ( at least the journals) and GL You may also want to look at Detail Vendor Ledger Entry Ledger as Second Table rather than Invoice Lines
Please sign in to leave a comment.