Hello All,
Can any one give me an idea to handle currency conversion.
in my source DB i dont have 1 table which structures as CurrencyFrom, CurrencyTo,Rate columns.(in this table we used to hole only current rate)
and one table call transacts (it has all debit,credit,conversuion,currency,etcc)
now i added currency table to my model and transaction as well, created relationship with Currency in trans and CurrencyFrom in Currency table
in the model itself, in query subject i created a filter as always, #prompt('enter country to convert','string')#
then in trans query subject i created Amount Converted, and definition as --> round(trans.amount*Currency.ToCurreny,2)
so when ever a user drags this amountconverted column to report in report studio and run the report user will be prompted to enter which currency he wants to see the results
so far everything is fine (usually our reports are comparing to previous year balance with current year).
now as per our new requirement from our end user,
now it needs to store each day rate in one table(we will manage it),
how can i handle (what can i do in FM model) to handle, user have opportunity to calculate conversionamount based on last year currency rate or present currency rate
when ever user try to creare a report, then it needs to show a prompt to select last year rates is calculate as last year conversion rates so how can we handle it
Please help me in regards
your ideas more valuable to me
asini
Can any one give me an idea to handle currency conversion.
in my source DB i dont have 1 table which structures as CurrencyFrom, CurrencyTo,Rate columns.(in this table we used to hole only current rate)
and one table call transacts (it has all debit,credit,conversuion,currency,etcc)
now i added currency table to my model and transaction as well, created relationship with Currency in trans and CurrencyFrom in Currency table
in the model itself, in query subject i created a filter as always, #prompt('enter country to convert','string')#
then in trans query subject i created Amount Converted, and definition as --> round(trans.amount*Currency.ToCurreny,2)
so when ever a user drags this amountconverted column to report in report studio and run the report user will be prompted to enter which currency he wants to see the results
so far everything is fine (usually our reports are comparing to previous year balance with current year).
now as per our new requirement from our end user,
now it needs to store each day rate in one table(we will manage it),
how can i handle (what can i do in FM model) to handle, user have opportunity to calculate conversionamount based on last year currency rate or present currency rate
when ever user try to creare a report, then it needs to show a prompt to select last year rates is calculate as last year conversion rates so how can we handle it
Please help me in regards
your ideas more valuable to me
asini