Adagio Tip Of The Month: Exporting Cash Batch Details

Jul 15, 2019

Question: Is there a way to export the details of a cash batch?

We have cash batches with payments in Receivables matched up to 100 or more invoices. The window to view these match up details in Receivables shows only 3 lines at a time with scrolling. We need this data in Excel to resolve a discrepancy. Unfortunately there is no ExcelDirect link icon. Is there a GridView that I can create to provide these details? Or can I use some other export function?

Answer: Yes. The table you are looking for with GridView is called “A/R Transaction Matching File”. It is the cross-reference to indicate the link where a transaction is applied against another (or others).

Note: when you are using the AR Transaction Matching File (or the AR Cash Posting Journal file, which is another possibility) it won’t include unapplied cash on the report.

This tip was inspired by a posting on the Softrak Technical Support Forum, where registered Adagio Accounting users can post questions to get answered by Softrak, members of the Adagio Consultant community, and fellow Adagio Accounting users. Be sure to check it out!