GV based on AP9.3C

We need to report on AP Invoice Transactions, over several fiscal years.
We need to see:
• Vendor # & Name
• Inv # & Date
• Each Acct/Dept that was expensed, with the appropriate $ amts (may have more than one detailed line)
• Optional Text 1 (that is entered in the Header)

What Table(s) would I go to display this?

I tried using the A/P Transactions and the AP Transactions/Vendor tables.
But this only displays one row per Invoice and does not display the GL Distribution.

Hi Samuel,

The GL distributions are stored in the 'A/P G/L Disbursements' data file, and in GridView would be loaded with this table into a separate view from the A/P Transactions table.

If you require to combine this into a single window, you would have to first create the view on this GL Disbursements table (since it has multiple details for each invoice), and then use Calculated columns to read the other Invoice information from the Transactions file. The dictionaries are not configured to use the 'Use Related Data' feature, so you would need to create a second view on the AP Transactions table as part of a workspace. Then a Calculated Column in both views with the same Title (say "Trans ID"), and syntax to get unique transaction IDs (say appending the vendor #, Transaction type and Document number). Finally, one Calculated Column for each Transaction column must be created with a GetLinkedValue formula, referring back to the other Transaction View, and using your "Trans ID" column as the linking field.

Hi Samuel

Except for the Optional Text 1 field, that's a standard report - the Vendor Transactions report and it can be ExcelDirected.

In GridView, it's fairly complicated. You would need to use the G/L Disbursements table as the driving table, and bring in other fields as needed from the Vendor Master and Vendor Transactions tables.

If the Optional Text 1 field is at the vendor level and not the invoice level, you can more easily use the GL Posted Transactions table to drive the report, grabbing the vendor name and Optional Text 1 from the Vendor Master table.

If you need more direction, feel free to contact me directly.

Steve