RE: Auto-Deleting Sales Orders

From: Matt Thomas

Date: 4 May 2005

We're using eB SP8 with Progress 9.1D all Windows (Char client) based.

Matt Thomas - Jamieson Laboratories
Programmer / Systems Analyst
(519)974-8482 Ext. 4254


-----Original Message-----
From: Bruce McIntyre [mailto:ae0b643c-b939-8280-de11-7003e487f4c5] 
Sent: Wednesday, May 4, 2005 10:41 AM
To: Matt Thomas; 
Subject: RE: Auto-Deleting Sales Orders


Please let us know what release of MFG/PRO and Progress you are using,
as there are alternative means to do this.  You do NOT want to
programmatically remove these records, as there are LOTS of traces that
would be left.

Bruce

--
Bruce A. McIntyre
ISS Group (http://www.issgroup.net)
Shaping Visions into Solutions
ae0b643c-b939-8280-de11-7003e487f4c5
V: 215.942.4718
F: 215.942.4962

-----Original Message-----
From:  [mailto:] On Behalf Of Matt
Thomas
Sent: Wednesday, May 04, 2005 10:34 AM
To: 
Subject: Auto-Deleting Sales Orders

Peggers,

	We're looking into automating the deletion of sales orders.
Reason being, we can't CIM a sales order delete because of the 'F5' key,
and it's very time consuming for our customer service people to, daily,
go in and manually delete the necessary sales orders.  We are wondering
if we can simply, from the back-end, using SQL queries, delete the SO
that we need to delete or are there many behind the scene processes tied
to deleting an SO that would cause problems if we simply deleted from
the so_mstr and sod_det tables?  Please let help us out.  

_____________________________________________________
 
Matt Thomas
Programmer/Systems Analyst
4025 Rhodes Drive
Windsor, Ontario N8W 5B5
(519)974-8482 Ext. 4254