Skip to Content
Nov 24, 2009 at 11:19 PM

PP_ORDER archiving - force archiving of obsolete orders



This is the first time we're archiving production orders (pp_order). We have orders from 1995 thru 2008 that need to be archived. When I ran the preprocessing program, a great deal of orders (80%) did not get flagged for deletion because they either have non-zero balances, are partially delivered, or are partially confirmed. The orders don't exist in COGI anymore and have been cleared. These orders, however, did not pass the validation checks. Can you recommend a way to archive orders that don't pass the normal validation checks? I was thinking of creating a database update utility program to set the deletion flags and deletion indicators. I'm not sure if this is feasible though. Please advise.

Thank you!