Technical Articles
How to Remove Negative Entries from Customer Credit Master and SAP Table – S066 and S067
Hello Everyone,
The following process will shed light on how to remove negative values shown in the Credit Management tables S066 and S067 and as well as shown in Customer Credit Master.
Problem Statement:
The issue is that negative values are shown in the Credit Management Tables – S066 and S067 – as well as in the Customer Credit Master. Due to this, the finance department of an organisation is not getting the correct credit exposure and details of open sale orders and deliveries of the customers. The system is allowing the creation of customer sale orders while the customer’s limit is over. Due to negative values, the system is not recognising the correct credit exposure.
Solution:
To overcome the above problem the following solution is as under to remove negative values from Table – S066 and S067 and also from Customer Credit Master.
Step-1: Run the standard program RVKRED77 in T code-SE38 and place the customer number in the field of Credit account as per the below screenshot.
Step-2: Go to Programme Menu—-> Click on Execute in Background as per the below screenshots.
Step-3: After clicking on “Execute in Background” the following screen will be displayed. On this screen, write “LP01” and click on the tick .
Step-5: After clicking on the tick on the above screen, the following screen will be displayed. In this screen, first, click on “Immediate”, then “Check” and finally click on the “Save” button.
Step-6: After “Save” on the previous screen, execute T code-SM37 to check the status of the Credit re-org running programme. After executing T code-SM37, the following screen will be displayed, and click on the “Execute” button.
Step-7: After executing the button on the above screen, If the status of the program/job shows “Active”, on the next screen then press the “Refresh” button on the upper left-hand corner of the screen. If the status shows “Finished”, it means the job has been completed successfully.
Step-8: When the status is “Finished” as per the above screen, then execute program RVKRED88 in SE38, to fetch the details of open orders and delivery. Please put the customer number and press on the “Execute” button as per the below screenshot.
Step-9: After executing the button as per the above screenshot, the detail of open orders and deliveries will be shown related to the customer.
To Conclude:
Once the above steps will be executed successfully the business will get the correct credit exposure of the customers to avoid any dispute in the future related to over-invoicing due to wrong credit exposure.
Suggestion:
To avoid any risk in Production system, instead to run both programs RVKRED77 & RVKRED88 directly in SE38, business can make Z T-codes to run this program in production system and give authorization to respective user for these T-codes to run these program.
Please follow Neeraj Jain for more content on issues & topics related to SAP Sales & Distribution and Material Management.
If any questions please click here
Thanks for your interest! Please share feedback, comments or suggestions below.
Best Regards,
Neeraj Jain
SAP Lead Consultant in HCL Technologies Limited
Informative blog
Thank for supporting and commenting...
Well described the process.
Thanks for your words!
Very reliable and great explained the solution ..... really helpful.
Thank you Sanjeev for comment and support...
Regards,
Neeraj Jain
Very useful
Thank you for commenting and support....
I know very little about the Credit side of SAP. I do however, know this is a great first blog. I love the step by step example. That sure helps me. There are times when I am developing things in areas I'm not sure of. I come back to blogs like this one to get me through issues!
Bookmarked it for possible future use. Glad to see in you in groups.
Thank you!
Michelle
BTW - My first blog I was running around showing it to people who didn't even know what a computer was - at times. OK that was my Grandparents. It was very a special time for me.
Keep them coming.
Thank you Michelle Crapo for your comments and supporting...your words are appreciated and also motivate me in future to post more blogs like this.
Thanks & Regards,
Neeraj Jain
Informative !!
Thank you!
Very well explained
Thank you!