The customer wants the manufacturing number and serial number to be generated automatically, is there a way?

1
I want the serial number to be recorded in the data in a fixed format.  Is there a good idea??   ex) OLED-TS2307L10001   OLED: productline TS: plant 23: year 07: Month L1: pruction line 0001: auto index
asked
2 answers
4

Hi,

 Create a microflow to generate the serial number automatically when a new product is created. 

  • Add a Create Object activity to the microflow and select the "Product" entity.
  • Set the values for the other attributes of the product (productLine, plant, year, month, productionLine).
  • Calculate the autoIndex using an expression. For example:
    • Retrieve the maximum autoIndex from existing products using the Retrieve activity.
    • Use the following expression to calculate the next autoIndex: 
      ($ExistingProducts/Max(autoIndex) + 1)

       

  • Concatenate the attribute values to form the serial number using the following expression: 
    'OLED-' + $Product/productLine + $Product/plant + $Product/year + $Product/month + $Product/productionLine + $Product/autoIndex

     

answered
0

Hi jaehun Park,

Make sure the attribute as auto number and I  microflow give the condition.

 

regards,

Praveen 

answered