Starting with the AP_Import _Generic_Invoice.xls Import File Template, fill out the Excel Spreadsheet as follows:
Vendor Name - name of the vendor the AP Invoice is being imported for.
Invoice Number - The Invoice Number must be unique for the Vendor it is being loaded for.
AP Vendor ID - The Vendor ID must be defined in Property Manager for the AP Vendor the invoice is being loaded for.
AP Vendor IDs are added/maintained at the Vendor Detail > AP Vendors tab.
Received Date - The date the AP Invoice was received. The date columns must be properly formatted as dates for the import process to be able to read them.
Invoice Date - The date of the AP Invoice. The date columns must be properly formatted as dates for the import process to be able to read them.
Due Date - The due date of the AP Invoice. The date columns must be properly formatted as dates for the import process to be able to read them.
Total Amount - This is the total amount of all AP Invoice Line Items.
Line Nbr - The Line Number of each AP Invoice Line Item. Always start at 1, and if the AP Invoice only has one line item, it's Line Number should be set at 1.
When an AP Invoice has more than one Line Item, the Vendor Name, Invoice Number, AP Vendor ID, Received Date, Invoice Date, Due Date and Total Amount must be included in the row for each Line Item.
Account Holder - The Account Number for Vendor Account Holder the AP Invoice Line Item is for.
Vendor Account Holders are added/maintained at the Vendor Detail > AP Vendors tab.
When importing AP Invoices with this process, the Vendor Account Holder must have an Account Number.
Expense Code - The GL Account Number where the AP Invoice Line Item is expensed/distributed to.
GL Accounts are added/maintained at System Administration > Accounting Setup - GL Account Setup.
Amt. - The Amount of the AP Invoice Line Item.
The sum of all AP Invoice Line Items must equal the Total Amount entered above.
Description - The Description of the AP Invoice Line Item.
