2024 Feb 19 10:49 AM - edited 2024 Feb 21 5:00 AM
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
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 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
Request clarification before answering.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.