AR Payment Import

Use the AR Payment Import (E820I) program to import customer payments from an ASCII file.  If there are no errors imported payments are automatically transferred to a cash receipts payment batch for updating in Cash Receipts Entry (RCE) if there are no errors. If there are errors in the transactions, the information is stored in a holding file where it can be viewed and corrected or deleted with EDI 820 Maintenance (PRCE) before it can be processed. See Background for more information.

  1. Enter data in these fields:

Field Name

Type / Max Length

Action / Description

Name of file to import

Required
45 alphanumeric

Enter the name of the file (up to 8-characters) if it resides on a native disc or enter the full path name including the file extension (e.g., C:\My documents\CMX.XML or U:\IMPORT\VMX.XML where U: is a mapped network drive) if the file is on your PC or network.

If the PC file is not found or if the file resides on a native disc, the program prompts to check for a sequential file. Click Yes if you entered the file name correctly or click No to re-enter the name of the file to import.

By default, the last file imported is displayed. To exit to the menu, clear the field and press Enter or Tab.

Name of batch file

Required
5 alphanumeric

Enter a batch name for this file. This name is associated with this file until import is complete.

D=Delimited or F=Fixed length

Required
1 alphanumeric

Select D if the file uses a delimiter or select F if fields are a fixed length.

If you import data from an ASCII file generated from Microsoft Excel, fields are a fixed length.

Field delimiter

Conditional
1 alphanumeric

If you selected D for D=Delimited, enter the field delimiter used in this file; for example T for tab, a ; (semicolon), or a , (comma).

Qantel Technologies recommends the semicolon delimiter because address and comment fields can include commas.
If the EDI Payment Log reports the Invalid record type message for every order header and line, you entered the wrong delimiter.

Default branch

Required

The default branch may be used as part of the criteria that determines GL posting accounts (maintained in Posting Criteria Maintenance).

Erase import file when done?

Optional

Select to erase the file after import or leave blank to retain it.

  1. Click OK when you complete data entry or click Cancel to exit the program.

If you click OK, the program displays the message Checking import file for structural integrity. When the processing completes, the program exits; the EDI administrator email address (specified in Drop File Interface Options - EDI 820 system options) is sent the EDI Payment Log and, if there are errors, the AR Pending Payment Error Report.