approval procedure query help

Hi there,

at the moment i am creating an approval procedure. This should check if a sales man enter a price that is less than the price from the standard price list. If it is, it should check if the customer already got this price.

If the customer got this price, there is no approval necessary. If the customer did not get this price, an approval procedure should be started.

I started to write this query, ith the idea to check a sum of two price for the approval. But i get an error if i insert this query.

DECLARE @x numeric(18,4)
SELECT @x= (SELECT $[$38.14.])

SELECT @x-T0.Price 
FROM ITM1 T0 
INNER JOIN OCRD T1 ON T1.CardCode = $[$4.0.0] 
WHERE T0.Pricelist = T1.ListNum and T0.ItemCode = $[$38.1.]

Has anyone another idea or tips to solve my issue ?

Regards Steffen