Tag: events

Create a Customer in Dynamics GP 2010 using eConnect

| 10/10/2012 | 0 Comments

A few days ago I created a simple example to create a vendor in Dynamics GP using eConnect.

Continue Reading

Big annoucement for Microsoft Dynamics GP’s Extender module

| 10/08/2012 | 0 Comments

Last week, while searching for something on Microsoft’s PartnerSource, I came across an announcement that Microsoft is discontinuing sales of the Extender module and that both sales and support of Extender will revert back to eOne Solutions , the original developer of Extender, starting February 1, 2013. Please note that eOne has always sold a more advanced version of Extender, called Extender Enterprise.

Continue Reading

Coding for specific dates in Crystal Reports

| 09/18/2012 | 0 Comments

Below is an old tip from one of the GP Reports Viewer monthly newsletters . In the past few months I have had to look this up several times, because I just cannot seem to remember the syntax, so I thought I would put it on my blog, where it will be easier for to find for everyone, including me.  :-) The situation where I last needed this was when I was creating a Crystal Report and wanted to hide a date field if it returns ’1/1/1900′, the equivalent of a NULL in Dynamics GP data

Continue Reading

Microsoft Dynamics GP Technical Airlift 2012: Getting here

| 09/11/2012 | 0 Comments

I have made it to Fargo, North Dakota, the home of Microsoft Business Solutions and the Microsoft Dynamics GP Product team.

Continue Reading

SQL view for rolling 12 months of sales by item in Dynamics GP

| 08/27/2012 | 0 Comments

Rolling twelve month reports are not always very easy to create,  and I have been seeing more requests for them, so I thought I would show an example of one way to do this. The view below is a variation of my sales by item by month view , however instead of specifying all months in a year, this will return the last 12 months, not including the current month. Note that this will be using the current date on the SQL server, not the user date specified in GP

Continue Reading

SQL view for Variable Allocation Accounts in Dynamics GP

| 08/23/2012 | 0 Comments

Below is a view that will return a list of the distribution and breakdown accounts for all active variable allocation accounts in your Dynamics GP. Nothing fancy, but sometimes it is easier to have a report of these rather than have to look at them on the screen, specially since you have to click on each distribution account one at a time to see what breakdown account they are using. Related code and table information: General Ledger tables GP Reports (there is a section for General Ledger reports under Dynamics GP SQL Sripts) create view view_Variable_Allocation_Accounts as — ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ — view_Variable_Allocation_Accounts — Created on Aug

Continue Reading

Vote for your 2012 GPUG All Star

| 08/10/2012 | 0 Comments

The time has come again to vote for the next year’s GPUG All Star awards. Surprisingly, I have been nominated to this award along with fellow co-presenter of many events, David Musgrave .

Continue Reading