Sage 100

 View Only
  • 1.  I'm trying to learn scripting. Created a simple sc

    Posted 02-22-2012 11:19
    I'm trying to learn scripting. Created a simple script that calcs value of a line UDF in SO Entry, but would like to use this script to perform the calculation without having to click the button. What event should I use for this task? Can anyone recommend literature that sheds light on this topic?


  • 2.  RE: I'm trying to learn scripting. Created a simple sc

    Posted 02-22-2012 11:37
    Mark, This is kind of a tough one. Literature on use-defined scripting can be tough to come by...Resolution ID: 529861 is a decent place to start. Column-Post Validate is a good place to start for some field on the SO Detail file.


  • 3.  RE: I'm trying to learn scripting. Created a simple sc

    Posted 02-22-2012 12:32
    I learned a tremendous amount watching Steve Malmgren's ""Look Ma, No Buttons! - The Next Generation of Customizer in Sage MAS 90 and 200"" videos. You can find them on the Sage Community Forum under Personalization, Customization and Productivity Tools. If your calculation relies on more than one field that could be modified in the data entry grid I would use the table pre-write event.


  • 4.  RE: I'm trying to learn scripting. Created a simple sc

    Posted 02-22-2012 12:36
    Of all the ones out there I have found the Dive Deep videos to be the best. I think Michael is correct on the pre-write.


  • 5.  RE: I'm trying to learn scripting. Created a simple sc

    Posted 02-22-2012 13:02
    +1 for Deep Dive.


  • 6.  RE: I'm trying to learn scripting. Created a simple sc

    Posted 02-22-2012 13:17
    @MichaelNottoli and @LouisAraiza if you use the table pre-write, does the data entry user get visual feed-back that the UDF has been filled?


  • 7.  RE: I'm trying to learn scripting. Created a simple sc

    Posted 02-22-2012 13:34
    Thanks folks!


  • 8.  RE: I'm trying to learn scripting. Created a simple sc

    Posted 02-22-2012 14:44
    @BrettLyder I don't think so. If you want to see the results of the UDF in the data entry then you'll need to add column based scripts on each element in the UDF calculation.