Duplicate a Posted Journal Entry

Posted on May 22, 2012 by Vaidhy Mohan

Rose Business Solutions, Inc. blogs about a really useful tip for Finance users on how to duplicate a posted journal entry.

It’s very much time saving if your journal entry is big enough.

VAIDY

Microsoft Dynamics GP 2013 – System Requirements

Posted on May 20, 2012 by Vaidhy Mohan

Microsoft had released the System Requirements for Dynamics GP 2013, that includes GP Web Client requirements as well. The system requirements page can be found here: System Requirements for Microsoft Dynamics GP 2013.

While I leave it to you to get informed about entire details, it’s worth to brief you about what are NOT supported:

Windows XP all editions
Windows Server 2003 all editions
Internet Explorer 7.0
Microsoft Office 2007
Microsoft SQL Server 2005 all editions
Windows SharePoint Services 3.0
Microsoft Office SharePoint Server 2007
Office Communicator 2007

So start planning for the future of GP.

VAIDY

Dynamics GP Developer Insight – Web Client Window Ribbon – Part 2

Posted on May 18, 2012 by Vaidhy Mohan

With some examples, Rushi Patel explains us about how the Web Client ribbon is customized for our real time needs.

Read it here at Developing For Dynamics GP blog post: Dynamics GP Developer Insights – Web Client Window Ribbon Part 2.

I am more excited to get my hands on GP 2013 development after reading such posts. It’s going to be delightful.

VAIDY

Cashbook Bank Transfer Error: Date entered is not a current period for checkbook [Checkbook ID]

Posted on May 17, 2012 by Vaidhy Mohan

This was a menace for the past 4 days, to say the least.

I was reported of this issue, where a user when trying to enter a bank transfer for a checkbook, on a date in previous month, he got this error message (in the title of this post) as shown below:

The above message occurred only for one particular checkbook and not for others.

First step was to ensure the fiscal period was not closed. It was not.

Second step was to ensure that they had not run the reconciliation for this checkbook, so genuinely it had closed the period. It was not.

Third step was to run check links for Checkbook Master, to ensure that things are fine with Checkbook ID master record. It was perfect.

Fourth step was to take SQL Profile and see where exactly this message pops up. When I took twice, the results were different. Due to Analytical Accounting. But that I never got to know since, my focus was more on CB tables.

I referred to the ONLY AVAILABLE forum post, Date Entered is not for Current Period for CashBook, which was way back in year 2010. No solution was provided though.

I decided to take the SQL profile again, but this time without Analytical Accounting to avoid extra lines on the trace file. I took the profile twice and both matched line by line.

The last table where the buck stopped was CBINT605 (Reconciled Amounts) on DYNAMICS database. When I queried this table manually, following was the result:

As you see above, there was a record for this checkbook ID, with a date 30-Apr-2012. Due to which, if you enter any date on or before 30-Apr-2012, it fails.

I checked the user again to ensure that he had not run any reconciliation for this checkbook. He assured that he didn’t, but he also mentioned that he was demonstrating this process to a user, but did not complete it. Bad. Demonstrating on a live company is very bad.

I took a backup of this table and then deleted this record.

Now, my checkbook accepts any date for it’s bank transfer entry.

MORAL OF STORY #1: Messages never lie. If there is a message, it will most probably be correct.

MORAL OF STORY #2: Never ever do any R&D on live company. Never ever demonstrate anything on a live company. That’s why test companies are for.

VAIDY

Moving Dynamics ERP to the Cloud? Avoid the Lightning

Posted on May 16, 2012 by Vaidhy Mohan

Quite an informative and the most relevant post about Cloud ERP environment.

Andrew Snook, Fastpath Inc., explains us why and how to take necessary precaution before deciding on moving our Dynamics ERP on to the cloud.

It’s very important and informative. Must read for all those who have got a serious thought about cloud ERP.

NOTE: For those who are new to this portal; you may have to register yourself on to this site to read the complete post. It’s a member-only site, but the membership is free of cost.

VAIDY

Dynamics GP Developer Insight – Web Client Window Ribbon

Posted on May 11, 2012 by Vaidhy Mohan

Rushi Patel, from Microsoft Dynamics GP Team in Fargo, has started a new series of posts on Developing For Dynamics GP blog that would shed some light on upcoming Dynamics GP in terms of underlying technologies and how its developed.

First post, Web Client Window Ribbon Part 1, talks about default Ribbon Rules that are followed in developing the web client window ribbon.

Awesome posts ahead.

VAIDY

Dynamic Future – Vote a Feature on Microsoft Connect

Posted on May 10, 2012 by Vaidhy Mohan

Mark Polino, after his uber-successful ways of informing the community about many things in Microsoft Dynamics GP, has found one more brilliant way to hook us on to Microsoft Connect (portal where we can voice our feedback about a Microsoft product).

It’s simply this: Every Tuesday, Mark would link us to a feature feedback on Microsoft Connect portal, which require Dynamics GP End Users/Consultants/Developers to vote for it, so it would be worked upon by Microsoft and would get released on subsequent major releases of this product.

Starting with May 1st, 2012, he has already pointed out two features that cry for our attention and vote:

May 1st, 2012: Unit Account should have the option to clear at Year End

May 8th, 2012: Management Reporter should allow each column to have it’s own current rate

And many more to come.

Stay tuned to his blog for future Dynamic Future posts.

VAIDY

Why consultants shouldn’t post Dynamics GP batches on a client’s system?

Posted on May 10, 2012 by Vaidhy Mohan

I second Christina’s point. Never ever, you consultant, post any transaction on a client’s system. Whatever it is. Be it correction entry or a backlog entry or a real time transaction or even a test entry to demo.

I learned that lesson very long back, around 5 years back, when I was in my infancy on consultancy. Like Christina, my lesson was also very bitter. And then, I never did that ever in my life.

VAIDY