The Dynamics GP Blogster: Dynamics GRC Day 2014 – All about …

This daylong meeting is critical for anyone that is responsible for risk management in a Microsoft Dynamics environment. Until next post! MG.- Mariano Gomez, MVP IntellPartners, LLC http://www.IntellPartners.com/. Posted by Mariano Gomez at 8:04 AM · Email ThisBlogThis!Share to TwitterShare to Facebook. Labels: Events. No comments: Post a Comment · Newer Post Older Post Home. Subscribe to: Post Comments (Atom) …. Dynamics Confessions Blogspot.

Visit site:
The Dynamics GP Blogster: Dynamics GRC Day 2014 – All about …

January 27, 2014 · Mariano Gomez · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 286

Financial consolidations and currency translation for … – MSDN Blogs

and multi-currency consolidations. The paper can be downloaded at: http://www.microsoft.com/en-us/download/details.aspx?id=41645 Is there any development of Dynamics GP? Page 1 of 1 (1 items). © 2013 Microsoft 

Read More:
Financial consolidations and currency translation for … – MSDN Blogs

January 21, 2014 · April Olson · No Comments
Tags: , , , ,  · Posted in: Blogs I Follow Total Views: 219

Suppressing drill down on specific report lines … – MSDN Blogs

About Dynamics Corporate Performance Management: Financial Reporting, Planning/Budgeting/Forecasting, and Consolidations.

See the original article here:
Suppressing drill down on specific report lines … – MSDN Blogs

January 20, 2014 · Jill Carter · No Comments
Tags: , , , ,  · Posted in: Blogs I Follow Total Views: 255

Dynamics GP Excel Dashboard available now!

 

This comes to us from one of Dynamics GP’s finest, the infamous Mark Polino! Jump to  www.DynamicAccounting.net/Analytics to get more details.

This is the truly painless way to get started with Excel dashboards, have someone else do it for you Smile. Imagine, an Excel dashboard with all of the bells and whistles ready to go. We’ve all seen and heard how cool dashboards are, and wish we had the time to figure out how to create them. Well, the time has been reduced to just a few minutes. Seriously, the dashboard is easy to install; and, honestly, I do mean easy.

Simplicity is a word that appeals to me, and Mark’s Excel dashboard falls into that category. One of the things I like to point out during my development/tool classes is that you should ALWAYS look around to see if anyone else has already created the thing you are wanting to create. So many times, the answer is yes.  This is one of those yes times.

If you want to get started, but can’t carve out the hours it takes to develop this anew, this is for you.

Though the dashboard is perfectly fine just like it is, you have the option to change it however you want. We all know that changing something is far easier than creating it from scratch.

Can you say plug and play?  I am among the laziest people out there. I know the macro language so well because it saves me time and clicks.  If I can save clicks, I’m all for it! This is my kind of dashboard; just connect it to your data source and you’re ready to go. And fear not, if data sources are not your area of expertise, Mark makes that easy too.

So what’s available? Mark has released a dashboard for the Sales series. Here’s what it includes:

● Top Customers with corresponding costs               
● Top Items with corresponding costs               
● Top Salespeople, Territories and Sites               
● Sales over time with forward looking projection               
● Sales mix over time by item class               
● A full range of data filters to control information

Click the link and check it out.

How many of these do you think Mark can develop in 50 minutes?   

Until next post!

Leslie          

Follow this link:
Dynamics GP Excel Dashboard available now!

January 17, 2014 · Leslie Vail · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 381

2014 Payroll Tax Tables–how to fill out manually

I’ve been getting quite a few calls lately about how to get the new 2014 tax tables if they can no longer get them from Microsoft. These folks are on versions 9 or 10, so they are out of luck on the download. Scandalous though it may be to remain on an unsupported version, they still have to update their tax tables. Fortunately, you can easily change the tax rates yourself using Dynamics GP.

After applying the current tax tables (as of 01-16-2014), this is what the windows look like:

FICAM

Administration | Setup | System | Payroll Tax
Enter or select the Tax Code
Push the Filing Status button
Scroll to Filing Status NA
Push the Tables buttonFICAM

 FICAS

Administration | Setup | System | Payroll Tax
Enter or select the Tax Code
Push the Filing Status button
Scroll to Filing Status NA
Push the Tables button
image

EFICM

Administration | Setup | System | Payroll Tax
Enter or select the Tax Code
Push the Filing Status button
Scroll to Filing Status NA
Push the Tables button
image

EFICS

Administration | Setup | System | Payroll Tax
Enter or select the Tax Code
Push the Filing Status button
Scroll to Filing Status NA
Push the Tables buttonimage

FED SINGLE

Administration | Setup | System | Payroll Tax
Enter or select the Tax Code
Push the Filing Status button
Scroll to Filing Status SINGLE
Push the Tables buttonPayroll Tax Tables FED SINGLE

FED MAR

Administration | Setup | System | Payroll Tax
Enter or select the Tax Code
Push the Filing Status button
Scroll to Filing Status MAR
Push the Tables buttonPayroll Tax Tables FED MAR

FED NRA

Administration | Setup | System | Payroll Tax
Enter or select the Tax Code
Push the Filing Status button
Scroll to Filing Status NRA
Push the Tables buttonPayroll Tax Tables FED NRA

If you can’t read the screen shots, I also have the numbers in the tables below:

FICAM

Administration | Setup | System | Payroll Tax
Enter or select the Tax Code
Push the Filing Status button
Scroll to Filing Status NA
Push the Tables button

If Over But Not Over Tax Amount Tax Rate On Excess Over

$0.00

$200,000

$0.00

1.45%

$0.00

$200,000

999999999.99

$0.00

2.35%

$0.00

$0.00

$0.00

$0.00

0.00%

$0.00

FICAS

Administration | Setup | System | Payroll Tax
Enter or select the Tax Code
Push the Filing Status button
Scroll to Filing Status NA
Push the Tables button

If Over But Not Over Tax Amount Tax Rate On Excess Over

$0.00

$117,000

$0.00

6.20%

$0.00

$0.00

$0.00

$0.00

0.00%

$0.00

EFICM

Administration | Setup | System | Payroll Tax
Enter or select the Tax Code
Push the Filing Status button
Scroll to Filing Status NA
Push the Tables button

If Over But Not Over Tax Amount Tax Rate On Excess Over

$0.00

999999999.99

$0.00

1.45%

$0.00

$0.00

$0.00

$0.00

0.00%

$0.00

EFICS

Administration | Setup | System | Payroll Tax
Enter or select the Tax Code
Push the Filing Status button
Scroll to Filing Status NA
Push the Tables button
 

If Over But Not Over Tax Amount Tax Rate On Excess Over

$0.00

$117,000

$0.00

6.20%

$0.00

$0.00

$0.00

$0.00

0.00%

$0.00

FED SINGLE

Administration | Setup | System | Payroll Tax
Enter or select the Tax Code
Push the Filing Status button
Scroll to Filing Status SINGLE
Push the Tables button
 

If Over But Not Over Tax Amount Tax Rate On Excess Over

$0.00

$2,250.00

$0.00

0.00%

$0.00

$2,250.00

$11,325.00

$0.00

10.00%

$2,250.00

$11,325.00

$39,150.00

$907.50

15.00%

$11,325.00

$39,150.00

$91,600.00

$5,081.25

25.00%

$39,150.00

$91,600.00

$188,600.00

$18,193.75

28.00%

$91,600.00

$188,600.00

$407,350.00

$45,353.75

33.00%

$188,600.00

$407,350.00

$409,000.00

$117,541.25

35.00%

$407,350.00

$409,000.00

$0.00

$118,118.75

39.60%

$409,000.00

$0.00

$0.00

$0.00

0.00%

$0.00

FED MAR

Administration | Setup | System | Payroll Tax
Enter or select the Tax Code
Push the Filing Status button
Scroll to Filing Status MAR
Push the Tables button
 

If Over But Not Over Tax Amount Tax Rate On Excess Over

$0.00

$8,450.00

$0.00

0.00%

$0.00

$8,450.00

$26,600.00

$0.00

10.00%

$8,450.00

$26,600.00

$39,150.00

$1,815.00

15.00%

$26,600.00

$82,250.00

$157,300.00

$10,162.50

25.00%

$82,250.00

$157,300.00

$188,600.00

$28,925.00

28.00%

$157,300.00

$235,300.00

$413,550.00

$50,765.00

33.00%

$235,300.00

$413,550.00

$466,050.00

$109,587.50

35.00%

$413,550.00

$466,050.00

$0.00

$127,962.50

39.60%

$466,050.00

$0.00

$0.00

$0.00

0.00%

$0.00

FED NRA

Administration | Setup | System | Payroll Tax
Enter or select the Tax Code
Push the Filing Status button
Scroll to Filing Status NRA
Push the Tables button
 

If Over But Not Over Tax Amount Tax Rate On Excess Over

$0.00

$9,075.00

$0.00

10.00%

$0.00

$9,075.00

$36,900.00

907.50

15.00%

$9075.00

$36,900.00

$89,350.00

$5,081.25

25.00%

$36,900.00

$89,350.00

$186,350.00

$18,193.75

28.00%

$89,350.00

$186,350.00

$405,100.00

$45,353.75

33.00%

$186,350.00

$405,100.00

$406,750.00

$117,541.25

35.00%

$405,100.00

$406,750.00

$0.00

$118,118.75

39.60%

$406,750.00

$0.00

$0.00

$0.00

0.00%

$0.00

That should do it!

Until next post

Leslie

See the original article here:
2014 Payroll Tax Tables–how to fill out manually

January 17, 2014 · Leslie Vail · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 637

Microsoft Dynamics GP 2013 Reporting – Second … – azurecurve

This book addresses most of the challenges and frustrations a company may face when preparing to build new reports. It enables you to create and manage reports as well as identify the most appropriate reporting tool for any 

Continue Reading:
Microsoft Dynamics GP 2013 Reporting – Second … – azurecurve

January 16, 2014 · Ian Grieve · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 273

GPUG Integration Showcase Series

Well, it’s been a hectic beginning of the year for me and projects keep rolling in, keeping me away from writing. However, there are other ways you can get in touch with The Dynamics GP Blogster. One of them is by joining me at the new GPUG Education Hub’s Integration Showcase Series. This series of online seminars will begin on January 20th and will end with an online interactive roundtable discussion where you will have a chance to ask all the presenters about the kind of stuff that keeps you up at night when it comes to integrating your corporate applications.

The series will feature different integration middleware products, integration techniques, and presenters from eOne Business Solutions, Scribe, Zap, and of course, moi! I will be talking about Integration Manager for Microsoft Dynamics GP and how you can leverage it to build powerful, yet easy to use integrations. Of course, I will talk about the tools strengths and limitations.

Date Time Product Title/Topic
January 20 2:00 PM EST Connector Dynamics Integration using Connector for Microsoft Dynamics
January 21 1:00 PM EST Scribe Dynamic GP Integration with CRM and SFDC
January 28 3:00 PM EST T-SQL Integrating with Microsoft Dynamics GP Using SQL Code
January 29 3:00 PM EST eConnect Do it MY Way! Custom Integration with eConnect
January 30 1:00 PM EST Integration Manager Integration Manager Please!
February 4 1:00 PM EST ZAP Integration Tool Leveraging the power of eConnect with Zap! Integration
February 4 3:00 PM EST Web Services Web Services Unlocks and Extends the Power of Dynamics GP
February 5 1:00 PM EST SmartConnect Who Needs a Developer? Create GP Integrations on your own!
February 5 3:00 PM EST Integration Series Roundtable

This series promises to be really exciting and I hope you can join the presentations and the closing roundtable discussion featuring all presenters.

If you are not a GPUG member, please click here to register and don’t miss out.

Until next post!

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

Follow this link:
GPUG Integration Showcase Series

January 15, 2014 · Mariano Gomez · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 300