Clearing Through Incoming payments

[Former Member]

Hi experts,

We have a business scenario where clearing through incoming payment need to be done on FIFO basis, that is, receivable with latest due date will get cleared first. But simultaneously, in the case of instalment plan, clearing should be on the basis of LIFO, that is, instalment amount with oldest due date with get cleared first.

For this we have created a Incoming payment clearing variant where we are grouping by contract account and sorting by due date(descending).

Another clearing variant for instalment plan has been created where items are sorted according to due date(not descending).It was copied from standard variant for instalment plan 20R.

Then we have assigned these variants in the path : Define Specifications for Clearing Types / Define Defaults for Incoming Payments.

For clearing type 19 (Cash Desk: Payment), we have assigned the clearing variant created on FIFO basis and assigned the clearing variant created on LIFO basis as Aletrnative clearing variant.

In the path Define Defaults for Collective Invoice/Installment Plan/Summarization Group, we have assigned the clearing variant created on LIFO basis.

But we have observed that at one time, only one clearing method is working, that is either on LIFO or FIFO basis(whichever has been assigned as alternative clearing variant for Clearing type 19.

Is there any way to achieve the specifications of our business scenarion, i.e, clearing on LIFO or FIFO basis depending on whether it is instalment plan or not?

Thanks in advance,

[AmlanBanerjee · Accepted solution]

Hi Saustav,

I would suggest you to have only one clearing variant which will incorporate both the scenarios for clearing and then assign it to the configurations for Define Defaults for Incoming Payments.

To elaborate, I would recommend to configure two clearing steps in one clearing variant rather than two separate clearing variants.

So,to proceed with the clearing variant, I would suggest you to keep the FIFO clearing approach as it is thru standard configurations in the first step.

In the next step for the LIFO clearing approach for Instalment plan, first group by main transaction and Doc no. and then Sort by main transaction and due date.

In the Group rule, use value 8 and plug in a custom FM.

This custom FM will filter the Instalment plan Items based on the doc type, Main Trnsaction and due date , then sort FKKCL_E115 structure by ascending due date and flag the value

Y_GEN_CLRG_PROPOSAL.

Also, you need to take care of a scenario, where in an Instalment plan and an another open debit item exists simulataneously and payment comes in.....then which one will be cleared first?

Hope it helps....

Thanks,

Amlan

[Former Member]

Hi Amlan,

Thanks a lot for your answer.

In the Grouping rule after using value 8, can you please mention the name of the standard FM from which we will copy and make a custom FM.

[AmlanBanerjee]

FKK_SAMPLE_TFK115 is the FM which you have to copy for the purpose,

Cheers,

Amlan

[Former Member]

Hi Amlan,

Thanks again.. This works perfectly

Regards,

Saustav