Results 1 to 3 of 3

Thread: JDE BIP If And Or Condition

  1. #1
    New Member dss01's Avatar
    Join Date
    Sep 2006
    Location
    NJ
    Posts
    14

    JDE BIP If And Or Condition

    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
    Regards,

    Deepak

  2. #2
    Member
    Join Date
    Mar 2009
    Location
    Phoenix, AZ USA
    Posts
    59
    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.
    Regards,
    Kim Schmidt

    - E1 9.1.4 ,TR 9.2.2 , iSeries, DB2
    - formerly Xe, 8.0, SQL Server, Oracle

  3. #3
    New Member
    Join Date
    Nov 2014
    Location
    India
    Posts
    15
    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.