SQL View to Return Budgets with Account User-Defined Fields

Microsoft Dynamics GPI was helping a client create a budget report recently where they wanted to have the same information available in more than one reporting too. While queries could be written and embedded there is scope for them to then diverge over time; the solution to this is to create a SQL view which all of the reporting tools can then select to make sure they always have the same data.

The view uses data…

Continue Reading Ian Grieve’s Article on their blog

SQL View to Return Budgets with Account User-Defined Fields

I was helping a client create a budget report recently where they wanted to have the same information available in more than one reporting too. While queries could be written and embedded there is scope for them to then diverge over time; the solution to this is to create a SQL view which all of the reporting tools can then select to make sure they always have the same data.

Blog Syndicated with Ian Grieve’s Permission

Author: Ian Grieve

Share This Post On