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

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

Tags:
Former Member
replied

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

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