Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Create input boxes for the variables to allow the user to change the values of the variables.
Hi All
Enclosed my Product A QVW file .Now I have about 15 Product . and in future may have more then 30 product.
I like to re phase my Question :-
If you open my QVW file , you will notice that EURO_SGD not not adjustable. may i know how to make it so that user can make the rate flexible ?
Once i am able to make it adjustable , i will figure out next step. Hope some one can advise me.
Paul
Hi Gysbert
I understand what you mean. But Since my expression is partial reload script , i am not able use input box. Any alternative ? This is because i have many different type of currency.
Paul
Hi Gysbert
I have change my database structure to make use of inputfield. can you advise me how to use inputfield on the above link ?
Paul
Hi!
Take a look in my file and see if you can get some ideas.