Benefits of VB Scripting
Sage 100 (MAS 90/200) includes a powerful feature that many users are not aware of. User-Defined VB Scripting allows for the addition of features and functionality to your current installation of Sage 100 without modifying Source code. VB scripting can be used for automatically populating Sage 100 fields, integrating Sage 100 with other applications as well as taking the Custom Office module to the next level. VB Scripting can be a useful and cost-effective solution to many of your needs.
Watch Now: Sage 100 VBScript Demos
Here are some preview demo videos of VBScripts that the Net at Work Sage 100 team has created and can be installed on your existing Sage 100.
If you have interest in any of these or would like to discuss creating a custom VBScript for your Sage 100 software – please contact us via the form below.
Credit Memo Automation in SO Invoice Entry
Module: Sales Order
This VBScript will automatically copy line items from an invoice (from invoice history) when using the Apply To function in SO Invoice Data Entry while creating a Credit Memos.
PO Cost Varies From Standard Cost (or Average Cost) Alert
Module: Purchase Order
This VBScript will create a message (pop up) in Purchase Order Entry when an item code is entered with a cost that varies by a specified percentage from the standard or average Cost.
Item Maintenance/Inquiry Tab Security
Module: Inventory
This VBScript will allow you to control access to all Tabs in Item Maintenance and the More menu options in Item Maintenance except for 1 specified tab.
Customer Maintenance Tab Security
Module: Accounts Receivable
This VBScript will allow you to control access to all Tabs in Customer Maintenance and the More menu options in Item Maintenance except for 1 specified tab.
Account Maintenance Tab Security
Module: General Ledger
This VBScript will allow you to control access to all Tabs in GL Account Maintenance and the More menu options in Item Maintenance except for 1 specified tab.
Display GP Amount and % in Sales Order Entry and Sales Order Invoice Data Entry
Module: Sales Order
This VBScript will add fields for the Gross Profit Amount and Gross Profit Percentage which would be added to the Lines Tab grid in Sales Order Entry and Invoice Data Entry.
In addition, the following fields would be added to the Totals Tab in Sales Order Entry and SO Invoice Data Entry:
- Total Sales
- Total Cost
- Gross Profit Amount
- Gross Profit Percentage
Custom Calculation of BOL or Shipping Weight for a shipment in Invoice Data Entry and Shipping Data Entry
Module: Sales Order
This VBScript will automatically calculate the shipping weight of each line item (per your custom formula) and the total shipping weight for an invoice/shipment
- All data fields used as part of your calculation must be stored in Sage 100
Block Duplicate AP Invoices Import From Visual Integrator
Module: Accounts Payable
This VBScript will prevent a duplicate invoice number for a vendor from being uploaded using Visual Integrator. If you use Visual Integrator to import invoices into Accounts Payable, you will find that the same file can be imported more than once after updating the initial batch. This posts an adjustment entry against each invoice and doubles the invoice balance*.
*This script will prevent this from happening. It will produce an error if an already posted invoice is encountered.
Get in Touch
1-800-719-3307
info@netatwork.com