Tag: General Ledger

Microsoft Dynamics GP backups with Windows Azure Blob Storage Service

| 12/15/2014 | 0 Comments

With the introduction of Dynamics GP 2013 R2, Microsoft delivered support for application database backups onto Windows Azure blob storage service  from within GP itself. Azure Blob storage is a service for storing large amounts of unstructured data, such as text or binary data, that can be accessed from anywhere in the world via HTTP or HTTPS

Continue Reading

Create a refreshable Excel report based on a SQL Server stored procedure

| 11/24/2014 | 0 Comments

A long awaited new feature is being released today for our GP Reports Viewer – Excel reports. What I think is truly amazing about this new feature is the fact that you can set up an Excel report based on a stored procedure to allow users to enter parameters and also to improve performance of your reports

Continue Reading

SQL stored procedure for all open AR transactions by customer name

| 11/24/2014 | 0 Comments

A little variation on my Unapplied AR Transactions view, this SQL stored procedure will return all open (unapplied) receivables transactions for customers with a name containing what is supplied as the parameter. In case you’re wondering why I am all of a sudden posting a stored procedure, I am going to follow this up later …

Continue Reading

Microsoft Dynamics GP 2015 Developer’s Preview: .NET Framework Interoperability – Part 3

| 10/29/2014 | 0 Comments

In part 2 of the series , I delivered a brief primer on the service architecture in Microsoft Dynamics GP 2015 and how you are able to consume services natively created with Dexterity. There are two types of services that can be created: services that wrap existing windows and forms functionality, i.e., creating a customer; and services that can wrap around existing sanScript procedures, i.e, retrieving customer information.

Continue Reading

Open letter to Jeff Edwards, Microsoft Dynamics Partner Strategy

| 09/10/2014 | 0 Comments

Mr.

Continue Reading

SQL view for easier General Ledger transaction searches in Dynamics GP

| 09/04/2014 | 0 Comments

Just about every Dynamics GP customer I have worked with, at one time or another, has had occasion to search the General Ledger for a particular dollar amount.

Continue Reading

Microsoft Dynamics GP 2015 Developer’s Preview: Loading the VHD image – Part 1

| 08/29/2014 | 0 Comments

Now that you are beyond the initial excitement of the preview release announcement  and have downloaded the RAR files with the links provided by Kevin Racer , Sr. Program Manager Lead with the Microsoft Dynamics GP team (See Microsoft announces Developer Preview for Dynamics GP 2015  for links to the rar files), it’s time to get the VHD image loaded. Note: you can use WinRAR or WinZip to extract the virtual hard drive image from the rar files downloaded from PartnerSource

Continue Reading