10/07/2010

Microsoft Dynamics Community Website got a new look

Microsoft Dynamics community website has got a version upgrade today with a complete new look and feel. The original community website was launched in 2007 and since then the website has become a one stop resource for Microsoft Dynamics users and professionals. Currently, the site is serving about 40,000 + members.

For a detailed information of the new features introduced with the community 2.0 release, visit the link below

Community 2.0 Features

10/06/2010

How to reverse Revenue Recognition transactions in Project Accounting

When the revenue is recognized for a project using Revenue recognition entry in Microsoft Dynamics GP Project Accounting module and if there is a situation where we would like to reverse the posted RR transaction. Here in this article, I put up the steps to do the same.

1. Make sure override RR amount is marked in PA | Billing | RR Options setup. Otherwise, the system wouldn’t allow us to change the amounts in RR entry window.

2. Open RR Entry window, Enter the customer ID and the Project ID for which revenue transactions that were posted earlier need to be reversed now.

3. Once the Project ID is selected, click the arrow next to Budget

RR-1

4. Enter the negative amount in each cost category in To recognize field. If the amount is higher than the recognized amount, then the system wouldn’t allow doing that.

RR-2

5.  Now Post the RR transaction so as to reverse the posted RR transaction.

10/02/2010

How to copy Smart list to Excel Report Builder

If you look to copy a report from Smart list builder (SLB) to  Excel Report Builder (ERB) or vice versa, there is an option in both SLB and ERB called “duplicate” in options menu to do this task for us.

To copy a report from SLB to ERB, Go through the following steps

1. open the report to be copied in SLB, Go to options | Duplicate

slb-1

2. Choose Excel Report in New List type and assign New list ID and New list name or accept defaults.

slb-2

3. Click Duplicate.

Now, Go back to ERB. The same report appears in ERB as in SLB. Repeat the same steps for copying report from ERB to SLB.

Display Totals in Smart lists

While we all know that Smart list doesn’t support displaying totals, We now have a workaround to beat this limitation in Dynamics GP 2010. Though I’m yet to test this functionality, I thought to quickly share this cool feature.

In Excel Report builder, Select the report and go to options and mark “Display totals at the end of each list”. This feature would then ensure all the numeric fields in the reports sum up when the report is published.

erb-1

We can duplicate all our existing smart list builder reports to Excel report builder using Duplicate option in Smart list Builder to copy them to Excel Report Builder.

EFT Module: Bugs or by Design?

Quite recently, I had a chance to work on EFT for Payables Management module first time as one of my clients wanted this feature implemented in their environment for Dynamics GP 10 for one of the global bank format. During the feasibility test, I found the following issues which I termed them as “bugs” while Microsoft Technical support doesn’t want them to term them as bugs and instead call them “by design”. Well, while I understand it is always difficult to accommodate specific requests into a product that has a global reach and instead guide those requests to be routed to a product suggestion however I felt the below issues are far more critical to be fixed as they question the very functionality of EFT module in specific.

In EFT File Format maintenance, there is calculation field mapping that is available to map certain fields. Whenever calculation type is selected in maps to field, then various options appear as shown in the image below.

eft_1

The purpose of these calculation types are as follows that is provided in GP documentation.

eft-2

The documentation states these types are often used in batch footers or file footers of flat files, however, it doesn’t explicitly deny the fact that they are supposed to work in other line types. Below are the issues with these calculated fields. (Not all calculated fields are tested)

1. Line count when used in File header generates 1 constantly when it is supposed to place the value of total number of lines in the file. Say a file has 10 lines including file header, it has to place a value of 10 but it generates value 1 constantly.

2. Total Credit Amount when used in batch header generates 0 value

3. Detail count when used in batch header generates 0 value

I didn’t test the other calculated fields though. I went to Microsoft Technical support route to help fix these issues and here is the final reply that I received from them.

The Line Count, Number of Credits, and Total Credit Amount calculations are only designed to work in the footer lines (Batch Control, File Control, etc).  They do not work in the header files at this point, by design.  The calculations create the field in the footer lines and then update them as the EFT file is written.  Adding the functionality to the header rows at this point is not a possibility and may slow down the file processing procedure as well.

I’m in total disagreement to the above statement personally for the following reasons.

1. EFT in its first place is a module that has to be configured according to the formats provided by different banks. In other words, the module needs to be flexible enough to set any type of format.

2. It is not logical to expect the banks to follow the GP format and it should be the other way round. Expecting all banks to have line count, Total credit and number of credits like fields only in footer lines is not a valid assumption in my personal opinion.

3. In EFT, there are some readily defined formats. Among those formats, CA-National Bank of Canada (refer to image below) and CA-RBC Royal Bank have line count field defined in the file header. So How can we say that this is by design when there are several banks requiring the line count and other fields in File header or Batch header or Detail lines?

eft-3

 

eft-4

4. If this is the case, what’s the point providing a user-defined format in the format type if the system isn’t flexible enough to accommodate the bank specific formats?

Having said the above, I must say the module works absolutely perfect in terms of functionality barring few other format issues. Fortunately, In my case I’m blessed with a highly qualified in house dexterity development team who has been able to take care of the above issues very quickly through dexterity. I just thought to highlight the above issues to get to know anyone else with better thoughts or similar experience on this.