5 Replies Latest reply: Jul 7, 2014 2:56 AM by Anders Tolf RSS

    How can i make exchange rate able to adjust by user ?

    PAUL YEO

      Goal :- How to make exchange rate can be adjust by user ? Now the exchange rate fix at 1.85

       

       

      PRoduct (A)

       

       

      Now my exchange rate i am using below script :-

       

       

          lET EURO_SGD = 1.85;

       

       

      Partial reload script , compute the LAND COST SGD as below :-

       

       

          NUM(TRIM(LIST_PRICE*(1-Discount)*$(TRANSPORT_IBH)*$(EURO_SGD)/$(MARKUP_5_PC))) as FOB_SGD_SUB,

       

       

      PRoduct (B)

       

       

      Now my exchange rate i am using below script :-

       

       

          lET USA_SGD = 1.4;

       

       

      Partial reload script , compute the LAND COST SGD as below :-

       

       

          NUM(TRIM(LIST_PRICE*(1-Discount)*$(TRANSPORT_IBH)*$(USA_SGD)/$(MARKUP_5_PC))) as FOB_SGD_SUB,

       

       

       

       

      Product A & B table i save in QVD file , and i use QVD file read both QVD file.

       

       

       

       

      Now user can compute the selling price From my Table expression , i using below expression :-

        

         FOB_SGD_SUB*RATE_P*TAX_*DUTY_*TRANSPORT_SUB_/1

       

       

      Now I like to know what i must do in for EURO_SGD & USA_SGD in order for allow user adjust the exchange rate ?

       

       

      Paul