dynamicsgpcookbook.blogspot.com

vmdyngp.blogspot.com

Dynamics GP - Learn & Discuss: Who uses BI? - Dwight Specht

http://vmdyngp.blogspot.com/2012/02/who-uses-bi-dwight-specht.html

Tuesday, February 28, 2012. This one's an awesomely simple yet on-the-dot post, which I read today. I am not going to brief about this post and I leave it to you read it fully, understand what exactly it wants us to learn. Here is the post, written by Dwight Specht. I myself am working on BI reports, a lot, nowadays and posts such as this only add to my constant improvement. Special thanks to Dwight. Subscribe to: Post Comments (Atom). View my complete profile. Average Days To Pay. SQL Server 2008 R2.

vmdyngp.blogspot.com

Dynamics GP - Learn & Discuss: Customer Credit Summary: Average Days To Pay

http://vmdyngp.blogspot.com/2012/02/customer-credit-summary-average-days-to.html

Tuesday, February 21, 2012. Customer Credit Summary: Average Days To Pay. I received an email today with a query on GP's "Average Days To Pay" on a Customer's Credit Summary. How GP calculates Average Days To Pay for a customer? According to GP's Receivables Management user manual:. The formula for calculating the average days to pay is:. ADTP = (Current ADTP) x (Number of Invoices) (Number of Days Taken to Pay Most Recent Invoice) / (Number of Invoices 1). Average Days To Pay. Microsoft Certified Micros...

vmdyngp.blogspot.com

Dynamics GP - Learn & Discuss: Packt's Microsoft Dynamics Mayhem

http://vmdyngp.blogspot.com/2012/02/packts-microsoft-dynamics-mayhem.html

Tuesday, February 14, 2012. Packt's Microsoft Dynamics Mayhem. Packt Publications has once again given us an opportunity to get desired Microsoft Dynamics books at staggering discounts. The list of books are quite handful. You do get favorite Microsoft Dynamics GP books (Cookbook by Mark Polino, Reporting by Liley and Duncan and Implementation by Victoria Yudin); all are awesome books for any GPian. Visit Packt's page to learn more about this and get benefited: Microsoft Dynamics Mayhem.

vmdyngp.blogspot.com

Dynamics GP - Learn & Discuss: RIP Apture - I Will Miss You

http://vmdyngp.blogspot.com/2012/01/rip-apture-i-will-miss-you.html

Wednesday, January 25, 2012. RIP Apture - I Will Miss You. How many of my blog readers remember about my blog being enabled with Apture Highlights? It's very sad that this beautiful feature is now no more. I got to know this long back, but the feature that I added on my blog still worked; until this morning. You check out Apture's Site. All you got to see is a message from Apture Team as below:. I am not sure what to express, but only one thing which I feel right now is this:. I will surely miss you.

vmdyngp.blogspot.com

Dynamics GP - Learn & Discuss: October 2011

http://vmdyngp.blogspot.com/2011_10_01_archive.html

Tuesday, October 11, 2011. User Access Setup Error: GPS Error RevokeUserAudit: 58. I faced this error message from the time I upgraded to GP2010 R2. The error message is thrown when we revoke access to a user on a company. Below is the exact sequence of error messages that I received:. Since I had not doing this frequently (it's maximum 3 users in 6 months) and also the purpose of revoking access was working without any issues, I did not consider this as a harmful message. 4 I then launched GP and opened...

vmdyngp.blogspot.com

Dynamics GP - Learn & Discuss: September 2011

http://vmdyngp.blogspot.com/2011_09_01_archive.html

Saturday, September 17, 2011. Using substring() with Text Fields - David. Back from my vacation, several posts grabbed my interest as a developer. This post from David is one of them. David explains how to resolve an issue that was found in Sivakumar's SDT (Support Debugging Tool) based solution. In a nutshell, the issue was with Text type fields and dexterity function substring(). Read it here; Quick Tip: Using substring() with a text field datatype. Links to this post. Subscribe to: Posts (Atom).

vmdyngp.blogspot.com

Dynamics GP - Learn & Discuss: August 2011

http://vmdyngp.blogspot.com/2011_08_01_archive.html

Thursday, August 18, 2011. Taking A Much Needed Break. As you all know by now, I have not been active on my blogging due to a very stringent schedule for past 5 months. And I had been burning my energy for past 2 years without a halt. Meeting people, visiting places, attending functions. I badly need it. Does not mean that I will not be keeping touch with Dynamics GP. :-) I will certainly be reading all posts from fellow bloggers and will be updating myself with happenings. Links to this post. David's po...

vmdyngp.blogspot.com

Dynamics GP - Learn & Discuss: July 2011

http://vmdyngp.blogspot.com/2011_07_01_archive.html

Sunday, July 31, 2011. Illegal Address Field" Error while accessing a Global. This one's interesting and quite straightforward too. I had to create a new Global. Field in my customization. Instead of creating a new field, I added an existing GP field ('Customer Number') and wrote my code to assign value and retrieve value as required. I created the chunk and when my code was executed at run-time, I received the following error message:. At the first look, it's all correct. I have referred to a Global.

vmdyngp.blogspot.com

Dynamics GP - Learn & Discuss: June 2011

http://vmdyngp.blogspot.com/2011_06_01_archive.html

Thursday, June 30, 2011. Support Debugging Tool (SDT) Build 15 Released. Support Debugging Tool (SDT) Build 15 has been released with crucial list of fixes, tons of features and enhancements. By seeing the list I could understand that plenty of efforts would have gone in to get this build up. I recommend everyone to update your environment with this new build to avail it to it's fullest. More about this release: Support Debugging Tool Build 15 Released. Links to this post. Monday, June 27, 2011. Consider...

vmdyngp.blogspot.com

Dynamics GP - Learn & Discuss: November 2011

http://vmdyngp.blogspot.com/2011_11_01_archive.html

Wednesday, November 30, 2011. SQL Tip: Find Table(s) Having A Particular Column. This SQL query is my savior for a long time now. Thought I would just share it with all budding SQL developers. Q: How to find the table(s) which contain a particular column which I know? A: Below is the query that would do the trick. Name = [ columnname. Column which you would want to locate. This query will return all tables which contains the specific column. And this query also would save your time immensely. This one's ...