And why not? After being the most talked about book this year and living up to that expectation, we now have a Site for this book.
Visit the Site: Microsoft Dynamics GP 2010 Cookbook Site.
VAIDY
Microsoft Dynamics GP 2010 Cookbook Site
Monthly Archives: July 2010
Exam Dumps – Emerging Trend in Dynamics Community
I would have read nearly 10 LinkedIn discussion posts and couple more in Forums/Newsgroups for the past one month, asking for Exam Dumps to veer thru’ Dynamics Certifications (ranging from Product to Sure Step). Thought I would just share my thoughts.
The reasons in my opinion for this trend:
1. Employers urge employees to clear certification to get more points & benefits thru’ Microsoft Partner Program.
2. Clients urge Employers to show more “Certified” consultants instead of even “Experienced” consultants.
3. Employees think, in fact believe, that once they get one certification they are on top of the existing breed of consultants and they can be in a demanding position.
Are these just myths or facts? Let’s keep that argument aside and think from a broader perspective.
Any Certification IS A MUST for any consultant. There is no second thought about it. But it is NOT A MUST to GET ONE BY ANY MEANS.
Conventional thinking with respect to Exams, Certifications, etc. has long gone. It’s all about know the details about a certain Certification in 1 day, collect the information on Exam the next day, throw queries on Newgroups/Forums/Pro-Networking Sites about Exam Dumps and get information those who would have put in their blood, soul, efforts, emotions, etc. quite easily the third day, go thru’ the dumps and get confidence that we know all about that Certification the forth day, schedule an exam the fifth day, attend the exam the sixth day and GET the Certification seventh day.
It’s just about 7 days task to get one certification. Does this really help us? Some say it does. Clever people always think about first getting a job and then learn whatever comes on their way. Conventional people always believe in learning the product first and then make sure that they are eligible for a Certification. By experience they become the ones to prepare dumps instead of collecting it from others and unfortunately left behind by those who are clever.
Recently I read a similar question from a Consultant, who wanted to clear past a certain certification and replies were a resounding “Unless you practice these concepts, dumps will not help you at all”. Of course, people. Come on. We are not school kids anymore.
I am a Certified Consultant myself and I can certainly tell you all from my own experience. I also got some dumps (trust me, I never posted any queries on any forums for sure). But those dumps were mere dumps for me, after 6 years of my GP Technical & Functional consulting experience. I simply believe that if I know about GL Reversing Entry in general and in GP in particular, I can answer 1000 questions framed on top of it. I don’t require a dump in that case and I feel proud that I got certified on my own expertise and experience.
I have met many people who excelled in the product first (ask them anything from any nook and corner, you would get more than what you expected) and then went for Certification to make sure that they have one for formalities. I have also met people who got a certification first thru’ dumps and still looking for jobs.
I am sure all of us know how to drive a car more than how Quantum Physics work. Because we drive daily in our life, we practice it. To get a license, we must first attend the classes, know the rules and regulations of that country, practice it for sometime and then attend the test. It’s no different here as well.
It’s that simple. If I cannot understand what a client requires and how I am going to solve it for him/her, then my so called “Certified Consultant” tag is just a label. But if I do know how to, then I am a Consultant who is eligible to get Certified.
I leave this open to all of you to decide how you would like to approach this concept called Certification. Needless to say, I am certainly willing to learn from all of your viewpoints.
VAIDY
Carefully Place Variables Assignment in Dex
This post is right after a coding correction done in one of my customizations.
There is a form which needs to be opened from both SOP Entry & SOP Inquiry. Based on the source, I had to either lock or unlock certain fields, exactly like how SOP Entry & SOP Inquiry windows work.
I created a GLOBAL field called “SOPSource” and created two Startup trigger scripts, namely SOP_Entry_Open_Addl and SOP_Inquiry_Open_Addl on SOP_Entry and SOP_Inquiry respectively. Inside each script, I wrote a piece of code like below:
open form SOP_Additional_Info;
SOPSource of globals = “ENTRY”; {“INQUIRY” for SOP_Inquiry trigger script}
And once my form is opened, in the Window_PRE event script, I had validated the SOPSource GLOBAL field and made sure that I locked or unlocked the appropriate fields.
Now, can anyone guess what was wrong with the above piece of coding?
Mistake: I wrote the GLOBAL field assignment after “open form” statement.
Reason: The above piece of code first opens the form and then assigns the SOPSource Global field with some value. By the time, it assigns the value, the form is already open and WIN_PRE event is already executed. Due to which, my “SOPSource of globals” will always contain an empty string value.
DUH…
Correct Way of Writing:
SOPSource of globals = “ENTRY”; {“INQUIRY” for SOP_Inquiry trigger script}
open form SOP_Additional_Info;
Those who are new to Dex programming, understand that as soon as a “open form” statement is executed, the form is immediately opened and do not wait for the rest of the calling script’s statements. If there is any dependency in the opened window for other statements in a calling script, we must ensure that these statements are written before we open this window.
VAIDY
Displaying 3rd Party Series’ Reports in Report Template Maintenance – Patrick
Boy, I never thought this “3rd Party” series would have such an impact (be it simple or silly or critical).
Patrick explains us one such very important but simple issue: Using 3rd Party Series Reports in the Report Template Maintenance Lookup Window
I have to now check all my customizations’ resources which are created under this 3rd Party series.
And when I reassign the series for those resources, I am not certainly going to place it in PROJECT series. As Patrick quips in his post in one place, if you read it completely.
VAIDY
Excel Report Builder & Pivots – A Head Start post by Devon
This article is a good one to get start of Excel Report Builder and creating a meaningful and handsful Pivots out that single set of data.
Read it here: Excel Report Builder – GP2010 Pivot Tables – Sales By… Anything!
VAIDY
New Resource to find Tables & Fields Information – Victoria Yudin
Victoria points to us a new way of easily finding Table & Field Information in GP.
And this also gives us a strong reason of why we all should use this wonder tool called Support Debugging Tool (SDT).
Go grab it for yourself and install it in first place, if you don’t have one in your GP Environment.
VAIDY
Analytical Accounting Error – After Restoring a Company Database
CAUTION: This post is NOT intended for SQL Administrators who are not familiar with GP Table Structures. The following script may have serious implication on certain GP environments, so please use it at your own risk. This method is also not supported by Microsoft for obvious reasons.
This message was quite annoying when I created a Test Company in GP10 and restored a Production DB for R&D and Testing purpose.
Analytical Accounting windows didn’t get opened and was throwing the following error message:
There were several articles which cautioned / warned off from restoring only Company DB, which I am quite aware of. Because restoring another Company’s DB on to a Test Company will not have any issues unless it has got some products, like AA, depending heavily and real-time on DYNAMICS DB.
After a bit of R&D here and there, this is what I did. There is a table called AAG00104 in DYNAMICS Database, which is Analytical Accounting Company Setup table. I wrote an UPDATE on this table for the newly created company record as below:
UPDATE DYNAMICS..AAG00104
SET aaCompanyStatus = 4, aaRelease = 10
WHERE CMPANYID = [Test Company ID Integer value]
This obviously worked in my environment and released the Test Company for AA usage.
As I mentioned at the start of this post, be cautious and do not venture into this unless you are sure of the consequences.
I am also not quite sure whether we have any fix for this issue, as I could not get one from CustomerSource or PartnerSource. I may have overlooked. Please do write a comment if we already have a script for this issue.
VAIDY
GPWindow – A Site for Dynamics GP Resources by Jivtesh
Jivtesh has come up with a noble concept; his new website called GPWindow.com.
Let me share with you about what I liked in this site:
1. The left panel lists us the top sites, based on the number of posts. For a Blogger like me: This means, the one who regularly blogs will get a chance to get more visibility. For a User who looks for a blog: This means, you have got a fair idea about the list of top most GP Blogs which are there for you.
2. The right panel recommends some of the GP Articles. Any post in any blog that has got a mention from other Bloggers or websites or forums.
3. On the top, there is a tab which takes you to:
3.1. Recommended Links: Those links from all GP blogs that are recommended by anyone out there in his/her blog, forum, website, newsgroups, etc. Awesome, isn’t it?
3.2. Latest Links: As the name suggests.
3.3. Top Hits: Those posts which got the most number of hits.
4. Center Panel gives us the best part; Categorization of posts. This is done by parsing post titles and categorizes it based on several keywords. While this list is not yet complete, it’s still comprehensive.
5. And finally there is a Custom Search, designed and created by Jivtesh. This is exactly what I am using in my blog as well. This allows users to focus on one place and get what they want without searching on different sites.
As the site name suggests, it’s clearly a Window to your GP resources.
What it means for a Blogger like me?
1. I am quite happy personally to have got listed as #5. Quite an achievement by me. Considering the fact that I started blogging for a completely different reason but got hooked to this beautiful concept called Knowledge Sharing. This opened up to me an entirely different community dedicated selflessly to help users, consultants & themselves. So it’s quite a proud moment.
2. I also feel very responsible now that my blog is listed. I must be up-to-date, relevant to what I write, accurate in what I share & should be right on concept.
3. I tend to work more on my blog & newsgroup activities, so that I learn more and I share even more to you all.
What it means for a user like me?
1. My search time is quite less from now on. I just open this site and enter what I want to know. Custom Search goes thru’ each and every GP site listed in David Musgrave’s blog and get what you want.
2. I get to see the most active blogs in GP Blogosphere.
3. I get almost anything that I wish to learn from one place.
And more, of course…
Thanks to Jivtesh for this wonderful concept site.
Important: Do post your feedbacks by clicking on Contact. This will enable Jivtesh to keep this site well maintained and improved.
VAIDY
Rename Tables in Crystal Reports – Victoria
Another nice tip from Victoria on How to Rename Tables in Crystal Reports. And this tip is quite handy.
VAIDY
Display Extender Data for GL Trx Lines on GL Inquiry – David
This post is awesome. And quite a practical requirement nowadays. David takes us thru’ the steps involved in writing a piece of code that does wonders for us.
Read it here: Display Extender Data for GL Trx Lines on GL Inquiry
VAIDY
Dynamics GP - Learn & Discuss 