Skip to Content

B1UP Validation with Joining Tables

Mar 07 at 12:57 PM


avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers