Input Masks in Acumatica

By | December 11, 2023

In the world of ERP systems, Acumatica is popular and well known for its flexibility and adaptability. One exceptional feature of Acumatica is its customization, allowing organizations to tailor the system to their precise needs. Input masks provide developers with a powerful tool to control and format user input, ensuring data accuracy and enhancing the overall user experience.

Understanding Input Masks:

An input mask is a string of characters that defines the format of permissible user input. Developers can apply input masks to various fields, restricting input to a predefined pattern. This not only ensures that data conforms to a specific structure but also simplifies data entry for users.

Key Features and Benefits:

1. Format Consistency:

PXStringAttribute: This attribute allows developers to define input masks for string fields. For example, a mask for a contact number field might ensure that users enter numbers in the format (XXX) XXX-XXXX.

 [PXString(InputMask = “(###) ###-####”)]

2. Improved Data Entry:

By guiding users to input data in a consistent format, input masks reduce errors and enhance the overall accuracy of data.

3. Enhanced User Experience:

The use of input masks provides a user-friendly experience. Users can quickly understand the expected format for data entry.

4. Adaptability to Different Scenarios:

Developers can customize input masks based on the specific requirements of different fields. For instance, a date field might have a mask that enforces the format MM/DD/YYYY.

[PXDate(InputMask = “MM/dd/yyyy”)]

5. Dynamic Input Masks:

Input masks can be dynamic, changing based on certain conditions. This flexibility enables developers to cater to various scenarios within the same application.

[PXString(typeof(Search<DacName.fieldName>), InputMask = “CUST-{0:00000}”)]

The default value for the key fields of the input mask is ‘>aaaaaa’. The control characters used are as follows:

  • ‘>’: Converts the following characters to uppercase.
  • ‘<‘: Converts the following characters to lowercase.
  • ‘&’, ‘C’: Accepts any character or a space.
  • ‘A’, ‘a’: Accepts a letter or digit.
  • ‘L’, ‘?’: Accepts a letter.
  • ‘#’, ‘0’, ‘9’: Accepts a digit.

This input mask configuration is designed to format and validate input according to the specified rules for uppercase/lowercase letters and digits.

About Us
Greytrix – a globally recognized and one of the oldest Sage Development Partner and a Salesforce Product development partner offers a wide variety of integration products and services to the end users as well as to the Partners and Sage PSG across the globe. We offer Consultation, Configuration, Training and support services in out-of-the-box functionality as well as customizations to incorporate custom business rules and functionalities that require apex code incorporation into the Salesforce platform.

Greytrix has some unique solutions for Cloud CRM such as Salesforce Sage integration for Sage X3Sage 100 and Sage 300 (Sage Accpac). We also offer best-in-class Cloud CRM Salesforce customization and development services along with services such as Salesforce Data MigrationIntegrated App developmentCustom App development and Technical Support to business partners and end users.
Salesforce Cloud CRM integration offered by Greytrix works with Lightning web components and supports standard opportunity workflow. Greytrix GUMU™ integration for Sage ERP – Salesforce is a 5-star rated app listed on Salesforce AppExchange.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

For more information on our Salesforce products and services, contact us at We will be glad to assist you.