AP Import Transactions window
You can import transactions into or generate transactions in an empty batch. You must set up, name, and place the file so it adheres to specific standards.
NOTE: You can only import or generate transactions in an empty batch. If you are in single-batch mode, you must post or clear any unposted transactions that are currently in the batch before you can import. If you are using multi-batch mode, you can create a new batch in which to import these transactions.
Column Position File (Fixed Length) 
Each field in the file you import starts at a specific position and contains a fixed number of characters. This file type is sometimes referred to as “fixed length.”
Tab Delimited File 
The fields in the file you import are separated by tabs.
Semi-Colon Delimited File 
The fields in the file you import are separated by semicolons.
Path/File 
You can type the path to the import file location or use the Browse button to locate this file.
Browse 
Use the ellipses button to browse for the file that contains the transactions you want to import. The browser that opens will search for a text file (.txt) or a file extension using the Company Code.
The file extension using the Company Code must be named APEXT.xxxxxx, where xxxxxx is your Company Code. For example, if the company code is DMOACT, then the file name would be APEXT.DMOACT. For more information about the formatting and placement of the import file, see Importing Accounts Payable Transactions.
Message 
The box below the import file types displays the transaction that is currently importing. This box also displays a message that indicates whether or not the import process was successful.
Progress 
The box below the message box indicates the progress of the import process by showing the percentage of the transactions that have been imported.
Begin Import 
Select this button when you are ready to import the transactions.
Published date: 12/03/2021