FICA : FICA Summarized posting in FI clearing issue with bank clearing account

[devendarbukyaa]

Hello everyone, can someone share inputs on the below situation in S4 HANA?

Let us say, Businesses using the FICA module for

contract accounting. Customer invoices are posted in the FICA, for example, there are 10 customers, and each customer has 10 invoices, totaling 100 invoices.

Bank sending BAI2 payment information for 10 customer's payments to SAP for all 100 invoices. All 100 customer invoices ($1 X 100=$100) are cleared in FICA as per the payment instructions in the BAI2 file.

After payments are posted in FICA, a summarized

accounting document (SA) is posted in the FI (Example, 100 customer invoices are paid, and all items are summarized per each Bank clearing GL as $100).

Bank clearing A/C Dr $100

to FICA account A/C $100.

When the same BAI2 file is uploading in the FI (FF_5),

main Bank A/C Debited and Bank Clearing a/c is Credited for each payment, so a total of 100 ZR documents is posted.

For example, PAYMENT for one customer invoice 1= accounting document #1000.

Main Bank A/C Dr $1

to Bank Clearing A/C Cr $1

Invoice 2, Accounting document #1001

Main Bank A/C Dr $1

to Bank Clearing A/C Cr $1

Now, in order to clear SA Document's Bank clearing Debit item $100(Summarized for 100 customer payments) to ZR documents bank clearing Credit item $1 for 100 documents, this is failing as SA document is posted as summarized for 100 invoices ($1 X 100=$100) and ZR document as each and individual document for the $1, FF_5 process unable to identify individual items posted from FICA.

To handle this situation, do we have any standard SAP-supplied solution? Please share information. How System can identify FICA summarized $100 entry to each ZR $1 document and clear.

I am thinking of some logic implementation to have a common value in the SA document and ZR document. Example: assignment field with bank transaction ID, then clear from F.13

I hope, I summarized the case well, but let me know if you need any further questions to answer this case.

[former_member653300]

Hi Bukya,

I also have a same requirement, do u got a solution for it?

Do somebody share some suggestion over here.

It will be helpful for us.

[shah_viraj]

Hi,

If I understood your problem correctly, you require line item wise entry in the FI Bank G/L account, for each entry posted in FICA. As you are currently receiving summarized entries in Bank G/L account into FI from FICA, you are facing issue matching with the bank statement.

Solution to this is, to use Line item posting of payment document from FICA. Make sure to tick the check box of Line Item(DFKKZK-XEIPH) while posting payment from FP05/FP25. In case you are using FPCJ, make sure to tick the same check box at the time of withdrawal.

This will give you line item wise entry in FI Bank G/L account from FICA to FI instead of posting summarized entry.

Regards,

Viraj.