Belinda Allen, Microsoft MVP Business Solutions
Things I've learned from years of working with Microsoft Dynamics GP.
In this video, I use a custom T-SQL script to exact both summaries from my Microsoft Dynamics GP General Ledger account numbers and my Budgets. Feel free to download the script and create your own view; or simply use the script within Microsoft Excel Query Editor, as I did. See the blog post for the script.
In this video, I use a custom T-SQL script to exact both summaries from my Microsoft Dynamics GP General Ledger account numbers and my Budgets. Feel free to download the script and create your own view; or simply use the script within Microsoft Excel Query Editor, as I did. See the blog post for the script.
Continue reading “Microsoft Dynamics GP GL Summaries vs. GL Budgets (Video)”
I LOVE MDA and apparently, so does Microsoft Dynamics GP MVP, Shawn Dorward. checkout his blog post below. He gives away a free MDA SQL View.
I LOVE MDA and apparently, so does Microsoft Dynamics GP MVP, Shawn Dorward. checkout his blog post below. He gives away a free MDA SQL View.
Earlier I wrote about how to use MDA for dimension analysis rather than Analytical Accounting. You can find that blog here. To continue that thought, I have created a SQL view to help users get that dimensional analysis data easily! The script captures commonly used data – if you feel I am missing something, please…
Continue reading “Dimension Analysis for MDA – SQL View for Microsoft Dynamics GP — GP Life Hacks”
When creating reports using Microsoft Dynamics GP Sales Order Processing (SOP) data, there are 8 potential status fields. Watch the following video to see an explanation of these 8 fields. In the video, Belinda uses Microsoft Excel and Get & Transform (the tool formerly known as Query Editor to review the SalesLineItems view in GP.
When creating reports using Microsoft Dynamics GP Sales Order Processing (SOP) data, there are 8 potential status fields. Watch the following video to see an explanation of these 8 fields. In the video, Belinda uses Microsoft Excel and Get & Transform (the tool formerly known as Query Editor to review the SalesLineItems view in GP.
Continue reading “Microsoft Dynamics GP SOP, Which Status Field to use when building reports”
The attached videos and steps show how to use Microsoft Excel to check unposted Payables entries along with their distributions for Microsoft Dynamics GP.
Originally Posted October 14, 2011
The attached videos and steps show how to use Microsoft Excel to check unposted Payables entries along with their distributions for Microsoft Dynamics GP.
Continue reading “Microsoft Dynamics GP Payables Management Batch Review using Excel”
Belinda Allen, Microsoft MVP Business Solutions 