SAP B1 approval of GR & AP Invoices That Total is greater than PO

[Former Member]

Hi All

I was wondering how best to test electronic SAP B1 approvals for the following scenario.

Our maintenance department raise purchase orders that are potential less of a value than what is invoiced after the jobs are completed.

So, currently Purchase orders are raised and distributed to service providers who action the job and then submit invoices for payment.

So, we have scenarios where a purchase order is approved for X amount , but will then either be Goods receipted  or AP invoiced for an amount that is higher than the purchase order amount.

I would ideally like to build an electronic approval process to support :

When a Purchase Order that is approved for X Amount is copied to either a Goods Receipt or AP Invoice, and the amount of the Goods Receipt or AP Invoice is greater than the approved amount  on the purchase order, by 10% up to $100, that further approval be required by a financial delegate set in the Approval template.

I know this is difficult with the current , limitations of SAP B1

So, hopefully some insightful minds can enlighten me on how best to tackle this.

Is there a way of using the standard Approval Process with a suitable  SAP Query set in the TERM conditions or would I need to do some work arounds with Stored procedures in the SQL management studio? If so , I would appreciate some guidance on how best to create.

regards

Clyde Carson

[kothandaraman_nagarajan]

Hi,

Please refer thread

Thanks & Regards,

Nagarajan

[Former Member]

Hi,

Check this Approval Procedures for dynamic Variable..

http://www.htmlpublish.com/convert-pdf-to-html/success.aspx?zip=DocStorage/f80cc06c60084194a3916269e...

[Former Member]

Hi Clyde,

You can also add stored procedures(Transaction notification) but this would block theaddition of document.

Do you want to block the additional of such documents?

Thanks,

Joseph

[Former Member]

Hi Clyde,

can you please check this for approval:

select distinct True from dbo.POR1 T0 INNER JOIN

                          dbo.OPOR T1 ON T1.DocEntry = T0.DocEntry  LEFT JOIN

                          dbo.PCH1 T2 ON T2.BaseEntry = T1.DocEntry LEFT JOIN

                          dbo.OPCH T3 ON T3.DocEntry = T2.DocEntry

where (T3.DocTotal*10/100) > (T1.Doctotal)

Thanks,

Joseph