Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Price Different between GRPO to AP Invoice

SAP Business One

Query Expert,

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


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


Mukesh Singh

Former Member


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,


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question