The Customer Balances report, run as a text file, creates a tab-delimited file including Regular Balance, Prepay Balance, and Unapplied Cash Balance by Customer.
Setup
At Accounting / Accounting Reports / A/R Status Reports select Customer Balances.
In the Report Criteria section, Select Customers by choosing Select or use the Classifications button. Set the Select Style to Current Balances. Select the Text File option and in the File Name field enter the file path location to save the document. Select OK.
The tab-delimited file created includes the Regular Balance, Prepay Balance, and Unapplied Cash Balance for each selected Customer. This file can also be generated from AgvAgent.
