Menu Path: Credit and Collections Collection Processing Customer Open Accounts Receivable Management
Manage and view open accounts receivable transactions.
Use Customer Open Accounts Receivable Management to display open receivable transaction detail for a specific billing customer, credit customer, paying customer, or sales representative. You can then mark transactions as disputed, mark reminder invoices as done, or create collection tasks for transactions.
For database information for this window, see Customer Open Accounts Receivable Management Database Information.
Button |
Description |
Exit |
Click this button to close the Customer Open Accounts Receivable Management window. |
Show Data |
Click this button to display open accounts receivable items on the Results tab based on the selected criteria on the Select tab. |
|
Click this button to display, email, or print the transaction, statement, collection letter, or reminder letter based on the selected Processing Options radio button. If you select the Transactions, Collection Letter, or Reminders radio button on the Results tab, processing is only performed for transactions for which the check box in the Print column is selected in the Transactions grid. If you select the Statement radio button on the Results tab, click this button to display Collection Statement Print, which allows you to output collection statements. Note You cannot print an imported invoice or memo. |
Select All |
Click this button to select the check box in the Print column for all transactions displayed on the Results tab. This button is only available if the Results tab is displayed. |
Deselect All |
Click this button to clear the check box in the Print column for all transactions displayed on the Results tab. This button is only available if the Results tab is displayed. |
Detailed Analysis |
Click this button to display A/R Average/Weighted Average Days to Pay/Past Due for Last 24 Periods, which allows you to view historical payment statistic information for the past 2 years. This button is only available if you select the Billing, Credit, or Paying radio button. |
Payment History |
Click this button to display Customer Payment History Inquiry, which allows you to view payments made by a paying customer. This button is only available if you select the Billing, Credit, or Paying radio button. |
Audit Trail |
Click this button to display Invoice Payment Audit Trail Inquiry, which allows you to view the audit trail of a specific invoice or other transaction. |
Related Orders |
Click this button to display Order Relationship Inquiry, which allows you to view orders related to a specific invoice. This button is only enabled if the selected transaction is associated with at least one order. |
Customer Prepayment Entry |
Click this button to display Customer Prepayment Entry, which allows you to view and edit orders associated with a selected prepayment. This button is only available if you select a prepayment transaction. |
Contacts |
Click this button to display Contacts, which allows you to view the customer contacts you are allowed to view for the selected customer. This button is only available if you select the Billing, Credit, or Paying radio button. |
Customer |
Click this button to display Customer Maintenance, which allows you to define customers and qualified prospects. This button is only available if you select the Billing, Credit, or Paying radio button. Note If you are not authorized to use Customer Maintenance, the Customer Inquiry window appears instead, and allows you to view information for the customer. |
Customer Notes |
Click this button to display Notes Entry, which allows you to view notes for a customer entered in the Customer Code field on the Select tab. This button is only available if the Billing, Credit, or Paying radio button is selected in the Customer Type radio set. The icon for this button includes a check mark if notes exist for the selected customer. |
Attachments |
Click this button to display Attachment Entry, which allows you to view and enter attachments for a selected open item. |
Notes |
Click this button to display Notes Entry, which allows you to view and enter notes for a selected open item. |
Remarks |
Click this button to display Customer Standard Remark Maintenance, which allows you to enter remarks for a selected chargeback or non-sufficient funds (NSF) transaction. Printable remarks can be added to chargebacks or NSF invoices so that customers can see a full explanation when these are printed out. You cannot enter remarks for other accounts receivable transaction types. |
Button |
Description |
Modify My Additional Filters |
Click this button to display Screen Additional Filters Maintenance, which allows you to set up additional filters for the Customer Open Accounts Receivable Management window. |
Field or Button |
Description |
Select whether to display accounts receivable transactions for a billing customer, credit customer, paying customer, or sales representative. For information on the functions of each type of customer, see Structure and Concepts. Note If you select the Billing or Paying radio button, accounts receivable transactions for the selected billing or paying customer are displayed. If you select Credit, accounts receivable transactions for every billing customer currently associated with the selected credit customer are displayed. |
|
All Billing Customers/All Credit Customers/All Paying Customers |
Select this check box to display accounts receivable transactions for all billing, credit, or paying customers. This check box is cleared by default, and only available if you select the Billing, Credit, or Paying radio button. |
Enter a customer code for which to display accounts receivable transactions, or click the Lookup button to select a customer code. Note The Lookup window displays both active and inactive customer. |
|
Enter a customer name for which to display accounts receivable transactions, or click the Lookup button to select a customer code. Note The Lookup window displays both active and inactive customer. |
|
Enter the user ID of a sales representative for which you want to display accounts receivable transactions, or click the Lookup button to select a user ID. This field is only available if you select the Sales Representative radio button. |
|
Select this check box to display accounts receivable transactions for all reference numbers. This check box is selected by default. |
|
Enter a reference number for which to display accounts receivable transactions, or click the Lookup button to select a reference number. If you want to display accounts receivable transactions for a range of reference numbers, enter the first reference number in the range. This field is only enabled if you clear the All Reference #s check box. |
|
Enter the last reference number in a range of reference numbers for which to display accounts receivable transactions, or click the Lookup button to select a reference number. If you want to display accounts receivable transactions for a single reference number, you can leave this field blank. This field is only enabled if you clear the All Reference #s check box. |
|
Enter a currency for amounts in the inquiry, or click the Lookup button to select a currency. This defaults to the default general ledger currency. |
|
Select this check box to display accounts receivable transactions for all reference dates on the report. This check box is selected by default. |
|
Enter a reference date for which to display accounts receivable transactions, or click the drop-down arrow to select a reference date. If you want to display accounts receivable transactions for a range of reference dates, enter the first reference date in the range. This field is only enabled if you clear the All Reference Dates check box. |
|
Enter the last reference date in a range of reference dates for which to display accounts receivable transactions, or click the drop-down arrow to select a reference date. If you want to display accounts receivable transactions for a single reference date, you can leave this field blank. This field is only enabled if you clear the All Reference Dates check box. |
|
Select whether to display open, closed, or both open and closed accounts receivable transactions. |
|
Select this check box to display accounts receivable transactions for all due dates. This check box is selected by default. |
|
Enter a due date for which to display accounts receivable transactions, or click the drop-down arrow to select a due date. If you want to display accounts receivable transactions for a range of due dates, enter the first due date in the range. This field is only enabled if you clear the All Due Dates check box. |
|
Enter the last due date in a range of due dates for which to display accounts receivable transactions, or click the drop-down arrow to select a due date. If you want to display accounts receivable transactions for a single due date, you can leave this field blank. This field is only enabled if you clear the All Due Dates check box. |
|
Select this check box to display accounts receivable transactions for all chargeback reminder dates. This check box is selected by default. |
|
Enter a chargeback reminder date for which to display accounts receivable transactions, or click the drop-down arrow to select a chargeback reminder date. If you want to display accounts receivable transactions for a range of chargeback reminder dates, enter the first chargeback reminder date in the range. This field is only enabled if you clear the All Reminder Dates check box. |
|
Enter the last chargeback reminder date in a range of chargeback reminder dates for which to display accounts receivable transactions, or click the drop-down arrow to select a chargeback reminder date. If you want to display accounts receivable transactions for a single reminder date, you can leave this field blank. This field is only enabled if you clear the All Reminder Dates check box. |
|
Select this check box to display accounts receivable transactions for all customer purchase order numbers. This check box is selected by default. |
|
Enter a customer purchase order number for which to display accounts receivable transactions, or click the Lookup button to select a customer purchase order number. If you want to display accounts receivable transactions for a range of customer purchase order numbers, enter the first customer purchase order number in the range. This field is only enabled if you clear the All Customer POs check box. |
|
Enter the last customer purchase order number in a range of customer purchase order numbers for which to display accounts receivable transactions. If you want to display accounts receivable transactions for a single customer purchase order number, you can leave this field blank. This field is only enabled if you clear the All Customer POs check box. |
|
Select this check box to display accounts receivable transactions of all transaction types. This check box is selected by default. |
|
Select this check box to display invoice transactions. This check box is cleared by default, and is only enabled if you clear the All Reference Types check box. |
|
Select this check box to display finance charge transactions. This check box is cleared by default, and is only enabled if you clear the All Reference Types check box. |
|
Select this check box to display credit memo transactions. This check box is cleared by default, and is only enabled if you clear the All Reference Types check box. |
|
Select this check box to display non-sufficient funds transactions. This check box is cleared by default, and is only enabled if you clear the All Reference Types check box. |
|
Select this check box to display debit memo transactions. This check box is cleared by default, and is only enabled if you clear the All Reference Types check box. |
|
Select this check box to display on account transactions. This check box is cleared by default, and is only enabled if you clear the All Reference Types check box. |
|
Select this check box to display chargeback transactions. This check box is cleared by default, and is only enabled if you clear the All Reference Types check box. |
|
Select this check box to display unapplied payment transactions. This check box is cleared by default, and is only enabled if you clear the All Reference Types check box. |
|
Select this check box to display prepayment transactions. This check box is cleared by default, and is only enabled if you clear the All Reference Types check box. |
|
Select this check box to only display disputed invoices. |
|
Select this check box to only display past due invoices. |
|
Select this check box to only display reminder invoices. |
Note Additional filters may appear in the My Additional Customer Filters section if customer filters are in set up in Screen Additional Filters Maintenance, or set up and loaded from an additional filters template in Additional Filters Template Maintenance.
This tab may include additional customer filters if customer filters are set up in Screen Additional Filters Maintenance, or set up and loaded from an additional filters template in Additional Filters Template Maintenance.
Field or Button |
Description |
Select one of the following options:
|
|
Enter an email address to which you want to email a report or letter, or click the Lookup button to select an email address for one of the customer's contacts. This field is only enabled if you select a specific customer on the Select tab. If you leave this field blank, and click the Email button, you are prompted to select recipients for the email. |
|
Click this button to email a transaction report, collection letter, or reminder letter based on the selected Processing Options radio button. Note This button is not used to email collection statements. Use Collection Statement Print to email collection statements. If an email address is entered in the Email Address field, the report or letter is emailed to that address. If the Email Address field is blank, you are prompted to select recipients for the email. This button is only enabled if you select a specific customer on the Select tab. |
|
This grid displays transactions based on the criteria selected on the Select tab. This grid includes the following columns:
Note Other transactions, such as chargebacks, do not have payment terms.
|
|
This field displays the total open amount for the displayed transactions. |
|
This field displays the total number of displayed transactions. |
Field or Button |
Description |
Select one of the following output options:
|
|
Save Report File |
Select this check box to save the Crystal Reports report (.rpt) file for the report to the folder entered in the Report Working Directory field for your user ID in User Profile Maintenance. You can use the report file to customize the report. For more information, see Crystal Reports FAQ. This check box is only available if you select the Screen radio button. |
Save Access Database File |
Select this check box to save the Access database (.mdb) file for the report to the folder entered in the Report Working Directory field for your user ID in User Profile Maintenance. You can use the Access database file to customize the report. For more information, see Crystal Reports FAQ. This check box is only available if you select the Screen radio button. |
Printer |
|
Subject |
|
Report File Prefix |
|
Add Additional Comments |
Select this check box if you want to include additional comments with the emailed report. If you select this check box, the Additional Comments window appears after you click the Print button in the ribbon, and allows you to enter the comments. This check box is only available if you select the Email radio button. |
Excel Format Name |
|
Format Maintenance |
Click this button to display Excel Format Maintenance, which allows you to set up Excel formats. This button is only available if you select the Excel radio button. |
Select this check box to include the entire heading from the first page of the report on all pages of the report. This check box is cleared by default, and only enabled if you select the Screen, Printer, or Email radio button. |
|
Select this check box to include the report title, page number, and printed date/time on all pages of the report. This check box is selected by default and only enabled if you select the Screen, Printer, or Email radio button, and if the Print Full Heading on All Pages check box is cleared. |
|
This field is disabled in this window. |
|
This field is disabled in this window. |
|
Select this check box to include horizontal shading on alternate lines of the report to make it easier to read report data. This check box is cleared by default, and is only enabled if you select the Screen, Printer, or Email radio button. |
|
Collate |
Select this check box to collate the printed copies of the report (if you are printing multiple copies of the report). This check box is cleared by default, and is only enabled if you select the Printer radio button and enter a value greater than 1 in the Number of Copies field. Example You are printing five copies of a 20 page report to distribute to five different people. Leave this check box selected, so that pages 1-20 of the first copy prints, then pages 1-20 of the second copy, etc. If you clear this check box, five copies of page 1 prints, then five copies of page 2, etc. |
Horizontal Shading Color |
|
Number of Copies |
|
These radio buttons are disabled in this window. |
|
These radio buttons are disabled in this window. |
|
These fields and radio buttons are disabled in this window. |
|
This field is disabled in this window. |
|
This field is disabled in this window. |
|
This field is disabled in this window. |
|
This check box is disabled in this window. |
|
This check box is disabled in this window. |
|
This check box is disabled in this window. |
|
Report Files |
This grid displays report files set up for the report, and is only available if report files are set up for the program in Report File Maintenance. This grid includes the following columns:
|