Automtic Clearing - FPMA Proportional Clearing Issue

[Former Member]

Hi Experts

We have a requirement to do proportional clearing when we use FPMA. Also the additional condition to satisfy is that it should do so in a manner such that the oldest due item is cleared first and anything which is left should be distributed proportionally

For example

15.01.2018 Due date I have $ 50 open item due

20.01.2018 Due date I have $100 open item due

20.01.2018 Due date I have another item due with $ 50

01.02.2018 Credit of -80

When we run FPMA the requirement is to clear the oldest due item first that is $ 50 then distribute proportionally the remaining amount of $ 30 as $20 and $10 to the respective open item which are due on 20.01.2018

I have tried quite a number of configuration settings but its is not working as expected

Any suggestions to achieve this will be very helpful

Best Regards

Varadarajan

[former_member199199]

Hi Varadarajan,

We have been able to address very similar requirement as you've given here, by creating custom FM (of TFK115) in a single clearing step. Please read the documentation of function module FKK_SAMPLE_TFK115; creating a custom copy of this and assigning in a clearing step would suffice your requirement.

Regards,

Bodhisattwa

[ChristinaHo]

Read KBA 1657731 - How to find Cookbook "Settlement Control".

In the mentioned IMG activity documentation you will find a lot of examples.

[Former Member]

Thanks Christina will check the above mentioned solution and see if it works

[william_eastman]

vadarajan:

you can either do proportionate clearing OR choose items based on age with configuration. You might achieve this with a custom grouping criteria to select the oldest item.

regards,

bill.

[Former Member]

Hi Bill

Thanks for the reply. When you are saying proportional clearing you mean the Clearing rule '1'. I have checked this but not able to achieve the oldest item clearing instead it clears each open item in proportion irrespective of the Item's due date.

Also when you say a custom grouping criteria to select the oldest item first does that mean to add Due date into the Grouping string?

Any help will be much appreciated Thanks in advance

Best Regards

Varadarajan B

[william_eastman]

correct. when you choose proportional then it would do it for all items of a group. a custom grouping would require you to create a custom function to choose your item - not using an existing grouping criteria since none of those would identify oldest single item

[Former Member]

Thanks Bill I will try the above mentioned solution and see whether it works