Hi all Need your expertise to advice on how can i make use of Axapta to provide another set of report in USD (second home currency) when current home currency is maitain with SGD.
Client is base in S'pore & has agree to use SGD as home currency in Axapta. However, due to Accounting policy requirement, client have to prepare another set of financial reports in USD (client's business transact mostly in USD) to submit to auditor. Base on requirement gather from client, they required to Profit & Loss Accounts 1. Exchange rate is base on monthly exchange rate (or average rate for the year). Preference will be on monthly exchange rate to achieve greater accuracy. 2. Remove realized & unrealized exchange gain/loss for computation. 3. Fixed Asset depreciation & disposal at historical rates. Balance Sheet Accounts 1. Exchange rate for monetary accounts (AR, AP, Cash borrowing or lending) is base on year end rate. 2. Exchange rate for non-monetary accounts (fixed asset, inventory, capital & reverse) is base on historical rate. 3. Inventory & fixed asset will be kept at historical cost when possible. 4. Prior retain earnings & share capital kept at historical cost. Does anyone have any idea how can I produce report in USD from above requirement? If you have already impletemented similar requirement for your client, do let me know. Pls advaice. Thank you.