on 06-25-2015 10:31 AM
Hi Expert,
We need approval Query for purchase order
Condition:
If any supplier not belong to same country and other than local currency and UDF attachment is not null then going for approval.
Can any one suggest.
Thanks in advance
Mukesh Singh
Have you tried this..
SELECT DISTINCT 'True'
FROM OPOR t0
INNER JOIN OCRD t1
ON t0.CardCode = t1.CardCode
WHERE t1.Currency <> 'INR'
AND t1.country <> 'IN'
AND ISNULL(t0.U_APInvAttc, '') = ''
AND t0.docnum = $[OPOR.docnum]
Rgds
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try This
If $[OPOR.doccur] <>'INR'
or $[OPOR.AtcEntry] IS null
Select 'False'
else
Select 'True'
Change the INr to your local currency...
Hope helpful
Regards
Kennedy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mukesh,
Please try below query for approval procedure
---------------
declare @Loccur Varchar (3), @Country Varchar (2)
Set @Loccur = 'INR'
Set @Country = 'IN'
Select Distinct Case When $[$63.0.0] <> @Loccur then 'True'
When T1.Country <> @Country then 'True'
When isnull($[OPOR.U_APInvAttc],'')='' then 'True'
Else 'False' end
From OCRD T1 where T1.CardCode =$[$4.0.0]
-------
Thanks
Unnikrishnan
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.