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

• 

  Martin Heigl

  • November 24, 2020 18:41
  • Official comment

  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

  • December 30, 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

  0
• 

  Martin Heigl

  • December 30, 2020 04:16

  Hi,

  see this link

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

   

  1
• 

  Sergio Fernandez

  • December 30, 2020 09:07

  Thank you Martin,

  It´s very helpful!

  0
• 

  WuPingHsien

  • January 05, 2021 00:25

  Hi Martin

  My question is which function screen should I deploy on?

  0
• 

  Karlo Mesquita Rodrigues

  • January 05, 2021 01:03

  Very nice, congratulation Martin!

  0
• 

  Martin Heigl

  • January 05, 2021 07:05

  Hi WuPingHsien,

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

   

  regards

  Martin

  0

Please sign in to leave a comment.