Clearing control

[kiran_kumar188]

Client requirement,

Open items clearing strategy should be last in first out

Example: - open items Due dates 20.04.2010 - 1000

20.05.2010 - 1500

20.06.2010 - 1700

Payment received on 15.06.2010 amount of 2000/-

Generally SAP system will clear 20.04.2010 amount 1000/- and 20.05.2010 1000/-, but client donu2019t want this method he want to clear first current month invoice should be clear like 20.06.2010 amount 1700/- and after that if amount left it should be clear outstanding amount like 20.05.2010 amount 300/-

or we have to use any bapi or event to do this transactions.

Please let me know how to do this configuration please

Thanks for the support

raj

[Former Member]

Check your clearing variant and steps and sort descending in your steps.

[AmlanBanerjee · Accepted solution]

Hi,

Go to the following path in SPRO-

IMG->Financial Accounting (New)->Contract A/c AR & AP->Basic Functions-> Open Item Mgmt->Clearing Control->Define clearing variants

Create a new variant and a clearing step.

In the clearing Step,in the sorting characteristic, choose "Due date with Deferral" and tick the sort check box.

Hope it helps....

Thanks,

Amlan

[former_member190606]

Hi raj,

All you have to do is make a clearing variant that clears item on FIFO basis and then just check the 'sort' checkbox. This will make your clearing variant to act on LIFO basis.

To create clearing variant for FIFO just create a new clearing variant, create 1 step and then add due date in the sorting characterstic. thats it!

hope that helps!

Regards,

Adil Kapadia