[BEAS] - Restart "Continuous number xxx" in batch number

Respondida

Sergio Fernandez

• 12 de noviembre de 2020 13:01

Hi everyone,

Is possible restart "Continuous number xxx" in automatic batch number assigment?

For example, I have this configuration:

I would like the continuous number xxxx to be reset every new day.

Is possible?

 

Thank you,

Sergio Fernández

Vote

5

• Comentario oficial

  

  Martin Heigl

  • 24 de noviembre de 2020 18:41

  Hi Sergio

   

  you can create a small script which create the barcode
  one example:

  http://help.beascloud.com/script/index.html?workordermanagement_getbatchnumber.htm

  Here the Script:

  // DistNumber = today (yyyy/mm/dd) + "-" + new counter for every day
  // Example: 20200501-0001, 20200501-0002, 20200501-0003 ...
  function GetBatchNumber
  select coalesce(max(substring("DistNumber",10,4)),0) into myCounter from "OBTN" where left("DistNumber",9) = '<today,yyyymmdd>-'
  setvar=myCounter=%numadd(myCounter,1)
  setvar=myCounter=000<myCounter,#0>
  setvar=e_DistNumber=<today,yyyymmdd>-<myCounter,right 4>
  end function
• 

  WuPingHsien

  • 30 de diciembre de 2020 00:56

  Hi

  I am very interested in this setting. Which screen should I deploy this script from?
  Configuration wizard? Post in manually (single event)?

  Thanks
• 

  Martin Heigl

  • 30 de diciembre de 2020 04:16

  Hi,

  see this link

  https://help.beascloud.com/script/index.html?userevent.htm

   
• 

  Sergio Fernandez

  • 30 de diciembre de 2020 09:07

  Thank you Martin,

  It´s very helpful!
• 

  WuPingHsien

  • 5 de enero de 2021 00:25

  Hi Martin

  My question is which function screen should I deploy on?
• 

  Karlo Mesquita Rodrigues

  • 5 de enero de 2021 01:03

  Very nice, congratulation Martin!
• 

  Martin Heigl

  • 5 de enero de 2021 07:05

  Hi WuPingHsien,

  do you don't have access to the youtube video?

   

  regards

  Martin

Iniciar sesión para dejar un comentario.