Display Vendor Invoice Information

Use the Vendor Service Inquiry (VSI) program to display invoice information, invoice history, and AP aging information for a vendor. See Background and Road Map for more information.

Note
If you accessed this program from another program, skip step 1.

Enter a vendor number, click the Lookup icon and use the standard lookup options to select the vendor from a list, or enter [***] for vendors not on file.

The program displays:

Field Name	Displays
Vendor	The vendor number; the name of the vendor displays below it
Tax type	The vendor's tax type: 1099: 1099 reporting GST: Goods and Services Tax No tax: Neither GST or 1099 reporting applies
Attn	The contact for this vendor
Phone	The vendor's phone number
Terms	Description of the AP terms associated with the vendor
AP aging by	Due date: Aging is based on the date the invoice is due Invoice: Aging is based on the date the invoice was entered The Select to age on I=Invoice or D=Due date Program option determines which displays. See step 4.
MTD inv	The total amount of invoices entered since the first of the month
YTD inv	The total amount of invoices entered since the start of the year
YTD pay	The total amount of payments made to this vendor since the start of the year
YTD adj	The total amount of adjustments made since the start of the year: Positive amount: Debit (owed to the vendor) Negative amount: Credit
YTD disc lost	The total amount of potential prompt payment discounts that were not taken
Disc taken	The total amount of discounts taken for prompt payment
<Month or Period>	The dollar amount of invoices for each of the last six months/periods The displayed label depends on the Period Desc 1 - 13 option in System Options Maintenance (XM) Statistics Period Descriptions. If you selected F for the F=Fiscal or C=Calendar history installation option, your periods set with Accounting Period Maintenance (GDM) may not match calendar months.
Current	The AP balance by invoice or due date for the current aging period
30 Days	The AP balance by invoice or due date for the 30-day aging period
60 Days	The AP balance by invoice or due date for the 60-day aging period
90 Days	The AP balance by invoice or due date for the 90-day aging period
120 Days	The AP balance by invoice or due date for the 120-day aging period

The Print in summary or detail Program option (see step 4) determines which fields are displayed in the list box when you enter the program. The Sum/Dtl button toggles between detail and summary.

Detail displays:

Field Name	Displays
Invoice no	The invoice number
Tr cd	The code for the transaction type: BF: Fixed billing BI: Billing invoice CM: Credit memo CP: Cash payment
Invoice date	The invoice date
Due	The due date
Discount	The discount date
GL post	The GL posting date
Trans amount	The transaction amount
Payment no	The check number or [Payment type]/[Number] for non-check payments
Reg no	The register number for this transaction
Remit to	The name to which payment was remitted

Summary displays:

Field Name	Displays
Invoice no	The invoice number
Org	GL organization
Hold?	Hold indicates that the invoice is ineligible for payment
Invoice amount	The invoice amount
Payment amount	The amount paid against the invoice
Net amount	The balance due (Invoice amount less Payment amount)

Choose the appropriate options:

To	Do This
Review your options for this program	Click Prog opts. See step 4.
Print the list of invoices	Click Print. See Print an Inquiry.
Toggle between detail and summary display	Click Sum/Dtl.
Display the PO number for the selected invoice	Click Purchases. See Display AP-Purchasing Detail by Invoice Number. Click Exit to return to this program.
Display payment information for the current and previous five months/periods and display a list of POs	Click PO inq. See Display Vendor Purchase Order Information. Click OK to return to this program.
Display vendor cost performance, delivery performance, and product quality	Click Analysis. See Display Vendor Cost, Delivery & Quality Performance. Click OK to return to this program.
Display 1099 invoices by vendor	Click 1099 info. See Display Invoices for a 1099 Vendor. Click OK to return to this program. This button displays only if the vendor tax type is GST or 1099.
Display payment statistics for this vendor	Click Stats. See step 3.
Specify a different vendor	Click OK.
Exit the program	Click Exit.

Click Stats to display these fields:
Note
No charge invoices are not considered in the totals / calculations.

Field Name

Displays

Avg days to pay

The average number of days we took to pay an invoice: Total number of days to pay / Number of invoices paid in this time period

Avg days late

The average number of days we were late paying an invoice: Total number of days late / Total late invoices

Avg days early

The average number of days we were early paying an invoice: Total number of days early / Total early invoices

Weighted avg days to pay

The average days to pay based on the proportional relevance of the age of the invoice. The weighting factor depends on how current the invoice is. Recent invoices and their respective payments are considered more important than other invoices. Invoices in these days ranges are weighted:

Days	1-6	7-12	13-18	19-24	24+
Weight	+ 10	+ 7	+ 4	+ 2	+ 1

Paid invoices

The total number of invoices for this vendor

Late invoices

The number of invoices paid late for this vendor

Early/on-time invoices

The number of invoices paid early or on-time for this vendor

Last payment amount

The amount of the last payment

Last payment date

The date of the last payment

Unpaid

The number of invoices that do not have a zero balance

% late

Percentage of invoices that were paid late: Late invoices / Paid invoices

% early

Percentage of invoices that were paid early: Early invoices / Paid invoices

% on-time

Percentage of invoices that were paid on the due date: On-time invoices / Paid invoices

Number of invoices paid in

The number of invoices paid in the displayed period of months: 1-6, 7-12, 13-18, 19-24, over 24 months, and totals.

The number of invoices for which To pay is or was less than or equal to the category displayed: 1-30 days, 31-60 days, 61-90 days, over 91 days, totals, and average days to pay for these invoices.

Click Prog opts to review your options. To change them:

Click the Runtime tab to set runtime options. See Set Options for Reports and Inquiries for more information.
Click the Sort tab to set sort order.
Click the Program tab to set these program specific options:

Field Name	Type / Max Length	Action / Description
Include history?	Optional	Select to display purchase orders that have been closed and moved to history with the PO-Receiver Archive (VEX) program or leave blank to omit them.
Print in summary or detail	Required 1 alphanumeric	Select S to default the initial display to summary or D to default to detail.
Select to age on I=Invoice or D=Due date	Required 1 alphanumeric	Select D to age based on the invoice due date or select I to age on the date the invoice was entered.
Exclude zero balance invoices?	Optional	Select to limit the display to invoices with non-zero balances or leave blank to include all invoices.

Click Save to save these options for future use.
Click Refresh to redisplay current options.
Click OK to apply these options or click Cancel to exit without applying them.