Use the Suppliers Report to review detailed information about your supplier records. You can use this report to verify the accuracy of your current supplier information and to help manage your master listing of supplier records. Payables provides detailed information for each supplier, and optionally, supplier site, including the user who created the supplier/site, creation date, pay group, payment terms, bank information, and other supplier or site information.
You can sort the report by suppliers in alphabetical order, by supplier number, by the user who last updated the supplier record, or by the user who created the supplier record.
Supplier For This Organization Only. Limit the report to suppliers with sites in a specific operating unit.
Order By.
Created By. Sort report alphabetically by the userid of the person who created the supplier record.
Last Updated By. Sort report alphabetically by the userid of the person who last updated the supplier record.
Supplier Name. Sort report alphabetically by supplier name.
Supplier Number. Sort report numerically by supplier number.
Income Tax Reportable Suppliers.
Yes. Limit the report to income tax reportable suppliers. This parameter allows you to easily review suppliers for which you will generate 1099 reporting.
No. Limit the report to nonincome tax reportable suppliers.
All. Submit report for all suppliers, regardless of income tax reportable status.
From/To Creation Date. If you want to limit the report to suppliers, supplier sites, or Bank Accounts that were created within a date range, then enter the range.
From/To Update Date. If you want to limit the report to suppliers, supplier sites, or bank Accounts that were last updated within a date range, then enter the range.
Note: If you enter values in the From/To Creation Date parameters and the From/To Update Date parameters, then the report will display only suppliers created within the Creation Date range specified, as well as last updated in the Update Date range specified.
If you choose to display Bank Account information and enter a date range The report will also display the associated Supplier and Site information in order to provide proper context even if the Creation/Update Dates for the supplier and site are outside of the entered date range.
Created By. If you want to limit the report to suppliers or supplier sites that were entered by a particular person, then enter the person's userid.
Updated By. If you want to limit the report to suppliers or supplier sites that were last updated by a particular person, then enter the person's userid.
Note: If you enter values for both the Created By and Updated By parameters, then only suppliers and sites that meet both these criteria will appear on the report.
Include All/Active Suppliers.
Active. Limit the report to active suppliers.
All. Submit the report for active and inactive suppliers.
Include Site Information.
Yes. List supplier site information for all sites for a supplier.
No. Do not list any supplier site information.
Include All/Active Sites. Note: This option is available only if the Include Site Information parameter is Yes.
Active. Limit the report to active supplier sites.
All. Submit the report for all supplier sites, regardless of status.
Include Home Country. To suppress the country name in the address for suppliers that are in your home country, enter No. You define your home country when you enter the Default Country profile option.
Site Pay Group. To list only sites that have the specified pay group, enter a pay group.
Include Contact Information.
Yes. List supplier site contact information.
No. Do not list any supplier site contact information.
Include All/Active Contacts. Note: This option is available only if the Include Contact Information parameter is Yes.
Active. List only active contacts.
All. List active and inactive contacts.
Include Bank Account Information.
Yes. List bank account information.
No. Do not list any bank account information.
Include All/Active Accounts. Note: This option is available only if the Include Bank Account Information parameter is Yes.
Active. List only active bank accounts.
All. List active and inactive bank accounts.
The Suppliers Report displays information you have entered for your suppliers in the Suppliers and Supplier Sites windows. For more detailed descriptions of these supplier attributes, see: Suppliers Pages Reference.
One Time. Payables displays Yes if you have enabled the One Time option in the Classification region of the Suppliers window.
PO Hold. Payables displays Yes if you have enabled the Purchase Order Hold option in the Purchasing region of the Suppliers window.
Taxpayer ID. Supplier's Tax Identification Number (TIN).
Tax Registration Num. Tax registration number, for example, a supplier's value-added tax (VAT) registration number. You enter a tax registration number for a supplier if it is required to pay or report on Value-Added Taxes (VAT).
Income Tax Reportable. Payables displays Yes if you have enabled the Federal Reportable option in the Tax Reporting region of the Suppliers window.
State Reportable. Payables displays Yes if you have enabled the State Reportable option in the Tax Reporting region of the Suppliers window.
Income Tax Type. Income tax type specified in the Tax Reporting region of the Suppliers window.
Status. Payables displays Active if the supplier has no inactive date or if the inactive date is after the Suppliers Report submission date.
Creation Date. Date the supplier record was entered.
Created By. Userid of the person who entered the supplier record.
Update Date. Date the supplier record was last updated.
Updated By. Userid of the person who last updated the supplier record.
Site Uses. Payables displays the site uses specified in the General region of the Supplier Sites window.
Site Name. Supplier site name.
Address. Supplier site address.
Status. Payables displays Active if the supplier site has no inactive date or if the inactive date is after the Suppliers Report submission date.
Creation Date. Date the supplier site record was entered.
Created By. Userid of the person who entered the supplier site record.
Update Date. Date the supplier site record was last updated.
Updated By. Userid of the person who last updated the supplier site record information.
Site Uses. Payables displays the site uses specified in the General region of the Supplier Sites window.
Payment Terms. Payment terms assigned to this supplier site.
Pay Group. Pay group assigned to this supplier site.
Payment Priority. Payment priority assigned to this supplier site.
Payment Method. Payment method assigned to this supplier site.
Pay Alone. Payables displays Yes if you have enabled the Pay Alone option in the Payment region of the Supplier Sites window.
Invoice Tolerances. Payables displays the invoice tolerance assigned to the supplier site.
Hold Unmatched Invoices. Payables displays Yes if you have enabled the Hold Unmatched Invoices option in the Control region of the Supplier Sites window.
Hold Unvalidated Invoices. Payables displays Yes if you have enabled the Hold Unvalidated Invoices option in the Control region of the Supplier Sites window.
Hold All Payments. Payables displays Yes if you have enabled the Hold All Payments option in the Control region of the Supplier Sites window.
Contact Name. Name of contact.
Position. Job title of contact.
Telephone. Telephone number of contact.
Status. Payables displays Active if the contact has no inactive date or if the inactive date is after the Suppliers Report submission date.
Bank Account Name. Name that you use to refer to the supplier site bank account.
Number. Supplier site bank account number that is used to receive electronic payments.
Curr. Currency of the supplier site bank account.
Primary. Payables displays Yes if this is the designated supplier site bank account for receiving electronic payments in the specified currency.
Effective Dates. A date range indicates that this bank account is designated as the primary supplier site bank account for the period specified.