AP Import Transactions window

AccountsPayableCS > Accounts Payable > Accounts Payable Bill Tasks menu > 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.