Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jan 08, 2015 at 08:04 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08, 2015 at 08:06 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 09, 2015 at 05:47 AM

    Hi,

    Please refer thread

    Thanks & Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded