best way to run consol incl foreign entity balance sheet by month

AI generated answer (using internal Slack threads):

To run a consolidated balance sheet including foreign entity by month, you can follow these steps: 1. Navigate to Reports > Financial > Balance Sheet. 2. Click on the "Customize" button to modify the report. 3. In the "Settings" tab, select "Consolidated" under "Basis". 4. Under "Period", select "Accounting Period" and specify the range of months you want to include in the report. 5. Under "Currency", select "Consolidated (Using Consolidation Exchange Rate)". 6. Click on the "Filters" tab and select the specific foreign entity you want to include in the report. 7. Click "Save" or "Save and Run" to generate the report. Please note that the balance sheet will show the consolidated balances of the selected entity in the consolidation currency. If you want to see the balances in the entity's functional currency, you would need to run the balance sheet report for that specific entity. If you are facing issues with the revaluation of foreign currency amounts, you might need to manually add a new column to your monthly rolling balance sheet report every month for the Amount with an Alternate Period Range equal to the month you want in that column. This, however, might not be suitable for external reporting integrations. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******