Tag: sql

Quick Tip: Debugging Visual Studio Tools – Developing For Dynamics GP

Awesome tip up there on Developing For Dynamics GP blog on how to debug VS Tools For Dynamics GP . I am late in blogging about this post

Continue Reading

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