cancel
Showing results for 
Search instead for 
Did you mean: 

Approval Query

Former Member
0 Kudos
51

Hi,

I would love some help on adding a datasource to this approval query for GR PO documents. I am using an add-on for requisitions and then also to create the PO via the di api. If the source is the di api I would like the query to ignore this. We have created a purchase limit for certain user who are allowed to bypass the add-on approval process if they have a udf user limit setup in SAP and can then create a PO directly in the system according to their limit. We do however have cases where the users put in a lower amount than the actual for the PO and then GRV it against an amount higher than their user limit. We would like to stop this.

If the PO (base Document) was created via the DI API we would like the approval to ignore the purchase limit on th GR PO according to the datacource on the PO.

Any help would be appreciated!!

Here is the current approval.

select CASE WHEN $[$22.0.NUMBER] > OUSR.U_PurchaseLimit then 'True' else 'False' end as LimitChk from OUSR

Many thanks

Jacques

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

I use the datasource field on PO level if 0 through the front end if I through the DI.

Jacques

former_member583013
Active Contributor
0 Kudos

I am not sure Which field you are referring as the DataSource field. Is this a UserField by any chance.

The Query would be like

IF DataSource = 1

Your Approval Query

former_member583013
Active Contributor
0 Kudos

Do you have a field on the PO which diffentiates a DI created PO from a User created PO?