How to set Lot/Serial with custom date format in Acumatica

By | April 30, 2024

In Acumatica, a software platform, we can customize the automatic numbering system for tracking inventory items, particularly Lot/Serial numbers.

Today, I’ll discuss how to utilize this feature with a personalized date format. This customization allows for better organization and tracking of inventory items based on specific dates, streamlining processes and improving efficiency.

Here I mentioned the steps to set Lot/Serial with custom date format in Acumatica.

1. Enable Lot/Track Serial Feature:  

Ensure that the Lot/Track Serial feature is enabled in your system settings. This feature likely allows you to track individual items or batches using serial numbers or lot numbers.

1

2. Create Configuration in Lot Serial Classes:

Navigate to the “Lot Serial Classes” screen where you can define how the tracking of Lot/Serial numbers will work. In this configuration, you’ll specify the parameters for tracking such as the format of serial numbers, whether they’re unique or can be reused, and any other relevant details.

Follow the configuration settings provided, which likely involve specifying the necessary parameters to suit your tracking needs.

2

3. Next, go to the stock item screen in your browser. Here, you’ll match the   configuration to the chosen stock item.

finished setting up everything. Now, go to the Receipt Screen and make a transaction.

3

After creating a transaction, we receive a date in the format yyMMdd along with the serial number.

By setting a custom date format, you can ensure that the Lot/Serial numbers in Acumatica display dates in the format that best suits your needs.

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 salesforce@greytrix.com. We will be glad to assist you.