SQL View to Return Budget Amounts by Accounting Period in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business CentralI 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

Author: Ian Grieve

Share This Post On
Share via
Copy link
Powered by Social Snap