Scripts that do something useful

This page is a quick method to get to ‘completed’ scripts that do something useful rather than proof of concept code.

These scripts are provided as is and may require changes for them to work in your environment.

Importing Budgets in to BUS100 Part II – this is a revised version of the script which takes advantage of WebServices which allows you to import budgets from an Excel Spreadsheet.

Importing Budgets in to BUS100 – this is a script which takes advantage of WebServices to allow you to import budgets from an Excel Spreadsheet.

Poor mans security, fudging user authentications in CRS692 – this script causes changes to supplier bank details by specific users to automatically change the supplier status to 10.

Journal Importing From Excel & jscript Handling of Error Messages Part II – this script uses purely the power of jscript to import journals (GLS100) from an Excel spreadsheet.

Validating Bank Account Details – Cancelling the Save – we illustrate how to cancel the committing of information to M3 in CRS692, providing some basic validation.  This script will also highlight the details which the script believes is incorrect.