27 Feb’17

Dynamics 365, BusinessImporting Budgets using Excel in Dynamics 365 for Financials

Dynamics 365 for Financials has a feature of defining Budgets for chart of accounts. The budgets can be defined in a multiple combination using dimensions and periods. Generally, companies have a huge list of Chart of Accounts and it becomes difficult to create budget for each chart of accounts in the system. Thus, Microsoft has provided a tool to import budgets in Dynamics 365 for Financials using Excel. Following are the steps to import budgets:

  1. In the global search, search for G/L budgets and click on it.
  2. Click on new to create a new budget. Provide a name & description to the budget and then click on Edit budget.
  3. Once the budget is created, go to Action tab and click on Export to Excel.
  4. On clicking of Export to excel, system will ask for Start date, No. of periods in budget and Period length. This data will be useful to design the budgets. (For e.g. Starting from 1st February 2017 I need to create a two-monthly budget for petty cash, then I will select start date as 01/02/2017, no. of period would be 2 and period length would be 2M).
  5. Once OK is clicked, an excel file will be downloaded in the system.
  6. Open the excel file and put the amount against the respective ledger and save the file.
  7. Once the file is saved, click on Import from Excel in the Action tab. The system will ask the Budget name which will be the newly created budget. There are two options available either to replace entries if there are any entries created previously or to add new entries if the user needs to append already created budget.
  8. On clicking of OK, the system will ask the path where the excel file is stored. After providing the path system will automatically either replace or add entries to the budget (depending on the option selected).

Conclusion

D365 for financials is a very good product for Small and medium size enterprises. The import budget features can become a very effective tool to design complicated budgets in the system within very less time.

 

Written by

Team Member

CloudFronts

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Reading more then 10K records in D3FOE OData API

    11 July’ 2018

    Introduction: We all know Dynamics 365 Finance and Operations has limitation of 10K records to be fetched at a time usi...

    Read more
  • Paging in D365 Customer Engagement v9.0

    10 July’ 2018

    Introduction: The Xrm.retrieveMultipleRecords method is used to retrieve a collection of records in Dynamics 365 Custom...

    Read more
  • Set up Dynamics 365 connection in Microsoft Social Engagement

    10 July’ 2018

    Introduction: This blog explains how to Set up Dynamics 365 connection in Microsoft Social Engagement. Steps to be follo...

    Read more
  • Voice of the Customer failed to install

    10 July’ 2018

    Introduction: Many people face issues in installing Voice of Customer solution on v9 environment and trying repeatedly ...

    Read more
  • Scribe Insight AX as a Web Service Find Block issue

    10 July’ 2018

    Introduction: If we need to look up for any value from AX then we do it by using a Find Block in Scribe Insight Eg: Basi...

    Read more