cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Business One Approval Process Query

shak9828
Participant
0 Kudos

Dear experts,

We are using SAP Business One 9.3 HANA.

We are trying to write a query for Approval Process.

SELECT distinct 'true' from OINV T0 where 'INV1.Quantity' > 'INV1.U_Available'

The approval process should work when the entered Quantity (31) is greater than the U_Available (30).

Our query is not working.

Thank you in advance,
Shak

Accepted Solutions (0)

Answers (0)