Automatic clearing of customer open items updated ...
source link: https://community.sap.com/t5/financial-management-q-a/automatic-clearing-of-customer-open-items-updated-scenario/qaq-p/13677849
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
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.
Recommend
-
22
Fixing a common problem: not clearing a selected option before setting a new selected option keywords: javascript, jquery capture date: Fri Apr 5 01:11:42 2019 last updated: Time-s...
-
12
The argument against clearing the database between tests April 2020 Some reasons why you might not want to remove data from the database between automated tests: speed, correctness, data...
-
7
Clearing Mac Storage Space July 15, 2020 · 760 words · ~4 minutes to read I recently needed to clear a large amount of space on my Mac’s hard drive in order to install Windows...
-
5
Updated retention settings for the Recoverable items subtree As part of Message center post MC...
-
1
Atif Farooq July 21, 2022 6 minute read ...
-
1
Opening Statement The following document and the opinions expressed within are based solely on my own personal experiences working with multiple SAP customers over the years. Take guidance from my suggestions, but ultimately the end resu...
-
2
Updated repository size limits and automatic garbage collection November 02, 2022 < 1 min read Share
-
7
Apple Store App Updated With Improvements for Saved Items and Enhanced Store Information ...
-
0
Ken Barseghyan 1 minute ago Open items in the clearing account 4 Views
-
11
Mathieu Lawnik Mar 25, 2022 at 10:47 AM How to populate custom field for app Manage Customer Line Items ? 783 Views...
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK