Scripting

First attempt at a post, so be gentle if I clicked the wrong buttons to get here. I'm looking to build a very, very basic understanding of Sage 100 scripting. Are there any decent resources that explain how to use and apply scripts using the more modern versions of Sage 100 (2017 and later), best practices for implementing a script, and/or templates based on the function of the script? By that last piece, I'm more curious of what's been built for use rather than rebuilding the wheel. For example, having a script execute at any stage (Post-Write, Pre-Write, etc) but goes to an external source to run a script based off of information that exists within Sage 100. @Sage100Routine @AlnoorCassim (tagging you simply because it looks like everyone tags you in this group)

Welcome to 90 Minds. Your question is a bit loaded (well very loaded) so I'll send you a chat. Now you'll get to see how the SocialCast chat works :)

Alnoor's scripting class before Summit in NOLA has paid for itself many times over. Short comments: scripting allows customization without enhancements. Buttons, UI scripts and BOI scripts... the possibilities are vast, so general ""best practices"" are hard to come by. There are ""better"" ways to do certain things (eg. use a childhandle object instead of creating a new object), but without knowing the business purpose of a script, recommendations are practically impossible.

Lol, I figured that was a very loaded question, @AlnoorCassim. And thank you for reaching out. @KevinMoyes : Very true. I have a feeling I'm already developing a reputation for novel-length posts and responses, so I didn't want to jump into all of the detail. My main interest is in Post-Write and executing SQL queries that bring in variables instantiated with the last values keyed into a Sage 100 screen. Looking to ""integrate"" other software suites to leverage the vast information contained within Sage 100 in other capacities. Right now I know enough to be dangerous, and by that I mean break my AR Customer Maintenance screen with my makeshift code that looks a bit ""Hunchback of Notre Dame""-ish without the charm.

@AlnoorCassim You have never chatted with me over SocialChat - my feelings are hurt!! :)