web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

Managing Inventory Across Product Dimensions Without Creating a Second Item

(0) ShareShare
ReportReport
Posted on by 35
Hello -
 
We manufacture two different product lines in the same location. We have an inventory item (a pallet) that is currently uses as a component on a BOM for Product Line A, so our transactions for this item are received into and posted against that product dimension.
 
We would now like to occasionally sell the same pallet on a sales order for Product Line B. Since most usage will continue to be for Product Line A, we would prefer not to create a separate item solely for Product Line B.
 
Is there a recommended way in Business Central to handle this scenario while ensuring inventory value and costs are assigned to the correct product dimension?
 
What we've tried:
 
1. Item Reclassification Journal
We reclassified inventory from Product Line A to Product Line B
  • The inventory Account entries behaved as expected.
  • However, the Inventory Adjmt Account was debited for the source product dimension and credited for the destination product dimension.
  • As a result, the cost impact still appears to remain with the original product line, even when the item is sold under the destination product dimension.
2. Transfer Order
We considered using a transfer order, but my understanding is that the transfer order is intended for inventory movement between locations. Both product lines exist within the same location.
 
Thank you for any guidance!
I have the same question (0)
  • CU22041105-0 Profile Picture
    86 on at
    Since both product lines operate within the same location, a transfer order may not be the best fit. One approach is to use dimensions on the sales transaction to allocate costs and revenue correctly for reporting. If cost ownership must move from Product Line A to Product Line B, you may need an inventory reclassification together with a cost adjustment or a custom allocation process, as standard Business Central does not fully reassign historical inventory costs between dimensions within the same location. It would also be helpful to know whether Product Line is configured as a Global Dimension or a Shortcut Dimension.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 690 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 545 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 304 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans