Importing AP Data

SUGGESTED

I am wanting to import a batch of AP invoices into Sage 500 ERP from an excel spreadsheet.

If I were to use the Import AP data function of Sage 500 ERP and select Voucher Batch as the Import Target what is the file name that I will be importing data to ? Also, how can I find the record layout and field names of that file ?

Is there more than one database file affected when this "Import AP Data" function is completed ?

  • 0
    SUGGESTED

    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

  • 0 in reply to garmel

    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.

  • 0 in reply to garmel

    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 ?