on 07-30-2007 6:57 PM
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!
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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.
User | Count |
---|---|
96 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.