GP 18.6.1695 (2023) Hung Quote from 12/31/99

  • GP 18.6.1695 (2023) Hung Quote from 12/31/99

    Posted by Clay Tait on May 8, 2024 at 8:09 pm

    First, thanks to Kerry and Jo for helping last time, I was unable to tag another reply to their inputs to thank them. So thank you both now.

    New Question, In smart list I have this one old quote that is not something we did – it just seem to have gotten there, I don’t know when, but it is there, and I can’t void or delete it. It says that this quote was POSTED ???

    It showes up in various Smart List reports as 33 lines of XXXXXX, XXXXXX and so on see attachment.

    And suggestions on how to get rid of this?

    Thank You.

    Jo deRuiter replied 2 weeks, 3 days ago 3 Members · 2 Replies
  • 2 Replies
  • Kerry Hataley

    May 9, 2024 at 6:15 am

    Good Morning Clay,

    So I want to say these are ‘orphan’ records, but the ‘XXXXX’ tells me it is from a ‘test’ print. I have NO idea how you got those inside SOP.

    Do you have an integration or were trying to develop one?

    OK, so my SQL side tells me you need to delete them from the following tables:

    You need to delete them in REVERSE ORDER to how DEX creates them…

    SOP10202 – SOP Line Comments

    SOP10106 – SOP User Defined

    SOP10200 – SOP Details Line

    SOP10100 – SOP Header

    REMEMBER – TEST in a <TEST> company first and make a backup…

  • Jo deRuiter

    May 10, 2024 at 10:28 am

    Clay, I am in full agreement with Kerry – If you remove those from the tables it will not show up any longer. Be very careful removing them and be sure to get it out of all tables.

Log in to reply.

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!