Hi, Have you set the secondary currency in company information?
I think this can help you. After the above settings, you can see the transaction in both company currency & secondary currency. You can also use the secondary currency in Financial Statement in Secondary currency. Regards Prasanna ----- Original Message ---- From: ppcheah70 <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, 4 December, 2007 7:29:13 PM Subject: [Axapta-Knowledge-Village] How can Axapta provide report (trial balance) in second home currency 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. Meet people who discuss and share your passions. Go to http://in.promos.yahoo..com/groups [Non-text portions of this message have been removed]