Sage 100

 View Only

  • 1.  Field on Totals Tab Contract Job

    Posted 03-26-2022 10:56
    Attempting to modify the balance in this field in a simple script that just passes a value back.  Even when I just put in a fixed value, it doesn't change, so I'm assuming I have the wrong field.  Currently using JJC_JobBilling_bus_BillableAmt.  I don't see any other option, so perhaps this is a temp field which is not in the file?


    ------------------------------
    Beth Bowers
    Mom to Peanut, ChiChi, Canton, Cagney and Daisy (I miss you, Sammy)
    Tennessee Software Solutions
    ------------------------------


  • 2.  RE: Field on Totals Tab Contract Job

    Posted 03-26-2022 14:02
    Maybe there isn't a field in the table. It might be a temporary variable as this is a calculated amount: Revised contract - Billed to date.  To change amount billable you probably have to change either the revised contract or billed to date amounts... Or override or modify the source code that calculates the amount billable.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 3.  RE: Field on Totals Tab Contract Job

    Posted 03-27-2022 17:10
    Beth - This is a calculated field and not really meant to be modified. I know you must be correcting something so just be careful. To answer your question, most likely your SetValue to BillableAmt worked but the screen is not auto-refreshing. You can check by clicking on Header then back on Totals again. Instead of trying to code it to refresh, I personally would do the script like this (where nNewBillableAmt represents your variable for then new billing amt).

    If oScript.UIObj Then
 	If IsObject(oUIObj) = False Then
		oUIObj = oScript.UIObj 'Updates will not have UIObj
		Set oUIObj = oSession.AsObject(oUIObj)
	End If
End If

oUIObj.InvokeChange "ML_BILLABLEAMT", nNewBillableAmt


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

    Email: alnoor@asifocus.com
    Ph:
    ------------------------------



  • 4.  RE: Field on Totals Tab Contract Job

    Posted 03-27-2022 17:21
    Had a feeling that was the case, @Alnoor Cassim.  I've decided to do it differently where I don't need to calculate that field.  Thanks for the info and the confirmation!​

    ------------------------------
    Beth Bowers
    Mom to Peanut, ChiChi, Canton, Cagney and Daisy (I miss you, Sammy)
    Tennessee Software Solutions
    ------------------------------

    Original Message


Related Content