We have seen a few support cases recently about a change to the Void Historical Payables Transactions and Void Open Payables Transaction windows in Microsoft Dynamics GP 2013 Service Pack 2. Here are the details of the enhancement from the Inside Microsoft Dynamics GP blog ( http://aka.ms/InsideGP ): Microsoft Dynamics GP 2013 Service Pack 2 Feature of the Day: Voiding Updates Previously the two windows were quite different with the Open window only allowing selection of the Vendor ID and the Historical window only allowing selection by Document Number
Hi Microsoft Dynamics GP Community With the release of Build 18 of the Support Debugging Tool (SDT) I have created a Support Debugging Tool Feedback Survey. This short 10 question survey is really important as previously we have only had anecdotal evidence of the community’s use of and support for the Support Debugging Tool. To help justify the continued development of the Support Debugging Tool, we need some hard data
It has been a way too long between releases, but I am finally ready to release Build 18 of the Support Debugging Tool for Microsoft Dynamics GP for versions 10.0, GP 2010 (v11.0) and GP 2013 (v12.0). This build includes fixes and enhancements to existing features as well as a few new features. I still have a number of great features planned for the Support Debugging Tool (SDT), but sadly just not enough time to develop them all. New in this build is a Feedback Survey so we can obtain some real data on the number of users, what features they use and their satisfaction with the tool
Hi everyone. Pam Misialek has just posted on the Inside Dynamics GP blog an article asking the community to help name the conference scheduled for 10 th to 12 th November 2014.
This will be a 2-for-1 post today as the example given solves a frequently asked question and was used to solve a customer issue. The question I’ve seen a number of times before and been meaning to write about is: “How can I fill the Sales Order Processing scrolling window to a specific line?”. With Dexterity it isn’t terribly difficult but is it possible with Visual Studio Tools?
Happy Valentine’s Day. Today, we have some updates from the official blogs for the products Microsoft Dynamics GP and Management Reporter
Overnight Microsoft officially announced that Satya Nadella would be taking over the company’s reins as Microsoft’s third CEO. Satya is a 46 year old family man with 3 children born in Hyderabad, India. He has been with Microsoft for 22 years and has had many roles across a multitude of areas within the company
Want to learn more about identifying reporting needs when planning a Dynamics GP implementation? Check out this article adapted by MSDynamicsWorld.com from my latest book, Microsoft Dynamics GP 2013 Implementation . There are still a few weeks to go in the book giveaway – you just need to post a comment on that blog post to be entered to win.
I have teamed up with Packt Publishing to organize a giveaway of my latest book, “ Microsoft Dynamics GP 2013 Implementation ”. Three lucky winners will receive a copy of the book. To enter the giveaway, all you need to do is visit the Packt book page to check out the book details, then post your expectations from the book or your initial thoughts about the book in the comments section at the bottom of this blog post.
You might have heard me discuss the TCP Chimney settings before.
Six months after the Xbox One was revealed , Launch Day, November 22 nd 2014, has arrived. Welcome to a new era of gaming and entertainment. For all the latest information check out the Xbox website and Major Nelson’s Blog: Xbox.com MajorNelson.com .
Sometimes it is the simplest things that make our lives easier.
In this post we will discuss about the use of recursive querying in SQL Server. Recently, I got a request from a Partner to develop a SSRS report for the Indented Bill of Materials in the Inventory module. I was going through the Dexterity Indented Bill of Materials report and found out that the report uses a temporary table.
Recently, I had a support case which asked the following: “When I go to Add the Sales Account Number to the Sales Line Items SmartList, there are three Sales Account Number Columns available.
A while ago, Microsoft Dynamics GP 2013 Service Pack 2 was released.
Today we will look into how we can configure mailing for CRM for the below configuration:- CRM Online + Email Router + Exchange Online A few guides that would be helpful when achieving the same is :- Microsoft Dynamics CRM Online Email Router Installation Guide However what is the email router? The Microsoft Dynamics CRM […]
Dynamics professionals can now get CRM 2013 certified! Exam Number Exam Title Release date Link Exam MB2-700 Microsoft Dynamics CRM 2013 Applications January 22, 2014 Link Exam MB2-703 Microsoft Dynamics CRM 2013 Customization and Configuration January 24, 2014 Link For all Dynamics CRM 2011 certified professionals please note that the below notice on the Microsoft […]
This article explains how we can achieve integration between Dynamics CRM 2013 and SharePoint 2013 in 5 simple steps! STEP 1: Download and Install the list component for CRM 2013 that can be found at the below link. Microsoft Dynamics CRM 2013 List Component for Microsoft SharePoint Server 2010 and Microsoft SharePoint Server 2013 (for […]
Microsoft Dynamics CRM Acquires Parature for Customer Service Capabilities – Jan 7, 2014 What CRM offers What Parature adds to the box Microsoft CRM currently has a customer care offering that delivers core customer service with :- Case management Universal queuing and routing Light scheduling Field service Parature provides :- Key self-service knowledge base software […]
Hi all I had uploaded the Dynamics GP 2010 database documentation on my site for online reference. For those who love to download this documentation for offline use, they can download the CHM files from the locations below. Download From Box.com Dynamics GP 2010 System Database Documentation Dynamics GP 2010 Company Database Documentation Alternate Download […]
Hi all As a follow up to my post titled “Dynamics GP 2010 SDK”, I have updated the SDK section with the details of the company database as well, as I had mentioned in the earlier post. You should now see a section in the SDK page as shown below for the company database, from […]
Hi all I have launched a new section in my blog called Database SDK which can be accessed from Documentation >> GP 2010 >> Database SDK When this page is opened, it gives options for viewing the details of the SQL objects in the Dynamics GP system database (i.e.) DYNAMICS. You can click on the […]
Recently there was a support request in the forum, http://social.microsoft.com/Forums/en-US/partnerdynamicsgp/thread/139b760a-5c63-4b16-b480-79f0a569075c where the requirement was as below. “We want to modify the Customer Maintenance window to make the Salesperson ID field uneditable for existing records only. I went into Modifier and made this field uneditable but that makes it uneditable each time the window opens. We […]
Hi all Sometime back, I had posted the SQL Script for AP-GL Reconciliation in my blog. At the time of posting the script, it had supported only one account index for AP. Today, I have updated the script to support multiple account indexes for Accounts Payable. Please take a look at the updated script in […]
When you have Analytical Accounting module installed and configured in a GP company, the Post Through GL for Computer Checks gets automatically disabled in the specific company (even if it was turned on). If we try to activate the same manually (with Analytical Accounting activated), we get the following error message and the system prevents […]
Hi all In this article, I am going to explain yet another functionality in Analytical Accounting, where we can restrict a dimension code to a specific account number (or) a specific range of accounts. When a dimension code is created, we need to grant access to the dimension codes to specific users who can use […]
Hi all This script is in continuation to the previous article where I had posted a script for Budgets vs. Actuals in Amounts in Analytical Accounting – By Dimension Code. This script is for viewing Budgets vs. Actuals (for amounts) at Budget Tree Node level. IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = […]
Hi all Today, I am posting a script for analyzing Budgets vs. Actuals (using Amounts) in Analytical Accounting. However, there are two methods of analyzing the budget information in Analytical Accounting. They are: Node Level Dimension Code Level This script is for viewing Budgets vs. Actuals at Dimension Code level. I will be posting the […]
Hi all This article is to explain how Analytical Accounting (AA) information is transferred from Purchase Orders to Receiving Transaction Entry. The scenario explained below is on an environment where there is one transaction dimension configured in Analytical Accounting. Create a Purchase Order with 2 line items as explained below. PO Number Line Seq. No […]
Hi all As a follow up to my post titled “Dynamics GP 2010 SDK”, I have updated the SDK section with the details of the company database as well, as I had mentioned in the earlier post. You should now see a section in the SDK page as shown below for the company database, from […]
Hi all I have launched a new section in my blog called Database SDK which can be accessed from Documentation >> GP 2010 >> Database SDK When this page is opened, it gives options for viewing the details of the SQL objects in the Dynamics GP system database (i.e.) DYNAMICS. You can click on the […]
Hi all Sometime back, I had posted the SQL Script for AP-GL Reconciliation in my blog. At the time of posting the script, it had supported only one account index for AP. Today, I have updated the script to support multiple account indexes for Accounts Payable. Please take a look at the updated script in […]
Hi all It has been some time since I have posted something useful on my blog. This was because I was busy writing up and testing the reconciliation script that I had developed to reconcile payables and receivables with the general ledger. In this article, I have posted a script to reconcile payables with general […]
Hi all Based on a request from the community, I have decided to post a script for identifying all the payments made on a specific date from a checkbook and the details of what was voided for the specific date. This query helps a great deal in reconciling the funds that were used for processing […]
Recently there was a support request in the forum, http://social.microsoft.com/Forums/en-US/partnerdynamicsgp/thread/139b760a-5c63-4b16-b480-79f0a569075c where the requirement was as below. “We want to modify the Customer Maintenance window to make the Salesperson ID field uneditable for existing records only. I went into Modifier and made this field uneditable but that makes it uneditable each time the window opens. We […]
Hi all The all awaited Build 16 of the Support Debugging Tool is available now…and of course with loads and loads of new features and splendid enhancements. Some of the key additions to SDT is listed below. Macro Recording Functionality SQL Profile Tracing Functionality Trigger Administration Functionality Automation Functionality for Microsoft Support Usage These are […]
Recently there was a support request in the forum, http://social.microsoft.com/Forums/en-US/partnerdynamicsgp/thread/a3237a4f-fa4c-4603-8048-94cc0b2af467 where the requirement was as below. “Is there anything in Accounts Receivable that will allow a certain type of document (whatever that may be) bypass the Credit Limit Check? My client has a customer with a Credit Limit of $5000. They are additionally seeking a […]
Recently there was a support request in the forum, http://social.microsoft.com/Forums/en-US/partnerdynamicsgp/thread/a3237a4f-fa4c-4603-8048-94cc0b2af467 where the requirement was as below. “Is there anything in Accounts Receivable that will allow a certain type of document (whatever that may be) bypass the Credit Limit Check? My client has a customer with a Credit Limit of $5000. They are additionally seeking a […]
This article is based on a recent support request on the SOP Blank Invoice Report form. The Item Description on the report was just 60 characters and the actual item description was about 100 characters. This resulted in the item description getting truncated. I have written this article using the article titled “How to display […]
We have seen a few support cases recently about a change to the Void Historical Payables Transactions and Void Open Payables Transaction windows in Microsoft Dynamics GP 2013 Service Pack 2. Here are the details of the enhancement from the Inside Microsoft Dynamics GP blog ( http://aka.ms/InsideGP ): Microsoft Dynamics GP 2013 Service Pack 2 Feature of the Day: Voiding Updates Previously the two windows were quite different with the Open window only allowing selection of the Vendor ID and the Historical window only allowing selection by Document Number
I hope to clear up some confusion about the One SmartConnect Windows Service functionality and where/how it should be installed for SmartConnect to function properly. The main purpose of the Windows Service is to execute SmartConnect maps on a scheduled basis but is also used to manage changed data source records and map logs. Map Schedules As long as the service is running on at least one machine, it will execute any SmartConnect map that is currently scheduled to run but if there is more than one server or machine running the SmartConnect Windows Service, each one will try and execute a SmartConnect map when it is due to be executed
Hi Microsoft Dynamics GP Community With the release of Build 18 of the Support Debugging Tool (SDT) I have created a Support Debugging Tool Feedback Survey. This short 10 question survey is really important as previously we have only had anecdotal evidence of the community’s use of and support for the Support Debugging Tool. To help justify the continued development of the Support Debugging Tool, we need some hard data
Friday, March 7, 2014 – Day 4 Convergence is almost over.
Thursday, March 6, 2014 – Day 3 After a night of party at Rock-n-Rave on Day 2 , I would be delivering 3 sessions today.
We have seen a few support cases recently about a change to the Void Historical Payables Transactions and Void Open Payables Transaction windows in Microsoft Dynamics GP 2013 Service Pack 2. Here are the details of the enhancement from the Inside Microsoft Dynamics GP blog ( http://aka.ms/InsideGP ): Microsoft Dynamics GP 2013 Service Pack 2 Feature of the Day: Voiding Updates Previously the two windows were quite different with the Open window only allowing selection of the Vendor ID and the Historical window only allowing selection by Document Number
I hope to clear up some confusion about the One SmartConnect Windows Service functionality and where/how it should be installed for SmartConnect to function properly. The main purpose of the Windows Service is to execute SmartConnect maps on a scheduled basis but is also used to manage changed data source records and map logs. Map Schedules As long as the service is running on at least one machine, it will execute any SmartConnect map that is currently scheduled to run but if there is more than one server or machine running the SmartConnect Windows Service, each one will try and execute a SmartConnect map when it is due to be executed
Hi Microsoft Dynamics GP Community With the release of Build 18 of the Support Debugging Tool (SDT) I have created a Support Debugging Tool Feedback Survey. This short 10 question survey is really important as previously we have only had anecdotal evidence of the community’s use of and support for the Support Debugging Tool. To help justify the continued development of the Support Debugging Tool, we need some hard data
Friday, March 7, 2014 – Day 4 Convergence is almost over.
Thursday, March 6, 2014 – Day 3 After a night of party at Rock-n-Rave on Day 2 , I would be delivering 3 sessions today.
Loading ...