3 Replies Latest reply: Jan 24, 2012 2:08 PM by anubankar RSS

    Scripting for price comparison

      Hi All

       

      I have a QVD file that has client proposals data. Various versions are created based on client feedback. My aim is to find out the discount given starting from base proposal. The data in QVD files is as follows:

       

      QVD1

      "Estimate"     "Estimate Copied From"     "Price"      

        X                  -                                       1000        

        Y                  X                                       900        

        Z                  Y                                       800        

        Z11               Z                                       750

       

      Note: No of iterations is not fixed.

       

      QVD2

      Sales Order     Estimate

      4040               Z11

       

      I want report o/p as follows:

      Sales Order    Discount Given

      4040               (1000-750) = 250

       

      Any idea how I can achieve this?

       

      Regards

      Anu