Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

How would you design this?

Posted on by 566

How would you design this with Dynamics NAV 2017?

Three different companies, same owner, same industry.

They share a production plant. Each company owns different machines.

They need to use MRP so Dynamics NAV manufacturing is a must.

They get sales orders from their customers indistinctly because any of them can sell final goods (books, by the way).

In a production order, it usually participates machines, personnel and raw materials not only for the company that got the sales order, but from the others.

At the end of the month they have lots of administrative complexity in figuring out what one company did for others of the group and make an invoice for that.

I see two possible solutions for design, please choose and comment:

a) set up three companies, create a "Virtual Production" fourth one for the plant that would run the production orders and develope some coustomization to syncronize sales/purchase orders and stock between Virtual Production Company and the 3 real. Use INTERCOMPANY to simplify invoincing among them.

b) set up only one company and use a new DIMENSION named Company to tag every single operation in other to track operations between them. Create a customization to generate invoices between them for the used resources. 

Unfortunately I see lots of customization...

*This post is locked for comments

  • AntonioTorre Profile Picture
    AntonioTorre 566 on at
    RE: How would you design this?

    Great answer Jens, this whole last week I have been discussing the issue with some experts and all come to a very similar solution you have described.

    We will finally go through solution a), this is 3 "legal" companies just for GL, and an extra "group" company for everything related to stock (po, so, manufacturing, warehouse...). We have decided not to synchronize orders and have them all together in "Group" company since we think it does not add any data value to "legal" companies.

    About intercompany, we will customize an automatic end-month process that would make sales/purchase invoices among companies of the group.

    We will also build an extra process to post inventory cost/adjustments to GL, which should not be very complex.

    Thanks again Jens!

  • Verified answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: How would you design this?

    Hi Astur,

    oh that's not an easy one. My first impulsive reaction was to say "don't use NAV", as it doesn't fit the requirements enough. The one I know that does fit the requirements starts with an S and ends with a P. Anyway. Some considerations on how to pull this off on NAV:

    1. MRP, production, inventory only work in one company in this case. You need to have the whole inventory and the whole park of machinery at hand when you do the planning. Also, purchasing from this one central company can be done... to decide which is which, hmm... So, this sounds like option a) could be viable, but with inventory and production all in one virtual company.

    2. Beware of the dimensions. Sounds nice, survives the powerpoint-test, unless I am in the audience ;) You can implement this with dimensions, but it is a far more complex customization than it appers to be at first. I have done this implementation of subsidiaries (permanent establishments) in the same company. Only for G/L, no MRP or production. It is working nicely, but it has increased the complexity of the overall application and posting routines. I would not even try to do this with inventory and production.

    3. Intercompany sounds nice, but with one central inventory, it is more of a representation of a correct balance sheet and income statement by independent company. The values for this invoice will not come out of NAV directly, especially not the split between the companies. So, just posting the result as G/L postings should suffice, IMO. In this case, no intercompany setup is needed.

    Come to think of it, I would recommend to have a look at Singhammer's SITE AddOn. This seems to work in the way you seem to require.

    with best regards

    Jens

  • Suggested answer
    M.Zayed Profile Picture
    M.Zayed 460 on at
    RE: How would you design this?

    Hi,

    I would recommend creating 3 different companies and using Navision standard IC (Inter company) features which will help you to create sales order, Purchase order and .........

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans