Archive for January 28, 2013

Listing all eConnect Modified PRE and POST stored procedures

As of recent, I was ask of a simple method to determine which eConnect PRE and POST stored procedures had been modified. After all, with a concrete list, you are able to script just the affected ones prior to a major version upgrade or a feature pack installation.

A modified stored procedure could be simply qualified as one on which you have ran an ALTER PROCEDURE statement or have edited it using SQL Server Management Studio.
With that said, the following query may not be failsafe, but provides a very accurate way of getting a list.

-- Created by Mariano Gomez, MVP
-- This code is licensed under the Creative Commons 
-- Attribution-NonCommercial-ShareAlike 3.0 Unported License.
-- http://creativecommons.org/licenses/by-nc-sa/3.0/legalcode
--
SELECT name, create_date, modify_date 
FROM sys.objects 
WHERE (type = 'P') AND (name LIKE 'ta%Pre' or name LIKE 'ta%Post') AND (create_date <> modify_date)

Enjoy!

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

See more here:
Listing all eConnect Modified PRE and POST stored procedures

January 28, 2013 · Mariano Gomez · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 272

Workshop: GP 2013 – Web Client Installation & Configuration

Please find the details of the ” GP 2013 – Web Client Installation & Configuration ” workshop below. Agenda High Level Architecture User Login Process Flow Session Host Services Session Central Service Session Service Session Management Proxy Service Session Management Service Runtime Service Digital Certificates Self-Signed Certificate Certificate Authority Installation Single Box Deployment Multi-box Deployment Session Duration 180 mins Advisory Hours Used 5-6 hours Target Audience Technical Decision Makers Business Decision Makers End Users If you are interested in any of the workshops mentioned above, click here

More:
Workshop: GP 2013 – Web Client Installation & Configuration

January 28, 2013 · Sivakumar V · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 214

Workshop: GP 2013 – What’s New

Please find the details of the ” GP 2013 – What’s New ” workshop below.

Read More:
Workshop: GP 2013 – What’s New

January 28, 2013 · Sivakumar V · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 179

Financial Reporting Data Mart for Dynamics SL … – MSDN Blogs

With the success of the data mart we offer for AX 2012, Dynamics NAV, and Dynamics GP customers, we are now excited to offer it to Dynamics SL 2011 customers using Management Reporter. The option will appear in the

See original article:
Financial Reporting Data Mart for Dynamics SL … – MSDN Blogs

January 28, 2013 · April Olson · No Comments
Tags: , , ,  · Posted in: Blogs I Follow Total Views: 217

Processing 2012 Payroll year end after loading 2013 payroll tax tables

Variations of this problem have been popping up everywhere, as it often does when changes are made to the payroll tax percentages and limits. I wrote this up to answer one of the forum posts, so I thought I would brush it off and publish it.
Here was the scenario:
The company had downloaded the 2013 payroll tax tables and processed 2013 payroll, but neither closed 2012 payroll nor installed the year end update for 2012.
Now they need to close 2012 payroll and then return to processing 2013 payroll. Here’s what I would do to get back on track.
1.       Download and install the January hotfix of Dynamics GP 2010, this includes the year end tax update (as well as a hot fix). The current build is 11.00.2164. It was released 01/24/2013. Be sure you have a backup, this will require a table update. Backup your forms and reports dictionaries and create package files for all of your modifications.
2.       Open the Payroll Tax Tables window and change your FICAS tax code to a wage limit of $110,100 and a rate of 4.2%
a.       To open the Payroll Tax Tables window follow the instructions below.
b.      Navigate to: Administration | Setup | System | Payroll Tax.

c. Select the FICAS tax code, select the Apply Tax Table item and click the Filing Status button.

d. Select the NA filing status and click the Tables button

e. Edit the table rates and change the But Not Over column to $110,100 and the Tax Rate column to 4.2% and then click the OK button.

3.   Click Save on the Payroll Tax Filing Status window.
4.   Click Save on the Payroll Tax Setup window.
5.   Now, your going to remove the extra Medicare Tax for the high income earners.
a. In the Payroll Tax Setup window select the Tax Code FICAM, Apply Tax Table, and then click the Filing Status button.

b. Select the NA filing status and click the Tables button

c. To remove the second row in the table, place your cursor in the second row, choose Edit from the menu bar and then Delete Row.

d. Now you need to adjust the first row’s maximum wage by entering $999,999,999.99 in the But Not Over column. Click OK to save and close the window.

6.   Click Save on the Payroll Tax Filing Status window.
7.   Click Save on the Payroll Tax Setup window.
8. Change the user date to 12/31/2012 (anything in 2012 will do)
9.   Create the year end wage file (close payroll).
10.  Make sure you’re happy with the W-2 amounts.
11.  Load the 2013 tax tables using the Payroll Tax Updates wizard
12.  Check to make sure the FICAS amounts reset to a wage limit of $113,700 and a rate of 6.2%
13.  Check to make sure the FICAM table includes the 2.35% extra for wages over $200,000.00.
14.  Don’t forget to set the User Date back to the right date to process 2013 payroll!
That should get you fixed back up.
Until next post!
Leslie

More:
Processing 2012 Payroll year end after loading 2013 payroll tax tables

January 28, 2013 · Leslie Vail · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 425

Dynamics GP Excel Paste V 4.0

We have finally released and uploaded a new version for the Excel Paste, this one has the following coverage:

1. The major move was the ability to integrate into multiple products, like combining the GL Transaction Entry with the Analytical Accounting.

2. Ability to Paste into modified forms and additional fields.

3. We have added a link between the defined Products and the actually installed products to avoid annoying errors if you have missed one product in your workstation.

4. Added an option to handle prompts or disable the handling, to avoid any annoying messages during the paste operation.

5. For users who are running behind firewalls, they used to have Slowness during the login to GP, we have fixed this by moving the online validation to be through the webservices first and then direct database connection.

6. We had many “Minor Bugs” that were reported, all been resolved.

Regards,


Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
http://www.di.jo

Read the original post:
Dynamics GP Excel Paste V 4.0

January 28, 2013 ·  · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 207

Broader Availability of Microsoft Dynamics CRM December 2012 Service Update

Bob Stutz announced on 21st January 2012 the broader availability of Microsoft Dynamics CRM December 2012 Service Update in his article here . After receiving praise from the First Access customers and prospects on the business value which was offered as a part of this release, this release is now rolling out to our full online customer base encompassing thousands of organizations, and is available for new trials and subscriptions in North America, with APAC/EMEA following shortly.

See the article here:
Broader Availability of Microsoft Dynamics CRM December 2012 Service Update

January 28, 2013 · Sivakumar V · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 185