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.
Split AP Invoice Batches by Date
Module: Accounts Payable
Moves invoices into new batches based on calendar period. The user will be prompted to enter a batch number to split into multiple batches by period. A batch will be created for each period and year.
Drop Ship Sales G/L Account: Automatically Override G/L account on Line Item
Module: Sales Order
This script will override the sales G/L account for a drop ship line item. Sales account to be used can be stored on the customer or the item record. Some customizations to this may be available. Contact us for more information.
Discount by Customer and Product Line
Module: Sales Order
Auto populates the discount percentage field on the line in Sales Order and Invoice Data Entry. A new table will be added in Sage (see below sample) where the discounts will be maintained. Credit Memos and Debit Memos will be excluded.
Custom Calculation of Shipping Weight for a shipment in Invoice Data Entry and Shipping Data Entry
Module: Sales Order
This VB Script will automatically calculate the shipping weight of each line item and the total shipping weight for an invoice/shipment.
– All data fields used as part of your calculation must be stored in Sage 100 (i.e. item ship weight)
Custom Calculation of Number of Pallets in Invoice Data Entry and Shipping Data Entry
Module: Sales Order
This VB Script will automatically calculate the number of pallets for each line item and the total number of pallets for an invoice/shipment
– A new field for “number of pallets” will be added to Item Maintenance. This is the number (or partial number) of pallets which the standard unit of measure occupies.
Drop Ship P/O G/L Account: Automatically Override G/L account on Line Item
Module: Purchase Order
This script will override the expense G/L account for a drop ship line item. Expense account to be used can be stored on the vendor or the item record. Some customizations to this may be available. Contact us for more information.
Automate Visual Integrator Import Job and Auto Archive Import Files
Module: Visual Integrator
Script will check for CSV files in a specified directory on a set schedule (e.g. every hour, once daily, etc.). Each file in this directory will be imported using the VI job before being moved to another directory for archival. Results for only the last imported file will be available in the Visual Integrator log. Depending on your version, Visual Integrator may or may not store a perpetual error log. (Newer versions do have a perpetual log.) Please contact us to discuss other options if you are on an older version and require a perpetual error log (results log for all imported files).
Get in Touch
1-800-719-3307
info@netatwork.com