As I know Import AP Data does not support importing from Excel and you may need to prepare special flat files (ASCII or Delimited) to import from. You can find the format of those files in help topics of the AP Import. Open the AP Import program and click "Help" button in the toolbar. Then select the help topic about Importing Pending Vouchers. Contact your reseller or me if you have further assistance for converting Excel to a special file for import.

Garik Melkonyan

www.garikmelkonyan.com

As I know Import AP Data does not support importing from Excel and you may need to prepare special flat files (ASCII or Delimited) to import from. You can find the format of those files in help topics of the AP Import. Open the AP Import program and click "Help" button in the toolbar. Then select the help topic about Importing Pending Vouchers. Contact your reseller or me if you have further assistance for converting Excel to a special file for import.

Garik Melkonyan

www.garikmelkonyan.com

We utilize DataPorter to import AP data from Excel.  Under System Manger<Tools<User Preferences you need to check the box under Preferences called "Show DataPorter on Toolbar".  We worked with our reseller to set everything up.  We also utilize this for JE's and PA entries as well.

Thank you. I've found the field layouts in "Importing Pending Vouchers" but what are the actual file names for the Voucher Batch, Voucher Header and Voucher Detail Record Layouts ?