Interesting Findings & Knowledge Sharing

| |

Succinctly – A Series of E-Books and Whitepapers

Posted 3 months ago

by Sivakumar Venkataraman

While a lot of information on application development is available on the internet and in books, that information is becoming harder to digest. If you do not enjoy reading several 500+ page books, or scouring the web for relevant blog posts and articles...
Microsoft Dynamics Most Influential People Top 100

Posted over 1 year ago

by Sivakumar Venkataraman

Hi all Congrats to Mark Polino, Jon Rivers, Mariano Gomez, Frank Hamelly, Victoria Yudin and all others who have got into the hall of fame for 2012. You have all been great mentors to the community, and there is absolutely no doubts in that. Thanks...
Moving into Microsoft

Posted over 1 year ago

by Sivakumar Venkataraman

Hi all After about 8+ years of experience in the Microsoft Dynamics GP & CRM platforms, I have finally achieved what I have been dreaming all these years – an opportunity to work in one of the most coveted organizations in the world – MICROSOFT...
Dynamics GP 2010 Database SDK Downloads

Posted over 1 year ago

by Sivakumar Venkataraman

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 Database SDK – Company Database Details Uploaded

Posted over 1 year ago

by Sivakumar Venkataraman

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...
Dynamics GP 2010 R2 Database SDK

Posted over 1 year ago

by Sivakumar Venkataraman

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...
Support Debugging Tool Customization #11 – Restricting Salesperson ID for Existing Customers

Posted over 1 year ago

by Sivakumar Venkataraman

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...
SQL Script for AP-GL Reconciliation – Updated

Posted over 1 year ago

by Sivakumar Venkataraman

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...
azurecurve.co.uk finally back up

Posted over 1 year ago

by Sivakumar Venkataraman

Well, after approximately thirty six hours of downtime azurecurve is back up and running. Speed currently seems to be up and down but I’m hoping this is just index rebuilds or similar slowing things down. If you encounter any problems … Continue reading...
US Subsidiary extends Cloud Offer

Posted over 1 year ago

by Sivakumar Venkataraman

ERP Cloud Value Offer What’s the Offer? $1000 rebate when customers in the United States ispurchasing either the Advanced Management (AM) or Business Essential (BE)through SPLA Licensing program The US subsidiary will have this offer inmarket effective...
Number of results columns doesn’t match table definition errors in Personal Data Keeper

Posted over 1 year ago

by Sivakumar Venkataraman

Hi everyone, If you are using Personal Data Keeper (PDK) you have probably seen a Get/Change message whose More Info button displays the error “Number of results columns doesnt match table definition.” There are a number of errors that can cause that...
Top 100 Most Influential People in Microsoft Dynamics 2012 Nominations

Posted over 1 year ago

by Sivakumar Venkataraman

It is that time again, last week Dynamics World started compiling their Top 100 list for 2012. They are starting by asking for nominations for people to include in their list which will be voted on in the coming months. Please visit their page which explains...
Leap Year

Posted over 1 year ago

by Sivakumar Venkataraman

The SmartConnect scheduling service was caught out by the 29th February 2012. That wonderful leap year event that only comes around every four years. For those that found their scheduled integrations either stopped or got excited and ran every minute...
Using Refund Checks In Microsoft Dynamics GP

Posted over 1 year ago

by Sivakumar Venkataraman

Date: February 24, 2012 Many Dynamics GP users think they are stuck using the standard word templates found within the Dynamics GP tool. What they don’t realize is they have options. In this video, Christina Phillips, BKD supervising consultant, takes...
Payroll Vacation and Sick Time Accruals in Dynamics GP

Posted over 1 year ago

by Sivakumar Venkataraman

Some people are surprised to learn that Dynamics GP Payroll can provide accrual capability for vacation and sick time. With the addition of PTO Manager, you can expand that functionality beyond the basics. Let’s look at the core vacation and sick accrual...
Updating Item Purchasing Unit Of Measure From A CSV

Posted over 1 year ago

by Sivakumar Venkataraman

After a slight mid-week diversion, here is another script I produced a while ago which updates the Item’s Default Purchasing Unit of Measure. It was produced when a client wanted to bulk update a large number of records which would … Continue reading...
Moving SQL Server Reporting Services from Native Mode to SharePoint Integrated Mode

Posted over 1 year ago

by Sivakumar Venkataraman

Historically, many of our customers started out deploying their Microsoft Dynamics GP reports to SQL Server Reporting Services (SSRS) in Native mode, meaning that they used a Report Manager site to access their reports. With the high adoption rate of...
Windows 8 Consumer Preview Available

Posted over 1 year ago

by Sivakumar Venkataraman

Windows 8 Consumer Preview now available for download. Yesterday, at the Mobile World Congress in Barcelona, Spain, Microsoft announced the availability of the Windows 8 Consumer Preview.; full details at the Building Windows 8 blog. I’m in the process...
Interview at Dynamicsworld.co.uk

Posted over 1 year ago

by Sivakumar Venkataraman

Hi all It was a surprise when I was contacted by James Burke at Dynamicsworld for an interview last week. I was happy in providing it and you can view the transcript of the interview in the URL below. http://www.dynamicsworld.co.uk/Interview-Sivakumar...
Unable to drill into PA Inventory Transfer Inquiry Zoom from Historical Journal Entries

Posted over 1 year ago

by Sivakumar Venkataraman

I was troubleshooting a recent issue in the community forums, where the user was trying to drill into the PA Inventory Transfer Inquiry Zoom window from a historical year journal entry. The PA Inquiry window opened but it did not populate any values in...
SQL Script for AP-GL Reconciliation

Posted over 1 year ago

by Sivakumar Venkataraman

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...
Windows Desktop Screen Layout Issue

Posted over 1 year ago

by Sivakumar Venkataraman

Today, I have decided to post an article on a recent issue which I assisted one of my friends, who had the desktop layout showing upside down. The issue generally happens when you press the CTRL + ALT and any of the keyboard arrow keys. I decided to explain...
Support Debugging Tool–Build 16 Available Now!

Posted over 1 year ago

by Sivakumar Venkataraman

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...
Seasons Greetings

Posted over 1 year ago

by Sivakumar Venkataraman

Hi all Wishing the entire community a Merry Christmas and a very Happy and Prosperous New Year 2012. Hope to post a lot more interesting articles in the following year… More coming soon! Read the rest of this entry
Posting Interruptions in Accounts Payable – Check Runs

Posted over 1 year ago

by Sivakumar Venkataraman

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)...

Microsoft Dynamics GP

About Interesting Findings & Knowledge Sharing