Discrepancy by Document
Form ID: (AR409030)
You can use this form to find any discrepancies between the AR and GL accounts for a specified customer in a particular financial period, caused by AR documents. The table displays a list of the AR documents that meet the selection criteria you specify, with information on each document, including the discrepancy (if applicable).
The system opens this form in a new window when you click a link in the Discrepancy column on the Discrepancy by Customer (AR409020) form for one of the listed customers. In this case, the current form displays all AR documents with discrepancies for the particular customer and 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 documents (and their 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 (or all applicable accounts, if no account is selected in this area) was updated by the specified customer's documents to be listed in the table. |
| Customer |
Required. The customer whose documents for the specified financial period (and account, if one has been selected) should be listed in the table. 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 the documents to be listed in the table updated during the selected financial period for the specified vendor. |
| Subaccount |
Optional. The subaccount of the selected account, if an account has been specified. 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 documents (meeting the other selection criteria) that have discrepancies. |
| Total GL Amount | The turnover for the specified account and the customer within the selected financial period, according to the total of values in the GL Turnover column. |
| Total AR Amount | The turnover for the specified account and the customer within the specified financial period; this amount is calculated based on the total values in the AR Turnover column. |
| Total Discrepancy | The total discrepancy for all the listed documents, which is the sum of the amounts in the Discrepancy column for each row in the table. |
Table
This table contains the list of AR documents posted within the specified financial period for the selected customer and AR account. It includes basic information on each listed document, including any discrepancy.
| Column | Description |
|---|---|
| Type | The type of the AR document that meets the selection criteria. |
| Reference Nbr. | The reference number of the AR document posted to the selected financial period for the selected customer (and AR account, if one was selected). If you click the link in this column, the system opens the document in a separate window on the appropriate form, which is one of the following: Invoices and Memos (AR301000), Payments and Applications(AR302000), or Cash Sales (AR304000). |
| Status | The status of the listed document. |
| Original Amount | The amount of the document, which is copied from the Amount box of the form used to create the document. |
| Batch Nbr. | The number of the general ledger batch associated with this document being posted to the general ledger. If you click the link in this column, the system opens the GL batch on the Journal Transactions (GL301000) form. |
| Post Period | The financial period in which the document was posted to the GL. |
| GL Turnover | The amount posted to the selected account by the document listed in this row. |
| AR Turnover | The amount by which the document in this row has changed the customer balance. |
| Discrepancy |
The difference between the amounts in the GL Turnover and AR Turnover column for the document in this row. |