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! 

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?

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?

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.