How to Align Lot numbers with Miscellaneous receipts numbers

By | January 21, 2021

“Miscellaneous Receipts” is the business process that is used to carry out the receipt of products into the warehouse without a corresponding transaction such as a purchase order or works order to receive the product against. Datalinx Warehouse Manager for Sage X3 allows the receipt of product to be recorded.

Whilst completing the receipt, the application checks and validates to ensure that the product code exists and if relevant, captures additional information such as serial and batch numbers together with date related details such as best before or use by dates. The resulting transaction is used to update Sage X3 with the receipt as if the transaction had been completed within Sage X3. The history record will also attribute the transaction details complete with date and time to the individual logged on at the hand held terminal.

Some companies would like to create their Miscellaneous receipts with a Lot Number that is the same as the Miscellaneous receipts transaction Number that created the product. This is useful for general quality assurance and for product recalls. Some lot numbers are generated with the use of date and time stamps to help identify a specific lot.

Why we make the Lot number same as Miscellaneous receipts number because this can make the tracing of the Lot easier. In Sage X3, there is a standard functionality of doing this.

Follow the below steps for the setup:


First make sure that Lot Management setting of product is checked as a ‘Mandatory lot’ and under the Lot Sequence field this MUST be blank as shown in below figure.

Fig: Product

Also, product category set up should be same as product setup, as shown in below figure.

Fig: Product category

In short product and that respective product category set up should be set as defined above.

Navigate To: Common Data> Product category > Receipts Tab > Management Rules Grid

1. Select Movement type as Miscellaneous Receipt’

2. Change the value of Lot entry as a ‘Free’

3. Change the value of Lot by default as a ‘Document number’.

4. Click on Save or OK button.

Please refer the below figure for the same.

Fig: Product category

We have completed the setup for product master and product category.

Now follow the below path for Miscellaneous Receipts creation,

Navigate To > Stock > Receipt/issue transaction > Miscellaneous Receipts

While creating the Miscellaneous receipts transaction, keep LOT no. as blank on line level and after creation you can see LOT no. is coming same as a Miscellaneous receipts transaction number. Refer below figure for the same.

Fig: Miscellaneous Receipts

With the help of this setup you can align the Lot numbers with the Miscellaneous receipts transaction number and it will also help to make the tracing of the Lot easier.

Hence after doing all the above steps we can able to align the same lot number with Miscellaneous receipts transaction number.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence. 

Greytrix caters to a wide range of Sage X3, a Sage Business Cloud Solution, offerings. Our unique GUMU™ integrations include Sage X3 for Sage, Dynamics 365 CRM, and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3. Currently we are Sage X3 Implementation Partner in East Africa, Middle East, Australia, Asia, US, UK. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit and India Legislation for Sage X3 to Sage business partners, end users and Sage PSG worldwide. Greytrix Sales Commission App for Sage X3 simplifies commission calculations and postings on sales transactions.

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

Greytrix is a recognized Sage champion ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star rated app listed on Salesforce AppExchange and GUMU™ integration for Dynamics 365 CRM – Sage ERP listed on Microsoft AppSource.

For more information on Sage X3 Integration and Services, please contact us at, We would like to hear from you.