Import CSV File - APOHUTIN
The Import CSV File utility will load multiple invoices defined within an Excel file. The file data must be organized in a manner that will allow the system to successfully match data to the corresponding field. Organized data must follow one of two formats: the format defined on the AP Configure Import Templates (APOHUTCT) page (no column headings), or a user-defined file that uses column headings to thread data into BusinessPlus. See the Accounts Payable guide for additional information.
Name of the CSV file to import: Specify the name of the input file. If the file exists on the BusinessPlus host, then you can just enter its name in the field provided. If the file exists on your local PC, then click the ellipsis (Remote) button to locate & upload the CSV file.
Choose an import Template: From the drop-down list, choose the appropriate template for this file. Templates are defined in APOHUTCT. If the file contains the proper column headings and you do not wish to use a template, choose "0000 NONE."
Choose the type of AP set to create: If the "0000 NONE" template option is chosen, then you must provide the type of AP Set to be created. If a template was provided, then the template will determine which type of Set is created.
New Set ID: Enter a new Set ID. The interface will process the input (CSV) file and create a new Set with this ID.
Line Printer Copies, Name, Pri.: Choose or update the printer where the tail sheet from the interface job should be printed and the priority level. Content may default to preferences stated in NU Manage Users page.
If there are any errors encountered during the job, they will be printed on the tail sheet. A brief status report will also be printed at the end of the job to confirm the number of records processed and the AP Sets that were created. The resulting OH Set can be seen on the APOHBTUB page.