Special price for customer

[MukeshSingh]

  Hi Expert,

We required approval query for A/R Invoice, If any customer define under special price list and his price in A/R Invoice not matching with special price list define master then going for approval.

Regards,

Mukesh Singh

[kothandaraman_nagarajan]

Hi,

Please note that, approval process only for header level, not on row level.

Thanks.

[Former Member]

Hi,

Use this query

SELECT 'True' from OINV v inner join INV1 v1 on v.DocEntry =v1.DocEntry

inner join OSPP s1 on s1.CardCode=v.CardCode and s1.ItemCode=v1.ItemCode

where v1.Price <> s1.Price and v.DocNum=$[OINV.DocNum]

[MukeshSingh]

Hi,

Your query not working, i think INV1 we need to put variable id?