Using A/P 8.1C (100801)
Is there an option available in A/P to export vendor transactions, with G/L disbursement details? We were successful in exporting the "Print Vendor Tansactions" report to Excel but it is a visual duplicate of the print version and contains headers and blank rows.

Thanks
Karin

Hi Karin,

In order to get a simple exported Excel file with vendor transactions and associated GL Disbursement details, you would need to have Adagio GridView 9.0C and create a view that combines the Transactions and GL Disbursement files together, with the information you want. No composite tables have been created that combine these 2 files together, which is why that version of GridView is necessary, so you can combine them yourself.

The 'Export Transactions' function within Adagio Payables (the green 'X' button, available from the Transactions tab when editing or viewing a vendor) can export transactions to a simple Excel file as well, but only for a single vendor and not with the GL Disbursements, so this will not meet your requirements.

In the meantime, we'll try exporting the GL transactions and see if we can pull the A/P transactions only.

Not sure if it's worth the purchase of Gridview for this purpose alone. We'll look at Gridview's capabilities and determine if it's a tool we might benefit from...

Thanks
Karin

Hi Karin,

What question are you trying to answer? You can isolate the AP transaction in the GL by selecting transactions with a source code of "AP". You can likely create a Source Journal to list the transaction you need.

That's exactly what we ended up doing!
Thanks