Viewing A/R Balance Summaries

Use the A/R Summary window to show a summary of the balances on accounts for a bill-to customer without needing to call up each individual account. In this window, you can view a breakdown of each ship-to customer associated with the original bill-to customer, as well as view the details for each ship-to account. This is a view-only window.

Note: If you select a customer that is a parent customer, or has dependent customers, the system displays information for the parent customer and all its dependents.

To view a summary of A/R balances:

  1. From the A/R menu, select A/R Inquiry to display the A/R Inquiry window.

  2. Populate the A/R Inquiry window.

  3. From the Inquiries menu, select A/R Summary to display the A/R Summary window.

The system populates the window with the following view-only information: Review for each account, as needed:

Column

Description

Parent / Bill-To

Indicates that this is a parent or a bill-to only customer.

Customer Index

and

Customer Name

Displays the corresponding customer name for the Parent / Bill-To column.

By default, the system displays the Index name as listed in theIndexfield in Customer Maintenance. Use the View Manager to change to theNameview and display the official name used in theCustomerfield in the Customer Maintenance record.

Balance

The total outstanding balance owed for the customer, including the amount in the Current column, as well as all aging buckets.

Current

The balance that has been invoiced less than 30 days and is not yet past due depending on your A/R aging method:

  • Method 1 - From the due date through one month from the due date.

  • Method 2 - From the due date through 30 days from the due date.

  • Method 3 and 4 - During the fiscal month in which the due date falls.

  • Method 5 and 6 - From the invoice date through one month from the invoice date.

  • Method 7 - During the calendar month in which the due date falls.

  • Method 8 - During the fiscal month in which the due date falls.

  • Method 9 - From the day after the due date through 30 days from that date.

30 PD (Past Due)

The invoiced balance that is at least 30 days past due but is less than 60 days past due.

60 PD (Past Due)

The invoiced balance that is at least 60 days past due but is less than 90 days past due.

90 PD (Past Due)

The invoiced balance that is at least 90 days past due but is less than 120 days past due. This amount is the same as the combined amounts in the 91 - 120 and Over 120 aging buckets in the Account Information area in the A/R Inquiry window.

Future

Depending on your A/R Aging Method, Future is a balance that has been invoiced, but is not current.

  • Method 1 - The invoice date through the due date.

  • Method 2 - The invoice date through the date before the due date.

  • Method 3 - Through the last of the calendar moth before the due date.

  • Method 4 - Through the last date of the fiscal month before the due date.

  • Method 5 - Method 8 - Nothing in Future.

  • Method 9 - Through the due date.

Note: For more information about how the system calculates aging buckets, see Understanding A/R Aging Methods.

  1. Do any of the following, as needed:

To...

Select this menu option...

print the summary information

File > Print

The Print Table window displays. Select whether to print the report in portrait or landscape orientation and click OK to send the report to your hold file.

print the A/R Aging Report

File > A/R Aging Report

The A/R Aging window displays.

locate account summary for a ship-to customer not displayed on the first page

Edit > Find

At the Customer Search prompt, enter the customer name and click OK to move to the customer's summary information.

view any ship-to customer accounts with zero balances

Edit > Show Zeros

To hide zero balances, select Show Zeros again to remove the checkmark next to it.

view receivables in detail for a selected customer

Inquiry > A/R Inquiry

The A/R Inquiry window displays.

view transactions on the selected customer's account

Inquiry > A/R Ledger

The A/R Ledger window displays.

view the open orders on a selected customer's account

Inquiry > Open Orders

The Sales Inquiry window displays.

view the outstanding bills on a selected customer's account

Inquiry > Open Bids

The Sales Inquiry window displays.

view or edit a selected customer's maintenance record

Inquiry > Customer Maintenance

The Customer Maintenance window displays.

  1. Save your changes and exit the window.

See Also:

A/R Inquiries Overview