Discussions – Dynamics GP – Dynamics Communities

SOP Order Not Moving to History – Not the Usual Solution

Tagged: SOP, sop invoice, sop-entry

Dynamics GP

SOP Order Not Moving to History – Not the Usual Solution

Posted by Jim Lines on November 1, 2023 at 12:59 pm

I have an SOP order that was transferred to an SOP invoice and have two problems.

1. An “on account” amount was applied to the Order. The invoice, for the full order, has been posted and in history, but did not carry over the deposits from the Order (I cannot confirm if the user marked the option when they transferred). Does anyone know if there’s a way to find out? I think it may be in temp tables. I’ve run reconcile/remove on the invoice with no luck.

2. The order is still open even though it’s been fully fulfilled and transferred. I’ve tried all the usual steps in my test company. Reconcile Sales Docs, Remove Completed Docs, Checklinks on all the usual tables. But the order remains “In Process” (SOP10100 SOPSTATUS = 8). I tried to manually change the SOPSTATUS to 9 (Complete), but when I reconciled the order again, it changed it back to In-Process.

Any help is appreciated. Thanks!

Notes:
GP 18.2

Jim Lines replied 1 year, 11 months ago 2 Members · 2 Replies
2 Replies

Chris Donnelly

Member
November 6, 2023 at 10:11 am

Up
0
Down
::
Jim,

Since you’ve got some SQL skill, this trick might work for you. If you can… void the sales order. It should go to history (as voided). Update the void status in SQL.

Good luck.

Chris
Jim Lines

Member
November 6, 2023 at 10:54 am

Up
0
Down
::
Chris, Thanks for the suggestion. I’ll run it through my test company and see what happens. Jim

The discussion ‘SOP Order Not Moving to History – Not the Usual Solution’ is closed to new replies.