Sage 100

Button Scripting on a ""detail"" table: I have a client who would like to have a button in the Invoice History Inquiry > Package Tracking screen to feed the tracking number along with a link to UPS to track, since the iship button is not working. It does not appear that button scripts work to feed ""line"" values though, because I cannot get this to work. If I were to feed a ""header"" value, such Invoice Number, Customer Number, etc, the script works, but maybe button scripting is not meant for tables that can hold multiple values? Can anyone confirm that or correct me? Thanks in advance!

@Sage100AdvancedScripting

I think the answer to your problem is just to wait until tomorrow. It's very likely the very old Sage web service that does the URL redirects for iShip and the Mapquest buttons will be reset (someone just needs to reboot that server) and everything will start magically working again.

BTW a button script can read multiple values, multiple rows. What you have to do is the get the name of the object for Package Tracking, then issue Set command to it. Then treat it like the SO Entry Lines grid where you can MoveFirst() then start a Do Until Loop where you loop until cBool(Eof). Inside the loop do a GetValue() on the fields you need or GetValues(). Then SetValue() on the TrackingID and MoveNext(). Then issue the oScript.LinesAdded=1 and the normal oScript.LoadGrid(gridname) to refresh. Instead of GD_Lines you have to find the name of this particular grid which looks like GD_TRACKING. The other grid navigation functions work too MoveLast(), MovePrevious(), EditKey, etc.

Thanks, Alnoor. I've now joined this group. It appears the iShip button has been a known issue for awhile and may be related to IE vs. other browsers. And thanks for the scripting tips - I will see what I can play around with this weekend.

At times, I wonder why Sage moved to a WIN platform - UNIX and DOS worked so well.....

Unix, DOS...feeling a bit nostalgic are we? why not Novel & CP/M while we are at it?

Novell - yes great file server OS, CP/M - Now THAT's old.....

Prudy I personally think it's better to troubleshoot this one than write a script. The iShip button should work other than problems this week. Many use it regularly so there would be an outcry if it stopped working altogether. Here is a charger I ordered from your client let's say. When you hit Pkg Tracking button in MAS, the formed URL would be: http://services.bestsoftwareinc.com/services.asp?sid=8®id=&trackingid=1ze13a031374813184 This is a Sage web service running old ASP 3.x from the early 2000's. Try that URL in their default browser and in a non-default browser. If it still doesn't redirect to the iShip URL below then add both bestsoftwareinc.com and iship.com as a Trusted Site or even better add them to the Local Intranet zone (Ctrl Panel / Internet / Security tab). It will feed iShip with this URL: https://iship.com/trackit/track.aspx?T=1&Track=1ze13a031374813184

Thanks, Alnoor. This appears to be working again for the client - I was not able to get onto their system, so I don't know what the problem was, but they have confirmed they can get to the tracking now. They still want a custom button for UPS alone, so after I complete more self-study, I'll see if I can do it for them.

There is always the good old copy and paste into Google Search two or three clicks. Cludgy but free.