Skip to main content

Posts

Exchange Rate Adjustment in Dynamics 365 Business Central: Unrealized Forex Gain/Loss

 Microsoft Dynamics 365 Business Central has a smart feature called 'Exchange Rate Adjustment. It is a powerful tool that automatically calculates unrealized foreign exchange gain and loss on open documents at month-end, perfectly handling currency fluctuations for you. Before you can run the 'Exchange Rate Adjustment,' you'll first need to set up the month-end exchange rates on the Currencies page in Business Central. Setup Month-end exchange rates Page: Currencies 1.     Select the "Exchange Rate". 2.     Enter the Month-end exchange rates into "Relational Adjmt Exch Rate Amt" based on the month that you will need to adjust. Once the Month-end exchange rate is setup, you can close the screen. To Run Exchange Rate Adjustment for the month Page: Exchange Rate Adjustment 1.      For the Starting Date , leave this field blank. This ensures that all open transactions are included in the foreign exchange gain/loss calculation, giving you a complete p...
Recent posts

Extending Your Financial Year in Dynamics 365 Business Central

Extending Your Financial Year in Dynamics 365 Business Central Need to extend your current financial year in Microsoft Dynamics 365 Business Central (BC)? You can easily do this within the "Accounting Period" page. This post will guide you through extending your financial period, for example, from the standard 12 periods (1/1/2024 - 31/12/2024) to 15 periods (1/1/2024 - 31/03/2025).     Step 1: Ensure Your Financial Year is Open in Business Central Before extending your accounting period in Dynamics 365 Business Central, the first crucial step is to verify that the financial year you want to extend is still open. Navigate to the "Accounting Period" page and check the “Closed” and “Date Locked” columns for the financial year ending 31/12/2024. These columns should be clear, indicating an 'Open' status.     Step 2: Extend Your Accounting Period     Once you've confirmed the financial year is open, you can proceed with the extension. Manually add in the add...

Personalize your screen in Business Central to help you work more efficiently

Do you know that you can customize the Business Central page to fit your needs using the Personalise feature? The Personalise feature only changes what you see; it does not impact other users.   To customize a page in Business Central, simply click Personalise in Settings > Personalise.  To Hide Columns Suppose you need to prepare data using the Excel Copy and Paste feature in General Journal page, and you would like to hide some of the columns on the General Journal page, you can use the Personalise feature to hide the unused columns.           1.        On the page that needs to be customized, point out the Personalize feature.           2 .        The Personalize feature is active if you see the Personalization banner appear at the top of the page together with the page name you are customizing. 3.      To remove a column, click ...

Why business central fixed asset depreciation amount is different from my calculation

  Upon data migration to Business Central, customers often wonder why the monthly depreciation amount is different from their calculations. The only explanation we've identified so far is that the data provided for the migration inadvertently caused either over- or under-depreciation of depreciation amounts. The following example illustrates how BC's depreciation amount will differ from your calculated amount.           1.        The following asset was migrated to BC with the cut-off date till 31 st August 2022.           2.        You can print the Projected Value report to check on the future depreciation and book value of the asset. Page: Projected Value           3.        According to your book, the trend of monthly depreciation from now until December 31, 2022 is $1,000, but BC is recording ...

How business central handle intercompany transaction easily

Intercompany transactions in Business Central allow you to make transactions with your intercompany partners. You can create intercompany transactions by creating an Invoice or a Purchase Invoice. Transactions made with intercompany transaction send separate documents with their own document numbers to each company. To establish intercompany transactions, intercompany partners must establish a common chart of accounts and common dimensions, where each company's chart of accounts and dimensions are mapped to the intercompany chart of accounts and dimensions. The Prerequisite Requirements and Preliminary Setup for Intercompany Transactions: i.                      Each Intercompany Partners need to identify the Intercompany Code that their company represents to setup as an Intercompany Partner Code. ii.              ...

Intercompany Setup in Business Central

Before you able to create a Sales Invoice or Purchase Invoice to your intercompany partners, there are some configurations need to complete in between the company you administer and the company your partner is managing.      1.        Setup Intercompany Partner Code   This setup will allow the system to differentiate which entity under the same Business Central should the invoice direct to. The Intercompany Partner Code should be unique and agreed upon by all companies. Page:  Intercompany Setup i.           Enable the “Auto Send Transactions” which allows system to send out to intercompany partner once there is transaction posted.     2 .        Setup Intercompany Partners Code This setup will configure the intercompany partners that will involve in the whole intercompany setup in BC. In another word, you will need to create a Intercompany...