FPB3 Transaction

[Former Member]

Hi All -

The FPB3 transaction for processing and uploading bank lockbox files has a default file format. Does thie file format have a name for it that we can tell the bank (our lockbox processor)? They are asking if it is a standard format.

For example in FI A/R module the bank lockbox transaction FLB2 will automatically process the BAI2 format with no changes. So the BAI2 is the format name we would give the banks if they asked. The BAI2 is a pretty standard format that a lot of banks support and has good documentation around this format.

Thanks in advance for taking the time to answer.

Regards,

Pradhip.S

[AmlanBanerjee · Accepted solution]

Hi Pradhip,

I dont think there is any definite file format name for processing and uploading payment files through FPB3 (Progarm name-RFKKZE00).

For processing a file through FPB3, the following conditions should be met-

(a) All fields must have character format.

(b) Every line can only contain one structure.

(c) One file header record (BFKKZG00 structure) per file.

(d) One payment lot header (BFKKZK structure).

(e) Any number of items (structure BFKKZP).

(f) Data for any number of lots in a file can be included; however the lot header must be specified first, and then the related line items.

For your requirement, one approach can be requesting the bank to send the payment file in a normal format.

At your end, you develop a program which will reformat the bank file into a file which will be accepted by FPB3 taking into consideration, the above conditions and other valiations (if any).

Once done, call the standard program RFKKZE00 which will create the payment lots and post the amounts to the customer accounts.

Hope it helps....

Thanks,

Amlan