On Friday a Customer Service Rep asked me to check into an order that she had just entered.

The order number shows up as 00000000 (zero's). We cannot change the order number, we cannot delete the order. I thought maybe the posting procedure would clean it up on Friday but it did not. The order is still in the file.

Should I access the tables directly and delete the records or is there some way to clean this mess up?

Not sure how this happened but I would delete it in SQL management studio with queries.

not sure how this happened but I would delete it in SQL management studio with queries.

not sure how this happened but I would delete it in SQL management studio with queries.

DELEETE FROM oeordhdr_sql WHERE ord_no='00000000'
DELEETE FROM oeordlin_sql WHERE ord_no='00000000'
DELEETE FROM oelincmt_sql WHERE ord_no='00000000'
DELEETE FROM oeordinq_sql WHERE ord_no='00000000'
DELEETE FROM oepdshdr_sql WHERE ord_no='00000000'
DELEETE FROM oehdraud_sql WHERE ord_no='00000000'
DELEETE FROM oelinaud_sql WHERE ord_no='00000000'

Afterwards I would run a reset allocations

Note, I purposely misspelled "DELEETE" because it wouldn't let me make this post, probably some sort of security on the website thinking I am up to no good.