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?
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?
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.
You can also look into Office Connector. It is to create the template to upload into sage. It has some nice reports as well.
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!
Kathy, Email me and I'd be happy to send you a color coded template. As Steve mentioned once the invoices are in excel you can write macros to do just about anything. Like copy and paste your credit card statements and run the macro to put the info in the right columns. Office Connector works well too, especially if you already own it.
Jenny-i am curious if you are able to assist me with this same issue? We have 200-300 credit card purchases each month. I have an assistant that manually enters these through AP/Tasks/Record payments by Credit Card. We then use Tasks/Verify Statement Balance to create an invoice for the monthly statement amount. We currently have 12 card users and frequently the executives (owners) do not supply receipts. She spends a ton of time chasing down information and entering purchases. We are using our bank's credit card platform and we have reached out to them for help. IF we can get the card users to start using the APP available, they can provide a report in a format we can then import. I do have Office Connector but i am not sure how to use it. What options do we have to streamline this process? Thank you for any input!
Susie, I have lots of questions. There are several ways to do this depending on how statements and invoices are routed. If you want to call me at 866-212-1208 I'm happy to give you my feed back and of course share the AP invoice import format in Excel.
I downloaded the AP template requirements and there are worksheets for invoices (API) and distribution (APD). How do you include the distribution with the associated invoice? Do you create one worksheet with lots of columns?
Hi Can I have someone reach out to me I have questions on how to enter credit cards transactions with job # and cost codes as well as GL #'s in AP without entering over 100 lines manually?
Allyson,
Please see my origional post above. If you email me at [email protected] I can send you a template for importing credit card entries and am happy to answer your questions. The process starts with importing AP invoices. There are two formats, "fixed" and "custom" based on your setup.
Jenny Evans
I tried downloading and it did not work for me. Did you download into excel?
Sorry for the delay in the reply - the email notices were going into spam.
You would need a row for the I data and a row for the D data. If there is more than one distributon for the invoice, you would have 2 D rows
Hopefully you can see the attached screenshot.
I only had the option to print the tempate information. I had to create the Excel templates manually based on the data in the printout.
Is the above screen shot the format?
Yes, that is the format I use. You also need to format the amounts as "numbers" without commas or parenthesis.
I'm in need of a file that would generate multiple invoices as well. If someone has a starting point that I could reverse engineer, I would greatly appreciate it.
*Community Hub is the new name for Sage City