SAP B1 GRPO Approval

[Former Member]

Hi

I have done the below setup

1. Created Approval Stage (Administration > Approval Procedures > Approval Stages). The No of stage is 1 and the approver is 1

2. Created user defined field Inspection in item master. The value is either 'Y' or 'N'.

My requirement is

Whenever the GRPO is created and item "inspection flag is set to 'Y'" the GRPO should be submitted for approval.

I have created the below query and assigned in the approval template

SELECT DISTINCT 'true'

FROM PDN1 T0

INNER JOIN OPDN T1 ON T1.DOCENTRY = T0.DOCENTRY

INNER JOIN OITM T2 ON T0.ITEMCODE = T2.ITEMCODE AND U_Inspection = 'Y'

WHERE T1.DocNum = $[OPDN.DocNum]

My issue is

The document is not submitted for approval.

Please help.

[kothandaraman_nagarajan · Accepted solution]

Hi,

Approval procedure will work only on header level not on row level. This is standard system design.

Thanks

[Former Member · Accepted solution]

Thank you

[Former Member]

Hi Suresh,

SELECT DISTINCT 'true'

FROM PDN1 T0

INNER JOIN OPDN T1 ON T1.DOCENTRY = T0.DOCENTRY

INNER JOIN OITM T2 ON T0.ITEMCODE = T2.ITEMCODE AND  variable <> 'N'

Note:-

In the place of variable you need to put SAP variable syntax of Inspection UDF.

Thanx and Regds,

Dhanraj K

[Former Member]

U_Inspection is in OITM table.  It looks like SAP Approval templates will work in header level and not all item levels.

[Former Member]

U_Inspection is in OITM table.  It looks like SAP Approval templates will work in header level and not all line levels.

[Former Member]

Hi

Try this query

SELECT DISTINCT 'true'

FROM PDN1 T0

INNER JOIN OPDN T1 ON T1.DOCENTRY = T0.DOCENTRY

INNER JOIN OITM T2 ON T0.ITEMCODE = T2.ITEMCODE AND T2.U_Inspection = 'Y'

WHERE T1.Docentry= $[OPDN.Docentry]