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.
It seems like a trivial subject for our dedicated readers but we had a new customer who is just learning Dexterity and he was having trouble recently trying to select items out of a ListBox. And just today the issue came up about Drop Down Lists (DDL) and getting the value selected using VBA in a different case. So this seemed like a good time to put this together. One thing to note is that while I refer to ListBox here in the example, the same rules apply to a Button Drop List (BDL), Drop Down List (DDL), or ListBox (LB). So in this case, the customer had 2 listbox controls.
Last month, I wrote an article about the Surface 2, Surface Pro 2 and accessories being announced . As a follow up I thought I would post links to some new videos and to the launch event, in case you missed it.
I was recently asked about a custom button that was added to a window and how to change the internet URL that the button opened when it was closed. I was not provided with any other information or screenshots. The answer to the question is that the method to change the URL depends on what tool was used to create the custom button
Recently, Microsoft announced new promotions for both new and existing users of Microsoft GP and NAV. These promotions allow for expansion, renewal or extension of new and existing software packages: Give Me 5 Again ( New Customers Only ) – There are two options to take advantage of this promotion Starter Pack plus 2 more Full Users for $3,000 . Special pricing available until December 24! Get yourself and two others started for a great low price. Starter Pack plus 2 more Full Users for $5,000 .
As mentioned in my post, Microsoft Dynamics GP 2013, Printer Selection, Named Printers, Page Orientation and the System Print Dialog , there was an issue where the feature to allow the printer destination to be changed after the report had been printed to screen did not honour printer setting changes made by Named Printers or the page orientation setting from report writer. This issue was logged as Problem Report 68382: GP 2013 System Print Dialog ignores printer Destination provided on Run Report command (as used by Named Printers). I am happy to announce that this bug has been fixed in Microsoft Dynamics GP 2013 Service Pack 2. So now you can have printer selection cake and eat it too.
Most employers who provide payroll for their employees withhold deductions from employees’ paychecks. There are times, however, when some deductions cannot be withheld for a variety of reasons
As mentioned in my previous post, RoboCup Junior WA 2013 Rescue Premier & Senior Dance State Champions , my sons and I went to Brisbane, Queensland for the Robocup Junior Australia 2013 National Championships on 21 st and 22 nd of September 2013.
This topic has been in my drafts list for ages after it was mentioned in this partner forum thread: Decimal places in GP2013 – SmartList to Excel . However, I did not want to write it up until I could offer some solutions for it at the same time.
Nothing is more frustrating than generating a report and noticing there are entire periods showing zero activity.
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 […]
Recently, I was responding to a forum discussion where the issue mentioned was as shown below. “Occasionally, one of the subsystems that we integrate invoices from will send over an invoice with an incorrect date (11/20/1911 instead of 11/20/2011). These invoices post just fine. However, when we process a check run that includes an invoice […]
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 […]
Hi all Sometimes, when we book invoices against vendors, we might have to post the expense into multiple GL accounts based for the purpose of financial reporting. Mostly I have seen a specific purchases account defaulted at the vendor level and the users manually add additional expense lines at the distribution window at the time […]
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 […]
A client of ours, sent out an email today saying that the YTD Sales Amount that they see on the Receivables Yearly Summary Inquiry window does not match with the Receivables Transactions smartlist’s Sales Amount pulled for the specific customer for the specific year. On analyzing the issue, I noticed that they have only pulled […]
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, I was assisting a forum user, who had requested an option to provide a visual indicator in the footer of the customer statement report, which indicates if the statement has a single page or multiple pages. After a little thought I had come up with this idea and replied back to the forum user […]
Based on a recent support request, I have decided to post yet another article which utilizes the Support Debugging Tool to achieve the above requirement, where in the voided documents do not appear in the Customer Statement. For this requirement, I have customized the RM Statement On Blank Paper version of the Customer Statement. The […]
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 […]
The Modifying Existing SmartLists feature will allow you to modify any existing SmartList. If it was created in SmartList Builder, it will open that setup. If it is one of the default lists that come with SmartList, it will create a new SmartList Builder setup that mimics the default list. It isn’t going to modify the actual default list, but is going to create a new one and hide the original. Let’s look at the feature in more detail when trying to modify one of the default lists that come with SmartList such as the Vendor list. With this new feature, you will be able to highlight any existing SmartList and click the Modify button in SmartList.
This probably would be a common error faced by many of us across the GP world, while trying to access GP 2013 Web Client. Upon launching GP web client on my browser, it asked me to enter my domain credentials and once I did that, I was greeted with following error: Complete error message is as follows: Severity: Critical Summary: An error occurred while initializing communication with the server
My second book as reviewer is Microsoft Dynamics GP 2013 Reporting – Second Edition written by David Duncan and Chris Liley. This book is second edition to their famous Microsoft Dynamics GP 2010 Reporting . So those who have read this book before would see the new book as an upgrade
I’ve been working on a re-design of my website, which is coming along nicely and I’m very excited to see it when it goes live! I’m moving away from a traditional “website” where I need to maintain Products and Services pages (which I don’t, if you are a frequent visitor), and going to Wordpress and a straight blog site. I’ll post another article just before it goes live, as the RSS feed likely will be different, for those who subscribe to my posts that way
The Modifying Existing SmartLists feature will allow you to modify any existing SmartList. If it was created in SmartList Builder, it will open that setup. If it is one of the default lists that come with SmartList, it will create a new SmartList Builder setup that mimics the default list. It isn’t going to modify the actual default list, but is going to create a new one and hide the original. Let’s look at the feature in more detail when trying to modify one of the default lists that come with SmartList such as the Vendor list. With this new feature, you will be able to highlight any existing SmartList and click the Modify button in SmartList.
This probably would be a common error faced by many of us across the GP world, while trying to access GP 2013 Web Client. Upon launching GP web client on my browser, it asked me to enter my domain credentials and once I did that, I was greeted with following error: Complete error message is as follows: Severity: Critical Summary: An error occurred while initializing communication with the server
My second book as reviewer is Microsoft Dynamics GP 2013 Reporting – Second Edition written by David Duncan and Chris Liley. This book is second edition to their famous Microsoft Dynamics GP 2010 Reporting . So those who have read this book before would see the new book as an upgrade
I’ve been working on a re-design of my website, which is coming along nicely and I’m very excited to see it when it goes live! I’m moving away from a traditional “website” where I need to maintain Products and Services pages (which I don’t, if you are a frequent visitor), and going to Wordpress and a straight blog site. I’ll post another article just before it goes live, as the RSS feed likely will be different, for those who subscribe to my posts that way
Loading ...