Showing results for 
Search instead for 
Did you mean: 

Use result of SAP B1 SQL query in SQL condition.for B1 UP validation

0 Kudos

Hi experts!

I would like to use the results of an SAP B1 SQL query in the SQL condition of a B1 UP validation.

I am aware that I can't use a parameter for this, but I am struggling to find an alternative method to perform this kind of operation. My validation attempts to alert a user when they are creating an Invoice for an item using a 'Unit Price' very different to the Last Purchase Price (LastPurPrc in the DB).

Any advice experts?



Accepted Solutions (0)

Answers (0)