---
title: Working With User-Defined Fields in Sage 100 ERP
description: Learn how User-defined fields (UDFs) can be used to customize and improve tracking and reporting in Sage 100 ERP (fka MAS 90 / MAS 200).
---

[RKL eSolutions | Technology Insights, Tips and Trends ](https://www.rklesolutions.com/blog)

# [Working With User-Defined Fields in Sage 100 ERP](https://www.rklesolutions.com/blog/sage-100-user-defined-fields)

 Written by [Christine Kuhn](https://www.rklesolutions.com/blog/author/christine-kuhn) | Jul 21, 2014 11:00:07 PM

When you originally implemented **Sage 100 ERP**, you probably made some important decisions about your chart of account structure, account segments, and other aspects of accounting and reporting.

But what happens if your tracking and reporting needs change over time? That’s where **User-Defined Fields (UDFs) **can help. Let’s take a look.

### **What is a User-Defined Field? **

User-defined fields can be **added to any table in the Sage 100 ERP database**. As the name suggests, these custom fields are defined and created by the user (that’s you!) and allow you to store and track additional transaction detail that may not be provided as a standard field in [Sage 100 ERP](https://www.rklesolutions.com/sage-100-erp/) (formerly "Sage MAS 90 / MAS 200").

You can create UDFs without the need for custom development, technical support, or modifying the database. Plus, the data you enter in your UDFs can be configured to carry through to your reports, orders, and invoices.

### **The Customization You Need, Without All the Complexity**

User-defined fields can be extremely useful for tracking special events, seasonal projects, or any non-financial data you want to track.

For example, you can create a UDF that stores and tracks a customer’s reward level based on dollars spent. That UDF can be set up to flow into in the Sales Order Invoice to adjust for special pricing or shipping discounts.

### **Keeps Your Sage 100 Chart of Accounts Clean**

One of the nice things about user-defined fields is that you can set them up and run detailed reports without adding new account numbers, segments, or anything else that might muddy up and complicate your chart of accounts in Sage 100.

Using “disposable” UDFs can keep your chart of accounts from growing unnecessarily large, complex, and messy.

### **How to Create a User-Defined Field**

To create a UDF we recommend that you use **Customizer** which is part of the [Custom Office](http://na.sage.com/~/media/site/sage-100-erp/assets/datasheets/Sage_100_ERP_Custom_Office_spec.pdf) module for Sage 100 ERP. Here are the steps to follow:

1. Expand Custom Office and Main. Double-click **User-Defined Field** and **Table Maintenance**.
2. Expand the module folder.
3. Select the table (entity), and click the **Edit Fields **button.
4. Click the **Add** button.
5. In the **Add Field **window, enter the field name and description.
6. Select an object type, and specify the UDF attributes.
7. Click the **Validation** tab and enter data validation types, if desired. Click **OK**.
8. In the **User-Defined Fields **window, click **OK**.

**That’s It - you've successfully created a new UDF!**

Contact us to learn about working with user-defined fields in Sage 100 or if you need help adding UDFs to a Crystal Report.

[Contact RKL eSolutions](https://www.rklesolutions.com/contact-us/)

[View full post](https://www.rklesolutions.com/blog/sage-100-user-defined-fields)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Christine Kuhn"
  },
  "dateModified" : "2023-04-22T14:22:10.960Z",
  "datePublished" : "2014-07-21T23:00:07Z",
  "headline" : "Working With User-Defined Fields in Sage 100 ERP",
  "image" : {
    "@type" : "ImageObject",
    "height" : 60,
    "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
    "width" : 60
  },
  "mainEntityOfPage" : "https://www.rklesolutions.com/blog/sage-100-user-defined-fields",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60.0,
      "url" : "https://www.rklesolutions.com/hubfs/RKL%20Logos/0001-5330483477089761811-1.png",
      "width" : 236.84212
    },
    "name" : "RKL eSolutions "
  }
}
```