Price Different between GRPO to AP Invoice

[MukeshSingh]

SAP Business One

Query Expert,

we need one approval query for A/P Invoice condition item group wise

Example

GRPO unit price is 120/- but when we received the Invoice from supplier then price is less or excess.

We need approval procedure if GRPO unit price not matching with A/P Invoice then goes for approval condition item group hard coded.

Thanks in advance

Regards

Mukesh Singh

[kothandaraman_nagarajan · Accepted solution]

Hi,

Try this approval query and do other setting for approval procedure.

SELECT distinct 'true' FROM OPDN T0  INNER JOIN PDN1 T1 ON T0.DocEntry = T1.DocEntry left join PCH1 T2 on T2.[BaseEntry]  = t1.docentry and T2.[BaseLine]  =T1.[LineNum] WHERE T1.[Price] <> $[$38.14.number]

Thanks & Regards,

Nagarajan

[MukeshSingh · Accepted solution]

Thanks sir