Vendor Summary

Form ID: (AP401000)

You use this form for quick inquiries about vendors' outstanding balances. You can view current balances or balances by a past period. To view the data on foreign currency transactions, select a particular currency. If no currency is selected, the system displays information on all documents in the base currency.

Note:

Amounts of debit adjustments, which have the negative sign, are considered in the calculation of the vendor's balance.

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
AP Aging	Navigates to the AP Aging (AP631000) report.
AP Balance by Vendor	Navigates to the AP Balance by Vendor (AP632500) report.
AP Coming Due	Navigates to the AP Coming Due (AP631500) report.
Vendor History	Navigates to the Vendor History (AP652000) report.

Selection Area

You use the elements in this area to select the vendors that meet particular criteria, such as financial period, vendor class, and currency of vendor transactions.


Element	Description
Company/Branch	The company, branch, or company group for which you want to view information. By default, the current company or branch is selected. You can select another branch, company, or company group to which you have access. This setting is required if the Multiple Base Currencies feature is enabled on the Enable/Disable Features (CS100000) form.
Vendor Class	The vendor class for inquiry. If you select no vendor, information on all vendors will be displayed. If the Customer and Vendor Visibility Restriction feature is enabled on the Enable/Disable Features (CS100000) form, the list of vendor classes available for selection may be limited based on the roles assigned to the user account to which you are signed in. In this case, the Restrict Visibility To box appears on the General tab of the Vendor Classes (AP201000) form. With the feature enabled, a vendor class is available for selection if one of the following is true: The Restrict Visibility To box is empty for the vendor class—that is, the vendor class’s visibility is not restricted. A branch, company, or company group is specified in the Restrict Visibility To box for the vendor class, and your user account is assigned to the role specified in the Access Role box of the Configuration Settings section of one of the following: the Branch Details tab of the Branches (CS102000) form for the branch, or the Company Details tab of the Companies (CS101500) form for the company or a company within the company group.
Period	The financial period for inquiry. If you make no selection, information about all open periods will be displayed.
AP Account	The AP account for inquiry. If you select no account, information on all accounts will be displayed.
AP Subaccount	The corresponding subaccount.
Currency	The currency of transactions for inquiry. If no currency is selected, all data will be displayed in the base currency.
Split by Currency	A check box that you select to display the vendor totals by currency.
Vendors with Balance Only	A check box that means (if selected) that information is displayed only about vendors with nonzero balances. Clear the check box to display all the vendors.
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 vendor summary 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 for companies that use different financial calendars, see Consolidated Reports for Companies with Different Calendars.
Total Balance	A read-only box showing the total balance of outstanding bills.
Total Prepayments	A read-only box that displays the total amount of prepayments released to vendors.
Total Retained Balance	The total amount of retainage withheld from the bills of all vendors in the selected branch that is not released yet 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

This table lists all the vendors for which information matches the criteria you have specified in the Selection area.

Table 1. Table Toolbar
The table toolbar includes standard buttons and buttons that are specific to this table. For the list of standard buttons, see Table Toolbar. The table-specific buttons are listed below.
Button	Description
Vendor Details	Navigates to the Vendor Details (AP402000) form and displays details about the vendor.

Table 2. Table Columns
Column	Description
Vendor ID	The ID of the vendor.
Vendor Name	The vendor name as it appears on the documents.
Last Activity Period	The most recent period when operations with the vendor occurred.
Currency	The currency that is used in operations with the vendor, by its ID.
Currency Beginning Balance	The outstanding balance at the start of the selected period, in the currency that is used in operations with the vendor. If no period is selected, it is the beginning balance at the start of the last activity period.
Currency Ending Balance	The outstanding balance at the end of the selected period, in the currency that is used in operations with the vendor. If no period is selected, it is the ending balance of the last activity period or the currency balance.
Currency Prepayment Balance	The balance of prepayments at the end of the specified period, in the currency that is used in operations with the vendor. If no period is selected, it is the current prepayments balance.
Currency PTD Purchases	The period-to-date amount of purchases, in the currency that is used in operations with the vendor. If no period is selected, it is the purchase amount during the last activity period.
Currency PTD Payments	The period-to-date amount of payments to the vendor, in the currency that is used in operations with the vendor. If no period is selected, it is the payment amount during the last activity period.
Currency Beginning Retained Balance	The total amount of unreleased retainage in the currency that is used in the operation with the vendor at the start of the selected period. If no period is selected, it is the balance at the start of the last activity period. This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
Currency Ending Retained Balance	The total amount of unreleased retainage in the currency that is used in the operation with the vendor at the end of the selected period. If no period is selected, it is the balance at the end of the last activity period. This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
Currency PTD Retainage Withheld	The period-to-date retainage withheld on the documents in the selected currency. If no period is selected, it is the retainage withheld during the last activity period. This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
Currency PTD Retainage Released	The period-to-date retainage amount released on the documents in the selected currency. If no period is selected, it is the retainage released during the last activity period. This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
Currency PTD Cash Discount Taken	The period-to-date amount of cash discounts taken, in the currency that is used in operations with the vendor. If no period is selected, it is the total amount of cash discount taken during the last activity period.
Currency PTD Tax Withheld	The period-to-date amount of withholding tax, in the currency that is used in operations with the vendor. If no period is selected, it is the total tax withheld on behalf of the vendor during the last activity period.
Currency PTD Credit Adjustments	The period-to-date amount of credit adjustments, in the currency that is used in operations with the vendor. If no period is selected, it is the total on credit adjustments during the last activity period.
Currency PTD Debit Adjustments	The period-to-date amount of debit adjustments, in the currency that is used in operations with the vendor. If no period is selected, it is the total on debit adjustments during the last activity period.
Currency PTD Prepayments	The period-to-date amount of prepayments released to the vendor, in the currency that is used in operations with the vendor. If no period is selected, it is the total on prepayments during the last activity period.
Beginning Balance	The beginning balance of the vendor (all currencies).
Ending Balance	The ending balance of the vendor (all currencies).
Prepayment Balance	The balance on prepayments.
PTD Purchases	The period-to-date amount of purchases, in the base currency. If no period is selected, it is the purchase amount during the last activity period.
PTD Payments	The period-to-date amount of payments to the vendor, in the base currency. If no period is selected, it is the payment amount during the last activity period.
Beginning Retained Balance	The total amount of unreleased retainage (in the base currency) at the start of the selected period. If no period is selected, it is the balance at the start of the last activity period. This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
Ending Retained Balance	The total amount of unreleased retainage (in the base currency) at the end of the selected period. If no period is selected, it is the balance at the end of the last activity period. This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
PTD Retainage Withheld	The retainage amount (in the base currency) withheld in the specified period. If no period is selected, it is the retainage withheld during the last activity period. This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
PTD Retainage Released	The retainage amount (in the base currency) released in the specified period. If no period is selected, it is the retainage released during the last activity period. This column appears on the form if the Retainage Support feature is enabled on the Enable/Disable Features (CS100000) form.
PTD Cash Discount Taken	The period-to-date amount of cash discounts taken, in the base currency. If no period is selected, it is the total amount of cash discount taken during the last activity period.
PTD Tax Withheld	The period-to-date amount of withholding tax, in the base currency. If no period is selected, it is the total tax withheld on behalf of the vendor during the last activity period.
PTD Realized Gain/Loss	The period-to-date amount of realized gains or losses on foreign currency transactions with vendors, in the base currency. If no period is selected, it is the realized gain or loss (RGOL) total during the last activity period.
PTD Credit Adjustments	The period-to-date amount of credit adjustments, in the base currency. If no period is selected, it is the total on credit adjustments during the last activity period.
PTD Debit Adjustments	The period-to-date amount of debit adjustments, in the base currency. If no period is selected, it is the total on debit adjustments during the last activity period.
PTD Prepayments	The period-to-date amount of prepayments released to the vendor, in the base currency. If no period is selected, it is the total on prepayments during the last activity period.