Posts

Showing posts from January, 2011

Round 2 US Payroll Tax Update is Released

Round 2 Payroll Update is now available for download on Customer source The much awaited US Payroll Round 2 Tax update for Dynamics GP 10 has been released this morning. The release has been updated on Customer source and Partner source. Round 3 which includes update for Illinois, Maine and Maryland is yet to be released though. Round 2 Tax update includes changes to the employer portion bringing it back to 6.2% contribution for FICA/Social security withholding. To download Round 2 update, Follow the link below Round 2 US Payroll Tax Update for Microsoft Dynamics GP 10.0

Payables Management - Document Number appear Blank

When Checkbook ID is selected in Manual Payment entry, the document number appear blank and the payables edit list displays an error that the duplicate check numbers are not allowed. S ometimes you tend to get confused at times when you see a weird system behavior. You go and look back at your fundamentals if it’s the case really. This happened to me recently while providing support to a client. This is related to an issue surfaced in manual payment entry screen of Payables Management module of Dynamics GP 10. We all know very well that the document number (check number) in manual payment entry defaults to the available next check number field in Check book maintenance screen when the checkbook ID is selected. In this case, when the check book ID is selected, it just appears blank and doesn’t default to the said field in checkbook maintenance. For a while, I got confused if this is by design and has to go back to my local install to check if this is really the case. Fortunatel

Excel Report Builder–Publish Report in GP 2010

"Excel Report Builder: You do not have security privileges to publish this report." I published an article in late 2009 titled Excel Report Builder: Publish Function that dealt with publishing permissions for report built in Excel Report Builder in Dynamics GP 10.0. Summary of this post is that only user ‘sa’ user can publish the report . Dynamics GP 2010 addressed this problem. I’d say it is resolved partially but not fully because even now not all users are allowed to publish the report. The Publish report permission has been extended to the users with the below server roles sa user DYNSA user db_owner database role sysAdmin fixed server role dbcreator fixed server role On one hand, I found this extension of users as welcoming but on the other hand, I don’t understand why it can’t be applied to all users and leave the control at the user security level. I think it is SQL server limitations which could have made this module developers handicapped to limit t

Send To E-Mail Problem with Office Outlook 2010

Image
One of the most flexible feature of Microsoft Dynamics GP is its ability to send reports by E-mail in text or PDF format on the fly. Majority of users find this feature useful and part of their day to day operation. Microsoft Office Outlook 2010 brought new issues to this feature. Starting Microsoft Office 2010, Outlook is available as a 32-bit application and 64-bit application. For those running with Outlook 2010 32-bit application, Send To E-mail feature is no issue. However Issue is with Outlook 2010. The Send to E-mail functionality simply doesn’t work with 64-bit Outlook 2010. When a report is run and send to E-mail, Text or PDF whatever, is selected, Dynamics GP does nothing. Reason for this is Dynamics GP is developed as a 32-bit application . Send to E-mail is a MAPI application which is creating the issue here. Reasons for this issue on part of Microsoft Office 2010 are outlined in this link . Now I think you ask yourself the same question that I ask myself. Why the heck

Dynamics GP 9.0 Support Ends

Image
  Support for Dynamics GP 9.0 ended yesterday, i.e., 11-January-2011. The support Lifecycle for Dynamics GP 9.0 can be found here . In order to avail support from Microsoft, It is required to upgrade to Dynamics GP 10.0 or higher. Mainstream support for Dynamics GP 10.0 ends on 09-October-2012. Important Note on Payroll Round 2 Update for Dynamics GP 9. Though support for Dynamics GP 9.0 ends on 11-Jan-2011, Microsoft will release the Round 2 Tax update for Dynamics GP 9.0 also as was unofficially told in Microsoft Dynamics Partner Forum discussion thread. The discussion can be found here . The word is also that Microsoft will provide Dynamics GP 9.0 support for the installation of this patch file alone. It applies the same for SBF 9.0. Disclaimer: Please note that the above is provided for informative purposes. Please contact Microsoft support Team or your authorized Microsoft Partner for any queries.

GP Customizations–Documentation Critical

Image
I was looking at this great piece of flow diagram for GP customization from Mark Polino this morning. He draws an important parallel between delivering a quality customization versus delivering a customization based on time constraint. Any developer working on a piece of code for customizing the application has to do it right instead of thinking to do it fast. (Image courtesy: Mark Polino’s Dynamic Accounting.Net Blog) Yes. This is the case. I have experienced this earlier. One instance when I was doing an implementation for a telecom sector client in one of my previous job assignments, there was a customization written by an earlier developer . I was told by the client that the developer did deliver it well but he has to do it fast due to time constraint. Ultimately this was a complete start over again. Clear understanding of requirements is important for a successful delivery of a customization. We should also keep in mind to always respect the business logic of the application wh

Tracking Payroll Updates

Image
Considering the Payroll hot topic, I’ve created the post with a consolidated list of threads being posted on Dynamics community forums whichever I’m finding them helpful. I’d update this post with any other threads that I find in due course of time. If you have any other information to be updated on this post, Please post in the comments section so that I can update the same over here. GP 10.0 Year End update and Security Issues – This post talks about the security settings that are changed after applying the year-end update. After 2010 Year End Update applied - This post talks about the reporting issues in Accounts Payable. Tax Updates GP 10 - This post seeks clarification about which payroll update to be applied. Monthly and Quarterly SUTA/FUTA Liability - This post seeks help in troubleshooting an issue where FUTA/SUTA liability was wrongly processed for Oct-Dec 2010 instead of calculating it for Dec 2010. Credit Card numbers hidden in MS Dynamics GP 10 after SP5 update

How to remove requisitions from Business Portal

Image
Consider this scenario of your development environment for Dynamics GP Requisition Management in Business Portal before deploying the production environment. What if you would want to remove all requisitions? Here is one easy method to accomplish the same. Deleting data from tables is not always the wise choice though. Requisition Management tables are stored in DYNAMICS database. Here are the tables where it holds requisition transactional data. Keep a backup of DYNAMICS Database first and then run a DELETE statement on these tables below to delete the complete data. ReqMgmtDocument – This holds the Requisition header data ReqMgmtLines- This holds the Requisition line items detail ReqMgmtOpenTasks- This holds list of requisitions waiting on for approval ReqMgmtAuditHistoryDocument-This holds complete history of the requisitions Header ReqMgmtAuditHistoryLines- This holds requisitions line item history After this, We can reset the Next Requisition number in Company setti

Fixed Assets Depreciation hangs on GP 2010

Image
  Recently I had encountered an issue while depreciating fixed assets in Dynamics GP 2010. The system hangs for a while and only option was to kill the dynamics.exe from the task manager. I found that there is an issue with assets for which depreciation is less than 0.01. What I did was to run the following statement first in SQL server to get rid of the current depreciation run after taking a backup of data. DELETE FA01500 DELETE FA41900 DELETE FA40203 DELETE FAINDEX Then, I set those penny assets depreciation method to None from straight line original life method. Now, ran the depreciation routine and it worked like a charm.

US Payroll 2011 Round 1 Tax Tables Update

Image
While going through discussion points in Dynamics GP forums, I observed the queries on Payroll (US) 2011 Tax table update is on a rising trend. Most clients have updated their tax tables to 2011 tables before closing out the year 2010. Adding to this, the new tables included FICA update which calculates Employee FICA SS @ 4.2%, the new rate instead of 6.2%. Since Dynamics GP calculation is based on one rate, both employer and employee rate is set @ 4.2% while it should be 6.2% for employers contribution. The workaround was to pass a GL adjustment for the remaining employer’s contribution. However, A Round 2 Tax update is planned to be release d by January 24th which is supposed to take care of this issue. It seems some clients have updated with 2011 tax tables before closing 2010 year-end. This might give errors on W-2 validation report. The fix to this issue as suggested by others is to download and install Round 7 tax update for 2010 and to re-install 2011 update once the 2010 is

Management Reporter Feature Pack 1 for Dynamics GP Released

Image
Management Reporter Feature Pack (FP) 1 is released for Dynamics GP and now available for download. This is good music to those using the Management Reporter and waiting for currency translation support. I have installed MR on my PC but could not get an opportunity to work on it in detail so far as it fails to connect outside the domain. (Image source: reese-consulting ) More information on this release can be obtained from this blog entry. Related Blog Posts on Management Reporter: Management Reporter Feature Pack 1 is now available! Management Reporter – Product Road Map Quick Post- Why I love Management Reporter In the trenches with Management Reporter