Automatic clearing of customer open items updated scenario

[Shubham2201]

Hi Experts,

My client wants to clear open customer line items through the FIFO process using automatic clearing on the basis of sorting it according to Profit center and date using standard SAP process. i.e. the system should automatically identify the older invoices and clear the earlier invoice first according to profit center and date wise in standard SAP system And partial  clearing is not permitted. Currently they are doing it manually through F-32 and tracking through excel.

Case 1


If a company has 5 invoices from December 2023 to February 2024 in the following sequence i.e  

• 15th December 2023 Rs.5000 invoice in Profit center TTM1, 
• 18th January Rs.3000 in Profit center TTM2 
• 13th February 
• Rs. 6000 invoice is raised in Profit center TTM1 invoice 
• Rs.4500 invoice in Profit center  TTM1 
• RS 1500 invoice is raised in Profit center TTM2 is generated

On behalf of these due amounts, the customer pays  a  lump sum amount of Rs. 11000 in profit center TTM1, 

Then the system should automatically adjust first two complete invoices which are older

•  i.e. of date December 5000 of Profit center TTM1.
•  and January of Profit center TTM1 of Rs. 6000 of Profit center TTM1 

Note - As no partial clearing is there in this case.

Case 2

If a company has 5 invoices from December 2023 to February 2024 in the following sequence i.e. 

• 15th December 2023 Rs.5000 invoice in Profit center TTM1, 
• 18th January Rs.3000 in Profit center TTM2 
• 13th February 
• Rs. 6000 invoice is raised in Profit center TTM1 invoice 
• Rs.4500 invoice in Profit center  TTM1 
• RS 1500 invoice is raised in Profit center TTM2 is generated
  
  

On behalf of these due amounts, the customer pays a lump sum amount of Rs.7000 in Profit center TTM1. 

Then the system should sort invoices according to invoice dates i.e. from December 2023 to January 2024 and Profit centers TTM1 

• i.e. of date December 5000 of Profit center TTM1 only.
• The next invoice is of 6000 and it cannot be cleared partially. 
• So system it will accumulate amount for next payment to get this invoice clear fully

On the basis of this scenario, can anyone suggest a guided solution as I am not getting proper results in F110 for customers using Profit center field and in F.13 also.