Sage 100

 View Only
  • 1.  No scripts working for just SO_SalesOrderDetail

    Posted 10-31-2020 14:05
    Edited by Rob Neal 10-31-2020 18:28
    Something strange just happened, and the only thing I can pinpoint for timing is that someone did a company copy immediately prior.  We have 5 scripts running for SO_SalesOrderDetail, and non of them are working now.  All other scripts for other modules/objects are working normally.  It's as if the Allow External Access checkbox is unchecked, but just for this one table.  I've tried unchecking that checkbox, saving the Company Maintenance screen then re-checking it (several times since this happened yesterday) but no luck.  I finally just rebooted the server, hoping that would resolve the issue, but no luck there either.  I've reviewed the SO_SalesOrderDetail master script (making sure not to save it) and nothing looks amiss there except my generally mediocre scripting techniques.  

    I've even placed a messagebox at the beginning of a couple a couple of the scripts as well as creating a whole new script (Post-Validate off the SO Detail Comment field) with just a simple message box, and nothing is firing.

    Any ideas would be gratefully accepted!

    #scripting




    ------------------------------
    Rob Neal
    ------------------------------
    ​​​​


  • 2.  RE: No scripts working for just SO_SalesOrderDetail

    Posted 10-31-2020 18:30
    Issue resolved

    Thanks to @Alnoor Cassim for the weekend help.  Bad syntax in one of 6 scripts caused the whole master script to fail, acting like none of them existed.  ​

    ------------------------------
    Rob Neal
    ------------------------------