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.

-- 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 th‎…

Blog Syndicated with Ian Grieve’s Permission