Hello Jim -- I run a report provided by SAP to figure out what entries in s066 and s067 that are inaccurate.
1) Run Report z_credit_value_compare to figure out what account is inaccurate in production.
-- This report submit rvkred07 to get the account number in production. However it will skip customers that are on hold for credit or delivery block.
-- It will pull in the database values from delivery, invoice, and order to compare with so66 and s067 table.
2) Take the account number from z_credit_value_compare and input it into rvkred88 to simulate the repair time in production.
3) Get quite time from basis and run rvkred77 to fix the in accurate entries.
Sorry about the vague question from the first post.
I was trying to figure out a better way to validate s066 and s067 and wanted to know what people are doing elsewhere to fix inaccurate data in s066 and s067. Because rvkred77 locks table vbak, likp, and vbrk, it has to run during system down time and this is a pain to run weekly.
Please let me know if you have implemented a better solution to this issue.
Thanks.
-Tung
| | | ---------------Original Message---------------
From: tung ho
Sent: Thursday, July 21, 2011 2:28 PM
Subject: How do i verify the entries in table s066 is accurate with open sales order
How do i verify the entries in table s066 is accurate?
Can i use va05 and list all open sales order for a date range to verify again the entries in s066 table for a customer? |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| | Popular White Papers
In the Spotlight IBM Helps Clients Exploit the Power of Cloud Computing. Click Here for IBM's Cloud Computing Virtual Briefing Center.  _.____.__ |
