Sage 100

HI All,
   I am not as much of a script guru as I wish I was.  I have a client that just went live with a Premium upgrade to 2019.  He is reporting that he is able to get this button script to return data when he runs it but he gets data. It is set to execute script on server.  Any thoughts on what is wrong?   It worked previously on the other server in the 2014 version.   New Sage server and new SQL server. 


------------------------------
Bob Osborn
Consultant
ACI Consulting
------------------------------

First check Allow External Access in Company Maintenance :-) But here is another shot in the dark. I presume sorderno and memocode variables are defined earlier in the script. Any chance he defined sorderno like this (instead of using GetValue) :

sorderno = SO_Sales_bus_SalesOrderNo

If so, then the field variable needs to be passed into this script like this:

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA
------------------------------

Original Message:
Sent: 8/4/2020 5:38:00 PM
From: Alnoor Cassim
Subject: RE: Script issue

First check Allow External Access in Company Maintenance :-) But here is another shot in the dark. I presume sorderno and memocode variables are defined earlier in the script. Any chance he defined sorderno like this (instead of using GetValue) :

sorderno = SO_Sales_bus_SalesOrderNo

If so, then the field variable needs to be passed into this script like this:

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA
------------------------------

Message moved to Sage 100 community.

------------------------------
Moira Goggin
Executive Director
90 Minds, Inc.
------------------------------

Original Message:
Sent: 08-04-2020 20:32
From: Robert Osborn
Subject: Script issue

Hi Alnoor,

Thanks much for replying.  Turned out to be a much more benign issue.  The user had their own customized screen and their screen button had not been pointed to the new server.. 

    

 

Thank you,

 

Bob Osborn

ACI Consulting

p 714.282.0378 ext. 402    f 714.282.0235

 

Bob@ACIconsulting.com

 

                   

This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

 

 

 

 

Original Message:
Sent: 8/4/2020 5:38:00 PM
From: Alnoor Cassim
Subject: RE: Script issue

First check Allow External Access in Company Maintenance :-) But here is another shot in the dark. I presume sorderno and memocode variables are defined earlier in the script. Any chance he defined sorderno like this (instead of using GetValue) :

sorderno = SO_Sales_bus_SalesOrderNo

If so, then the field variable needs to be passed into this script like this:

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA
------------------------------