View Accounts Receivable (A/R)

Go To User Guide - Accounts Receivable

Accounting>File>Accounts Receivable>View A/R

This options allows you to access an individual invoice for a selected receivable account. You can also view customer account activity.

When viewing All Account Activity, credit memos and add-ons are NOT displayed. As of the 08/03/11 revision of version 11, the all account activity option ages billed orders. Note that if undelivered orders (option 2 or option 3) are on the report, it does not age.

Field	Explanation
Report Type	Select one of the report types by clicking inside the circle. Partials refer to orders that have been partially billed.
First/Last Name	Leave blank for a list of ALL activity. First Name: Enter a first name or press F8 to access the customer list. Last Name: If exported from the customer list, the last name will be filled out. Otherwise, type in a last name.   Tip: The button to the right of the last name field can be toggled. Four Lines means that the search will look for names that are similar to what was entered. Use this if an exact spelling is not known. One Line means that the search will look for an exact match.
Start/End Date	Enter the starting and ending dates here. (This date represents the customer order date). If left as is, all records will be included in the process (of course, depending upon the other parameters set.)
Sub Sort	The View A/R is first sorted by customer name. Then, choose to sub-sort the list by Invoice #, Delivery Date or Order Date.
Print Options	Print Preview: Click in this box to view the report on-line. Print Lines: this option will display the customer order lines. Print Receipts: this option will display any payments or discounts to the order. Print Additional Information: this option will display entries in the User Defined field from the customer order (the field directly below the Estimated Delivery Date field)
Output CSV	When sending this report to .csv file and including the lines and receipts, the data could be confusing.  Now rows pertaining to the header are marked as 1, lines as 2 and reports as 3 in the last column.  In addition, the invoice total information is included with the header information while the line and receipt rows have zeros in the Total Charges, Total Credits, and Balances columns. In the example below several columns have been hidden. The additional information from invoice headers is now sent to the .csv file

Report Example

  Note: The report Invoiced but not delivered

This option will list all customer orders which have been invoiced but not job costed.

Customer orders are invoices by printing an acknowledgement and entering an invoice date on the printing options screen. Each time this is done, the number of times an invoice has been printed will be updated. 

List of CSV Output

Invoice Number

Order Date

Delivery Date - the delivery date entered at job cost.

Invoice Amount -the total charges for the order.

Total Charges - the total that has been billed.

Total Credits - the total of payments and discounts applied to the order.

Current A/R - the current total for accounts receivable

Balance - the balance on the order

Days to Pay - the number of days the order remained unpaid.

Aging - 0 to over 90

Ship to Name

Ship to Address #1