How do I combine different types of divisions within MS Dynamics GP?

Jim Gundell's Profile

I am converting to MS Dynamics GP (decision made before my arrival).  I have a food manufacturing division, an import division and a retail division.  I am inclinded to use the manufacturing model in MSDyn, since costing has been and remains an issue.  But then i have to force the other divisions into that model.  I don't see a way to easily track individual store P/L.  Any ideas would be greatly appreciated.


Proformative Advisor
Member's Profile

I'm not a GP person, but in Navision and Nav-Dynamics you had departments and projects (and I believe in Dynamics other dimensions) that can be used.

Why not try that model?

To comment, and for full access, login or register
Member's Profile


Thanks for pointing me in the right direction. A quick bit research indicates that you are correct. I feel better.


To comment, and for full access, login or register
Member's Profile

You should be able to get a dimension model. You can then use this to separate your import and manufacturing divisions, and then track individual stores and even segregate by region by the way you setup the dimension hierarchy.

To stock your stores you would need to transfer finished goods from your manufacturing finished goods warehouse into separate warehouses for the retail stores. I think you would have to locate a Point-of-Sale model for the stores. It may take some integration to make it a seamless integration.

Have you purchased multiple companies? You then would need to setup inter-company transactions. To make things easier setup all the companies with the same chart of accounts. You could then use the manufacturing model for just the one company and setup the Store division with a Point-of-Sale model. Then use dimensions to identify the stores.

The best advise is talk with your consultant. They probably have seen something like your situation and should be able to help you. Just be sure to explain your concerns and ask question when the option they show you doesn't seem to work the way you would like it to work. Try not to customize the system too much it will cost every time you need to up grade the system.

Good Luck

To comment, and for full access, login or register
Member's Profile


Thanks for the response and all of the thought that you put into it. This is not multiple companies; just the one with autonomous divisions. I've also lived through the nightmare of over-customization of software. Very uncomfortable feeling.

I have started researching the dimension approach. I like what I've seen so far. I think it will not be the problem that I imagined.

Your Proformative tag indicates that you are unemployed. If that is still the case, email your resume to me. Let's see if I can help you like you have helped me.

Jim Gundell
jgundellatcomcast [dot] net
(925) 922-1590

To comment, and for full access, login or register