Appendix > Appendix > Format Requirements for Importing Transactions > Order Entry File Format Requirements
Order Entry File Format Requirements
Before you begin the import process, you need to make sure the text file is in the proper format and that all required fields have entries. If the external file is properly formatted, it will help eliminate the possibility of errors. Be sure to use the formats provided here and not from the actual database files. In some cases, the text file format is modified when it is saved into the database; for example, the transaction types are saved as different numeric values than the text file reflects.
If errors occur, an Import Error Report will be generated and errors on the report will indicate exactly which transaction has the problem. This will help you to quickly identify them for correction. The tables contained in this topic provide the requirements for the external file that is used to import Order Entry transactions. After you import the transaction information from your external file, you can view the transactions in the Sales Order Entry window.
Published date: 06/04/2021