Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sales Order #00000000 1

Status
Not open for further replies.

bcygan

Technical User
Mar 24, 2006
20
US
We are running Progression 7.6.300b and somehow our customer service created a Sales Order #00000000. The order has since been recreated and billed out but now we have this order that cannot be deleted. Any ideas?
 
I have seen that only on one other site. You will need to delete the Order Header (OEORDHDR_SQL) and Order Detail(s)(OEORDLIN_SQL, if they exist) using MS SQL Query Analyser or Pervasive control center. Another method is to export the line and header (system manager), remove the approprate records with a editor and re-import the two tables. Make certain you have a proper backup of those tables before attempting..

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top