• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

JDE BIP If And Or Condition

dss01

Member
Hello!
I am trying to add a IF condition with between values for e.g. If (Amount >= 1000 AND Amount < 2000).
I am not able to find the keyword for AND clause. I have tried a lot of this, but none of them are working.

Thanks in advance for your help!

E1 9.2.
TR: 9.2.2.2, BIP 12.2.1.3.0
 
Deepak, I use this code to conditionally display a signature on a check: <?if:../Signature_Flag_ID3='Y' and Amount_ID5 < Threshold_ID5?> In my case, the flag was in the next higher level of the XML from the amount tags so I needed to use the XPath notation prefix ../ to tell BIP where to find it.
 
Hi Deepak,

We had a requirement of showing total amount based on days past due ...Meaning between 2 values of past due days ...

I am using the following tag for it and is working fine.....See if it helps you...

<?sum(current-group()/AmountOpen_ID26[(../DaysPastDue_ID66<=-31 and ../DaysPastDue_ID66 >=-60)])?>

Let me know if it works
 
Top