Uploading Accounts Payable invoices from Excel or CSV templates

Question

Does Sage 300 CRE permit upload of batches of payable invoices from either Excel or CSV upload templates? Can an upload tool be built to import multiple supplier expense invoices at a time with a template?

MistyS · Answer

As Steve Reed indicated in his post, go to AP / Tools / Import Invoices. Then click Import Format, then Start (to print). This will give you a page showing you the Field Names, descriptions, field type (alpha/numeric/etc.), & character limit for the field. For numeric fields, do not use formats with dollar signs or commas. 
 You can set up a template in Excel. Use the Field Names shown for the column headers. You'll need a column for each field in the same order as shown on the print out - even if you don't use the field. API Invoices need 15 columns, API Distribution needs 16. Every row of data will need to start with API (or APD) in the first column. 
 Once you've filled in your data in the Excel file, save with a new name, if you haven't already. Then, delete the header row & save the file as a CSV. The import will fail if you leave the header row. 
 Next open the file in Notepad to save it as a TXT document. If there are any rows at the bottom of the document that are just commas, delete them. Do not delete any commas at the end of rows with data. 
 Go again to AP / Tools / Import Invoices & choose your TXT file to import it. Once the import has completed successfully, you will need to post the module. 
 I use this method to import invoices for AR and journal entries in GL module. Works great & saves a lot of time!

Steve Reed · Answer

Go to Accounts Payable / Tools / Import Invoices. Click help and you'll locate the template. You may have to create a macro to run over your vendor invoice data to get into the template layout.

Kassy · Answer

You can also look into Office Connector. It is to create the template to upload into sage. It has some nice reports as well.

Sage Construction & Real Estate

Uploading Accounts Payable invoices from Excel or CSV templates

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING