Supplier Reports

The XMVL Reports page provides various report types that you can run and export to a file. These reports are designed to track the supplier XMVL upload and activation process.

To access the following vendor reports, click Suppliers and then click the Reports sub-tab:

Matched Vendors - The Matched Vendors report provides information on the vendor, their TIN/IPP ID, the date the vendor was matched, public or private company, the vendor address, SetID, the type of match, and the Disburser user that did the matching. The report displays all matched vendors for the Disburser filtered by Set ID
Matched Vendors - No Invoices Received - Displays all matched vendors for a Disburser filtered by Set ID that do not have any invoices on file in IPP. The purchase orders are aging and the services or goods were never delivered and invoiced, or the vendor has never accessed the IPP application.
Matched Vendors - No Payments Received - Displays any matched vendors where the vendor has not received payment for their goods or services. The vendor may be paid outside of IPP.
XMVL Report Exceptions - Displays XMVL suppliers that are in “Exception” status. Includes a reason the supplier went into exception. Some of the issues that could cause exceptions are missing TINs or IPP IDs, invalid countries, invalid ZIP/postal code, invalid State/Province, or length exceeds maximum requirements. This report is limited to the vendors the Disburser user has permission to view. If the XMVL upload fails, the Disburser user or the BRM can run the report and locate where the errors occurred.
XMVL Import Status Report –Displays the status of imported vendor files. It shows the scheduled date and time, starting and complete date and time. IPP only shows those vendors the Disburser user has permission to view.
XMVL Log - The log displays the number of suppliers that were added or updated in the supplier directory on a specific date. This report is limited to the vendors the Disburser user has permission to view.

Matched Vendors Report

Field Name	Description
Company Name	Vendor company name.
TIN/IPP ID	Identification number used by the Internal Revenue Service (IRS) in the administration of tax laws, or the IPP ID.
UEI	If supplied, displays vendor’s UEI.
DUNS/DUNS+4(EFT Indicator)	If supplied, displays 9-digit numeric identifier issued by Dun and Bradstreet used to track locations for business and other entities. DUNS+4 is a 4-digit alphanumeric extension to the DUNS number, which the individual organization maintains. Note: If UEI is provided, and there is a 4-digit extension, it is referred to as the EFT Indicator. If not supplied, displays “Not Available”.
Site Address	Address where the vendor business establishment is located.
Activation Date	Date that the vendor was activated in the IPP system.
Match Type	Method of activity between the vendor and the agency in regard to POs/BPOs, invoices/credit memos, and payments. The choices are: Invoice - the vendor only sends invoices Invoice-Pmt - the vendor sends invoices and the Disbursing agency or U.S. Treasury sends payments
Vendor ID	Displays the agency provided vendor identification which is a unique identifier from the agency ERP system associated to a vendor.
SetID	Displays the vendor business unit which is a unique identifier associated with one or more business units of a single vendor.
Matched By	Displays the Disburser user name that matched the vendor in IPP.
Date Vendor Matched	Displays the date when the vendor match was created.
Scope	Displays the type of company. The choices include: Public - a company trading on the stock exchange Private - a company owned by individual(s)
Category	Displays the symbol for the transactions between the vendor and the agency.

Matched Vendors - No Invoices Received Report

Field Name	Description
Company Name	Displays the vendor company name.
TIN/IPP ID	Displays the identification number used by the Internal Revenue Service (IRS) in the administration of tax laws or the IPP ID.
UEI	If supplied, displays vendor's UEI
Site Address	Displays the address where the vendor business establishment is located.
DUNS/DUNS+4	If supplied, displays 9-digit numeric identifier issued by Dun and Bradstreet used to track locations for business and other entities. DUNS+4 is a 4-digit alphanumeric extension to the DUNS number, which the individual organization maintains. Note: If UEI is provided, and there is a 4-digit extension, it is referred to as the EFT Indicator. If not supplied, displays “Not Available”.
Activation Date	Displays the date that the vendor was activated in the IPP system.
Match Type	Displays the method of activity between the vendor and the agency in regard to POs/BPOs, invoices/credit memos, and payments. The choices are: Invoice - the vendor only sends invoices Invoice-Pmt - the vendor sends invoices and the Disbursing agency or U.S. Treasury sends payments
Vendor ID	Displays the agency provided vendor identification which is a unique identifier from the agency ERP system associated to a vendor.
SetID	Displays the vendor business unit which is a unique identifier associated with one or more business units of a single vendor.
Matched By	Displays the Disburser user name that matched the vendor in IPP.
Date of First PO Issued in IPP	Displays the date when the agency sent the vendor the first purchase orders through the IPP application.
Date Vendor Matched	Displays the date when the Disburser user matched the vendor.
Aging of First PO (Days)	Displays the number of days from when the PO was received in IPP to the present date.
Category	Displays the symbol for the transactions between the vendor and the agency.

Matched Vendors - No Payments Received

Field Name	Description
Company Name	Displays the vendor company name.
TIN/IPP ID	Displays the identification number used by the Internal Revenue Service (IRS) in the administration of tax laws or the IPP ID.
UEI	If supplied, displays vendor's UEI
Site Address	Displays the address where the vendor business establishment is located.
DUNS/DUNS+4	If supplied, displays 9-digit numeric identifier issued by Dun and Bradstreet used to track locations for business and other entities. DUNS+4 is a 4-digit alphanumeric extension to the DUNS number, which the individual organization maintains. Note: If UEI is provided, and there is a 4-digit extension, it is referred to as the EFT Indicator. If not supplied, displays “Not Available”.
Activation Date	Displays the date that the vendor was activated in the IPP system.
Match Type	Displays the method of activity between the vendor and the agency in regard to POs/BPOs, invoices/credit memos, and payments. The choices are: Invoice - the vendor only sends invoices Invoice-Pmt - the vendor sends invoices and the Disbursing agency or U.S. Treasury sends payments
Vendor ID	Displays the agency provided vendor identification which is a unique identifier from the agency ERP system associated to a vendor.
SetID	Displays the vendor business unit which is a unique identifier associated with one or more business units of a single vendor.
Matched By	Displays the Disburser user name that matched the vendor in IPP.
Date of First PO Issued in IPP	Displays the date when the agency sent the vendor the first purchase orders through the IPP application.
Date Vendor Matched	Displays the date when the Disburser user matched the vendor.
Category	Displays the symbol for the transactions between the vendor and the agency.

XMVL Report Exceptions

Field Name	Description
Date	Displays the date of the exception.
Reasons	Displays the reasons for the exception.

XMVL Import Status Report

Field Name	Description
File Name	Displays the vendor company name.
Date	Displays the date the file was uploaded.
Imported By	Displays the Disburser user name who uploaded the file.
Total #	Displays the total number of files in the import.
# Succeeded	Displays the total number of files successfully uploaded.
# Failed	Displays the total number of files that failed to upload.
# New	Displays the total number of new files in the upload.
# Updated	Displays the total number of files updated in the upload.
Import Status	Displays the status of the import: Completed or Failed
Comments	Displays the scheduled time for the import,the date and time the load began, the date and time the import completed.

XMVL Log

Field Name	Description
Date	Displays the date that the log was created.
New Suppliers	Displays the names of the new vendors loaded into IPP.
Reasons	Displays the names of vendors that had changes made to their information.