Posts

Showing posts from October, 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

How to reverse Revenue Recognition transactions in Project Accounting

Image
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 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. 5.  Now Post the RR transaction so as to reverse the posted RR transaction.

How to copy Smart list to Excel Report Builder

Image
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 2. Choose Excel Report in New List type and assign New list ID and New list name or accept defaults. 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

Image
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. 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?

Image
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. The purpose of these calculation