Tag: sql

Developing with the Microsoft Dynamics GP 2013 Named System Database

| 07/26/2013 | 0 Comments

Microsoft Dynamics GP 2013 introduced another long sought after feature….

Continue Reading

SQL view for sales quantities by item by site by month in Dynamics GP

| 06/14/2013 | 0 Comments

As many variations for item quantity summaries as I think I have posted on this blog, there is always another one to be had.

Continue Reading

SQL view for SOP sales by customer by month

| 06/07/2013 | 0 Comments

Someone asked me for code to get monthly SOP sales and I could have sworn I already had that. But I searched and didn’t come up with anything, so here is a new view to show SOP sales (the total of SOP invoices less returns) by month

Continue Reading

Assign sequential numbers in SQL Server

| 05/07/2013 | 0 Comments

Here is a cool little SQL Server tip from the April GP Reports Viewer newsletter. Say you have a list of rows and you want to assign sequential numbers to them, so that you always know which one is first, second, etc.

Continue Reading

Support Debugging Tool Build 17 hotfix 2 released

| 04/12/2013 | 0 Comments

Following on from the release of the Support Debugging Tool Build 17 hotfix , I am releasing a hotfix 2 build. It turns out that some of the changes in the way the  Support Debugging Tool adds buttons to the Standard Toolbar were still not perfect. We had a few reports that when the SDT dictionary was installed, newly created users would be missing their menus.

Continue Reading

Support Debugging Tool Build 17 hotfix released

| 01/31/2013 | 0 Comments

Just before I went on leave over Christmas and New Year, I announced the release of the Support Debugging Tool Build 17 . Well, as much as I try to ensure that there are not any bugs in the code, I managed to introduce one

Continue Reading

Happy New Year – 2013

| 01/01/2013 | 0 Comments

It’s now become a little tradition of mine to sit in front of the computer when I get up on New Year’s Day, sipping coffee and checking my email…hoping that I once again can write a little blog post like this one. I just got that email I was waiting for, letting me know that I have received the 2013 Microsoft® MVP Award for Dynamics GP! This makes my 9th year as a Dynamics GP MVP and I am honored.

Continue Reading