Vendor Details Report

Modified on Thu, Oct 30 at 4:44 PM

The Vendor Details report provides a comprehensive summary of vendor-related information to ensure accuracy, including payment details, contact information, export workflows, and automation options mapped within Ottimate. This report gives you complete visibility into vendor configurations across your locations and groups.

Vendor Details Example

Filters

Filter	Description
Group	Select a location group to filter data. Use "All" to view across all groups
Location	Choose a specific location within the group or "All" for all locations
Vendor with Invoice	Filter vendors based on if the vendor has invoices present (Yes/No/All)
Vendor ID	Search for a specific vendor using their accounting vendor ID

Field Description

Field	Description
Location	Location specified on your invoice
Vendor Name	Accounting vendor name
Accounting Vendor ID	Unique identifier for the vendor in your accounting system
Vendor Payment Method	Payment method configured for the vendor (e.g., Offline, ACH, Check)
Remittance Vendor Name	Vendor name used for remittance purposes
Vendor Address	Primary vendor address
Remittance Address	Specific address for remittance/payment purposes
Vendor Email	Vendor's email address
Customer Account Number	Your account number with the vendor
Payment Terms	Net payment terms from your vendor (e.g., NET30, 1)
Use a Default GL Account for All Items	Yes/No value indicating if a default GL is coded for this vendor
Default GL Account	GL value if "Use a Default GL" is selected
Mark as Paid	Yes/No value indicating all invoices from this vendor should be marked as paid
Bank Account	Bank account used to generate the offline payment in VendorPay
Auto Mark as Exported	Yes/No value indicating all invoices are to be marked as Exported
Auto Archive	Yes/No value indicating all invoices are to be marked as Archived
Skip Approvals	Yes/No value indicating all invoices from this vendor skip approvals
Process Header and Line Items	Yes/No value indicating whether both header and line item details are processed
Process Header	Yes/No value indicating whether header details only will be processed
Inventory Vendor	Yes/No value indicating vendor is used for inventory processing
Export Line Items	Yes/No value indicating line items should be included when exporting invoices
Date of Vendor Setup	Date vendor underwent vendor setup process (YYYY-MM-DD)
PIQ Internal ID	Internal system identifier for the vendor
Location ID	Internal identifier for the location
Company ID	Internal identifier for the company
PIQ Vendor ID	Internal vendor identifier in the PIQ system
Vendor Tags	Tags assigned to the vendor for categorization

How to Use

Vendor Configuration Review: Audit vendor setups across locations to ensure consistency and accuracy.
Payment Method Analysis: Identify which vendors use specific payment methods for cash flow planning.
Contact Information Management: Verify and update vendor contact details and remittance addresses.
Automation Settings: Review which vendors have automated processing, approval skipping, or export settings enabled.

Access Model

Category: Admin Exports Availability: This report is available to all users as a standard report across all plans.