Use this task to import one or more AP Invoices into Property Manager from a file. If you don't see an Import Type that works with your file, contact Bostonpost Client Support at myMRI or contact a Client Support Analyst directly at (877) 579-8896 to have a new Import Type created. Both of the template files (Excel Spreadsheets) must be saved as CSV File before it can be imported into Property Manager.
Please click each Import Type for the rules necessary in creating the AP Invoice Import Files:
Generic Invoice - allows you to import AP Invoices from a properly formatted Excel spreadsheet that is saved as a CSV File (comma delimited text file) (AP_Import _Generic_Invoice.xls).
Vitus - allows you to import AP Invoices from a properly formatted Excel spreadsheet that is saved as a CSV File (comma delimited text file) and has been formatted for properties that have a relationship with Vitus (AP_Import_Vitus.xls).
Import Type has been defined for file you are attempting to import.
Each detail row in the import file has a valid Vendor ID with unique Invoice Number.
Accounts Payable Detail General Information Invoice Import
Select the Import Type from the drop down list for the file you are importing.
Click on the Find File button to browse to where the file you are importing is saved.
You may need to change the file type to Excel Files to see the file to be imported.
After selecting the file to be imported, review the details of the file listed in the bottom half of the window, and then click Finished to import the file.
When an error occurs while importing a file, you will receive detailed messages as to why one or more payments in the import file failed to load. I.e. - Vendor ID does not exist in Property Manager, the Vendor Account Holder does not exist for the Vendor, the Invoice Number has already been used by the Vendor, date columns are not properly formatted, etc.
If there are no errors, click Yes to import the AP Invoices or click No to cancel the process.
The Imported AP Invoices will be available on the Accounts Payable Detail > General Information tab in the appropriate To-Do List Activity to continue on in the Accounts Payable process.