Small and medium business | Business Central, N...

Items sold as components and on their own

(6) Share

Report

Posted on by LA-17050840-0

Hello all, I need help. What is the best way to see how many pieces of item was sold as part of assembled item and how many on its own? I know I could check how many assembled items with this component were sold and how many on its own and add it but I would like a simple overview, nothing complicated. Thank you

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Mansi Soni 8,909 Super User 2025 Season 2 on at

Like (2)

Report

Hello,

To get a simple overview of how many units of an item were sold on its own vs. as part of an assembled item in Business Central, check Item Ledger Entries (filter by Entry Type = Sale) to see direct sales, and use Assembly Order Lines or Assembly Orders to see how many were used as components in assembled items. This gives you a clear split without needing complex reports.
For a cleaner summary, you can also create an Analysis View to track item sales more flexibly by combining various filters like item, location, and variants if required.

Hope this answer will help you!

Regards,
Mansi Soni

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,529 Super User 2025 Season 2 on at

Like (1)

Report

Table: Item Ledger Entry Filters: Entry Type = Sale Item No. = [your item] Exclude entries with Order Type = Assembly

Thanks, Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,150 Super User 2025 Season 2 on at

Like (1)

Report
Hope this might be helpful:

To get a simple overview of how many pieces of an item were sold as a component vs. on its own in Business Central:

For standalone sales: Check Item Ledger Entries and filter Entry Type = Sale.

For component sales (as part of an assembled item):

Check Item Ledger Entries and filter Entry Type = Assembly Output (for the assembled item) and then use the Assembly Order Lines to see the component usage.

Alternatively, use the About Assemble to Order - Sales report (Report 915), which is designed to show sales figures for components sold both as part of assemblies and separately.

Combining data from Item Ledger Entries and utilizing the About Assemble to Order - Sales report provides a comprehensive overview.

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
Suggested answer

Ben Baxter 6,620 Super User 2025 Season 2 on at

Like (1)

Report

Open your Item Ledger Entry table and switch to the Analysis view:

Then group your data by Item No. and Entry Type:

This will give you an onscreen, dynamic view of what you're looking for. You can then expand the requirements to total quantities, sales $, etc.

If this response helped answer your question, please mark it as a Verified Answer.

Best Regards,

Ben Baxter

Accent Software Inc

Was this reply helpful? Yes No
Suggested answer

Andrés Arias 4,190 Super User 2025 Season 2 on at

Like (1)

Report

Hello,

According to my understanding you could have some options:

- Item Ledger Entries by filtering the Item and Source Type fields.
- Use the option of: Item Analysis View, and using filters.

I hope I can help you.

Regards.

Andres

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,637 Super User 2025 Season 2 on at

Like (0)

Report

You can use the Item Ledger Entries page to see how many pieces of an item were sold on their own and how many were part of an assembled item. Just filter by the item number—entries with Document Type = Sale show individual sales, and those linked to Assembly Orders show the item used in assemblies. Additionally, you can check the Assembly BOM or Item References to find which assembled items include the component. This gives you a quick way to understand how the item is used and sold without creating complex reports.

You can check this Report as well - Assemble to order - Sales.

Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,748 Super User 2025 Season 2 on at

Like (0)

Report

If you want to manage accurately, you need Item Tracking Line, for example, use Lot No. to manage whether the item is assembled or purchased. If the structures of the two numbers are different, it should be possible to count them.

Hope this can give you some hints as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,373 Most Valuable Professional on at

Like (1)

Report

Hi, good day
I hope this can help you, and give you some hints.

Assembly Reports and Analytics in Business Central - Business Central | Microsoft Learn

Best Regards
Gerardo

Was this reply helpful? Yes No