Mohammad R. Daoud: How to add attachments to Purchase Order Workflow?

In a new post, Mohammad Daoud shows us How to add attachments to Purchase Order Workflow.

Weekly Dynamic: Troubleshooting Security

Troubleshooting security issues keeps coming up and keep giving the same answer so I thought that I would write about it.

Troubleshooting security errors is simple IF you do a little prep work. Here is all you have to do to resolve security errors.

• Install the Support Debugging Tool
• Give everyone access to the MBS Debugger User Role
• Under the Support Debugging Tool Administrative settings, set Automatic Open Mode to Open on Errors and Warnings.

What happens now is when access is denied to a window or a report, a user gets details of what resource is being denied.

• The user can click export to send this file to a security Administrator.
• The security admin can import the file in to the Support Debugging Tool to see exactly what was denied.
• The security admin can drill back to review and set security from the imported file.

Once the Support Debugging Tool is setup this is quite simply the easiest and simplest method of figuring out security access issues.

You are using an earlier version of the Dynamics.dic « DynamicsGP.ie – Global Insights from Ireland

Ian Stewart also looks at an issue when You are using an earlier version of the Dynamics.dic

Office 365 and Dynamics GP – the skinny « DynamicsGP.ie

Ian Steward looks at Office 365 and Dynamics GP.

Updated SQL Script for fixing Primary Key Errors in Analytical Accounting | Interesting Findings & Knowledge Sharing

Over at Interesting Findings & Knowledge Sharing, is an Updated SQL Script for fixing Primary Key Errors in Analytical Accounting

PragmaticWorks Webinar–Free SQL Training

PragmaticWorks is offering free SQL Server 2008 Business Intelligence.

It’s not strictly GP related but don’t pass up free BI training.

Guidelines for Payroll W-2 Benefit Reporting - Dynamics GP Support and Services Blog

Over at the relaunched GP Support and Services blog, Terry Heley looks at Guidelines for Payroll W-2 Benefit Reporting.

Dynamics GP 2010 Reporting Book Review | Aaron Berquist - High Dynamic Range

Aaron Berquist likes Chris and David’s Dynamics GP 2010 Reporting Book.

Dynamics Month Ends Today

If you thought about taking advantage of Packt Publishing’s 20-30%discounts on Dynamics books this is the last day.

So if you’re looking for the Microsoft Dynamics GP 2010 Cookbook or Dynamics GP Books on Reporting, Implementation or Sure Step hurry up! You have to buy today.

Friday Fun - Practical Jokes you can play with Dynamics GP

• Use the Support Debugging Tool to change the colors in Dynamics GP to match your favorite team.

As an example, I offer this mildly obnoxious Florida Gator inspired theme:

Troubleshooting Named Printers Issues - Developing for Dynamics GP

David Musgrave looks at Troubleshooting Named Printers Issues.  Just a hint, this is not a 3 step plan. David does a deep dive into Named Printers troubleshooting.

Microsoft Forecaster – Using Overrides to present relevant data to users - Dynamics Corporate Performance Management

Digging into Microsoft Forecaster, Dynamics Corporate Performance Management looks at Using Overrides to present relevant data to users.

Of course, if you had the new DynAcctNet Android app you’d be able to follow Dynamics Corporate Performance Management on your phone.

Weekly Review: Turning a Project into a Fixed Asset

A common request is to turn a Project from the Project Accounting module, into a Fixed Asset in the Fixed Asset module. There is no native functionality to do this and based on my conversations with the Dynamics GP team, it's not going to happen so you might as well understand the workaround and it looks like this:

1) Create a Miscellaneous Log Cost Category for Fixed Assets pointing the Contra Account to the FA Clearing account and the Cost/Expense account to wherever you are collecting the project costs (a WIP account, a project FA WIP account, etc.). You'll be doing a negative misc log so the cost collection location will be credited and contra (FA Clearing) will be debited.

2) Once the project is ready to become a Fixed Asset, process a negative Misc Log transaction using the Fixed Asset Cost Category to remove an amount equal to the total cost of the project.

a. This setup makes it easy to exclude the FA Cost Category when analyzing project costs while still leaving the project at zero

b. This process provides a transactional audit trail to show that the project was closed out and moved to Fixed Assets

3) Create a Fixed Asset. The GL Transfer mechanism will move the costs from the FA clearing account to the appropriate Fixed Asset account.

The reality is that the number of fields that would actually transfer from a project is really small, single digits small. The complexities of creating a Fixed Asset from a project become large very fast. For instance, how do you deal with multiple assets from a single project, complete assets but incomplete projects, partial capitalization of a project, combining Cost Categories for capitalization, etc. The benefits of creating something to manage this are far outweighed by pain of dealing with all of the possible scenarios. Realistically, this is best handled through a process like the one described here.

Posted by Mark at 6/01/2009 02:23:00 PM

Microsoft Excel - Where to begin: PowerPivot for Excel

I’ve blogged and spoken about how cool PowerPivot is. Well, if you’ve been wanted to play with it, check out Inside Microsoft Office’s Where to begin: PowerPivot for Excel.

Dynamics Confessor Blogspot: Notable settings on the Account Maintenance Window

New from Leslie Vail is a look at Notable settings on the Account Maintenance Window.

New DynamicAccounting.net Android App!

The DynamicAccounting.net Android app has been updated and is completely new.

Now you can get the latest news from DynamicAccounting.net on the go and you have access to all of the Dynamics GP product blogs (like Inside Microsoft Dynamics GP or Developing for Dynamics GP). Plus you get access to all of the GP MVP blogs from folks like Mariano Gomez and Frank Hamelly along with a bunch of other Dynamics GP sites from influencers like Dwight Specht. Additionally, access to  MyGPSearch has been rolled in as a feature as well.

The DynamicAccounting.net Android App is 99 cents in the Android Market or you can use the bar code below to get it directly on your phone.

The app has be rebuilt from the ground up. Unfortunately, that means that there isn’t an upgrade path for existing users. Sometimes you have to break things to move forward.

For now, I have a list of all of the users who have purchased the old version. If you want a refund on the old application to purchase the new one, email me with this link or at the email address on the blog and I’ll refund your Google account.The old version will continue to work just fine but you won’t be able to update or re-download it.

Rebuilding the app gave me the opportunity to easily create iPhone or Windows Phone 7 versions but I’m not sure that the demand is there to cover the much higher developer fees from Apple and Microsoft. If you are interested in an iPhone or Windows Phone 7 version email me so that I can gauge demand.

Mapping Functions: What are they and where can I find out more about them? - Connector -- Integrating Dynamics ERP with Dynamics CRM

 

Char Gust has a great look at Mapping Functions: What are they and where can I find out more about them? - Connector -- Integrating Dynamics ERP with Dynamics CRM .

She doesn’t mean driving maps. This is about mapping Dynamics GP to CRM using the Connector.

The Dynamics GP Blogster: Microsoft Dynamics GP "12" Multi-tenant Architecture

Mariano looking into Microsoft Dynamics GP "12" Multi-tenant Architecture. This essentially allows multiple Dynamics databases making managing different installs on a single instance much easier.

Getting the name of a month from the month number in SQL Server | Victoria Yudin

Victoria shows us how to Get the name of a month from the month number in SQL Server. This is very handing for reporting from Dynamics GP.

How to add Item Category Long Descriptions to reports using the Support Debugging Tool - Developing for Dynamics GP

David Musgrave shows How to add Item Category Long Descriptions to reports using the Support Debugging Tool over at Developing for Dynamics GP

Mohammad R. Daoud: SOP Master Numbers not being assigned properly

Mohammad Daoud looks at how to deal with SOP Master Numbers not being assigned properly

Where Do You Find Your Next Hire? « The Death of Reason

Dwight Specht looks at the success of our college hire program in his new post, Where Do You Find Your Next Hire?
Though it’s a great post, he neglected to mention a few things that I wanted to highlight.
First, David Duncan was a hire out of college three years ago, now he’s the co-author of a book on Reporting in Dynamics GP. Hire to expert, 3 years. It took me 10 years to get my first book out. Apparently I’m a little slow. Thank goodness the second one is available. Maybe I can catch him on the average.
Second, Kelsey Andrich is doing a terrific job blogging on what it’s like to go from college to consulting. In the process, she and all of the other hires, help I.B.I.S. make this process better.
Third, our college hires push our more experienced people. They learn at a pace that is freakishly fast and I’ve confessed on more than one occasion to a little jealously. Those of us who have been around for a while are running to stay ahead of them and losing. It’s fantastic.
Finally, despite Dwight’s flagrant generalization, I am well below the 46-53 age bracket. This means that even if he is better looking than me, I will always be younger and have better hair.

Revisiting the Cloud: Why Hybrid Solutions for Microsoft Dynamics GP Ring True | MSDynamicsWorld.com

Make sure to check out my new MSDynamicsWorld article Revisiting the Cloud: Why Hybrid Solutions for Microsoft Dynamics GP Ring True

Dynamics GP - Learn & Discuss: Analytical Accounting Menu Master Table (SY07110) Records Multiplying - Bug & Workaround

Vaidy digs into what looks to be an Analytical Accounting bug in Analytical Accounting Menu Master Table (SY07110) Records Multiplying - Bug & Workaround.

Mohammad R. Daoud: Empty “Table Name” when doing Import/Export for EFT File Format

Mohammad Daoud resolves an Empty “Table Name” when doing Import/Export for EFT File Format.

SQL Script for POP Receiving Transactions with AA Information | Interesting Findings & Knowledge Sharing

From Interesting Findings & Knowledge Sharing comes a SQL Script for POP Receiving Transactions with AA Information.

Dynamics GP Land: eConnect Integrations: 90% Data, 10% eConnect

Steve Endow looks at eConnect Integrations: 90% Data, 10% eConnect. I have to say that I generally agree. Even though I tend to work with econnect via SmartConnect rather than as a development environment, the same ratio applies.

The Dynamics GP Blogster: Upgrade Strategies for Microsoft SQL Server 2008

Mariano points us to nice look at Upgrade Strategies for Microsoft SQL Server 2008 in his new post.

GP2010 PTO manager “Use Custom Accrual Method” checkbox

My colleague Amy Walsh looks at GP2010 PTO manager “Use Custom Accrual Method” checkbox at DynamicsCare.

Management Reporter – “An error occurred while retrieving balances from the source system provider.” » Summit Group Software Blog

New from the Summit Group is an issue with Management Reporter – “An error occurred while retrieving balances from the source system provider.” along with a hot fix from Microsoft.

Dynamics GP Land: And a One, And a Two, SQL Report Security

Christina Phillips does a great job looking at SQL Report Security in her latest post at Dynamics GP Land.

Wanda’s Wicked Workshop Winner

Congratulations to Jennifer Hershberger. She was the first to read all the way to the end of Wanda’s Wicked Workshop and email the correct answer to the movie question. The answer was “The Private Eyes.”

Jennifer used a secret code from FastPath to get a free copy of the story and now she’s the proud winner of the Microsoft Dynamics GP 2010 Cookbook: Lite Edition. 

Though the prize has been won, you can still get a free code from FastPath and read a great story about Dynamics GP.

Weekly Dynamic: Find Debit or Credit Amount

Sometimes you need to find a particular amount that could be either a debit or credit. Maybe it’s a rogue transaction or a posted amount that went to a wrong account and you just can’t find it.

Well, this is easy to do with a SmartList. All you have to do is:

1. Open up the default Financial | Account Transactions SmartList
2. Open the Search window
3. Set Debit Amount equal to the amounts your looking for.
4. Repeat this with Credit Amount
5. Set the Search Type to Match 1 or More. This is an “or” setting meaning that it will find transactions where Debit Amount or Credit Amount equals the amount entered.
6. Further refine the search limiting it to certain accounts or dates

Dynamics GP Land: Implementation Trauma AGAIN!!

Christina Phillips continues her implementation series with a look at Implementation Trauma AGAIN!!

Friday Fun

I confess. I’ve seen project plans like this. I think I even implemented a plan like this once.

Dynamics GP Land: Fun eConnect Bug: Check those field lengths!

Having fun in Dynamics GP Land, Steve Endow tries to exterminate an eConnect Bug: Check those field lengths!

The Dynamics GP Blogster: Microsoft Dynamics GP Database Installation and Upgrade Statuses

New at the Dynamics GP Blogster, Mariano tackles Dynamics GP Database Installation and Upgrade Statuses.

GP 12 Web Client Architecture - Inside Microsoft Dynamics GP

Jan Manley adds a some additional information around customized templates for the GP 12 Web Client Architecture , adding to Mariano’s posts on that subject.

Dynamics GP Land: One Very Hairy Dynamics GP Integration

Steve Endow describes One Very Hairy Dynamics GP Integration. I’ve got one of these going on now too. It’s not quite as bad as the one Steve describes but I’ve definitely got less hair because of it.

The Dynamics GP Blogster: Unhandled script exception: Illegal address for field '[Not Found]' in script 'Unregister_Triggers'

Mariano latest post looks at Unhandled script exception: Illegal address for field '[Not Found]' in script 'Unregister_Triggers'

Weekly Review: SQL Snapshots and Dynamics GP

 

Sometimes when implementing Dynamics GP you do a lot of backing up and restoring. Large implementations can require multiple test environments, development environments, etc. Sometimes you need to push a large number of transactions through for testing over and over again, restoring the environment each time.

Well all of those backups and restores take time. A faster alternative is to use functionality in SQL Server to take a snapshot of a company. Snapshots have lots of limitations that make them unsuitable for typical backup/restore needs but for activities that require multiple reloads they are a lifesaver. Why? Snapshot restores are fast. Smoking fast. 4 second restores fast.

In a test on an old, single processor machine, the default TWO company and the Dynamics DB took 45 seconds to backup and another 45 seconds to restore. A snapshot took 6 seconds to backup and 4 seconds to restore. What's more, the snapshots don't slow down much as the db size increases. We've seen GP databases that take an hour for a full backup and restore still create a snapshot in under 10 seconds and restore in under 10 seconds.

Unfortunately Snapshots only work on the Enterprise Edition of SQL Server but if you want to know more about both the power and the limitations of snapshots, here is a great overview.
Here is the SQL Code I used to create and restore my test snapshots:

CREATE DATABASE DYNAMICS_dbss ON
( NAME = 'GPSDYNAMICSDat.mdf', FILENAME =
'c:\DYNAMICS_dbss.ss' )
AS SNAPSHOT OF DYNAMICS;
GO
CREATE DATABASE TWO_dbss ON
( NAME = 'GPSTWODat.mdf', FILENAME =
'C:\TWO_dbss.ss' )
AS SNAPSHOT OF TWO;
GO
-------------------------------------------------
RESTORE DATABASE DYNAMICS FROM DATABASE_SNAPSHOT = 'DYNAMICS_dbss'
go
RESTORE DATABASE TWO FROM DATABASE_SNAPSHOT = 'TWO_dbss'
go

[H.T. to Ross Carlson for this]

Originally Posted by Mark at 5/25/2009 09:00:00 AM

ERP Software vs. Business Discipline: Which Provides the Real Benefit? | 360° ERP Blog

All I’m going to say is “Preach it brother!”

“First, recognize that ERP software is no substitute for well-defined and disciplined business processes.”

ERP Software vs. Business Discipline: Which Provides the Real Benefit?

First Rule of Blogging

Provide a way for people to contact you beyond comments or a contact page.

The backstory:

I was impressed enough with someone’s recent blog post that I wanted to send them a free copy of the Microsoft Dynamics GP 2010 Cookbook: Lite Edition.

So I visited their website to get their email address and surprise them with a book. No email address.

I drilled down into their profile, surely it’s there. No email address. I saw that their blog had moved and visited the newest site. No email address.

Their Twitter account is a shared/company Twitter account so I hate to Direct Message it. Who knows who will get the message.

I’ve run into that a couple of times lately where I want to drop a blogger a private message and there is no way to contact them short of commenting on the blog and sometimes even that’s not available.

At DynamicAccounting.net I’ve got my email address, Instant Messenger address and my personal cell phone number on the main page. In six years I’ve gotten exactly one phone call that crossed the line.

I’m the only one who posts to both of my Twitter accounts, feel free to DM me. I’m easy to find and connect with on Linked In and Facebook too.

It’s sad that someone just missed out on a free book. It’s a good book too.

How to REALLY be Influential in Microsoft Dynamics - Mad Mark, the GP Road Warrior

Forget the list. If you REALLY want to be Influential in Microsoft Dynamics, check out my new Dynamics Community article.

Kuntz Consulting is back with a bug

Kuntz Consulting ran into some GP R2 Report Writer issues recently and they cover it in I’m back with a bug!

Get Wanda’s Wicked Workshop Free and a Chance to Win a Microsoft Dynamics GP 2010 Cookbook: Lite Edition

I’ve teamed up with FastPath to give away free PDF copies of my Wanda’s Wicked Workshop short story. Wanda’s Wicked Workshop is a fun tale of using Dynamics GP to really get a handle on your business.At the very end of Wanda’s Wicked Workshop is a clue to win a free copy of the just released Microsoft Dynamics GP 2010 Cookbook: Lite Edition

All you have to do is:

• Go to www.gofastpath.com. At the bottom under 05.16.11 is a secret code.  Grab the code.
• Stop and look hard at Config AD and Audit Trail while you’re there. You know that you want them in your environment.
• When you’re done, go to the Wanda’s Wicked Workshop page and click Add to Cart.
• Enter the secret code and update the cart to get your free copy.

Read the story and at the very end is a question based on something in the story. Be the first to send me the answer to the question and you will win a free copy of the Lite Cookbook. No one has answered the question yet so you’ve still got a chance.

Thanks again to FastPath for helping with this.

Project on the Rocks: Ain’t No Big Surprise « The Death of Reason

Dwight Specht is back posting on projects and risk management with a look at Project on the Rocks: Ain’t No Big Surprise

Can't connect to the Management Reporter server

iSolutions also looks at when you Can't connect to the Management Reporter server

The Dynamics GP Blogster: Microsoft Dynamics GP "12" Web Client Architecture - Part 3

Mariano continues his terrific series on the Microsoft Dynamics GP "12" Web Client Architecture - Part 3. If you’ve missed anything in the series makes sure to go back and review.

Interesting Findings & Knowledge Sharing » Table Structure Definitions – Fiscal Period Setup

Over at Interesting Findings and Knowledge Sharing they’ve got a nice look at Table Structure Definitions for Fiscal Period Setup.

Management Reporter Report Queue Status window stays stuck at Queued

iSolutions looks at a problem where the Management Reporter Report Queue Status window stays stuck at Queued. We’ve encountered this same issue and it can be pretty frustrating. It’s scheduled to be fixed in SP 2.

More 100 Most Influential

 

David Musgrave takes a look at the Microsoft Dynamics Top 100 Most Influential People for 2011 list. For some inexplicable reason David didn’t make this year’s cut but frankly David doesn’t need to be on a list to be influential.

Mariano Gomez weighs in with his thoughts as well.

Doug Pitcher’s 100 most famous, awesome and totally influential Dynamics people for 2011

Doug Pitcher took his bitterness about not making the 100 Most Influential in Microsoft Dynamics and created Doug Pitcher’s 100 most famous, awesome and totally influential Dynamics people for 2011.

I’m on at number 5 and apparently if I had included Doug on my list of people missing from the top 100 I would have moved up.

The list is a hoot. The problem is that now I don’t want Doug to make the top 100 list so he’ll do another one of these next year. Stupid unintended consequences.

Announcing the New ‘LITE’ Cookbook for Microsoft Dynamics GP 2010

I am thrilled to announce that Packt Publishing has released a new ‘Lite’ edition of the Microsoft Dynamics GP 2010 Cookbook.

For those of you who just aren’t ready to bite off the whole Cookbook, the Lite edition gives you a taste of what’s in the full cookbook at a much lower price point. Packt’s new line of Lite editions are designed around minimum effort, maximum value.

Get the ebook version of the Microsoft Dynamics GP 2010 Cookbook: Lite Edition right now for only $8.49 or get the book/ebook combo for just $17.99.

Even better, if you later decide that you want the full version of the Microsoft Dynamics GP 2010 Cookbook, the price of the Lite edition can be applied as a discount against the full Cookbook meaning that you can’t lose on this investment.

The full details are on Packt’s launch site for the Lite editions.

The Lite Cookbook is also available at Amazon and Barnes and Noble but right now, the best deal is from Packt.

This is the only Microsoft Dynamics related book included as part of the launch of the Lite editions and I am thrilled that it’s available. I think that this book will open up these recipes to more of the Dynamics community. Get yours today.

How to read a Dexterity Script Profile to solve Performance Issues

From David Musgrave comes some great information about How to read a Dexterity Script Profile to solve Performance Issues.

This is a detailed example and provides a great real world look.

Management Reporter – Currency Translation with Microsoft Dynamics GP 2010 - Dynamics Corporate Performance Management

Over at Dynamics Corporate Performance Management they have a look at Currency Translation with Microsoft Dynamics GP 2010.

GP2themax - Helping users get the 'max' from Dynamics GP: Why do you think your company's utilization of GP is not optimal?

Frank Hamelly digs into why users think their company's utilization of GP is not optimal.

I’ve had some thoughts on this before. I’m huge believer in ongoing training. Too often companies fail to train beyond implementation. On the flip side, a lack of training is is also used as a crutch by some people.

Ultimately, a person is responsible for their career and a ton of learning opportunities are available for people willing to put in a little work.

Interesting Findings & Knowledge Sharing » Missing Object Explorer in SQL Server Management Studio

Over at Interesting Findings & Knowledge Sharing is a look at Missing Object Explorer in SQL Server Management Studio.

Top 100–Who’s Missing?

Over the last day or so I’ve had a number of conversations with folks about people missing from the 100 Most Influential in Microsoft Dynamics list.
Some of the more prominent names that I think should be on the list are:

• David Musgrave – He a prolific Dynamics GP blogger, he answers questions in the forums, he wrote the incredible Support Debugging Tool, provides support for it and he’s a highly rated speaker at events like Convergence. Plus the GP MVP’s voted him an honorary MVP. (He can’t be an MVP because he works for Microsoft. Apparently the MVP recognition isn’t enough to make him quit. Go figure.)
  
  So how is it that David Musgrave didn’t make the list?
  
• Adam Berezin / David Gumpert / Jason Gumpert – One of these guys should have made it based on all the hard work they put in at MSDynamicsWorld.com.
  
  [Disclaimers: MSDynamicsWorld and DynamicsWorld.co.uk are two different entities with some overlap in audience. I do a lot of writing for MSDynamicsWorld.]
  
  But when you run one of the largest websites dedicated to all of the Dynamics products and put on two virtual conferences a year around Dynamics I would think that you crack you the top 100.
  
• Nick Hoban – Nick runs the wildly successful Dynamics Community site for Microsoft. Surely someone who runs a site that affects tens of thousands of Dynamics users has the juice to make the top 100.
  
  [Disclaimer, yes I write for them too. Get over it.]
  
• Bob McAdam, Frank Hamelly, Errol Shoenfish, Chad Sogge and Pam Misialek

These are few more names that surprise me in their absence.

Weekly Dynamic: SmartList Any Field

SmartList contains an item in the Column Name section of the Search Box labeled Any Field. When searching a SmartList Any Field does just what you expect. It search any field in the SmartList for the value you input.

For example, using Any Field begins with cen in the Fabrikam Sales Order Invoice will return any fields whose value start with “Cen”

There can be some problems with this though. A bug in some versions of GP prevents this from working right. Even in GP 2010, I’ve seen errors where the search generates errors trying to convert a field to search it. It’s not perfect but that doesn’t mean that it’s not useful.

Blogger is Back

I had a few missing posts from the blogger outage. Thanks to Windows Live Writer my posts all seem to be back.

The Dynamics GP Blogster: Microsoft Dynamics GP "12" Web Client Architecture - Part 2

Mariano moves into the middle of his look at the Microsoft Dynamics GP "12" Web Client Architecture with Part 2

Accessing Internet Information from Report Writer - Developing for Dynamics GP

David Musgrave looks at Accessing Internet Information from Report Writer.
I’ve run into this before and it’s interesting because the Internet Information windows actually access Company level tables so it often requires a little extra work to get to them.

 

Management Reporter – Careful when Rounding a Balance Sheet | FRxBuzz

Jan Harrigan moves into Management Report territory and tells us to be Careful when Rounding a Balance Sheet.

New Letter Function for Collections Management in Dynamics GP 2010 R2 - Dynamics GP Support and Services Blog

From the revitalized GP Support and Services blog is a look at the New Letter Function for Collections Management in Dynamics GP 2010 R2.

This is important because based on some of the naming the in the letter you might be confused about what it’s actually supposed to do.

System Requirements for Microsoft Dynamics GP 2010 R2 - Inside Microsoft Dynamics GP

Over at Inside Microsoft Dynamics GP Pam Misialek looks at the System Requirements for Microsoft Dynamics GP 2010 R2.

Management Reporter - Top 10 Knowledge Base Articles - Dynamics Corporate Performance Management

Dynamics Corporate Performance shows us the Top 10 Knowledge Base Articles around Management Reporter.

2011 - 100 Most Influential in Microsoft Dynamics

The 2011 list of the 100 Most Influential in Microsoft Dynamics is out from DynamicsWorld.co.uk.
There are lots of names that you’ll recognize on the list. I’ve moved up a few notches to number 16 but I’m more impressed with Andy Snook of FastPath. He debuted at number 18. Andy must have incriminating pictures of someone to have become so influential so fast.
Dwight Specht made the list at number 75 and in classic Dwight fashion, humbly accepted this recognition.
As I’ve said before, it’s great to be on list, even if some things make no sense. For example I have no intention of walking up to Steve Balmer (#41) and asserting my claim to be  more influential.
I’m surprised at a few folks who didn’t make the list. Bob McAdam, Errol Shoenfish and Pam Misialek are a few that come to mind.
I am also thrilled at some folks who did make the list. I.B.I.S. had 4 people on the list this year including Andy Vabulas who moved up to number 27 and Clinton Weldon who debuted at number 90.
The thing about Clinton is that he’s actually gotten more fixes and features into GP than anyone I know. He just influences behind the scenes. In other words, he gets things done, unlike some people who are louder and higher on the list. I’m referring of course to number 16.
Congratulations to everyone who made the list and congratulations to everyone who was nominated. Certainly every GP person that I saw nominated deserves to be on this list.

Weekly Review: SQL Data Mining Add In.

Microsoft BI marches forward. The latest cool tool is also free. Microsoft has released its Data Mining Add In for SQL Server. While not necessarily GP specific it should work just fine against GP databases and cubes. I could spend a whole bunch of bits here telling you about it but why don't you just go here and see for your self how cool this is.

One caveat, this requires Office 2007 and SQL Server 2008 so some of you may not be ready for it yet.

Originally Posted by Mark at 5/18/2009 09:00:00 AM

New Letter Function for Collections Management in Dynamics GP 2010 R2 - Dynamics GP Support and Services Blog

From the revitalized GP Support and Services blog is a look at the New Letter Function for Collections Management in Dynamics GP 2010 R2.

This is important because based on some of the naming the in the letter you might be confused about what it’s actually supposed to do.

Confessions of a Young Consultant: Communication | DynamicsCare

My colleague Kelsey Andrich continues her look at what it’s like to be a young consultant (as opposed to us old consultants). Here newest post looks at Communication.

Interesting Findings & Knowledge Sharing » SQL View for Purchase Order Details with AA Information

Continuing with Analytical Accounting SQL scripts, Interesting Findings and Knowledge Sharing has a new SQL View for Purchase Order Details with AA Information

Dynamics GP Help

Dynamics GP Help is a new blog jumping into the GP space. Make sure to visit and make them feel welcome.

Dynamics Confessor Blogspot: Mekorma MICR error message (GP10)

Leslie Vail solves a Mekorma MICR error message for GP10

Quick Tip: How to create conditional Triggers in Dexterity

David Musgrave delivers a Quick Tip: How to create conditional Triggers in Dexterity.

Dynamics GP - Learn & Discuss: Getting Month Numbers between two dates in T-SQL

In a new post, Vaidy shows us how to Get Month Numbers between two dates in T-SQL

Easier Administration: Discovering Free SQL Tools and Tips for Microsoft Dynamics GP | MSDynamicsWorld.com

My new piece on Easier Administration: Discovering Free SQL Tools and Tips for Microsoft Dynamics GP is up at MSDynamicsWorld.

Let me encourage you to check out my related session at Decisions Spring 2011. This is a free, virtual event so really, you’re out of excuses for not attending.

The Top 10 Microsoft Partner MVPs -- Redmond Channel Partner

I’m in the list of The Top 10 Microsoft Partner MVPs from Redmond Channel Partner.

The Dynamics GP Blogster: Microsoft Dynamics GP "12" Web Client Architecture Series

Mariano has a new series looking at the upcoming Microsoft Dynamics GP "12" Web Client Architecture
The overview and Part 1 are up now.

Interesting Findings & Knowledge Sharing » Understanding Voucher Numbers in Receivables & Payables

Over at Interesting Findings & Knowledge Sharing, Sivakumar digs behind the scenes to provide an  Understanding Voucher Numbers in Receivables & Payables

The Dynamics GP Blogster: Free post Microsoft Dynamics Convergence Atlanta 2011 webinar

Mariano and crew are offering some Free post Microsoft Dynamics Convergence Atlanta 2011 webinars that include a chance to win a free, one day guest pass to Convergence 2012.

Dynamics GP Land: Implementation Trauma Continued

Christina Phillips continues her look at Implementation Trauma over at Dynamics GP Land.

Interesting Findings & Knowledge Sharing » Rebuilding Corrupt Resource Descriptions in Dynamics GP

Sivakumar looks at Rebuilding Corrupt Resource Descriptions in Dynamics GP

GP 2010 Guru’s Guide to Reporting | DynamicsCare

Amy Walsh likes Chris and David’s new book Microsoft Dynamics GP 2010 Reporting as well. She looks at in GP 2010 Guru’s Guide to Reporting

Dynamics GP Land: Payroll and Tips

Christina Phillips digs into Payroll with Payroll and Tips (Run Screaming Away, NOW!). Frankly Christina, it’s not fair to compare payroll to Sales and Use Tax. Sales and Use tax (as codified in the U.S.) is way more screwed up than payroll.

20-30% Discount on Dynamics Books in May

Its Dynamics Month at Packt Publishing and that means discounts on Microsoft Dynamics Books.

• Buy any Microsoft Dynamics print book and get 20% off
• Buy any Microsoft Dynamics eBook and get 30% off

Those discounts include these fantastic books, all of which are highly recommended, especially mine

Microsoft Dynamics GP 2010 Cookbook	Microsoft Dynamics GP 2010 Reporting	Microsoft Dynamics GP 2010 Implementation

If you’ve been thinking about buying the Microsoft Dynamics GP 2010 Cookbook or the just released Microsoft Dynamics 2010 Reporting for example, now is the time to do it.

Microsoft Excel - Portable formulas: A PowerPivot benefit you’ll never believe you lived without

Diego Oppenheimer digs into the power of Portable formulas: A PowerPivot benefit you’ll never believe you lived without.

If you analyze data from Dynamics GP, you need to look at PowerPivot.

Dynamics is “All In” the Cloud. What Does This Mean for Partners?

Software Advice has a new interview up with Marie Huwe, General Manager of Marketing for Microsoft Dynamics. The topic is  Dynamics is “All In” the Cloud. What Does This Mean for Partners?

Manual Payroll Check - Calculating Employer FICA

iSolutions has a look at the new FICA fields in GP 2010 for processing a Manual Payroll Check.

Keeping Word Templates in synch with Report Writer - Developing for Dynamics GP

Dave Dusek looks at the process to Keep Word Templates in synch with Report Writer.

Hands on Labs from Convergence Now Available - Inside Microsoft Dynamics GP

The Hands on Labs from Convergence are Now Available.

Hands on labs are one of the great features of Convergence allowing you see and touch feature without having to go through the pain of a full install. Make sure to checkout the Hands on Labs from Convergence 2011.

Reporting Central: The Closer – Easily Reconcile Microsoft Dynamics® GP, Never “Tick and Tie” Again | DynamicsCare

If you want a look at The Closer and you missed last weeks webinar you can catch the replay at DynamicsCare

Weekly Dynamic: Why Won’t the SQL Transaction Log Clear?

In the past we’ve looked at the SQL transaction log

• To Find Databases Where the Log is Too Big
• To find out Why the Transaction Log is Full
• To Monitor the Transaction Log for Unusual Growth

This week, courtesy of the illustrious Paul Randal, we have a SQL Script to help figure out why the log can’t clear. The script is

select log_reuse_wait_desc from sys.databases

and you get back results like this:

Mohammad R. Daoud: eConnect Error: The argument type `SqlClient` cannot be converted into parameter type `Microsoft.Dynamics.GP.eConnect.EnumTypes+ConnectionStringType`.

Mohammad Daoud explains how he solved the eConnect Error: The argument type `SqlClient` cannot be converted into parameter type `Microsoft.Dynamics.GP.eConnect.EnumTypes+ConnectionStringType`.

Microsoft Dynamics GP System Administrator: Should You Separate Accounting Controls and Duties? | MSDynamicsWorld.com

Over at MSDynamicsWorld, Gloria asks Microsoft Dynamics GP System Administrator: Should You Separate Accounting Controls and Duties?

In addition to Gloria’s look at how and when to use the SA account I would add a shout out to Fast Path’s Config AD which allows security assignment to be separated from security setup. This allows consolidated security assignment from centralized security group.

Config AD also allows single sign on based on Active Directory. This reduce risk since users have fewer passwords to remember, making them less likely to write them down. It also reduces password related support calls.

Mohammad R. Daoud: Cash account is not being loaded in Cash Receipt and Manual Payment if the payment type is “Check”

Looking at why the Cash account is not being loaded in Cash Receipt and Manual Payment if the payment type is “Check” Mohammad Daoud found an issue with Payment Document Management.

Weekly Review: Dynamics GP 10 & 2010 Roles vs. Classes

 

In Dynamics GP 10, the User Class functionality that was previously used to assign security to groups of users has been superseded by the new role based security design in Microsoft Dynamics GP 10. But, user classes still exist as part of the user setup. Lets look at what purpose User Classes still serve in GP 10. The move to role based security means that classes are now divorced from their primary security role and it proves to be a good breakup because it adds flexibility to the system.

One area that still relies on User Classes is Organizational Structures. Organizational Structures are used to control access to accounts when Account Security is turned on. A user class is assigned to a level in the organizational structure. This limits the accounts in the chart of accounts that are available to a class of users and can be much simpler than adding individual users. For example, a set of AR users assigned to Division 1 can be put in a Division 1 class tied to an organizational structure that limits their chart of accounts access to Division 1 P&L accounts and company wide balance sheet accounts. This means that AR users and AR supervisors could be in one class even though they have different security roles. [One caveat, turning on Account Security without defining organizationl structures makes it look like the chart of accounts has been wiped out so turn this feature on carefully.]

Additionally, user classes provide two benefits in SmartLists. First, users can make a SmartList favorite visible only to their class. Previously this would have meant that an AP clerk would have access to a favorite but not an AP supervisor since they might be in different classes for security. That's less likely now that each would have a separate security role. This shows the added flexibility that classes bring to the new role based security structure.
Second, the system administrator can force Navigation Bar shortcuts like SmartLists down to user classes. When this is done, the individual user cannot remove these shortcuts. This means that it's easier for the administrator to ensure that all related users have a common subset of shortcuts. For example, it's easy now for a company to put a shortcut to an office supplies ordering website on all Purchasing user class members regardless of their level in the organization.

Contrary to my initial thoughts that Role Based Security in Dynamics GP 10 would make user classes obsolete, the opposite has happened. The continued presence of user classes has actually added flexibility to the system.

Originally Posted by Mark at 3/30/2009 09:00:00 AM

Mohammad R. Daoud: Post to General Ledger has not been marked for this batch.

Mohammad Daoud tackles a posting issue in Post to General Ledger has not been marked for this batch.

Confessions of a Young Consultant: Going Solo | DynamicsCare

My colleague, Kelsey Andrich just tackled her first solo project. Check out here experience in Confessions of a Young Consultant: Going Solo.

Nice job Kelsey.

Looking for Office 365 Beta Customers - Inside Microsoft Dynamics GP

Microsoft is Looking for Office 365 Beta Customers who also use Dynamics GP.

Fun Day Monday - It's SmartList Monday! - Inside Microsoft Dynamics GP

Monday, March 23rd, 2011.

SmartList Monday. Be there. Virtually. Follow the link.

Fun Day Monday - It's SmartList Monday!

Troubleshooting Upgrade to Dynamics GP 2010 R2, Part 2 | Aaron Berquist - High Dynamic Range

Aaron follows up with a part 2 to his post on Troubleshooting Upgrade to Dynamics GP 2010 R2.

It’s interesting to note that most of the R2 issues I’ve seen and read about have been pretty minor so far and in my experience, the GP team has been very responsive publicly to R2 install issues.

Helpful Hints for Logos in Word Templates for Dynamics GP 2010 - Dynamics GP Support and Services Blog - Site Home

New from the Dynamics GP Support and Services Blog are Helpful Hints for Logos in Word Templates for Dynamics GP 2010. That’s a great looking logo they’ve got there.

Troubleshooting Upgrade to GP 2010 R2 | Aaron Berquist - High Dynamic Range

Aaron Berquist solved a little issue with the GP 2010 R2 upgrade and wants to share the solution in Troubleshooting Upgrade to GP 2010 R2.

The Dynamics GP Blogster: IM - "You must close all Microsoft Dynamics GP windows in order to run an integration"

Mariano look at a setting that eliminates the pesky "You must close all Microsoft Dynamics GP windows in order to run an integration" message in Integration Manager. Of course, if you have the wrong windows open your integration may not work but for experienced users that’s usually not a problem.

Microsoft Dynamics - Spring Webcast Series - Inside Microsoft Dynamics GP

From Inside Microsoft Dynamics GP comes a - Spring Webcast Series with a look at HR/Payroll and What’s New in GP 2010 R2.

Introducing Microsoft Dynamics GP 2010 Reporting!

It’s big, it’s bold and now it’s loose! New from my colleagues Chris Liley and David Duncan is the book Microsoft Dynamics GP 2010 Reporting. I had the privilege of reviewing the raw version of this book and it’s phenomenal. The information that they packed into 360 pages is incredible.

In my Excel session at Convergence I mentioned that this book would be out before you got through your emails back at the office and here it is.

If you want an ebook version check out the Packt Publishing website.