Welcome, Guest
Username: Password: Remember me

TOPIC: 0 order number?!

0 order number?! #2978

  • kskipper
  • kskipper's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 30
  • Thank you received: 1
  • Karma: 1
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?
The administrator has disabled public write access.

0 order number?! #2987

  • dgillz
  • dgillz's Avatar
  • OFFLINE
  • Platinum Boarder
  • Posts: 395
  • Thank you received: 14
  • Karma: 6
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.
www.gainfocus.biz
Worldwide support for Macola Progression, Macola ES, Synergy, Event Manager and Crystal Reports.
Last Edit: by dgillz.
The administrator has disabled public write access.
Time to create page: 0.034 seconds
Powered by Kunena Forum  Protected by R Antispam