Introduction The Additional Reporting Currency feature in Business Central allows a company to maintain its financial records in a secondary currency, in addition to the primary currency. This secondary currency is used for reporting and analytical purposes, providing a clearer picture of the company’s financial health in the context of different economic environments. The use of Additional Reporting Currency for Regulatory Compliance, Simplified Financial Reporting, Enhanced Decision Making.  Steps to achieve the goal:  1. Defining the Additional Reporting Currency  Navigate to the “General Ledger Setup” page and specify the additional reporting currency. This can be any currency other than the primary currency of your company’s base country/region.  Here I am going to set SGD as my Additional Reporting currency. Before I set SGD in my Additional Reporting currency, I have to make sure I am assigning the exchange rates properly.  2. Specifying Exchange Rates  Define the exchange rates between the primary currency and the additional reporting currency. This can be done through the “Currency Exchange Rates” page. It is crucial to regularly update these rates to reflect current market conditions.  3. Specify the residual gain and loss account in your Currency  The field is ideally not visible in screen. You can personalize and make those fields visible on your screen. Click on Settings icon-> Personalize->Field->Select the field and drag the field in your screen.  Set the GL account to update its additional Currency value for future transactions. Globally search Chart of Accounts and Open the G/L Account that you wished to update its Additional currency value whenever you Adjust the transactions. No Adjustment: The default selection. No adjustments are made to the account Adjust Amount: Any gain or loss in exchange rates is reflected in the LCY amount field. Adjust Additional-Currency Amount: Any gains or losses in exchange rates are taken into account when adjusting the additional currency amount field. Please Note: You cannot set VAT Purchase or Vat Sales Account and G/L Accounts which you have tagged in Currency page (Realized gain and loss, Unrealized gain and loss, residual gain and loss) as for Additional reporting currency. As it can throw error when you perform Revaluation in the system. 4. Final Setup  Go to general ledger setup and set the Additional Reporting currency SGD and set Retained Earnings Account, Set Document not as per the screenshot below and click on OK.  This is batch job used to convert LCY transactions to Additional Currency. The exchange rate that is in effect on the work date is used in the job.The entry that is posted to the retained earnings account should be indicated in the Document No. field. On the last day of every closed year, this rounding entry is made to ensure that all income and expense accounts have a zero balance.The same account used when running the Close Income Statement batch job. You would view the below message once the transaction is calculated in the system. Click on OK. You can change the Additional Reporting currency again in future once it is set. Please note any Analysis created for previous Additional Currency that you must delete. Before and After setting up this configuration  – Before the Additional Currency Setup   The Chart of Accounts Additional Currency Net change and Additional Currency Balance to Date is blank no values.  – After the Additional Currency Setup   The Chart of Accounts Additional Currency Net change and balance to date value has been set.  Please Note: Warning Issued by Microsoft on Additional reporting Currency  Conclusion  The Additional Reporting Currency feature in Microsoft Dynamics 365 Business Central offers a robust solution for maintaining financial transparency and compliance. By setting up and leveraging this functionality, businesses can streamline their financial reporting processes, enhance decision-making, and ultimately achieve greater financial clarity and control.  Whether you are a small business expanding into new markets or a large enterprise with operations in multiple countries, the Additional Reporting Currency feature in Business Central can provide the tools you need to succeed in a complex financial landscape.  We hope you found this article useful, and if you would like to discuss anything, you can reach out to us at transform@cloudfronts.com

Introduction For companies operating in diverse countries or regions, managing business transactions and financial reporting in multiple currencies is essential. Due to frequent fluctuations in exchange rates, it’s necessary to update these rates regularly in Business Central. Microsoft recently released a new feature you can now see how an exchange rate adjustment will affect your records before finalizing it. Just use the “Preview Posting” option on the Exch. Rates Adjustment report (Report 596). You can choose to see either detailed or summarized results and decide how dimensions are managed for gains and losses. Steps to achieve the goal:  – Enable the New Feature: – Access Exchange Rate Adjustment: – Choose Dimension Settings: – Preview Posting View:   Note: Due to local regulations, it’s not recommended to enable the “Enable use of new extensible exchange rate adjustment, including posting review” feature in the Swiss (CH) version.  Conclusion The steps outlined in this blog, you can effectively utilize this feature to maintain accurate records and enhance your organization’s financial management capabilities. Whether you’re adjusting for a specific period or managing multiple dimensions, this feature streamlines the process and helps you stay compliant with local regulations. Implement these practices to ensure your business remains responsive to currency fluctuations. We hope you found this article useful, and if you would like to discuss anything, you can reach out to us at transform@cloudfronts.com

Introduction: Businesses in the digital age depend on cloud platforms and ERP systems integrating seamlessly. Dynamics 365 Finance & Operations (F&O) and azure integration is one such potent combination. Numerous advantages, such as improved scalability, agility, and data-driven decision-making capabilities, are made possible by this integration. The step-by-step instructions for connecting Azure with Dynamics 365 F&O will be provided in this blog. Steps to achieve the goal: Step 1: Setting up Azure Services a. Create an Azure account: Sign up for an Azure account if you don’t have one already. b. Provision Azure resources: Set up the required Azure resources such as virtual machines, databases, storage accounts, and other services according to your needs. Below are few links to create azure account. https://learn.microsoft.com/en-us/answers/questions/433827/how-to-get-an-azure-account-without-credit-card https://azure.microsoft.com/en-in/free/students Step 2: Configure Azure Active Directory (AAD) a. Click on New on the App Registration page. Set the name and set the type like below screenshots. b. Once you click on Ok button you would get notification like below. c. Now go to API Permission and click on Add permission d. Select Dynamics ERP e. Select Delegated Permission f. Select all permission and then click on Add Permission g. After selecting this permission again add permission on the screen this time selected Application Permission. h. Now we have to generate client secret value. Just select Certificates and secret. i. You will see the below screen where you can generate a new client secret j. Once you click on new you will see below screen where you can set the date to which this secret key would be valid. Max validity is 2 years. k. This is how the secret value would look like just copy Value. l. Now copy the Directory ID and Application ID Step 3: Connect Azure Services to F&O a. Go to Finance and Operations and serach globally Azure Active Directory/Microsoft Entra ID b. And then click on New and add your client id over here and set User ID as Admin. Please Note you should have the admin access right if not this won’t work. Conclusion: Azure integration with Dynamics 365 Finance & Operations empowers businesses to streamline processes, unlock data insights, and achieve operational excellence. Next blog would be how to connect standard API on postman and perform get and post function. Stay tuned! We hope you found this article useful, and if you would like to discuss anything, you can reach out to us at transform@cloudfronts.com

Introduction:  Many Businesses supports buying and selling items with different unit of measures. How to configure this in Business Central without showcasing your inventory in decimals. Let’s take an example: We will be buying the goods always in dozen whereas we can sell the items in PCS or CARTONS. Steps to achieve the goal: 2. Once the base unit of measure is set to PCS. Go to the Item Unit of Measure page by click on Related-> Unit of Measure. 3. By default PCS line would be set to 1. Add new line enter DOZEN and next right 6 which means 1 dozen has 6 PCS. 4. Next line add CARTONS and enter the qty per unit of measure as 72. which means 1 Cartons has 72 PCS in it. 5. Once the above lines have been set. Let’s pass Item journal where will be increase the inventory by dozen and sell the items in PCS and CARTONS. Ideally the inventory would be shown without any decimal value. 6. Below is the explanation how system would calculate into PCS as when you buy and sell in different items. 7. Purchase 100 dozen which is 600 PCS. This would be converted by Business Central itself. As we have defined 1 dozen as 6 PCS. 8. Sales 7 Cartons which is 702 PCS. This would be calculated by Business Central itself as per the Item Unit of Measure configuration where 1 cartons is 72 PCS. 9.Once the above transaction is posted the inventory would be whole value without any decimal. Conclusion:    Thus, we saw how we can use alternative Unit of measure in Business Central. We hope you found this article useful, and if you would like to discuss anything, you can reach out to us at transform@cloudfronts.com

Introduction Invoices and shipments are frequently handled differently by different businesses. Processes, for example, can range from one person posting everything on a purchase order to numerous employees working on their own sites. On the User Setup page, you can now select how each user can handle invoices. Steps to achieve the goal 1. Go to User Setup select the users you want to give this restriction and then there are two columns Sales Invoice publishing Policy and Purch. Invoice Posting Policy 2. There are three values in these options Below is the impact of the above three options in different documents of purchase and Sales transactions. Document Option 1: Allow Option 2: Prohibited Option 3: Mandatory   Displays a series of options Confirmation dialog Confirmation dialog Sales Order Ship Do you want to post the shipment? Do you want to post the shipment and invoice?   Invoice       Ship and Invoice     Sales Return Order Receive Do you want to post the receipt? Do you want to post the receipt and invoice?   Invoice       Receive and Invoice     Inventory Pick Ship Do you want to post the shipment? Do you want to post the shipment and invoice?   Ship and Invoice     Purchase Order Receive Do you want to post the receipt? Do you want to post the receipt and invoice?   Invoice       Receive and Invoice     Purchase Return Order Ship Do you want to post the shipment? Do you want to post the shipment and invoice?   Invoice       Ship and Invoice     Inventory Put-away Receive Do you want to post the receipt? Do you want to post the receipt and invoice?   Receive and Invoice     Warehouse Shipment Ship Do you want to post the shipment? Do you want to post the shipment and invoice?   Ship and Invoice     Note: If you are trying to post invoice transactions from the general journal the above restriction would not be used in the General journal table. Conclusion Thus we saw how we can restrict the users to post the purchase and sales transactions. Thank you very much for reading my work. I hope this helps!

Introduction. They might be some need to copy the data from one batch to another. In Business central there are multiple ways to do so use copy & paste method or use or configuration packages or Use Standard Journal Feature. Let’s understand about the Standard Journal Feature in detail. But please note Standard Journal Function is not present in other journals apart from General Journal. Steps to achieve the goal: Go to batch where you want to move the data from. There will be action to save as a standard Journal. 5. You would be able to see the Standard Journal you have created. Click on Ok. Please note if you change the amount of the line after copying from the Standard Journal. It will not be reflected the same in Standard Journal. As it is used as Template. Conclusion: Thus we saw how we can use Standard Journal Feature in Business central. Thank you very much for reading my work. Hope you enjoyed the article!

Introduction: Intercompany Transaction is useful feature to track all transaction that is happening with the specific intercompany. Many organizations consist of more than one company, and these companies often engage in various intercompany transactions. It’s important for an organization to be able to track these transactions with ease, and Microsoft Dynamics 365 Business Central allows you to do just that. With Dynamics 365 Business Central, your organization can reduce errors, improve productivity, and post transactions across multiple subsidiary companies. Business Central makes it easy for your organization’s companies to engage with one another in the same way they would with external customers and vendors. Steps to achieve the goal: Intercompany setup Globally search intercompany setup Set the name and check the Boolean “Auto send Transactions” the option to auto send transactions to the intercompany partner as soon as it arrives in the intercompany outbox, and not have to manually send/receive the intercompany transaction. 3. Go to setting icon there is option to Company information. 4. Fill in the Intercompany Partner Code, Intercompany Inbox Type. and Intercompany Inbox Details fields. Conclusion: Thus we saw how we can configure Intercompany Setup and create IC customers and Vendors. Thank you very much for reading my work. Hope you enjoyed the article!

Introduction: Administrators may need to restart a specific Business Central environment to resume normal operation in some cases as a troubleshooting step. Steps to achieve the goal: Go to your settings and select Admin Center. 4. Then click on Restart Environment Action.

Introduction: There might be a need where user wants to cancel the Posted Purchase Credit Memo which was posted by mistakenly. Ideally we cannot cancel the Posted Purchase Credit Memo if it is generated from Posted Credit Memo or Purchase return Order. But if the Posted Purchase Credit Memo is generated from cancel Posted Purchase Invoice . Steps to achieve the goal: If a Posted Purchase Invoice is cancelled then system post the Purchase Credit Memo and cancelled field is set to true in Posted Purchase Invoice. Go to its corresponding Posted Purchase Credit Memo you would be able to cancel action in the Posted Purchase Credit Memo. Cancel action Visibility code added by Microsoft. Conclusion: Thus we saw how we can cancel Posted Purchase Credit Memo in Business central. Thank you very much for reading my work. Hope you enjoyed the article!

Introduction: Based on certain values dynamically show and hide the fields in the request page of the report. Ideally, we cannot directly use visible property to fields. we can do this by enabling the visibility of fields using groups. Steps to achieve the goal: Create a groups and add the fields which you want to show and hide based on selected data. For example, I have an option filed called Filter By- State, Customer, and Both. If I choose Customer then the Customer field should be visible and if I choose State then the State field should be displayed if I choose both then the Customer and State field should be visible. Create a 2 boolean variable which is of InDataset Create Customer and State field and assign it to groups in report. Then the field value which is been used to show or hide other fields write the below code OnValidate trigger So the above code will do the following if my Filter By field is State then the State field will be visible and if it is Customer then only the Customer field will be visible. If both are selected then both Customer and State fields will be visible. Note: If you want to show or hide the field based on only one value then you don’t need to use the InDataset attribute on the Boolean variable Conclusion: Thus we saw how we can dynamically show and hide the fields based on selected values on the request page in Business Central. Thank you very much for reading my work. Hope you enjoyed the article!