How to Remove Negative Entries from Customer Credit Master and SAP Table – S066 and S067
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.
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.
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.
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.
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.
SAP Lead Consultant in HCL Technologies Limited