Skip to Content
0
May 24, 2018 at 02:29 AM

Proportional Clearing FPMA - Not happening

107 Views Last edit May 24, 2018 at 02:31 AM 2 rev

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