Sage 100 SQL - Use Script Tied to Button on Production Entry Header to Open UDT Screen and Return Data From UDT to Production Header

Question

Is it possible from the Production Header panel, via a script, either tied to a button click event or on one of the table events, to open an existing UDT (so that the user can see the UDT), then get a value from it and set a textbox on the Production Header panel? 
 What I am looking to do is have the user open Production Entry, click a button to open a UDT (that is already populated with data) and have it show to the user, then allow the user to click a UDF checkbox on the UDT to select and return a value from the row of the checked UDT to the Production Header screen to set a textbox. The reason we want to use this approach is because the data in the UDT will change based on some action they take when creating the Production Entry record. 
 I have seen some code out there on how to access a UDT and other MAS90 tables in memory which I have done before, but I have never been able to/know a way to open a UDT and have it show to the user. 
 Thanks in advance!

BillyVanilli · Answer

I don't know how to do that but you could do the following: 
 1) Create the UDT fields as UDFs on the Production Entry Header 
 2) Add those fields to a custom panel for Production Entry (button panel) 
 3) When the user selects the line from the UDT (through the lookup described in my first post) fire a script to write the UDT values for the selected record to the UDFs on the Production Entry Header and have the script open the panel (script clicks the button) 
 4) All fields that don't need to be modified by the user can be set to read only, or not shown on the panel at all. Let the user change the data on the panel. 
 5) When they click the okay button or a custom button that you create fire a script to update the UDT based on values of the UDFs on the Production Entry Header. 
 Probably not the most elegant way, but I use it every now and then when I need a mini UI in scripts.

connex · Answer

I use Internet Explorer sans menus and icons to pop-up table displays. You could do the same with the UDT fields if you know a bit of HTML and scripting.
The only problem being is that IE is at end of life…

Sage 100

Sage 100 SQL - Use Script Tied to Button on Production Entry Header to Open UDT Screen and Return Data From UDT to Production Header

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING