SAP B1 GRPO Approval

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.