FICA to FICO Line item flow

[former_member392819]

Dear All,

I have a challenge in my current project for line items flowing from FICA to FICO.

My client uses FPCJ for posting receivables in form of Cash, Cheque and RTGS. By EOD, when user does "Post Withdrawal", the postings from interim account will be posted to Incoming Account and the same will be transferred to FICO as a bulk amount. But when I receive my bank statement, the statement will have a break up of payment where as my incoming bank account shows only one bulk entry.

How do I need to reconcile with my bank statement in this scenario?

what is the best practice followed in the industry in this scenario?

If I change my interim account to bank incoming account, what would be the impact?

Thanks in advance.

Regards,

Sravan

[AmlanBanerjee]

Hi Sarvan,

You can have different Cash desk clearing GL A/c for different payment categories in posting area 0160.

So at the FICA end, you will have a clear segregation of the payments coming from different payment sources.

Now as the incoming bank statement contains the split up based on the payment categories, you will be able to reconcile it.

Hope its clear now.

Thanks,

Amlan

[former_member392819]

Hi Amlan,

Does that mean, the reconciliation will happen between Cash desk clearing A/C (Created for bank) and bank statement?

Regards,

Sravan

[AmlanBanerjee]

Hi Sravan,

When using 'Post Withdrawl' functionality, for different payment categories,separate FICA documents are posted for each payment categories, under the same reconciliation key.

As per what I understood your requirement, you don't want to sum up the total against the bank clearing GL A/c when the reconciliation key flows to FI-GL and you want to have a separate FI Doc for separate payment categories so that it gets reconciled with the Bank statment easily.

To meet your requirement, you need to enhance event 0061.(copy of FM, ISU_ALLOCATION_EVENT_0061)

This event will be called during the creation of FICA doc for the 'Post Withdrawl' functionality.

In this event, you have the option to set the indicator FKKKO_CUS-XEIBH; if its set as 'X', then it would create a separate FI document when transferred to FI-GL.

Now based on the origin key, you can set this indicator FKKKO_CUS-XEIBH as 'X' and check the result at the FI end.

Hope it clears your query.

Thanks,

Amlan