Mark Polino's Blog, page 353

Weekly Review: Backwards Allocation Accounts in Dynamics GP

 

We've covered Fixed Allocation accounts here before but I've got a new use for them now. Typically a Fixed Allocation account takes an amount posted to that account and passes it to multiple other accounts based on the setup percentages. Recently I ran into a situation where we wanted to do the opposite.

In Project Accounting you can force transactions to change various segments to match the segment values assigned to the project using the subnet mask functionality. For example, a department segment is changed on posting to match the department assigned to the project. It works great until you run into a particular cost category that you DON'T want to change based on the project. You can't control subnet masks by cost category, an account type either gets a mask or it doesn't. In our case, for certain allocation transactions to a particular cost category, we wanted them all to hit the same department but Project Accounting was transforming the department segment causing us problems.

The solution was to create a Fixed Allocation account for each department. The allocation accounts all pointed to the same real GL account with a 100% allocation. In other words, instead of using an allocation account to spread costs to multiple departments, we used multiple allocation accounts to rollup costs to a single department. This kept the GL clean and avoided polluting the chart with a whole bunch of accounts since allocation accounts are pass through accounts that don't show up on financial statements.

I love finding new uses for old features!

Originally Posted by Mark at 6/08/2009 09:00:00 AM

What are the Worst Mistakes You can make (or have made) with Dynamics GP?

John Lowther and I are working on a presentation for the upcoming GPUG Summit and we are looking for the worst mistakes you can make with Dynamics GP. We have some of our own ideas but we would love to get more ideas from everyone else. If you've got a nasty mistake that you've made or seen with Dynamics please comment on this post or email me at mpolino@gmail.com.

Dynamics GP Land: Account Level Security and Advanced Search, Uh-Oh

Christina Phillips looks at disconnects in Account Level Security and Advanced Search. I agree with Christina that this is a problem but for different reasons.

I've personally never seen a business where the descriptions of an account in the chart were so sensitive that users couldn't see them. In most cases, the descriptions aren't descriptive enough not to mention so descriptive that they would cause concern. The problem I have is that the message returned is that the account doesn't exist, when clearly, it exists, the user is just denied access.

This is similar to the problem that happens when user accidently turn on advanced security. It appears that the account don't exist instead of indicating that security is restricted. Check out the whole article for details.

Dynamics GP Land: Implementation Trauma, Number Three!

From deep in Dynamics GP Land, Christina Phillips drop Implementation Trauma, Number Three! on us with a look risks and difficult conversations in implementations.

Confessions of a Young Consultant: Managing the Ropes

Once again I marvel at the transparency of Kelsey Andrich. I think I'm transparent and I read something like Confessions of a Young Consultant: Managing the Ropes.

Keep up the great work Kelsey.

Microsoft Dynamics GP Discussion.

Welcome Samuel Mathew and his blog Microsoft Dynamics GP Discussion. A blog created to share my thoughts about MS Dynamics GP to the discussion.

Microsoft Dynamics GP "12" Architecture Series - Developing for Dynamics GP

If you're interested in new on the upcoming Dynamics GP "12", David Musgrave pulls together available information into a single post a Microsoft Dynamics GP "12" Architecture Series.

Let's Get FOCUSED on FRx & BI in Texas - Microsoft Dynamics Community

If you're interested in BI check out GPUG's BI event coming to Texas this summer. There's more at Let's Get FOCUSED on FRx & BI in Texas - GPUG Events & News.

Mohammad R. Daoud: Dynamics GP Vs. Dynamics AX

Mohammad Daoud looks at Dynamics GP Vs. Dynamics AX. While I generally agree with his comments, I think that GP is more customizable than people with less effort than people give it credit for. It also has much strong financials.

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.