Greetings, All:
We are running Progression SQL 7.6.300C on SQL 2000.
One of my salesmen converted a quote to an order this morning and now we cannot find the order. We have looked in the open order, history and consolidated views and the order doesn't come up by order number. It also doesn't come up when using customer number. In the open order view it WILL come up by Item Number. But when you try to drill down on the Item Number, you get the message "No line items for this order".
I queried the ORORDHDR_SQL and ORORDLIN_SQL tables for the order number and it doesn't appear there so I don't believe it is an orphaned header or line record. When you run an audit trail report, it doesn't indicate the conversion from quote to order and simply ends with an ADD action on the line items. There are no DELETE actions.
Lastly, Multiple Level Item View is still showing an allocation for the order that is missing. But when you click the open orders button the order in question doesn't appear.
Can anyone shed some light on what may have happened? I couldn't find anything in the forum when I searched.
Thanks,
Chris Poulin
We are running Progression SQL 7.6.300C on SQL 2000.
One of my salesmen converted a quote to an order this morning and now we cannot find the order. We have looked in the open order, history and consolidated views and the order doesn't come up by order number. It also doesn't come up when using customer number. In the open order view it WILL come up by Item Number. But when you try to drill down on the Item Number, you get the message "No line items for this order".
I queried the ORORDHDR_SQL and ORORDLIN_SQL tables for the order number and it doesn't appear there so I don't believe it is an orphaned header or line record. When you run an audit trail report, it doesn't indicate the conversion from quote to order and simply ends with an ADD action on the line items. There are no DELETE actions.
Lastly, Multiple Level Item View is still showing an allocation for the order that is missing. But when you click the open orders button the order in question doesn't appear.
Can anyone shed some light on what may have happened? I couldn't find anything in the forum when I searched.
Thanks,
Chris Poulin