I posted a SQL view towards the end of January which returns the start and end date of accounting periods in Microsoft Dynamics 365 Business Central.
The SQL view below uses that view to return the budget figures from Dynamics BC for each accounting period grouped by account and the global and budget dimensions.
-- drop view if it exists
IF OBJECT_ID(N'uv_AZRCRV_BudgetAmountByAccountingPeriod'
Continue Reading Ian Grieve’s Article on their blog
SQL View to Return Budget Amounts by Accounting Period in Microsoft Dynamics 365 Business Central
I posted a SQL view towards the end of January which returns the start and end date of accounting periods in Microsoft Dynamics 365 Business Central. The SQL view below uses that view to return the budget figures from Dynamics BC for each accounting period grouped by account and the global and budget dimensions.
Blog Syndicated with Ian Grieve’s Permission
More About This Author
Array
Dyn365GP26 July 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Enable Sustainability Features for Integrations with APIs
Dyn365GP26 July 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Manage Subscription Billing and Revenue and Expense Recognition
Dyn365GP25 July 2024New Functionality In Microsoft Power Automate 2024 Wave 1: Scale Faster with Power Automate Process Mining Thin Client App
Dyn365GP25 July 2024New Functionality In Microsoft Power Automate 2024 Wave 1: Use the New Desktop Flow Running Timeout Property