Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Inventory valuation to account for internal division profit

(0) ShareShare
ReportReport
Posted on by

Hi guys,

As part of our expansion, we have just purchased one of our suppliers.

They will become another division of our company and will continue to sell directly to their existing customer base, some of whom are already customers of ours and we were their largest customer.

We would like to maintain the margin on sales from our old supplier to our company so that we can conduct a historical analysis of sales and also measure the profitability of the division.

We are going to set the new division up as a new responsibility centre within our existing company and all sales to customers from this division will be attributed to the new RC. The problem we have however is that we want to maintain our current price structure, including margins and to do that the cost price for sales made by the new division will be the actual cost price of the goods, whereas the cost price for sales made from our existing branches needs to be the price that we would have purchased the goods for if the new division was still an external supplier.

Are you following me so far??

So we are looking for a way to transfer stocks from the new RC to our existing RC's in an increased cost price for the existing divisions, BUT we are also trying to avoid artificially inflating the value of our inventory.

Here is a very basic example of what currently happens:

As a separate company Sales to us Direct sales
Cost price $10.00 $10.00
Sell price $15.00 $20.00
Margin 33% 50%
Our current sales Direct sales
Cost price $15.00
Sell price $20.00
Margin 25%

in the example above, the supplier makes a margin of 33% on sales made to us and a 50% margin on direct sales and we make a margin of 25% on our direct sales.

This is what will happen as standard once they are a division of our company:

As a division of us Transfers to us Direct sales
Cost price $10.00 $10.00
Sell price $10.00 $20.00
Margin 0% 50%
Our future sales Direct sales
Cost price $10.00
Sell price $20.00
Margin 50%

in the example above transfers are at cost and therefore do not have a margin so as the biggest customer of our supplier, the profitability of the division will drop markedly compared to their previous performance and our profit will jump from 25% to 50%, which is a huge increase compared to historical performance. When combined the overall profit will be accurate but it will be very difficult to compare current figures to historical figures.

Has anyone come across a requirement similar to this and if so, how did you handle it??

Thanks,

Warren.

*This post is locked for comments

  • Suggested answer
    Alex A Profile Picture
    2,348 on at
    RE: Inventory valuation to account for internal division profit

    Hello,

    In acquiring another company such as a supplier, I believe the best way to handle this is to setup a new company in NAV to operate that supplying vendor that you purchased. The new company in NAV will share the same database (same users list, same form customizations, and etc...) but will have it's own master data tables - meaning they will have their own Item list, and you can set the cost and pricing however you need on their own Item card(s). In fact you would be able to migrate their data from their existing system straight into yours retaining all their original Item pricing/settings.

    You will also have the flexibility of being able to setup sales line discounts to cover all the various prices to different parties. So, they will still be able to sell to their own customers at whatever price but you can configure sales to your parent company at the price you need.

    If they share some of the same customers or if you are a customer of theirs then it works fine because each company has it's own customer and vendor list. You can still create Purchase orders to buy from them and they can still create Sales Orders and Invoices to track the sales. You can receive the items and pay the invoice just like normal. Yet you have the option of using the inter-company postings as well. You'll be able to track the finances and everything separately yet you have the option of rolling all the financials up into a consolidation company if desired.

  • Suggested answer
    Alexander Ermakov Profile Picture
    28,094 on at
    RE: Inventory valuation to account for internal division profit

    Hi wphaddock,

    If I follow you correctly, you would like to have still the sales margin of your division still 33% when making sales to you, after the merge process, instead of 0%, in order to maintain the historical analysis?

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans