Microsoft Dynamics GP’s Project Accounting suite is a robust, highly configurable and flexible module which is fully integrated with other modules within the Dynamics GP product suite. The flexibility of configuration, setup and integration to other modules makes it an attractive choice for tracking financial data by contract, project and cost category. It allows you to maintain complete control over project costs and execution, while also maintaining control over project budgets.
Being a developer I often find myself in situations where I need to troubleshoot SQL queries that are not performing well and generally need optimizations. I would like to share some interesting tips on how SQL Server handles queries and what execution plans might be better than others. A query execution plan is an ordered set of steps that are used to access the data in SQL server. If you are working with SQL Server Management Studio once you have started a new query window click the following button (or CTRL + M) so you can enable execution plans. In the examples below I will be using tables from AdventureWorks database which is a sample database provided by Microsoft.
Microsoft Dynamics’s Convergence, a gathering of 12,000 customers, partners and Microsoft employees, was great this year. Almost transformative, and as an experienced Convergence attendee, here are my five takeaways that make me think this was a great Convergence:
1. The president of Microsoft, Satya Nadella, attended and was the keynote speaker. Ballmer was absent the last two years, which for me, was not an issue, as his messaging was stale and confirmed in my mind he did not understand business applications. See number five below for more detail about why the keynote was so transformative.
Sales tax filing and reporting rules vary between jurisdictions in material ways. Each state has unique filing schedules, forms, payment thresholds and other administrative requirements that can trip you up. Here are some common filing and registration errors and what you can do about them.
I often speak with owners, managers and staff at organizations struggling with growth or a changing business model who sense “things are out of control” and believes there “must be a better way” to manage their business. Many reach out to technology as a corrective path to this “better way”. With so many different technology solutions on the market, each offering a countless number of unique attributes, sorting through them and selecting the right solution for your organization can be an extremely time-consuming and even mind-numbing task. I’ve often seen this process become unfocused, frustrating your attempts to improve things. I have boiled a technology selection process to five focused steps.