Skip to Content
Technical Articles
Author's profile photo Neeraj Jain

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-4:         After clicking on the tick on the previous screen, the following screen will be displayed, also on this screen click on the tick icon.

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

Assigned Tags

      10 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Gopesh Kumar Agrawal
      Gopesh Kumar Agrawal

      Informative blog

      Author's profile photo Neeraj Jain
      Neeraj Jain
      Blog Post Author

      Thank for supporting and commenting...

      Author's profile photo Nirbhay Jain
      Nirbhay Jain

      Well described the process.

      Author's profile photo Neeraj Jain
      Neeraj Jain
      Blog Post Author

      Thanks for your words!

       

      Author's profile photo SANJEEV PANDEY
      SANJEEV PANDEY

      Very reliable and great explained the solution ..... really helpful.

      Author's profile photo Neeraj Jain
      Neeraj Jain
      Blog Post Author

      Thank you Sanjeev for comment and support...

      Regards,

      Neeraj Jain

      Author's profile photo Ajay Verma
      Ajay Verma

      Very useful

      Author's profile photo Neeraj Jain
      Neeraj Jain
      Blog Post Author

      Thank you for commenting and support....

      Author's profile photo Michelle Crapo
      Michelle Crapo

      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.

      Author's profile photo Neeraj Jain
      Neeraj Jain
      Blog Post Author

      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