Skip to the main content.





Paya Nuvei Logo 2


AvidXchange Logo USE


2 min read

Sage 100 Consultant Tip - How to Use Customizer and Crystal Reports to Add a Field and Run Reports

Sage 100 Consultant Tip - How to Use Customizer and Crystal Reports to Add a Field and Run Reports

Sage 100 Consultant Tip - Add a Custom User Define Field (UDF) to a Sage 100 Panel with Customizer and Report on it with Crystal Reports

Question: Mike, we own Sage 100 (formerly MAS90) and we would like to know how to add a simple box to the Accounts Receivable Cash Receipts Entry screen. Is it possible to add a field to enter the number of customers that come through the door every day?  We'd like to collect this data and build a report to show this information with different date ranges.

Answer: The Sage 100 Custom Office Module allows you to add a user-defined field to any screen in Sage 100 and report on it from the database. You simply add the new field to the Custom Office and create a simple Crystal Report. You will also need to properly link the UDF to History.

NOTE: We advise that you consult with your certified Sage 100 ERP consultant before making any changes to your Sage 100 ERP system. If you don’t currently work with a Sage 100 consultant, contact us, call 760-618-1395 or email us and we are available to help. Sign up for more helpful Sage 100 consultant tips & tricks below! 

Sage 100 Tips and Tricks

Sage 100 Consultant Tip: 7 Steps to Create UDFs with Customizer and Report on Field Data with Crystal Reports

Here are the steps.

STEP 1 - You will be adding to the database, so you will need to have all users out of the system.

Click Custom Office>Main>User-Defined Field and Table Maintenance, select AR Cash Receipts Deposit, right click and edit fields.

Sage 100 Consultant Tip Crystal Reports.jpg

Step 2 - Once the UDF window opens click on the plus button to add a new field and type in description Daily Customers, then click OK.

Sage 100 consultant tip Customizer

STEP 3 - On the next screen click update, then Yes, the update again. You will also want to link this new UDF with Cash Receipts History. To do this you will do much the same steps with AR Cash Receipts History, give it the same name.

Sage 100 consultant tip Crystal Reports

STEP 4 - Now click tab 3 Data Sources, and set to AR_CashReceiptsJournal_upd, Data Source should be AR_Cash ReceiptsDeposit and the Column set to UDF_DAILY_CUSTOMERS as should below. This will link to history. Then do the update steps.

Sage 100 consultant tip Customizer UDF

STEP 5 - Next add the Daily Customer field to the Customizer and save the new customization. Click on Custom Office>Customizer selection> open the Accounts Receivable> Cash Receipts Entry> DDEPOSIT panel.

Please note:  The procedure is simple here, but sometimes the biggest issue with doing customizations is finding the correct fields and tables, we are just giving an example.

Sage 100 consultant tip Customizer fields

STEP 6 - You can now create a new field on the panel for the Daily Customers and Save the Panel.

Sage 100 consultant tip User Defined Fields

STEP 7 - Next you can create a very simple Crystal Report using AR Cash Receipts Deposit History Table.

Sage 100 consultant tip

We hope this was helpful. There are many other applications to help save time throughout Sage 100 using tools like Customizer and Crystal Reports. If you have any questions, please contact us, call 760-618-1395 or email us and we will be happy to help.

Check out other related Sage 100 Consultant Tips on Crystal Reports:  

Written by Mike Renner:  Partner of WAC Solution Partners - Greater Los Angeles, a Sage 100 ERP consultant and support provider based in Indio, CA.

Mike is an expert on ERP and fund accounting and supports Abila Fund Accounting and Sage 100 ERP with over 25 years in the accounting software industry. Mike is also a Sage Certified Trainer and a recognized leader in the design, implementation and support of ERP systems, including Sage.

Specialties:  Sage 100 ERP (formerly Sage MAS90 / MAS200), Abila MIP Fund Accounting™, Acumatica, QuickBooks Pro Advisor

ERP Implementation Partner Selection Tips and eBook

ERP Implementation Partner Selection Tips and eBook

How to Find the Right ERP Implementation Partner Working with the right ERP implementation partner will be critical to the success of your ERP...

Read More
Are You Outgrowing Your ERP Manufacturing Software?

Are You Outgrowing Your ERP Manufacturing Software?

3 Tips for Finding the Best ERP Manufacturing Software for Your Business If your manufacturing company is outgrowing your software the search for...

Read More
5 Ways a New Manufacturing ERP Helps Your Business Grow

5 Ways a New Manufacturing ERP Helps Your Business Grow

Grow Your Business with a New Manufacturing ERP Solution The economy is constantly changing, and manufacturing companies have been hit hard by recent...

Read More