Open Forum

Expand all | Collapse all

Need to remove a "rogue" sales order

Jump to Best Answer
  • 1.  Need to remove a "rogue" sales order

    TOP CONTRIBUTOR
    Posted May 15, 2019 07:37 PM
      |   view attached
    Hi All,

    We have a sales order in GP2018 that shows up in the SOP Inquiry window (see screenshot) but not in the Transaction window where it could be dealt with.  It has no dollar amounts and is not a valid order.

    Checklinks does not remove it.  The Reconcile utility just indicates "This document could not be accessed" and does not remove it.

    What SQL table(s) do I need to remove it from?

    Thanks!

    ------------------------------
    Don McCready
    Retired Controller and IT Director
    The Schaefer Group, Inc.
    Beavercreek OH
    ------------------------------


  • 2.  RE: Need to remove a "rogue" sales order
    Best Answer

    TOP CONTRIBUTOR
    Posted May 15, 2019 08:15 PM
    Gang,

    Found my answer.  SOP10100 was the table where the record had to be removed.  I kinda feel like I hollered before I was hurt.  :-)

    Thanks,

    ------------------------------
    Don McCready
    Retired Controller and IT Director
    The Schaefer Group, Inc.
    Beavercreek OH
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role