Discrepancy by Document
Form ID: (AP409030)
You can use this form to find any discrepancies between the AP and GL accounts for a specified vendor in a particular financial period, caused by AP documents. The table displays the AP documents that meet the selection criteria you specify, with information on each document, including the discrepancy (if applicable).
The system navigates to this form when you click a link in the Discrepancy column on the Discrepancy by Vendor (AP409020) form for one of the listed vendors. In this case, the current form displays all AP documents with discrepancies for the particular vendor 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, 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 was updated by the specified vendor's documents to be listed in the table. |
| Vendor |
Required. The vendor whose documents for the specified financial period and account 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 vendor is available for selection if the Restrict Visibility To box on the Financial tab of the Vendors (AP303000) form is empty or contains this branch (or the company or company group that contains this branch). |
| Account | Required. The AP 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 vendor within the selected financial period, according to the total of values in the GL Turnover column. |
| Total AP Amount | The turnover for the specified account and the vendor within the specified financial period; this amount is calculated based on the accounts payable documents. This amount is the sum of the amounts in the AP Turnover column of the table |
| 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 AP documents posted within the specified financial period for the selected vendor (and AP account, if applicable). It includes basic information on each listed document, including any discrepancy.
| Column | Description |
|---|---|
| Type | The type of the AP document that meets the selection criteria. |
| Reference Nbr. | The reference number of the AP document posted to the selected financial period for the selected vendor and AP account. When you click this link, the document is opened in a separate window on the appropriate form, which is one of the following: Checks and Payments (AP302000) or Bills and Adjustments (AP301000). |
| Status | The status of the listed document. |
| Original Amount | The amount of this document, which is copied from the Payment Amount box in the Summary area of the Checks and Payments form or the Detail Total box in the Summary area of the Bills and Adjustments form. |
| Batch Nbr. | The number of the GL batch associated with this document being posted to the general ledger. When you click this link, the batch is opened on the Journal Transactions (GL301000) form in a separate window. |
| 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. |
| AP Turnover | The amount by which the document in this row has changed the vendor balance. |
| Discrepancy |
The difference between the amounts in the GL Turnover and AP Turnover columns for the document in this row. |