Printing the A/R Customer Transactions Report

The Customer Transactions report lists transactions that were posted to customer accounts during the period you specify when you print the report. You can order the transactions by document date, by document number, or by fiscal year and period. Use this report to obtain an overview of the current status of your customer accounts.

To print the A/R Customer Transactions report:

1. Open Accounts Receivable > A/R Transaction Reports > Customer Transactions.
2. On the A/R Customer Transactions Report screen for Report Type, select whether to list customer transactions by document date, by document number, or by fiscal year and period.
3. Specify the range of transactions to include on the report. More...
   • If you selected to list transactions by document or document number, specify the start date for From Document Date and the end date for To.
   • If you selected to list transactions by fiscal year and period, specify the starting year and period for From Year/Period and the ending year and period for To. Documents entered and posted before or after the year and period range do not appear on the report
4. Select the customers to include on the report. More...
   1. For Account Type, choose whether you want to include all types of customers, only Open Item customers, or only Balance Forward customers.
   2. In the Select Customers By table, you can choose one to four selection criteria to limit the customers included on the report.

      For the first selection, choose from Customer Number, National Account, Customer Group, Billing Cycle, and Short Name. For the remaining three selection criteria, you can also choose additional fields to limit the customers.

      You can then specify the range for each of the selection criteria that you choose.

      If you do not choose any selection criteria, the report includes all customers with the account type you select.

5. Select the order to list customers on the report. More...

   1. In the Sort Customers By table, you can choose one to four sort orders. For the first selection, choose from National Account, Customer Group, Billing Cycle, Short Name, Account Set, and Territory. For the remaining three sort orders, you can also choose additional fields to sort the customers.

      If you do not select a sort order, the report sorts by customer number.

   2. For each sort order, you can also select the Title option (to include titles for each sorted group) and the Total option (to include subtotals for each sorted group).
6. For Select Transaction Types, select one or more transaction types to include on the report. The choices are Invoice, Debit Note, Credit Note, Interest, Unapplied Cash, Prepayment, Receipt, and Refund.
7. If you want to group transactions by type for each customer, select the Sort Transactions By Transaction Type option.
8. In the Include and Show areas, select any additional information to include on the report. More...
   • Contact/Phone/Credit Limit. Select this option to include the contact person, phone number, and credit limit for each customer.
   • Space for Comments. Select this option to leave a blank space at the end of each customer listing for your comments.
   • Customers with a Zero Balance. Select this option to include customers whose accounts have a zero balance. This can be used to find customer accounts that are dormant. Note that an account could have a zero balance and still have outstanding transactions (such as an offsetting invoice and credit note).
   • Totals by Transaction Type. Select this option to include a subtotal for each transaction type (invoices, debit notes, credit notes, interest, unapplied cash, prepayments) after the listing for each customer.
   • Applied Details. Select this option to include all the documents (such as receipts and credit notes) applied to each reported invoice. If you do not select this option, the report shows only the balance owing for each document.
   • Fully Paid Transactions. Select this option to include documents that are fully paid, but not yet cleared from Accounts Receivable.
9. If you use multicurrency accounting, use the Print Amounts In field to select whether to show transaction amounts in the customer currency or the functional currency.
10. Click Print.

    The report appears in a new Sage 300 window. You can print the report or export it to a file.

Last published: 4/8/2016