I have a file from the bank where its seems to be a standard format.
This ia a AR type file.
One line has the check number, check amount check date and space for upto two separate invoices.
A second line has space for upto 5 more invoices.
As standard, the first line is proceeded by a flag, character '6'.
The 2nd line has a flag, character '4' to indicate its the 2nd line.

How do I configure EBS to handle this kind of lines from the input file?

Thank you

Hi,

can u show us a bank format what you are asking?

Lines begining with "6" has the check info and upto 2 invoices
Lines begining with "4" is optional. Can hold upto 5 more invoices for the same check.

Sample Data (some digits were changed):
6575002001432728703110090200391161848016089410020111012008415 11012008417
4575002601911012008422 3738Y 11012008414 11012008413

Field Name Size Position Data Sample
Type 1 1 6
batch 3 2-4 575
Item 3 5-7 002
Amount 8v99 8-17 0014327287
bank # 9 18-26 031100902
Bank Acct 10 27-36 0039116184
check # 8 37-44 80160894
check date 6 45-50 100201
Invoice 1 12 51-62 11012008415
Invoice 2 12 63-74 11012008417
Filler 6 75-80


Name Size Position Data Sample
Type 1 1 4
batch 3 2-4 575
item 3 5-7 002
type 1 8 6
sequence 2 9-10 01
indicator 1 11 9
Invoice 3 12 12-23 11012008422
Invoice 4 12 24-35 3738Y
Invoice 5 12 36-47 11012008414
Invoice 6 12 48-59 11012008413
Invoice 7 12 60-71
Filler 9 71-80