Void OR Return? - Belinda's Advise

Belinda advises on what needs to be done when we want to reverse a wrong SOP Invoice. Read it here: Void an Invoice or enter a Return.

Now, let me add to that advise. As she has pointed out, if you have posted an SOP Invoice and if it involves an Inventory Item, it's a thumb rule that we must pass a Return.

Return does the following:

1. Returns Inventory Items to our Stock.
2. Returns Serial / Lot Numbers for the respective Item as well.
3. Reduces also the Customer Receivables.
4. Passes a reverse GL.

So your Inventory is correct, Receivables is correct & is your GL.

VAIDY

SmartConnect 2010 Hotfix - Crucial

There is a SmartConnect 2010 Hotfix available now, which is crucial for 64 Bit Installations specifically.

More details here: SmartConnect 2010 Hotfix.

VAIDY

VBA - Adding Extender Windows to GL Transaction Entry Lines : David Musgrave

This is another code wonder from David Musgrave.

A Hybrid approach (VBA & Dex) which solved a GP - Extender issue. Read it here: VBA - Adding Extender Windows to GL Transaction Entry Lines.

A Must Read for GP Developers.

VAIDY

GP, ODBC DSN & 64 Bit Systems

This post is long pending, since I had worked on the topic around 2 months back.

According to GP Installation Instruction, To set up an ODBC data source, enter the name you assigned to the SQL Server when you installed Microsoft SQL Server. A data source name called Dynamics GP also is created using SQL Native Client. If you don’t want to set up an ODBC data source, mark the Do not create a data source option.

It's very handy (and recommended too) to create the ODBC DSN thru' GP Installation, when we install GP on a 64 Bit System. We all know that GP is a 32 Bit Application. When we install GP on 64 Bit System, it gets installed with 32 Bit Compatibility.

Typically, on a 64 Bit System there are two ODBC Data Source Maintenance wizards available. One is for 64 Bit and other for 32 Bit. What you open from Control Panel -> Administrative Tools (or Start -> Run -> ODBCAD32.exe), is nothing but default 64 Bit ODBC DSN Maintenance wizard.

Microsoft Dynamics GP & CRM - A Gradual Progress

I am currently working on a realtime GP & CRM 2-Way Integration.

Needless to say, I have learned a lot and would like to share what I have learned. And moving forward, you would be seeing a mix of articles which talks about both Dynamics GP (my life) and Dynamics CRM (my interest).

As a first step, I will be posting my first CRM article about CRM - GP Adapter's Picklist Configuration utility in a couple of days.

I hope you all would be interested.

VAIDY

Management Reporter Features - Explained by Sandeep Walia

There are many articles across the Blogosphere on Management Reporter for MS Dynamics ERPs.

This one's pretty good in terms of explaining the basics of MR. And also the points which would make Customers migrate to MR from FRx.

Read the article, Management Reporter For Dynamics ERP – An Analysis, on ERP Software Blog.

UPDATE (19JUN2010): The above link to the original article on ERP Software Blog, seems to be broken and not working.

VAIDY

Niraj's First Birth Anniversary...!

KINDLY NOTE: This post is PERSONAL and nothing to do with Dynamics GP...


Time moves on... Moves on very fast...

Our beloved NIRAJ, Son of Shan & Uma, completes his first year in this world. :-) Yup tomorrow is his first Birth Anniversary...

Let's all join to wish him a Happy Birthday & Blissful Life...!!!

VAIDY

Avoiding Sign-Off Hell - Mark Polino

I had seen this not long ago. And this article by Mark Polino should have come a bit earlier.

Read it: Avoiding Sign-Off Hell.

MUST READ for all Partners / Consultants.

VAIDY

Why Extender Information does not get transferred?

I have been getting this query on WHY EXTENDER INFORMATION ON A SOP QUOTATION DOES NOT GET TRANSFERRED TO THE CORRESPONDING ORDER?

Well, there is obviously no logical reason behind it. Given the fact that SOP User Defined values are getting transferred from Quote to Order to Invoice, we expect the same thing from Extender Information also. Point substantiated.

Deploying GP SSRS Reports - maxRequestLength Error & Resolution

I was deploying GP SSRS Reports on SQL Server 2008 64 Bit and was facing the following error message:

There was an exception running the extensions specified in the config file. ---> Maximum request length exceeded.

Googled it and here the resolution: http://www.developmentnow.com/g/115_2006_4_0_0_735861/Request-Length-Exceeded.htm

I hope this would be a useful tip for people out there deploying SSRS for GP.

VAIDY