more-arw search

Q&A Forum

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.


Topic Expert
Wayne Spivak
Title: President & CFO
LinkedIn Profile
(President & CFO, |

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?

Jim Gundell
Title: consultant
(consultant, ) |


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


Gregory Schaub
Title: Controller
Company: Unemployed
(Controller, Unemployed) |

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


Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email [email protected] to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.