Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

Encontré y modifique un poco esta validación para el TN, lo que hace es :

Validar que el campo Ref2 del recibo de producción (OIGN.Ref2) no esté vacío y sea igual que el Número de Orden de Fabricación del Detalle (IGN1.BaseRef)

@object_type =  '59' AND @transaction_type IN ('A','U')

Begin

DECLARE @DocEntry AS NVARCHAR(10)

Set @DocEntry = @list_of_cols_val_tab_del

IF (SELECT COUNT (*)

FROM OIGN T0

INNER JOIN IGN1 T1 ON T0.DocEntry = T1.DocEntry

WHERE  (T1.BaseType ='202'  and  (T0.Ref2 = '' OR T0.Ref2 is NULL OR T1.baseref <> T0.Ref2  ) )   and T0.DocEntry = @DocEntry )> 0

Begin

Set @error = 111

Set @error_message = 'Error en Campo Ref 2: Verifique dato ingresado '

End

End

Me ha sido de mucha utilidad y lo comparto.

Saludos.

1 Comment
Labels in this area