Last post Jan 30, 2008 07:29 AM by TATWORTH
Jan 30, 2008 07:02 AM|kak.mca|LINK
Hi Good morning to all,
We are developing one application for client in US. This is basically FINANCE application.
They have developed their business in UK also. So, more than three currency formats can play the game. viz. USD, GBP, EURO.
They asked us to develop one web application to meet their new requirement.
Now, they are asking like the following:
Whenever one user accesses his report while staying in US, the report should populate all the results in USD currency format only, and the user should able to convert into other formats also.
In the same way,
Whenever one user accesses his report while staying in UK, the report should populate all the results either in GBP, or EURO currency formats based on the location they are staying, and the user should able to convert into other formats also.
Can anyone please suggest how can I do this?
Thanks in Advance,
Jan 30, 2008 07:29 AM|TATWORTH|LINK
In the data tables storing the financial information, you will need to store not a just the posted value but the posted currency as well. This would work with the aid of a currency conversion table, but is still troublesome, so my suggestion for table structure