How to change the LOT’s expiration date (for multiple sites) in Sage X3

By | September 15, 2020

In some business scenario customer wants to change the expiry date when product exist in multiple sites, of the existing Lot numbers of its existing stock, and they were hunting for a solution which could help them with this.

A lot number is an identification number assigned to a particular quantity or lot of material from a single manufacturer. Lot numbers can typically be found on the outside of packaging. For cars, a lot number is combined with a serial number to form the vehicle Identification Number.

The lot number enables tracing of the constituent parts or ingredients as well as labour and equipment records involved in the manufacturing of a product. This enables manufacturers and other entities to perform Quality control checks, calculate expiry date and issue corrections or recall  information to subsets of their production output. It also gives consumers an identifier that they can use in contacting the manufacturer and researching the production of goods received. For example, to trace back the origin of fish or meat, in case of a public health problem.
The expiry date is associated with a lot in stock. It indicates a usage end date for the stock of a product and is controlled in the issue movements. In Sage X3, there is a standard functionality, with the help of this user can modify the LOT’s expiration date for multiple sites.

Follow the below steps to modify or change the LOT’s expiration date:


For example, we have FIN501 product at two different sites which has LOT expiration date is 08/09/20, as shown in below figure.

Fig : Stock by lot

Now we will modify the existing Product LOT expiry date with the help of below screen.

Navigate To: Stock > Lot modification > Lot mass change

  1. Select the All sites check box when the lot number is existing at multiple sites for respective product.
  2. Enter product
  3. Enter LOT number
  4. Enter the LOT expiration date
  5. Click on OK.

Please refer the below figures for the same,

After clicking on OK button, it will display one screen to verify the entry.

Now after saving the entry it will show one pop up message Entry validation select as a Yes, as shown in below figure.

After this process log file will be generated with the modified data, as shown in below figure.

Now the Lot expiration date has successfully modified. You can check the modified expiration date with the help of stock inquiry screen i.e. Stock by lot screen.

Navigate To: Stock > Inquires > Stock by lots

1. Enter a product and click on search button

2. It will show the multiple no. of LOT number, you can check the respective Lot number expiry date, as shown in below figure.

With the help of above steps user can modify or edit the LOT expiration date for multiple sites.