cancel
Showing results for 
Search instead for 
Did you mean: 

Automatic clearing of customer open items

Shubham2201
Discoverer
0 Kudos

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.

Case-1


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

  • 15th December 2023 Rs.5000 invoice in Profit centre 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 TTM2 is generated

 

On behalf of these due amounts, the customer pays  a  lumsum amount of Rs. 9000, then the system should automatically adjust first two complete invoices which are older i.e of date December and January of Profit centre TTM1 of Rs. 5000 and Rs. 4500 of Profit centre TTM1 and clear both the invoices.

 

Case 2

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

  •  on 15th December 2023 Rs.5000 invoice in Profit centre TTM1
  • 18th January Rs.3000 in Profit centre TTM2 & Rs.6000 in Profit centre TTM1
  • 13th February Rs.4500 invoice in Profit centre  TTM1 & 1500 in Profit centre TTM2

On behalf of these due amounts, the customer pays a lumsum amount of Rs.14000 then the system should sort invoices according to invoice dates i.e from December 2023 to January 2024 and Profit centresTTM1 & TTM2 i.e Rs. 5000, Rs. 3000 and Rs. 6000.


Please help me solving this issue.
Thanks




Accepted Solutions (0)

Answers (2)

Answers (2)

rhoresh1
Explorer
0 Kudos

Hi,

Yes, it's possible. We've created an automation that helps the F.13 (automatic clearing) work better.

In our case, we based the clearing on a variable of the FI doc.

However, you can add a rule that is based on date.

We used InsightZAP in the process. 

sanilbhandari
Product and Topic Expert
Product and Topic Expert
0 Kudos
Hi Do you have profit centre filled in Customer/vendor line items in entry view of FI Document?
Shubham2201
Discoverer
0 Kudos

Hi thanks for help actually the scenario is bit complicated awhich I have updated in the post can u please go through the scenario and let me know if it will work for the scenario 
@sanilbhandari  I have profit centre in the FI Document

sanilbhandari
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi @Shubham2201 

The below OSS Note should answer your question:

2403746 - Profit Center field for vendor or customer clearing - SAP for Me

Please check your underlying data first.

Thanks & regards

Sanil Bhandari