During our implementation, a little over a year ago, our consultants set us up with one vertex database. All of our sales orders, in both our CRP and Prod environment were hitting the same vertex database. Does anyone have an idea on how to clean up the vertex database and delete all the CRP test data out? We need to compare the F03B11 table to a table in Vertex. What common fields do you thin we should use? Has anyone ever had this same issue as we are experiencing?


Well Known Member
You don't have your system configuration in your signature. Perhaps you could give us a bit more information.

For Vertex Sales and Use, the only table that I am aware of that gets updated with JDE data is the REGPR00001. Delete all your records out of this table with SQL and you should be good to go (assuming your TDM database is accurate).

JD Nowell
OW: B7332
ES: AS400 V4R4 CO: DB2/400 SP: 11.2
Users: 250 TSE Users: 100