Skip to Content
Former Member
Mar 19, 2009 at 01:32 PM

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 
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