Prevent Partial Clearing of Single Line Item

[Former Member]

Hi Experts,

Kindly provide the solution for below FI-CA scenario: -

1. There are 3 receivable in FPL9 e.g. 1) Rs. 100, (2) Rs. 200 and (3) Rs. 300 = Total = Rs. 600

2. Posting date of above receivable docs are  (1) 01/01/2012  (2)  02/02/2012  (3) 03/03/2012

3. Payment on Account is of Rs. 550.

4. Clearing rule is set as First In First Out

5. As per the clearing rule doc. (1) and (2) will be completely cleared but doc (3) will be partially cleared i.e. rs. 250 and rs. remain as due/overdue

I need solution for how we can block partial clearing of any single line item: i.e. after FPMA, payment on Account remains as Rs. 250 and Receivable doc (3) remains completely uncleared.

[AmlanBanerjee · Accepted solution]

Hi Pankaj,

Are you only looking for the partial clearing block through FPMA, i.e. in the auto clearing process?

What about the scenario, where there are outstanding open items and payment comes and gets posted in in SAP and clears the outstanding Open items....

Moreover, if you are only concerned with FPMA and want to block the partial clearing, you have to make changes in the clearing rule under the clearing step for the clearing variant that has been assigned for auto clearing.

Also, you can also have a look at the event 590 through which you can exclude items from automatic clearing.

Hope it helps..

Thanks,

Amlan

[Former Member]

Dear Amlan,

Thanks for the reply.

I am only concerned about FPMA. As per current system settings for my client, all the incoming payments are posted via FP05 or FP25. In this case payments are posted on Account only it is not clearing any due or overdue line item. We need to perform FPMA for auto clearing.

Clearing Variant is maintained as per due date sorting criteria (First In First Out). Now i am struggling to make necessary Config if the last line item which is going for partial clearing should be blocked for clearing and balance credit items remains on Account (as explained in exaple secanrio).

When i am maintaining Amount Rule as "1 - Partial Clearing Not Permitted" under clearing steps it is not clearing any item.

Kindly provide the necessary config settings for this.

Regards,

Pankaj

[AmlanBanerjee]

Hi Pankaj,

I dont think that, you can block the partial clearing through standard configuration.

However, you can do it through enhancements.

Option-1- In the last clearing step, set the amount rule as blank and clearing rule as 8, and plug a custom FM by copying the standard FM FKK_SAMPLE_TFK115.

In here you can insert a check, if there is any partial clearing and then you can delete the items from the T_FKKCL_E115 table.

Also set the end of assignment value as 9.

Option-2- If you don't want to change the clearing steps, you can also block the partial clearing through event 590. This event is called before the clearing control and in here you can exclude items from the automatic clearing.

Plug in a FM which will first check the total debit items with the total credit items available for clearing.

If the total debit items > total credit items, then sort all the debit items by posting date.

Now, compare it with the credit ones to check which on would get partialy cleared and then initilaize field XAKTP_0590 in the table of items (T_0590),to delete the item.

Clearing control is then only called and automatic clearing carried out for the remaining items.

Hope it helps...

Thanks,

Amlan

[Former Member]

Thanks a lot Amlan.

I will follow the steps provided by you. Hope it will solve my purpose.

Regards,

Pankaj