Customer Summary

Form ID: (AR401000)

You can use this form to view outstanding customer balances by the criteria you select, such as the customer class, the financial period, and the account-subaccount pair used for the customers of the class.

Form Toolbar

The form toolbar includes standard buttons and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands can be shown as buttons on the form toolbar, as commands on the More menu, or in both places. These commands are listed in the following table in alphabetical order.


Command	Description
AR Aging	Navigates to the AR Aging (AR631000) report
AR Balance by Customer	Navigates to the AR Balance by Customer (AR632500) report
AR Coming Due	Navigates to the AR Coming Due (AR631500) report
Customer History	Navigates to the Customer History (AR652000) report
More	Opens a menu where commands are organized in categories.

Selection Area

By using the elements in this area, you can select the criteria of customers to be listed in the table.


Element	Description
Company/Branch	The company, branch, or company group for which you want to view information. By default, the current company or branch is selected. You can select another branch, company, or company group to which you have access. This setting is required if the Multiple Base Currencies feature is enabled on the Enable/Disable Features (CS100000) form.
Period	The financial period for inquiry. If you leave the box blank, information related to all open periods will be displayed.
Customer Class	The customer class selected for inquiry. You can leave the box blank to list customers of all classes. The list of classes may be limited based on the roles assigned to the user account to which you are signed in if the Customer and Vendor Visibility Restriction feature is enabled on the Enable/Disable Features (CS100000) form. With the feature enabled, the Restrict Visibility To box appears on the General tab of the Customer Classes (AR201000) form. You can select a customer class if one of the following is true: The Restrict Visibility To box is empty for the customer class—that is, the visibility of the customer class is not restricted. A branch, company, or company group is specified in the Restrict Visibility To box for the customer class, and your user account is assigned to the role specified in the Access Role box of the Configuration Settings section of one of the following: the Branch Details tab of Branches (CS102000) form for the branch, or the Company Details tab of the Companies (CS101500) form for the company or a company within the company group.
AR Account	The Accounts Receivable account used for customers to be listed.
AR Subaccount	The corresponding subaccount.
Currency	The currency for which you want to display data. You can leave the box blank to view the balances in the all currencies used by the customers if you select the Split by Currency check box or in the base currency if you clear the Split by Currency check box.
Split by Currency	A check box that you select to view the customer balances by currency. (This check box is visible only if the Currency box is blank.)
Customers with Balance Only	A check box that you select to display information on only customers that carry non-zero balances. Clear the check box to display all customers.
Use Master Calendar	A check box that indicates (if selected) that the data in the table will be shown for the master calendar. The table will show the customer summary details posted for the master calendar. If the check box is cleared, the report will show data for the financial period in the company calendar. If the Company box is blank, this check box is selected by default. This check box appears on the form only if the Multiple Calendar Support feature is enabled on the Enable/Disable Features (CS100000) form. For details on running consolidated reports and inquiries, see Consolidated Reports for Companies with Different Calendars.
Consolidate by Parent	A check box that you select to indicate to the system to display the consolidated balance for parent accounts that have child accounts for which the Consolidated Balance check box is selected on the Billing tab of the Customers (AR303000) form. The child accounts are excluded from the list if the check box is selected. The box is available if the Parent-Child Customer Relationship feature is enabled on the Enable/Disable Features (CS100000) form.
Total Balance	A read-only box that shows the total balance for the customers of the selected class or all classes calculated using the specified criteria.
Total Prepayments	The total amount of customer prepayments calculated for the selected criteria.
Total Unrealized Gain/Loss	The total amount of unrealized gains and losses calculated for transactions matching the selected criteria.
Total Retained Balance	The total amount of retainage withheld from the invoices of all customers in the selected branch that is not released yet at the end of the period (if specified) or at the end of the last activity period (if the period is not specified). This read-only box appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.

Table

The table contains the list of customers matching the criteria you have specified in the Selection area.

Table 1. Table Columns
Column	Description
Customer ID	The unique identifier of the customer, which is also a link. Click the link to navigate to the Customer Details (AR402000) form with the details of this customer.
Customer Name	The customer name as it appears on the documents.
Last Activity Period	The last period when any transactions related to the customer were released.
Currency	The currency used by the customer.
Currency Beginning Balance	The beginning balance on documents in the specified currency.
Currency Ending Balance	The ending balance on documents in the specified currency.
Currency Prepayment Balance	The balance of prepayments made in the specified currency.
Currency PTD Sales	Period-to-date sales made in the specified currency.
Currency PTD Payments	Period-to-date payments made in the specified currency.
Currency Beginning Retained Balance	The total amount of unreleased retainage in the currency that is used in the operation with the customer at the start of the selected period. If no period is selected, it is the balance at the start of the last activity period. This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
Currency Ending Retained Balance	The total amount of unreleased retainage in the currency that is used in the operation with the customer at the end of the selected period. If no period is selected, it is the balance at the end of the last activity period. This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
Currency PTD Retainage Withheld	The period-to-date retainage withheld on the documents in the selected currency. If no period is selected, it is the retainage withheld during the last activity period. This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
Currency PTD Retainage Released	The period-to-date retainage amount released on the documents in the selected currency. If no period is selected, it is the retainage released during the last activity period. This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
Currency PTD Cash Discount Taken	The cash discount total on cash discounts takes in the specified currency.
Currency PTD Credit Memos	The total on credit memos made in the specified currency.
Currency PTD Debit Memos	The total on debit memos made in the specified currency.
Currency PTD Prepayments	The total on prepayments made in the specified currency.
Beginning Balance	The customer's outstanding balance (in the base currency) at the start of the specified period. If no period is specified, the column shows the balance at the start of the last activity period.
Ending Balance	The customer's outstanding balance (in the base currency) at the end of the specified period. If no period is specified, the column shows the balance at the end of the last activity period.
Prepayment Balance	The unapplied amount of the customer prepayments.
PTD Sales	The total amount (in the base currency) of the period-to-date (PTD) sales for the specified period. If no period is specified, the column displays the total sales amount during the last activity period.
PTD Payments	The total amount of the period-to-date payments (in the base currency) received from the customer for the specified period. If no period is specified, the column displays the total payment amount during the last activity period.
Beginning Retained Balance	The total amount of unreleased retainage (in the base currency) at the start of the selected period. If no period is selected, it is the balance at the start of the last activity period. This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
Ending Retained Balance	The total amount of unreleased retainage (in the base currency) at the end of the selected period. If no period is selected, it is the balance at the end of the last activity period. This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
PTD Retainage Withheld	The retainage amount (in the base currency) withheld in the specified period. If no period is selected, it is the retainage withheld during the last activity period. This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
PTD Retainage Released	The retainage amount (in the base currency) released in the specified period. If no period is selected, it is the retainage released during the last activity period. This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
PTD Overdue Charges	The total amount of the period-to-date overdue charges (in the base currency) processed for the customer for the specified period. If no period is specified, the column displays the total overdue charges amount during the last activity period.
PTD Cash Discount Taken	The total period-to-date amount of cash discounts received by the customer for the specified period. If no period is specified, the column displays the total on all the cash discounts taken by the customer during the last activity period.
PTD Realized Gain/Loss	The total PTD amount of realized gains and losses received as the result of operations with the customer. If no period is specified, the column displays the total realized gain or loss (RGOL) amount for the customer during the last activity period.
PTD Credit Memos	The total PTD amount of credit memos received from the customer. If no period is specified, the column displays the total credit memo amount for the customer during the last activity period.
PTD Debit Memos	The total PTD amount of debit memos received from the customer. If no period is specified, the column displays the total of the debit memos for the customer during the last activity period.
Unrealized Gain/Loss	The amount of unrealized gain or loss calculated for open documents.
PTD Prepayments	The amount of prepayments received during this period until the current date.