SOP Order Not Moving to History – Not the Usual Solution

  • 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 12 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.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!