Display a calculated value (not a UDF) on a customized window?

Question

My goal is to calculate a value with a script and display it on a customized window similar to this. Essentially my script calculates the open quantity for items on a purchase order that are within 30 days 
 The next trick is to display the result. 
 At this time the script is triggered by clicking on the button that says PO 30 day 0. The code below then changes the text displayed on the button to return the result. That works but I really would prefer to have it displayed in a similar manner to the ordered | received and back ordered fields at the bottom of the window. And eventually the calculation will be triggered automatically when the orders tab is entered and there won't be a button.

This is not a UDF to be updated/displayed, it is just a calculated value. 
 I have tried to change the text value (note the Text 4 field to the left of the button that says PO 30 day 0. 
 I suspect the SetControlProperty below is what I want to do but the property of "TEXT" that I am trying to change is not correct. Pretty sure it is as simple as that, but I can't find a reference to tell me what the correct property is to change. Help. 
 
 'code not shown that calculates PO30daytotal 
 result = "PO 30day "&cstr(Po30daytotal) 
 retval = oUIOBJ.SetControlProperty ("BT_LINK_2","Text", result) 'changes the text on the button that executes the routine - works 
 retval = oUIOBJ.InvokeChange ("Fonted_Text_4","Text", result) 'attempt to change text of a text field - no go 
 retval = oUIOBJ.SetControlProperty("Fonted_Text_4","Text", result) 'attempt to change text of a text field - no go 
 'following pops up a text box that displays the info - it works! but I really don't want a pop up retval = oSession.AsObject(oSession.UI).Messagebox("Quantity Pending " & POAlltotal & "/" & PO30daytotal & " " & resultl )

David Speck · Answer

Several methods to accomplish this depending on when you need the value calculated. 
 Fonted Text added to a panel is only processed when the panel is first drawn, think of it like the post load event. You can not modify the text afterwards typically. Although i feel like at one point i accomplished this but it might have been changing the color and not the text itself. If you only need the calculation to perform once, you can prefix the calculation with an "=" just like with excel to enter a formula, you can then reference variables present in the UI object's scope. The "formula" must return a "string" value though. So if you wanted to perform a mathematical equation, you have to convert the final output to a string value, i.e. [=STR(2*4)] will display "8" where the text is placed when the panel is drawn. 
 
 The next option is useful when you need to update the value, such as on the post read of a record or some other event. For this, you can either create a UDF in the "MAIN" table for the task so that you can add it as a place holder to the panel and configure it to be locked and borderless (if you don't want to see the outline of the control, making it look like it is just text). You can then use either the Business object's SetValue on it or if it is purely for informational purposes only and you don't want the value saved to the record or to trigger the "Do you want to save changes" prompt, you can use the [oUIObj.SetControlProperty "Control_Name", "Value$", "Value To Set"]. If you want to use the latter, than you don't technically have to add a UDF to the table, instead, in customizer, choose to add a UDF to the target panel and then click the "Show All" button, then pick a field from the list, excluding any fields under the "MAIN" tree, that will create a control on the panel prefixed with "ALB_", you should get the best result if you use a field from another table, see the attached images for an example of this.

I needed a total of four "informational" fields so i just picked the first four fields from the "BillNo" tree 
 
 Then update the field captions. 
 Here's a snippet of the code used to update them. 
 oBM_Production_UI.SetControlProperty "ALB_BillNo_BillNo", "Value$", FormatNumber(nQuantityOrderedOriginalTotal, 4) oBM_Production_UI.SetControlProperty "ALB_BillNo_Revision", "Value$", FormatNumber(nQuantityOrderedRevisedTotal, 4) oBM_Production_UI.SetControlProperty "ALB_BillNo_BillDesc1", "Value$", FormatNumber(nQuantityToProduceTotal, 4) oBM_Production_UI.SetControlProperty "ALB_BillNo_BillDesc2", "Value$", FormatNumber(nQuantityCompletedTotal, 4) 
 
 Here's the end result.

There is one more method that can be used to do "advanced" calculations when a Fonted Text is first drawn but it requires knowledge of the ProvideX language since it uses the XEQ function and the logic must be in a file similar to PERFORM LOGIC. It is used like the following, [=XEQ("PathToFileContainingProvideX","Value/Variable to return from the function", "Value/Variable passed as parameter to the "CALLED" program specified")]

Sage 100

Display a calculated value (not a UDF) on a customized window?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING