The default Vendor Analysis report file names are:
-
Excel: Vendor Analysis Report_<MMDDYYYY>_<hhmmss>.xlsx
-
PDF: Vendor Analysis Report_<MMDDYYYY>_<hhmmss>.pdf
The following table shows the columns and names for the Vendor Analysis report’s Excel file.
|
Column |
Name |
|---|---|
|
A |
AP NUMBER |
|
B |
ACCOUNT NUMBER |
|
C |
DATE |
|
D |
VENDOR NUMBER |
|
E |
VENDOR NAME |
|
F |
CHECK NUMBER |
|
G |
INVOICE NUMBER |
|
H |
CHECK DATE |
|
I |
TYPE |
|
J |
ENCUM AMOUNT |
|
K |
LIQUID AMOUNT |
|
L |
PAYMENT AMOUNT |
|
M |
OUTSTANDING ENCUMBRANCE |
The AP number is a combination of the purchase order number and the line number.