BAI2 file format- 4 record

[former_member857785]

Hello SAP Guru's-

In testing the lockbox functionality, I have a client who has a customer that remits with over several hundred line items in one check. In the 4 record, the bank sent me a file with the following format

Record Type 4

Batch Number 001

Item Number 001

Overflow Type 4

Overflow Seq Nbr 01 to 99 then start 01 again

Last Ovfl Flag 9 (on last record)

On the Overflow Sequence number, when they got to 99 they started over to 01 on the next line item. Is this correct? I understood that they should change the overflow type from a 4 to a 6 and restart with a new 4 record?

Please help!

I will AWARD POINTS.

Many thanks!

[Former Member · Accepted solution]

Hi,

Please go through the following regarding Record 4 for BAI2 file format:

-

---

<i>Record 4: Table FLB24

4002003401716000002 00000100000000000000

4002004402918000018 00001000000000000000gh

• The item in blue is the Record Type indicator. Record Type 4 can appear numerous times in the Lockbox file. Record 4 is the “Item Record” and it is used to hold one invoice each. (Field name OR001)

• The item in green is the Batch Number for the Lockbox. This item will have 3 characters. (Field name OR002)

• The item in red is the Batch Item Number for the Lockbox. This item will have 3 characters/spaces. (Field name OR003)

• The item in purple Type of Overflow record (1 space). In this case, it is a ‘4 record’ because it contains only its own item, not an item overflowed from a preceding 6 Record. (Field name OR004)

• Bright green is the Sequence Number for the record (2 spaces). (Field name OR005)

• The item in yellow is the End Indicator for the Lockbox. A ‘9’ indicates the last record of a Lockbox (1 space). (Field name OR006)

• The next items in black are the Invoice Numbers (16 characters/spaces each). Only 1 invoice is placed into each 4 Record. (Field name IVCNR) The best field format convention would be to use left-justification, blank-padding right for the invoice number(as shown in the Record 4 above).

• The items in dark yellow are the Payment Amounts per invoice (10 characters/spaces). (FiT)

• The items in gray are the Deduction Amounts per invoice (10 characters/spaces). MT)

• Dark Blue is the External Reason Code for the payment. (Field name RESTG)

• Up to the next 30 character spaces are available for short text. They may be left blank if desired. (Field name OR011)</i>

-

---

In BAI2 overflow type is not changed, 4 is correct. Only in BAI format it is changed.

Thanks

Murali.

[former_member857785 · Accepted solution]

Thank you Murali but what should happen if we have a file that has several hundred 4 records for one 6 record?

The bank provided me a file that when it reached 99 in overflow sequence number, the next 4 record was 01. Is this correct? Can I send you the file for you to review?

Thanks Murali

MORE POINTS AWARDED

[former_member857785 · Accepted solution]

Murali-

This is what the file looks like:

4003001494099005472 2 00000000000000015323

4003001495099006217 2 00000000000000010679

4003001496099006357 2 00000000000000012941

4003001497099006477 2 00000000000000007247

4003001498099006860 2 00000000000000002999

4003001499099007097 2 00000000000000039488

4003001400099007119 2 00000000000000020330

4003001401099007158 2 00000000000000066646

4003001402099007235 2 00000000000000011843

4003001403099007478 2 00000000000000006075

4003001404099008243 2 00000000000000006760

4003001405099008369 2 00000000000000021730

4003001406099008524 2 00000000000000017742

See what I mean? It goes on for several pages and when it goes to 99, it starts back to 01. Will that impact the file in a negative way?

THANKS

[Former Member · Accepted solution]

Hi,

I don't think it will have any impact. Basically, it is only two characters field, so it cannot be increased.

In fact while processing the Lockbox file in SAP, some of the fields are not considered in SAP. You can do two to three rounds of testing in test / quality with this scenario.

Thanks

Murali.