Sage Partners
Connect on Twitter
  • Home
  • Find a Reseller
    • By Location >
      • U.S. Partners
      • Canada Partners
    • By Sage Product >
      • Sage ERP Partners >
        • Sage 50 Partners
        • Sage 100 Partners
        • Sage 300 Partners
        • Sage 500 Partners
        • Sage X3 Partners
        • Sage Intacct Partners
      • Sage Construction Partners >
        • Sage 100 Contractor (Partners)
        • Sage 300 Construction (Partners)
      • Other >
        • Sage CRM Partners
        • Sage HRMS Partners
        • MIP Fund Accounting
  • Sage Product Info
    • Sage 50
    • Sage 100 >
      • Sage 100 Tips & Tricks
      • Sage 100 System Requirements
    • Sage 300 >
      • Sage 300 Installation Guides
    • Sage Intacct
    • Sage 500
    • Sage X3
    • Sage Construction >
      • Sage 100 Contractor
      • Sage 300 Construction
      • Sage Estimating
    • Other Sage Products >
      • Sage Fixed Assets >
        • Sage Fixed Assets User Guides
      • Sage CRM
      • Sage HRMS >
        • Sage HRMS System Requirements
  • Sage Add Ons
  • Resources
    • Blog
    • Popular Articles
    • Buying Guides >
      • Inventory Management Tips
      • ERP Implementation Failure
  • Contact Us

Working With User-Defined Fields in Sage 100 ERP

3/24/2015

0 Comments

 
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.

Working With User-Defined Fields in Sage 100 ERP

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.

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

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 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.

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 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 a Sage Partner to learn about working with user-defined fields or if you need help adding UDFs to a Crystal Report.

Need Sage 100 Support or Training?

Click below to search our directory and find a Sage Authorized partner in your area.
Find Sage 100 Partners in Your Area

Related Articles
How to Backup Sage 100 Company Database
How to Reverse a Check in Sage 100
How to Add Custom Crystal Reports to Your Sage 100 Menu


Like this Article?
Please share it with your friends and co-workers!

0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    ARE YOU A SAGE PARTNER?

    Get Your Business Listed Here!

    Click below if you're interested in having your business listed in this online directory of Sage Partners.
    Get Started
    Sage Warehouse Management
    Scanforce WMS for Sage
    Sage Cloud Hosting
    Picture

    Popular Articles

    Big Bang Implementation vs Phased Approach
    (Pros, Cons)

    ---
    What's New in
    Sage 100 2022

    ---
    What's New in
    Sage 300 2023

    ---
    New Release:
    Sage Intacct 2022

    ---
    What Does ERP Stand For?
    ---
    Sage 100 System Requirements and installation Guide
    ---
    Sage 300 Installation Guide
    ---
    Sage 100 Tips & Tricks

©2023 Top-Sage-Resellers.com. All rights reserved. This material and content on this website may not be reproduced, displayed, modified or distributed without the express prior written permission of the copyright holder. This website is not owned, operated, affiliated with, or endorsed by Sage Software, Inc. or Sage Intacct, Inc. Sage, Sage logos, and Sage product names mentioned herein are registered trademarks or trademarks of Sage Software, Inc. and/or its affiliates. Other product names mentioned are trademarks of their respective owners.
Privacy Policy