Approval Procedure for Invoice based on Customer group

[Former Member]

Hi I am looking for Invoice approval based on Customer group.I used below query but it is not working. SELECT distinct 'true'  FROM dbo.OINV T0  INNER JOIN dbo.OCRD T1 ON T0.[CardCode] = T1.[CardCode] where  $[ocrd.GroupCode.number] =  102 Regards- Mona

[kothandaraman_nagarajan]

Hi,

try this:

SELECT distinct 'true'

FROM dbo.OINV T0

INNER JOIN dbo.OCRD T1 ON T0.[CardCode] = T1.[CardCode] and T1.GroupCode=102

where  T1.CardCode=$[$4.0.0]

Thanks & Regards,

Nagarajan

[Former Member]

Hi,

Try This

SELECT distinct 'true'

FROM dbo.OINV T0

INNER JOIN dbo.OCRD T1 ON T0.[CardCode] = T1.[CardCode] and T1.GroupCode=102

where  T1.CardCode=(select $[$4.0.0])

regards,

Raviraj

[Former Member]

Hi,

You must include current document info in approval.

Try:

SELECT distinct 'true'

FROM dbo.OINV T0

INNER JOIN dbo.OCRD T1 ON T0.[CardCode] = T1.[CardCode] and T1.GroupCode=102

where  T1.CardCode=$[$4.0.0] and T0.DocNum=$[$8.0.0]

Thanks,

Gordon