Discrepancies by Vendor

Form ID: (AP409020)

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

The system navigates to this form when you click a link in the Discrepancy column on the Discrepancies by Account (AP409010) form. In this case, the current form displays all vendors 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 vendors (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 to which you are currently signed in.
Financial Period	Required. The financial period during which the selected account was updated by a document of the vendor or vendors to be listed in the table.
Vendor	Optional. The vendor for which you want to display data. You can leave this box empty to display data for all vendors 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 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 documents of the vendor or vendors 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 Discrepancies	A check box that indicates (if selected) that the table should list only vendors that have documents (meeting the other selection criteria) with discrepancies during the selected financial period.
Total GL Amount	The turnover for the specified account and vendor 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 AP Amount	The turnover for the specified account and vendor within the selected financial period. 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 vendors, which is the sum of the amounts in the Discrepancy column for each row in the table.

Table

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

Table 1. Table Columns
Column	Description
Vendor ID	The ID of the vendor whose documents updated the selected account during the specified financial period.
Vendor Name	The name of the vendor.
GL Turnover	The GL turnover for the account and subaccount you have specified and the vendor listed in this row.
AP Turnover	The AP turnover for the specified account and vendor; this amount is calculated based on the accounts payable documents that updated the vendor's balance.
Discrepancy	The difference between the amounts in the GL Turnover and AP Turnover columns for the vendor listed in this row. If you click this link, the system opens the Discrepancies by Document (AP409030) form in a pop-up window, where you can review the list of documents that caused the discrepancy.