Results 1 to 3 of 3

Thread: JDE BIP If And Or Condition

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    New Member dss01's Avatar
    Join Date
    Sep 2006

    JDE BIP If And Or Condition

    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:, BIP


  2. #2
    Join Date
    Mar 2009
    Phoenix, AZ USA
    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.
    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
    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.