serial number

Answered

João Antonio

• May 09, 2018 20:00

Need help!
I need to set up a serial number for production order, in the serial configuration I need to run a procudure and display an error.
Image one where proc is.
The second image is the field size error.
Do you Any idea.

 

 

Vote

2

• 

  João Antonio

  • May 10, 2018 14:16

  Hi friends,
  The problem is already solved.

  Here's the solution:

   

  function nextnumber

   

  setvar=ItemCode=<select Itemcode from OITM  where ItemCode = '{dw_1.item.ItemCode.value}'>

  sql=execute dbo.FRANumeroSerie <ItemCode>

  setvar=beas_numberfirst=<select RTRIM(LTRIM(CAST(RTRIM(LTRIM(A.U_CODMOD)) +''+ RTRIM(LTRIM(CAST(A.U_SEQPREF AS CHAR)))+ ''+ RTRIM(LTRIM(CAST(A.U_SEQ AS CHAR))) AS CHAR(40)))) as chassi from "@FRV_CCHA" a inner join OITM i on i.U_codmod = a.Code where i.ItemCode = '{dw_1.item.ItemCode.value}'>

  setvar=beas_localserial=<beas_numberfirst>

  setstr=s_parm1=<beas_localserial>
   
  end function

   

Please sign in to leave a comment.