RKL eSolutions Blog Trends and Insights

How to Configure Auto-number on Customers in Sage X3

14 Days of Learning Sage X3

This is the twelfth lesson in the series Learning Sage X3. When adding new customers in Sage X3, it is convenient to use auto-numbering. In this lesson I am going to go over how to configure auto-numbering on customers.

Before getting further, I wanted to further explain Business Partners (BP for short) from the first blog post. A BP can be a customer as well as other alliances you may have. They can be multiple BP types at the same time. Please refer to Figure 1 to view the field we will be adding the functionality too.

Figure 1 – See the BP Partner Customer field (Common Data -> BPs -> Customers)

BP Partner Customer Field Sage X3

The next step is to configure the Parameter within the SAFE X3 framework controlling this setting. We need to alter the Sequence Number Definition for the Sequence Counter for the customer. The Sequence Counter is ‘BPC’. You can find this by pressing ESC + F6 on the Customer ID field on the Customer maintenance window. Short-cut keys have been mentioned in a previous blog.

Now we know the change to make, navigate to Setup -> General Parameters -> Sequence Number Definition -> Structures (Refer to Figure 2 below). Now select the Sequence ‘BPC’ for the customer field. You will see the components listed below.

Figure 2 – Structures maintenance window

Structures maintenance window Sage X3

To complete the configuration go into the customer category and assign the sequence field to ‘BPC’ so it allows the system to use the sequence counter.

Figure 3 – Please refer below by navigating to Customer Category (Common Data -> BPs -> Customer Category)

Customer Category Sage X3

Save your changes to validate the change. Now when you add a new Customer to the system and select the Category ‘US’ it will use the Customer Counter mask defined. You can also apply this base logic to Products, Suppliers, etc.

Stay Tuned for Lesson 13

This is the twelfth post in Learning Sage X3. The next post (Lesson 13) will review, How to Change Commissions in Sage X3 will post on December 12th, 2017. Other lessons in this series can be viewed at:

Lesson 1 of 14 - Important Acronyms and Definitions

Lesson 2 of 14 - General Navigation and User Interface

Lesson 3 of 14 - Sage X3 PU 11 

Lesson 4 of 14 - Setting up Chart of Accounts

Lesson 5 of 14 - Sage CRM for X3

Lesson 6 of 14 - How to Add a Custom Report

Lesson 7 of 14 - How to Add a Column to a Left List in Sage X3

Lesson 8 of 14 - How to Export Data from Sage X3

Lesson 9 of 14 - How to Print a Report to Word and Excel

Lesson 10 of 14 - How to Configure a Field to be Mandatory

Lesson 11 of 14- How to Track Changes Made in Sage X3

Need Help with Learning Sage X3?

Contact us if you have more in-depth question or want to Learn Sage X3 or to request help with your system.

Contact RKL eSolutions

Tags: Sage X3
Devin Cenekofsky

Written by Devin Cenekofsky

Devin Cenekofsky is a Sage X3 Solution Architect with RKL eSolutions, LLC. He focuses on project management, finance, and distribution for Sage X3. Devin also assists with Sage Enterprise Intelligence reporting tool as needed. He has worked with RKL eSolutions for 6 years with a background in information systems and ERP software. When not working, Devin enjoys working out, golfing, and spending time with family and friends.