Skip to Content
avatar image
Former Member

B1UP Validation with Joining Tables

Hi Experts,

We currently are running a validation through the TN but would like to process the checks on specific fields with B1UP on the front end.

The TN SQL check is:

SELECT @error=1,@error_message='Mettler [RE40 Refractive Index Upper] limit exceeded' FROM oign T0 WITH(NOLOCK) JOIN ign1 T1 WITH(NOLOCK) ON T0.DocEntry=T1.DocEntry JOIN OITM item WITH(NOLOCK) ON item.ItemCode=T1.ItemCode JOIN IBT1 T2 WITH(NOLOCK) ON (T2.ItemCode=T1.ItemCode AND T2.BaseType=59 AND T2.BaseEntry=T0.DocEntry) JOIN OIBT T3 WITH(NOLOCK) ON (T3.ItemCode=T2.ItemCode AND T3.BatchNum=T2.BatchNum AND T3.WhsCode=T2.WhsCode) WHERE item.ManBtchNum='Y' AND (T3.U_RE40 > item.U_RE40U) AND T0.DocEntry=@list_of_cols_val_tab_del

How would one modify the following SQL code to be used with the B1UP validation config as a SQL condition?

Thank you in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers