Sage 100

 View Only
  • 1.  Vendor Price Level Maintenance script

    Posted 07-31-2020 13:45
    Has anyone been able to script the Pricing Type in Vendor Price Level Maintenance? We would like it to default to "Item Code" every time, but I can't seem to be able to trigger it properly. If so, what event did you use? I've tried them all with a basic SetValue script & it ignores it. Its like by the time you select it, its too late to change it since its part of the key. I tried Post-Read & Default Values as well.

    Thx!

    #script #scripting ​​

    ------------------------------
    Dana Young
    Lehman Wesley & Associates
    Lansing MI
    ------------------------------


  • 2.  RE: Vendor Price Level Maintenance script

    Posted 07-31-2020 17:00
    Since it is part of the primary key, none of the table events are triggered until the primary key is set, which includes the PricingType field. 
    I could not find a way to manipulate the default value for the dropbox without loading in additional logic into the dynamic NOMADS variables for the focus events.
    I found that the PricingType defaulted to whatever was last selected when maintaining multiple new records. 
    So a UI post load event script with the following will set it initially to "Item Code". If they change it to something else, then that last value will be used.
    oUIObj.InvokeChange "PricingType", "I"


    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------



  • 3.  RE: Vendor Price Level Maintenance script

    Posted 08-03-2020 13:46
    @David Speck II thank you for checking into that! ​I think this will actually help a bit by using the Post-Load. Thx!

    ------------------------------
    Dana Young
    Lehman Wesley & Associates
    Lansing MI
    ------------------------------