Microsoft Dynamics GP

Microsoft Dynamics GP users, have you ever wondered how to delete a Sales Order Processing (SOP) batch that has already been printed?  Today, I will explain how to do just that, whether some or all of the documents in it have been printed.When you try to delete a batch of sales invoices where some or all have been printed, you will receive an error:This error occurs because documents in this batch have already been printed. By design, Dynamics GP will not allow you to delete a sales document once it has been printed. You can void the documents but not delete them.If you do not want to void the documents, you can also resolve this issue by manually updating the SOP10100 TIMESPRT column to equal zero for this batch in SQL Management … [Read more...] about How to Delete a Previously Printed Sales Order Processing Batch in Dynamics GP

Microsoft SQL Server Reporting Services (SSRS) is a great tool for writing custom reports for Microsoft Dynamics GP users. One issue that caused a little frustration was having to create multiple reports to accommodate different databases in GP. When a customer would request a change to a report, I would have to modify the report and then redeploy the report three or four times. Finally, I decided, “Why not make the data source dynamic?”After a little searching on the web, I found a way to base the data source connection on a parameter. My first step was to create a parameter to allow the user to select the company they would like to run the report against. This is easy enough to accomplish by creating a dataset based on the following … [Read more...] about Dynamic Data Source in Microsoft SQL Server Reporting Services for Dynamics GP

There are multiple ways to navigate your way through Microsoft Dynamics GP. Using the Navigation Pane is one way. However, this underutilized Dynamics GP feature can do much more!The Navigation Pane is on the left side of your Dynamics GP screen.It can be customized to show the modules used by user.Once configured, these Navigation Pane options can be used to quickly move around from window to window without having to use the drop-down menus. Any window in your preferred module is just a click away.This is all very handy. However, most customers are missing out on the true power of these Navigation Lists. After clicking on the Module, notice the upper left of Dynamics GP. The Shortcuts have now changed to Lists.Click on any … [Read more...] about Navigation Pane and Navigation Lists in Dynamics GP – What You’re Missing

Back in May of this year, I first wrote about Microsoft Dynamics GP adding Document Attachments into the core product. This post is a follow-up to that article. Now that Document Attachments have been enabled, you can setup attachments to automatically flow between areas of the accounting system. Enabling Document Attachment Flow in GP 2013 A key feature in the new Document Attachments feature in GP 2013 is the ability to have attachments ‘flow’ through the accounting process. This is fairly straightforward. What is meant by ‘Flow’ is that anywhere a card type item is used, such as an Item, Vendor, or Customer, the attachments associated with that card type will be added as a reference in the new area. A very simple example of this is if … [Read more...] about Document Attachments in Microsoft Dynamics GP 2013 – Part 2

Today, I would like to share a resolution to an error message when using Integration Manager to import records into Sales Order Processing. Recently, I was working with a customer who was trying to import sales invoices into Microsoft Dynamics GP, but the integration was failing with an error on one document: “ERROR: Document cannot be edited, it is being edited by another user.”These types of errors usually point to temp records being stuck in one of the temp tables… SELECT * FROM DYNAMICS..ACTIVITY SELECT * FROM DYNAMICS..SY00800 SELECT * FROM DYNAMICS..SY00801 SELECT * FROM TEMPDB..DEX_LOCK SELECT * FROM TEMPDB..DEX_SESSION …where the resolution is to delete those tables after having all users exit the system. DELETE … [Read more...] about Integration Manager: “Document cannot be edited; it is being edited by another user”