It is often desirable to generate transactions in another application and import them into ACCPAC, where the complete suite of accounting functions is available. This enhancement imports transactions into Accounts Receivable from other systems. It provides a database format to which the data must conform. Reports have been added showing the data to be imported as well as erroneous data that is not suitable for import.

Before the update process is started the program will review the import database and remove all records that have already been imported successfully. Any reports on the import status should be run prior to importing again.

Several fields are required for the system to be able to import. Other fields are optional and will be used if they are in the database. For example, the customer number is mandatory or the invoice cannot be completed. If an invalid customer number is used the system will not process the record and will return an error that says "No customer Number" or "Invalid Customer Number".

If a field is included in the database that is not required, and it is included on the list below, it will be used instead of system defaults. For example, the item description is not required. If it is not used in the database it will be automatically extracted from the item file. The customer terms are not required and would be extracted from the customer file.

The invoice number (INVNO) will be generated automatically by the system. If one customer's records should be divided into several invoices, make sure each of the records to go on each invoice has a separate number. The system will still assign new numbers but the old invoice number will determine which records go on which invoice. If the invoice number field is not used, or left blank, each customer will receive one invoice.

• CUSTNO
• ARTYPE - if left blank it will be a regular invoice ITEM
• QTYORD
• QTYSHP

OPTIONAL FIELDS

• INVNO
• GLAREC - GL Sales linking code - customer & Item records.
• GLASST - GL Asset linking code - customer & item records.
• PDISC - Customer record.
• PDAYS - Customer record.
• PNET - Customer record.
• TERR - Customer record.
• TAX - Customer record.
• REFNO - Payment reference, blank.
• CHKNO - Payment reference, blank.
• SHIPVIA - "Delivered"
• FOB - "Origin"
• PONUM - "Verbal"
• ORNUM - "None"
• PTERMS - Customer record.
• ORDATE - Current Date.
• SALESMN - Customer record.
• PRICECODE - Customer record.
• TAXDIST - Customer record.
• PAYMENT - Payment on this invoice 0.00
• INVDTE - Current date.
• TAXCODE - From invoice taxrate
• PRICE - Item record.
• DESCRIPTION - Item record.