A few days ago I created a simple example to create a vendor in Dynamics GP using eConnect.
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.
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
I have made it to Fargo, North Dakota, the home of Microsoft Business Solutions and the Microsoft Dynamics GP Product team.
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
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