Discrepancy by Customer

Form ID: (AR409020)

You can use this form to find any discrepancies between AR and GL accounts that have been updated for each customer (or for a customer you select) in a specified financial period. The table displays a list of customers that meet the selection criteria you specify, with the discrepancy (if applicable) listed for each customer.

The system navigates to this form when you click a link in the Discrepancy column on the Discrepancy by Account (AR409010) form for one of the listed accounts. In this case, the current form displays all customers with discrepancies for the particular account.

Form Toolbar

The form toolbar includes only standard buttons. For the list of standard buttons, see Form Toolbar and More Menu.

Selection Area

In this area, you select the settings that determine the customers (and discrepancies, if applicable) to be listed in the table.


Element	Description
Branch	Required. The branch for which you want to display data. By default, the system inserts the branch you are currently signed in to.
Financial Period	Required. The financial period during which the selected account was updated by a document of the customer or customers to be listed in the table.
Customer	Optional. The customer for which you want to display data. You can leave this box empty to display data for all customers whose documents updated the selected account in the specified financial period. If the Customer and Vendor Visibility Restriction feature is enabled on the Enable/Disable Features (CS100000) form, the list of values may be limited based on the branch selected on the current form. A customer is available for selection if the Restrict Visibility To box on the Financial tab of the Customers (AR303000) form is empty or contains this branch (or the company or company group that contains this branch).
Account	Required. The AR account that documents of the customer or customers to be listed in the table updated during the selected financial period.
Subaccount	Optional. The subaccount of the selected account. This box appears on the form if the Subaccounts feature has been enabled on the Enable/Disable Features (CS100000) form.
Show Only Documents with Discrepancy	A check box that indicates (if selected) that the table should list only customers that have documents (meeting the other selection criteria) with discrepancies.
Total GL Amount	The turnover for the specified account and customer within the selected financial period, according to the general ledger records. This amount is the sum of the amounts in the GL Turnover column of the table.
Total AR Amount	The turnover for the specified account within the specified financial period. This amount is the sum of the amounts in the AR Turnover column of the table.
Total Discrepancy	The total discrepancy for all the listed customers, which is the sum of the amounts in the Discrepancy column for each row in the table.

Table

This table contains the list of customers whose documents updated the selected account within the specified financial period. It includes basic information on each listed customer, including any discrepancy.

Table 1. Table Columns
Column	Description
Customer ID	The customer ID of the customer whose documents updated the selected account during the specified financial period.
Customer Name	The customer name of the customer.
GL Turnover	The GL turnover for the account you have specified and the customer listed in this row.
AR Turnover	The AR turnover for the specified account and customer; this amount is calculated based on the accounts receivable documents that updated the customer's balance.
Discrepancy	The difference between the amounts in the GL Turnover and AR Turnover column for the customer listed in this row. If you click this link, the system opens the Discrepancy by Document (AR409030) form in a separate window, where you can review the list of documents that caused the discrepancy.