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
- Dyn365GP3 February 2024SQL Query on Matomo Database to Calculate the Number of Visits to Each Page
- Dyn365GP2 February 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Use Virtual Tables to Expose More Business Central Data in Dataverse
- Dyn365GP2 February 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Manage Work Orders in Field Service, Invoice Them in Business Central
- Dyn365GP2 February 2024In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Manage Consignment Stock at a Customer Location