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?

Member's Profile


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


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