AccuImport

The AccuBuild Import Utility Program (accuimport.exe) which is used to import spreadsheet data into AccuBuild user batches. The import utility supports the following types of batch records:

Best Practices for Using the Import Utility - The recommended process for importing batch records from Excel Spreadsheets into AccuBuild is to make sure the user batch that you will be importing to is empty. This will allow you to print the imported batch as a separate set of entries once they have been imported so that you can validate the totals before posting the entries. The following information outlines specific business rules for each type of batch that is imported:

Import Utility Business Rules:

AP Payable Invoices

 Special Field Handling:

NA_NO – The Vendor Number field will NOT be validated during the import process so make sure that the Vendor Numbers that are included in the import spreadsheet are valid vendor numbers that already exist in the system.

INV_REF_NO – This field will be auto assigned based on the Next Invoice Ref No from the Payable

Properties Screen. This number needs to be UNIQUE for each entry and if a duplicate number exists, and error message will be displayed.

TRANS_DATE – This field will be set to the INV_DATE field during the import.

 Error Messages:

Error 7057: The record update failed. The key value produced from this record was not unique, and an index for the current table has the UNIQUE property. The key value supplied for APPJBAT:PRIMARY is not unique. Press Cancel to Cancel entire batch.

Press Cancel to abort the import and cancel ALL records OR click OK to ignore the record that is causing the duplicate error and continue importing the remaining records.

This error is caused by a duplicate INV_REF_NO number being assigned to the imported entries. Check the payable invoice batch to make sure the batch is empty before doing the import. Also check the AP Properties to make sure a valid entry exists for the Next Invoice Ref No field.

Equipment Journal Entries

 Special Field Handling: 

TRANSTYPE – The field must be a valid transaction type. Currently 40 = Depreciation.