1 Reply Latest reply: Feb 4, 2013 12:08 PM by 988339 RSS

    Final price in Demantra

    Adi Md
      Hi All
      I am trying to set formula to derive final price of item from multiple price list setup. We have got 6 different pricelists. The item will have its price only in 1 pricelist. The item is not repeated in any other pricelist. Currently my client expression for series item_price has several if conditions checking each pricelist one by one. Can I use any other function to simplify this?
      Appreciate any help on this.
        • 1. Re: Final price in Demantra
          988339
          An alternate option:

          While loading these price lists into Demantra, you may want to load another series which represents unit price for all the items. This can be done as part of load process with a simple customization.

          This will simplify your series expressions and would also help with performance of worksheets which use price list as series.

          Thanks
          Raj
          (http://oracledemantra.blogspot.com/)