Price Different between GRPO to AP Invoice
SAP Business One
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
Nagarajan K replied
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,