Sage 100 Help: Making a Standard Field Required Part 2

Making a Standard Field Required in Sage 100- Part 2.

Review Part 1 from last week here

Last time we discussed how to use Advanced Field Settings to make a standard field in Sage 100 required; however, this cannot be done with all fields. Notice that the required checkbox is disabled for the Tax Schedule field under AR Customer Master.

So how can we make this field required? Starting with version 4.40, User-Defined Scripts can now be added. The following steps describe how to do this.

NOTE: Allow External Access under Company Maintenance must be checked for the company that you want user-defied scripts to run under. This option is found under the Preferences tab.

Go to User-Defined Field and Table Maintenance. Under Accounts Receivable, right-click on AR Customer Master and select User-Defined Scripts…

Click on the Add… button

Select Table Pre-Write from the Event dropbox

Type in a script name and click Yes to create the script. The following is a script that will make it so that a Tax Schedule will have to be entered on a customer record before it can be saved.

Here is the script to make it easy to copy.

retVal = 0

SalesTaxReporting = “”

TaxSchedule = “”

retVal = oSession.GetParameter(“A/R”,”SalesTaxReporting$”,SalesTaxReporting)

if SalesTaxReporting = “Y” then

retVal = oBusObj.GetValue(“TaxSchedule$”,TaxSchedule)

if Trim(TaxSchedule)=”” then

retVal = oScript.SetError(“Entry of Tax Schedule is required.”)

end if

end if

It first checks to make sure the Sales Tax Reporting option is turned on then it checks to see if the Tax Schedule field has a value. If the Tax Schedule is blank, the user cannot save the record.

After the script is entered, click Accept, Ok, Close, Close and then Compile. This will make the script active. Finally click Close

Open Customer Maintenance. Select a customer without a Tax Schedule (or create a new customer)

When a change is made to the customer records (or if this is a new record), then the program will now check to see if Tax Schedule has a value when the program tries to save the record. When I click the Accept Button, I get the following message

The program will then make me fill in the Tax Schedule before I can save the record.

If you need assistance with your Sage 100 ERP software, contact Oasis Solutions Group. Oasis provides training, service, support and custom programming for accounting, ERP, HR/Payroll and CRM software. Contact us at or 502-429-6902 for more information about how we can help your business.

You may also like

In 2024, we’re living in the future. Pocket-sized AI and portable workspaces have shown us that finding balance at work is as ...

NetSuite, the cloud-based enterprise resource planning (ERP) software, has released its 2024.1 version, packed with exciting features and enhancements to ...

Stay tuned on our ERP path!

Subscribe to our newsletter and get the latest news