Impulz Technologies LLC

Menu
  • Home
  • Products
    • IMPULZ Positive Pay
    • IMPULZ Product unlock
  • Solutions
    • Microsoft Dynamics 365 Finance & Supply Chain Management
    • Microsoft Azure
    • Microsoft Power Platform
      • Power BI
      • Power Apps
  • Services
    • Application Support And Maintenance
    • Azure Cloud Services
    • ISV Development
    • Project Resources
  • About Us
  • Blog
  • Clients
  • Contact Us

Impulz Technologies LLC

Dynamics 365 Finance and Supply Chain: Implement budget check via custom logic

  • Home
  • Blog
  • Dynamics 365 Finance and Supply Chain
  • Dynamics 365 Finance and Supply Chain: Implement budget check via custom logic
  • November 29, 2023
  • Shahbaz Khan

Budgeting is a crucial process for any business, as it helps to plan out expenses. Budgeting helps in reaching business goals, in addition to anticipating operational changes. Without a budget, a business may experience overspending and underperformance, which could ultimately lead to the company’s closure. In this blog post, we will show you how to implement custom budget check in D365 Finance and Supply Chain using the logic of Actual vs Budget Report.

 

There is a standard report in D365 Finance and Supply Chain which shows the amount of budget allotted vs the amount of budget spent against an account. Users can use this report to see at multiple drill downed levels along with budget model. By using the main logic in this report, you can implement custom budget check in D365 on any out of the box process.

What is Actual vs Budget Report in D365?

D365 Actual vs Budget Report is a standard report that shows the difference between the budgeted and actual amounts for a financial account.  The user can access it from the Budgeting module, under Reports > Budget Reports > Actual vs Budget Report. You can also filter out or drill down to see the details of each transaction that contributes to the budget or actual amount. Alternatively, you can export the report to Excel or PDF format, or print it for further analysis

How to use Actual vs Budget Report’s logic for implementing budget check?

You need to understand the logic behind the report and the views that are used to calculate the data to use Actual vs Budget Report for budget check. Microsoft uses two main views for the calculating data for this report, which are PSNBudgetAnalysisBudgetView and PSNBudgetAnalysisActualView. One view shows the amount of budget allotted and one shows the actual spent amount. We will need a main account and a budget model ID against which the amounts will be calculated to find out the current value of budget amount from these views.

Use the following queries to get the amount of allotted and actual budget amounts from both of the views:

  • To get the allotted budget amount, use this query:

select sum(AccountingCurrencyAmount) from psnBudgetAnalysisBudgetView

where psnBudgetAnalysisBudgetView.MainAccountId == “MainAccountId”

&& psnBudgetAnalysisBudgetView.BudgetModelId == “BudgetModelId”

  • To get the actual budget amount spent, use this query:

select sum(ReportingCurrencyAmount) from psnNBudgetAnalysisActualView

where psnNBudgetAnalysisActualView.MainAccountId == “MainAccountId”

availableBudgetAmount = psnBudgetAnalysisBudgetView.AccountingCurrencyAmount – psnNBudgetAnalysisActualView.ReportingCurrencyAmount;

By taking the difference from both sum values  we will get current budget amount available for the mainAccountId.

Note:

If calculation needs to be against a specific financial dimension then add condition on the DisplayValue column in both views.

Posted in Dynamics 365 Finance and Supply Chain

Recent Posts

  • Optimizing Azure Workloads: Automate VM Startup and Shutdown
  • Landed Cost – Auto Cost Setup in Microsoft D365 Finance and Supply Chain
  • Big Data Capabilities of Azure Synapse, Databricks, and Data Factory
  • Fix Database Synchronization Errors in Microsoft Dynamics AX 2012
  • Dynamics 365 Finance and Supply Chain: Implement budget check via custom logic

Recent Comments

No comments to show.

Archives

  • April 2024
  • December 2023
  • November 2023
  • October 2023
  • July 2023
  • April 2023
  • February 2023
  • January 2023
  • October 2022
  • September 2022
  • August 2022
  • July 2022

Categories

  • Business
  • Dynamics 365
  • Dynamics 365 Finance and Supply Chain
  • Dynamics AX 2012
  • Introductions
  • Microsoft Azure
  • Microsoft Dataverse
  • Microsoft Power Platform
  • New Technologies
  • Power BI
  • Uncategorized

Latest Post

  • Optimizing Azure Workloads: Automate VM Startup and Shutdown
  • Landed Cost – Auto Cost Setup in Microsoft D365 Finance and Supply Chain
  • Big Data Capabilities of Azure Synapse, Databricks, and Data Factory
  • Fix Database Synchronization Errors in Microsoft Dynamics AX 2012
  • Microsoft Dynamics 365 Finance and Supply Chain: Set up cost type code in Landed cost module

Tags

Auto Cost Automation Ax2012 Azure Azure AD Azure Databricks Azure Data Factory Azure Synapse Cost Accounting D365 D365 code management D365 FO Azure DevOps Dataverse Development DevOps Duty Dynamics 365 Finanace and Operations development VM Dynamics 365 Finance and Operations Dynamics 365 Finance and Supply Chain Dynamics 365 FO Security Dynamics 365 with git Dynamics Lifecycle Services Export Freight Full Sync errors Import Item Cost Allocation Landed Cost Lifecycle Services Microsoft Azure Microsoft Dataverse Microsoft dynamics Microsoft Dynamics 365 Microsoft Dynamics 365 Commerce Microsoft Dynamics 365 Finance and Operations Microsoft Dynamics 365 version control Model Driven Apps Power Apps Power Platform Shipment SQL Error Transportation Voyages Web APIs XDS Framework
© Impulz Technologies - All right reserved.