Export Cash Batch Details

Is there a way to export the details of a cash batch? We have cash batches in AR used to do match ups that may have 100 or so invoices matched up to a payment. The window to view these match up details in AR shows 3 lines at a time with scrolling. We need this data in Excel to resolve a discrepancy. Unfortunately there is no Excel direct link icon. Is there a Gridview that I can create to provide these details? Or some other export function?

Hi Susan:

Yes, that window is small, not re-sizable and not ExcelDirect-able.

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).

Hi Susan

One warning about 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.

Steve

Thanks for the help!