Sage 100

 View Only

  • 1.  SO_SalesOrderHeader record disappearing

    Posted 08-24-2023 10:22

    Has anyone experienced this?

    Sales Order created with all drop ship lines. PO generated for SO, writes back PO numbers to SO, etc. Then when they are ready to invoice the drop ship, the SO number is not available from SO Invoice Data Entry. If they go back to Sales Order Entry & key in that number, they get "This Sales Order number entered already exists in the History file", but if you look at it in SO History Inquiry, it shows "Active Order". If I look at it in SQL, the SO_SalesOrderHeader record is gone, but the SO_SalesOrderDetail records still exist. 

    I can fix it by recreating the SO_SalesOrderHeader record in DFDM or SQL & they can then invoice it. If they want to fix it on their own, they have to delete the order & re-enter.

    This has happened about 4-5 times that they have reported. Sage doesn't know why its happening & only suggested running process monitor. They are on v2022.2, Premium. They have a very high volume of orders, like 600-800/day, with maybe 20-50 drop ships per day. So this isn't happening daily or even monthly, but they are getting annoyed that they have to reach out if they want to have it fixed to use the same order number. They did report it when they were still on v2019 as well, so its not something in just the new version. I can't reproduce it on-demand. 

    Any thoughts?




    ------------------------------
    Dana Young
    Lehman Wesley & Associates
    ------------------------------


  • 2.  RE: SO_SalesOrderHeader record disappearing

    Posted 08-24-2023 20:48

    I don't know the answer to this. Is it only on Sales Orders that consist of only drop ship lines? Do they ever experience this issue with non-drop ship type sales orders? What third-party enhancements are in us? 



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Moodus, CT
    ------------------------------



  • 3.  RE: SO_SalesOrderHeader record disappearing

    Posted 08-24-2023 20:59

    Sage City seems to have a report/question on this about four years ago - unfortunately there isn't a resolution listed

     


    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Moodus, CT
    ------------------------------

    Original Message


  • 4.  RE: SO_SalesOrderHeader record disappearing

    Posted 08-25-2023 11:32

    Thanks for the Sage City link; I am going to add that to my case with Sage so they know its been an issue for years now.

    All of the ones I've come across are drop ship only items & they've generated a P/O from the S/O. Both my clients have reported the same conditions. 3rd party enhancements that they both have are InstaDocs & ScanForce Whse Mngmt. 



    ------------------------------
    Dana Young
    Lehman Wesley & Associates
    ------------------------------

    Original Message


Related Content