What Are the Different Output Files?

The EFT processing creates flat files for a customer's account. These files are defined as a line delimited flat file with a line size of 100 bytes. They are designed like forms, with column headers, data, totals, etc.

Note: The output files are created by the system, but the AR user must transmit them.

The output files are sent electronically to a customer listing open or adjusted items. The totals will create a direct debit or credit to the customer's bank account.

There are three types of output files.

  • Notification flat files

  • Adjustment flat files

  • Payment files

Communication number

There are three communication methods for notifications and adjustments you can define: fax, EDI, and alternate EDI. These are maintained on EFT Notification (AR09.5). You can define the same or different communication methods for notifications and adjustments. A communication method is needed for notifications (pre- and final) and adjustment documents. If you the same communication methods for both, only one number is required. If you different methods, two different numbers are required.

The first line of the flat file is the customer's communication number. The format of the communication number depends on the default communication method defined for the customer on Customer (AR10.1). The table below describes the communication number types and formats.

File Position Type
1-95

Customer communication number formats.

  • Fax number - 15 characters

  • Fax extension number - 5 characters

  • EDI number - 15 characters

  • Alternate EDI - 95 characters
96-100

Customer communication type formats

  • FAX

  • EDI

  • User-defined alternate EDI type Example: EMAIL

Notification Flat Files

EFT Notification Print (AR105) creates flat file for pre- and final notifications for each customer.

File location File name

For UNIX platforms:

$LAWDIR/print/ username /ar105/1

For Windows platforms:

%LAWDIR%\print\ username \ar105\1

For IBMi platforms:

/LAWDIR / print / username /ar105/1

A combination of system date and time plus an ascending 8 digit sequence number.

Adjustment Flat Files

EFT Extract (AR110) creates a flat file for EFT adjustments.

File location File name

For UNIX platforms:

$LAWDIR/print/ username /ar110/1

For Windows platforms:

%LAWDIR%\print\ username \ar110\1

For IBMi platforms:

/LAWDIR / print / username /ar110/1

A combination of system date and time plus an ascending 8 digit sequence number.

The Lawson Software user is responsible to transfer the file from the Platform variable machine to the customer.

The client must have a program to read each file and, based on the first line communication number and communication type.

  • route the file to a Platform variable based fax server,

  • download the file to a customer,

  • route the file to an E-mail server, or

  • send the file to a third party for transmission.

Payment Files

EFT Payment Creation (AR115) creates customer payment records in an ACH format or a non-formatted layout. The ACH format follows the CCD (Cash Concentration Disbursement) requirements.

The Lawson Software user is responsible for the sending and receiving of the file to the appropriate bank or other receiver for funds transfer to take place.

File location File name
For UNIX and IBMi platforms:

$LAWDIR/ productline /work/ACHTAPE

/LAWDIR / productline /work/ACHTAPE

(ACH formatted output)

AR115ACHTAPE (for Customer Group processing)

EFTACH9999 (where 9999 is the Company Number being processed)

$LAWDIR/ productline /work/NONTAPE

/LAWDIR / productline /work/NONTAPE

(Non-formatted output)

AR115NONTAPE (for Customer Group processing)

EFTNON9999 (where 9999 is the Company Number being processed)

$LAWDIR/ productline /work/BACSTAPE

/LAWDIR / productline /work/BACSTAPE

(European format)

AR115BACSTAPE (for Customer Group processing)

EFTBCS9999 (where 9999 is the Company Number being processed)
For Windows platforms:
%LAWDIR%\ productline \work\ACHTAPE
%LAWDIR%\ productline \work\NONTAPE
%LAWDIR%\ productline \work\BACSTAPE