A/R Collections Report

Go To User Guide - Accounts Receivable

Accounting>File>Accounts Receivable>A/R Collections Report

This report allows viewing accounts receivable records yet to be paid.  The system does not consider a customer order a receivable until it has been job costed.

Field	Explanation
Report Type	Select the appropriate Report Type.  Choose Delivered Invoices with Balance, Un-Delivered Invoices, Both Delivered and Un-delivered Invoices, All Account Activity, and All Delivered Invoices.
Parameters	Select a specific customer to run this report for or by leaving this parameter blank, this report will list Accounts Receivable for all customers.
Start Date and End Date	Select the Start Date and End Date for the report.
Sub Sort	Select to sub sort this report by Invoice #, Del. Date and Order Date.  The primary method used on this report for sorting is by Customer.
Print Preview	This selection allows previewing of the report before printing.
Output to CSV	Select this option to export this report to a .csv file for viewing in Excel.  Enter the appropriate path in the field provided otherwise this report to be sent to the RFMS directory.  If using Bill Qty in Order Entry, this will be the value used on the printed report. Both the actual and Bill Qty will be shown on the .csv output.
Print Lines	Selecting this option prints the corresponding Customer Order Lines
Print No Balance Invoices	This selection includes Invoices that have no balances.
Print Additional Info	With this option selected anything in the Job Number field (on the Customer Order) will display on this report.

List of CSV Output

Customer Name

Telephone

Invoice

Order Date

Del Date (Bill Date)

Total Charges

Total Credits

Balance

Days to Pay

0 - 30 Days

31 - 60 Days

61 - 90 Days

Over 90 Days

Ship to Name

Ship to Address

LIne Number

PC

Inv Number

 Style Item

Color Desc

Serial Num

Width

Qty

Unit

Price

Line Total

Status

Store

Sales Rep

Bill Qty

Invoice Total

Fin Charge

Payment

Discount

Job Number