Scripting

  • 1.  Have a script to purge Quotes. Runs fine as Admin

    Posted 08-27-2016 12:09
    Have a script to purge Quotes. Runs fine as Admin role, but unable to get handle to SO Bus Obj with other roles - error on Avatax ""One or more Avatax objects could not be created"". I've given at least VIEW rights to everything I could think of that might have to do with Avatax, no go. Does anyone know of any totally bizarre think Avatax may be requiring that I would never think of in a million years? Or do you think I have to give delete instead of view somewhere? (User role has full rights to all tasks in SO.)


  • 2.  RE: Have a script to purge Quotes. Runs fine as Admin

    Posted 08-27-2016 12:58
    WAG - is this a BOI script where you're running from the outside of the MAS Launcher and connecting to pvxcom? Are you also running from a wkstn? (and is this OzLink?) If so, you have to register the AvaTax DLLs on the wkstn first. This can be done by copying \mas90\AvaTax folder to your workstation (e.g. copy to C:\Sage\AvaTax) then run their .BAT file (rt-click Run as Administrator). Before running it, I like to edit the BAT file and put a PAUSE at the end so I can see if DLLs registered successfully. Then run your script.


  • 3.  RE: Have a script to purge Quotes. Runs fine as Admin

    Posted 08-27-2016 13:20
    But... since they have been using Avatax for quite some time here with no issues AND It doesn't have the issue when I a have rights to everything in Sage in my Role.... would this still be helpful?


  • 4.  RE: Have a script to purge Quotes. Runs fine as Admin

    Posted 08-27-2016 13:21
    It's not Ozlink, BTW. Let's not even discuss them.


  • 5.  RE: Have a script to purge Quotes. Runs fine as Admin

    Posted 08-27-2016 13:55
    Heck, that did it. I was so convinced it was a role, but I created a new test role with full rights to everything and it still wouldn't work. No idea why it did with the Admin role. Whatevs - THANK YOU, @AlnoorCassim !!!!!


  • 6.  RE: Have a script to purge Quotes. Runs fine as Admin

    Posted 08-27-2016 14:13
    Woohoo. Also note if the script is going to run from other wkstns, repeat and rinse on the procedure.