Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Don McCready]

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
——————————

[Don McCready]

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
——————————
——————————————-