Page History: AP Invoice Import
Compare Page Revisions
Page Revision: Wed, 26 Sep 2012 09:04
General Information
Default Menu Location Transaction >> Importers/Exporters >> Accounting >> AP Invoice Import
Screen Name IMPORTAPINV
Function The AP Invoice Import screen allows users to import external Account Payable invoices into Adjutant.
 AP Invoice Importer |
Required Spreadsheet format
A template Invoice Import Spreadsheet may be downloaded hereA template Distribution Import Spreadsheet with examples can be downloaded hereSpreadsheet Explanation
A: Invoice Number
B: The Vendor ID or Vendor Number
C: The Payment Priority for the Invoice, learn more about
Payment Priorities HERED: The Payment Terms for the invoice, learn more about the Rule Maintenance set up of
Payment Terms HEREE: Enter the Purchase Amount of the Invoice
F: Enter the amount that has already been paid on the invoice
G: The remaining open balance of the invoice
H: User Defined Reference field acts like a note to distinguish each invoice, ei. "July '12 Rent"
I: AP Account
J: Purchase Date is the date order was entered in the system
K: Transaction Date can be thought of as a postmark date, or when the invoice was received
L: Due Date is based off the terms of the invoice and the transaction date
M: Discount Date the last day the invoice can be paid and still qualify for a discount
N: Price Discount
O: Price Days
P: Price Net
Q: Discount Percentage
R: Discount Amount
S: Adjustment Amount
T: Approved to Pay amount
U: Approved Adjustment
V: Amount 1099
W: Buyer
X: Check number
Y: Check Date
Z: Check Account
AA: Type 1099
AB: Description
AC: Template order type
AD: Voucher number
AE: Vendor RemitTO number
