Customer Details

Form ID: (AR402000)

You use this form to track outstanding balances for a specific customer. You can select the branch, financial period, currency, and Accounts Receivable account–subaccount pair used for the customer; you then view the list of documents associated with the customer that meet the specified criteria.

By default, the form displays the list of open customer documents (that is, those with the Open status), but you can add to the list closed documents and unreleased documents by selecting the Show All Documents and Include Unreleased Documents check boxes, respectively. The balance of documents with the Refund and Voided Refund types is treated as a payment with a reverse sign.

Note:

Cash sales transactions are shown as split into Cash Sale and Cash Sale Invoice transactions.

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.
AR Register	Navigates to the AR Register (AR621500) report.
Create Invoice	Navigates to the Invoices and Memos (AR301000) form, so that you can create a new invoice for the selected customer.
Create Payment	Navigates to the Payments and Applications (AR302000) form, so that you can create a new payment for the selected customer.
Customer History	Navigates to the Customer History (AR652000) report.
More	Opens a menu where commands are organized in categories.
Pay/Apply Document	Navigates to the Payments and Applications (AR302000) form so that you can pay for the selected document. This command can be invoked only if the document has the Open status; if this command is invoked for a document with another status, the system displays an error message.

Selection Area

You use the elements in this area to select a financial period, a customer, and the currency of the operations for which you want you want to view customer documents. Also, you can select a particular Accounts Receivable account with the corresponding subaccount.


Element	Description
Company/Branch	The company or branch for which you want to view information. By default, the current company or branch is selected. This box is required if the Multiple Base Currencies feature is enabled on the Enable/Disable Features (CS100000) form.
Customer	Required. The customer whose open documents you want to view. The list of values may be limited as follows: If a branch is selected in the Company/Branch box, you can select a customer whose settings permit the use of the selected branch(the Restrict Visibility To box on the Financial tab of the Customers (AR303000) form contains this branch, the company of this branch, a company of a company group, or is empty). If the Company/Branch box is empty, you can select a customer whose visibility is not restricted to the branch, company, or company group to which the user's role is assigned.
Period	The financial period for which you want to customer documents. If you make no selection, customer documents related to all open periods will be displayed.
Currency	The currency of the documents to be included in the list. Leave the box empty to display all documents that meet the other criteria you have selected.
AR Account	The AR account used for the customer.
AR Subaccount	The corresponding subaccount.
Show All Documents	A check box that indicates (if selected) that closed documents (that is, those with the Closed status) are included in the list. The check box is not displayed if a financial period is selected in the Period box.
Include Unreleased Documents	A check box that indicates (if selected) that unreleased documents (that is, those with the On Hold and Balanced statuses) are included in the list.
Use Master Calendar	A check box that indicates (if selected) that the data in the table will be shown for the master calendar. That is, with the check box selected, the table will show the customer details posted for the master calendar. If the check box is cleared, the data in the table will be shown for 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.
Include Child Accounts	A check box that you select to view documents of both the parent account and its child accounts. If this check box is selected, the Balance by Documents, Current Balance, Prepayment Balance, and Balance Discrepancy boxes (in the Selection area of the form) will 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 check box appears on the form if the Parent-Child Customer Relationship feature is enabled on the Enable/Disable Features (CS100000) form.
Balance by Documents	A read-only box that displays the total balance recalculated for all of the selected customer's documents that match the selected criteria. (The balance shown in this box will not change based on whether the Show All Documents check box is selected because Closed documents do not affect the balance.) The amount in this box is equal to the Current Balance value minus the Prepayment Balance value. If you have no selection criteria specified on the current form other than the customer, the same value is displayed in the Balance box on the Customers (AR303000) form.
Current Balance	A read-only box that displays the customer balance retrieved from the Accounts Receivable account history for this customer, which is stored in the database. The value in this box is the sum of the Balance by Documents and Prepayment Balance values.
Prepayment Balance	The balance of customer prepayments calculated for the selected criteria. S2.6.2 Balance of PPI for Prepayment Account shall be shown with negative sign. Balance of PPI for AR Account shall be reflected with positive sign.
Balance Discrepancy	A read-only box that displays the difference between the Balance by Documents value and the sum of the Current Balance and Prepayment Balance values. If unreleased documents are not included (that is, if the Include Unreleased Documents check box is cleared on this form), the Balance Discrepancy value should be zero. If the value is nonzero, there may be errors in the database. In this case, we recommend running the Recalculate Customer Balances (AR509900) process to find discrepancies in records.
Retained Balance	The total amount of unreleased retainage withheld from the customer invoices in the selected branch 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 documents matching the criteria specified in the Selection area. The amounts or balances on customer payments are shown as negative values.

To open a particular document on the Customer Details (AR402000) form, you can double-click anywhere in the corresponding row.

Table 1. Table Columns
Column	Description
Customer	The customer associated with the document (the customer ID followed by the customer name).
Branch	The branch to which the document is related. This column is available only if the Multibranch Support feature is enabled on the Enable/Disable Features (CS100000) form.
Type	The type of the Accounts Receivable document: Invoice, Debit Memo, Credit Memo, Payment, Voided Payment, Prepayment, Prepayment Invoice, Refund, Voided Refund, Overdue Charge, Balance WO, Credit WO, Cash Sale, Cash Return, or Is Empty.
Reference Nbr.	The identifier of the document as it was assigned by the numbering sequence.
Post Period	The period to which the document transactions should be posted.
Date	The date when the document was created.
Due Date	The due date of the document.
Status	The status of the document.
AR Account	Shall be visible only under the 'VAT Recognition on Prepayments' feature.
AR Subaccount	Shall be visible only under the 'VAT Recognition on Prepayments' feature.
Currency	The currency of the document.
Currency Origin. Amount	The amount in the currency of the document (before discount).
Currency Balance	The balance of the document in the specified currency.
Currency Cash Discount Taken	The cash discount taken in the specified currency.
Currency Original Retainage	The retained amount in the currency of the document. This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
Currency Total Amount	The total amount in the currency of the document (including the retained amount). This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
Currency Unreleased Retainage	The amount of unreleased retainage in the currency of the document. This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
Origin. Amount	The original amount of the document, before payment application, in the base currency.
Balance	The balance of the document, if a payment was applied, in the base currency. S2.6.2 Balance of PPI for Prepayment Account shall be shown with negative sign. Balance of PPI for AR Account shall be reflected with positive sign.
Cash Discount Taken	The amount of cash discount received by the customer on the document.
Original Retainage	The retainage amount in the base currency. This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
Total Amount	The total amount of the document in the base currency (including the retained amount). This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
Unreleased Retainage	The amount of unreleased retainage in the base currency. This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
Retainage Invoice	A check box that indicates (if selected) that the document is a retainage invoice. This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
Original Document	The reference number of the invoice with retainage to which this retainage invoice is related. This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
RGOL Amount	The total amount of realized gain or loss (RGOL) incurred as the result of currency rate fluctuation.
Payment Method	The payment method used by the customer for the document.
Customer Invoice Nbr./Payment Nbr.	The reference number of the original customer document.
Description	A detailed description of the document.
The following columns are hidden by default. To display these columns, click the Column Configuration button (); in the Column Configuration dialog box (which the system opens), drag the column to the Selected Columns list.
Currency Period Beg. Balance	The account balance in the specified currency at the start of the selected financial period.
Period Beg. Balance	The balance of the account at the beginning of the selected financial period.