Deleted SO - Traceability

[Chris Kelleher]

Hello,

Using 8.6E and EDI...

We're facing a dificulty in what concerns the SO deletion:

when we delete a SO, completely or just a line there seems to be no record
of it.

This prevents us from refusing an order by EDI once there isn't any record
of it in the system.

Does anyone know if there is any kind of deleted orders record or how to
keep track of it?

Thanks in advance,

Mário Faria
Schlumberger Portugal

 

[Chris Kelleher]

Mario,

If you delete a sales order line item or a complete sales order there will
be not track of it, except for in the Transaction History transaction type
ORD-SO, if you have keep booking history in the sales order control file set
to Yes.

Do not understand what the relationship in your case is with EDI. Or at
least what you try to accomplish.

regards,
Danny Gaethofs
Origin QAD NL

 

[Chris Kelleher]

We wrote a Sales Delete trigger (both so_mstr and sod_det).

In the delete trigger, we said if the program name that is causing the
deletion is not your Invoice Posting program (after all, it's okay for that
program to delete sales order records), you capture whatever data you want
(order#, cust#, date, time, userid, #lines, etc) and create records wherever
you want (usrw_wkfl, aud_det, side table, etc). Then you can write
whatever inquiry/report programs to view that data, or use it in your EDI
processing.