Include Parts in Replenishment Report
The replenishment report helps track inventory for main products and product parts. While main products appear on the website, individual parts do not. They still need to be tracked for inventory purposes. This guide covers how to ensure product parts are correctly captured in the replenishment report.
What you'll accomplish: Configure product parts in Business Central so they appear in the replenishment report for inventory tracking.
Time required: 5-10 minutes
What you need:
Access to Business Central
Main product already set up in BC and SharePoint
Complete list of parts that make up the product
Collection year for each part
How Parts in Replenishment Reports Work
Main products vs Parts:
Main products: Published on the website (e.g., a complete chandelier)
Parts: Components of the main product (e.g., glass shades, mounting hardware, bulbs)
The relationship:
Main products are assembled from multiple parts
Parts are NOT published on the website individually
Parts ARE tracked in the replenishment report for inventory
Why this matters:
Inventory needs to track parts separately
Replenishment report shows what parts are needed
Helps manage stock levels for assembly
Prerequisites
Before you can add parts to the replenishment report, the main product must be fully set up:
1. Main product configured in Business Central:
Item created with complete details
No. field (SKU) filled
Description field completed
All required attributes configured
See guide: Add Attributes to a New Product
2. Main product has SharePoint folder:
Product folder exists in SharePoint
Located in:
Website assets / Products / [Collection] / [SKU]Primary image uploaded
See guide: Add a New Product
3. Assembly BOM complete:
Assembly BOM lists all parts that make up the main product
Every component part is included in the BOM
BOM is accurate and saved
Without complete Assembly BOM: Parts won't connect to the main product correctly.
The Three-Step Process
To ensure parts appear in the replenishment report:
Step 1: Main product fully set up (BC + SharePoint) ✓
Step 2: Assembly BOM has complete parts list ✓
Step 3: Each part has Collection Year attribute configured ✓
Result: Parts appear in replenishment report organized by collection year.
Step 1: Verify Main Product Setup
Before working with parts, confirm the main product is complete.
Check Business Central
1. Search for the main product by SKU
2. Open the item card
3. Verify:
If incomplete: Complete the main product setup first before proceeding with parts.
See guides:
Check SharePoint
1. Navigate to:
2. Verify:
If missing: Set up the SharePoint folder before proceeding.
See guide: Add a New Product
Step 2: Complete Assembly BOM
The Assembly BOM (Bill of Materials) lists every part that makes up the main product.
What is an Assembly BOM?
Assembly BOM defines:
All parts/components needed to assemble the main product
Quantity of each part required
How parts relate to the finished product
Example - Chandelier:
Step 3: Add Collection Year to Each Part
This is the critical step to capture parts in the replenishment report.
Why Collection Year Matters
For parts to appear in the replenishment report:
Parts must have the Collection Year attribute configured
This attribute connects parts to the collection
Replenishment report organizes by collection year
Without Collection Year:
Parts won't appear in the report
Can't track inventory by collection
Add Collection Year Attribute
For EACH part in the Assembly BOM:
1. Open the part's item card in Business Central
Search for the part by item number
Open its item card
2. Navigate to Item > Attributes
Same location as main product attributes
Attributes window opens
3. Add "Collection Year" attribute
Click "New Line"
Select attribute: Collection Year
Enter the value: Year of the collection
Example:
2024,2025Use 4-digit year format
4. Save
Close the attributes window (auto-saves)
Collection Year is now configured for this part
5. Repeat for all parts
Every part in the Assembly BOM needs Collection Year
Use the same year for parts belonging to the same collection
Collection Year is the ONLY Required Attribute
For parts (not main products):
Required: Collection Year attribute
Not required: Category, Collection Name, or other attributes
Why? Parts aren't published on the website, so they don't need the same attributes as main products. Collection Year is sufficient for replenishment report tracking.
Verification Checklist
Before considering the setup complete, verify all requirements:
Main Product:
Assembly BOM:
Each Part:
Result: Parts will appear in the replenishment report organized by collection year.
What Happens Next
After completing all three steps:
Parts are linked to the main product via Assembly BOM
Collection Year captures parts in the system
Replenishment report generates with parts listed
Parts appear organized by collection year
Inventory tracking enabled for parts
When to check: Run or view the replenishment report to verify parts appear correctly.
Important Notes
Parts Are NOT Published Online
Critical distinction:
Main products → Published on website
Parts → NOT published on website
Parts → Only tracked internally for inventory
Why separate?
Website shows complete products customers can buy
Inventory system tracks individual parts for assembly
Different purposes, different visibility
Assembly BOM Must Be Complete
If parts are missing from the Assembly BOM:
They won't connect to the main product
They won't appear in the report even with Collection Year
Inventory tracking will be incomplete
Always verify Assembly BOM includes every single part needed to assemble the product.
Collection Year is the Key
This single attribute makes parts visible in the report:
Without it: Parts are invisible to the report
With it: Parts are tracked and organized
Don't skip this step for any part.
One Year Per Part
Each part has one Collection Year value:
Use the year of the collection it belongs to
Example: 2024 Collection → Collection Year =
2024Keep it simple - 4-digit year format
If a part is reused across collections:
Set Collection Year to the primary collection
Or create separate part items for each year
No Other Attributes Needed for Parts
Parts don't need:
Category attribute
Collection Name attribute
Dimensions
Finish options
Any other attributes
Parts only need:
Collection Year (for replenishment report)
Basic item information (No., Description)
Why? Parts aren't displayed on the website, so they don't need website-specific attributes.
Troubleshooting
Issue: Parts not appearing in replenishment report
Solutions:
Verify each part has Collection Year attribute configured
Check Collection Year value is saved (not blank)
Ensure parts are listed in Assembly BOM of main product
Confirm main product is fully set up in BC and SharePoint
Re-run or refresh the replenishment report
Issue: Only some parts appearing in report, not all
Solutions:
Check which parts have Collection Year configured
Missing parts likely don't have Collection Year
Add Collection Year to missing parts
Verify Assembly BOM includes all parts
Issue: Parts appearing under wrong collection year
Solutions:
Check Collection Year value for each part
Verify year is correct (e.g.,
2024not2023)Update Collection Year if incorrect
Save changes and re-run report
Issue: Can't find Collection Year attribute in Business Central
Solutions:
Open part item card
Navigate to Item > Attributes
Click "New Line"
Search for "Collection Year" in attribute list
If missing, may need to be added to BC by admin
Issue: Assembly BOM is empty but product has parts
Solutions:
Access Assembly BOM from main product item card
Add all parts to the BOM
Enter correct quantities
Save the BOM
Then add Collection Year to each part
Issue: Main product not set up correctly
Solutions:
Complete main product setup first
Ensure BC item card is filled out
Verify SharePoint folder exists
Configure main product attributes
Then proceed with parts setup
Common Scenarios
Scenario 1: New product with parts for replenishment tracking
Create main product in Business Central
Add main product attributes (Category, Collection Name, etc.)
Create SharePoint folder and upload images
Open main product item card
Configure Assembly BOM with all parts
For each part: Open item card, add Collection Year attribute
Save all changes
Parts appear in next replenishment report
Scenario 2: Existing product, need to add parts to report
Main product already exists and published
Open main product item card
Check Assembly BOM - add any missing parts
For each part in BOM: add Collection Year attribute
Save changes
Parts now tracked in replenishment report
Scenario 3: Part missing from report
Run replenishment report - part is missing
Find the part item in Business Central
Check Assembly BOM - is part listed? If no, add it
Check part attributes - does it have Collection Year? If no, add it
Save changes
Re-run report - part now appears
Scenario 4: Multiple products share same parts
Parts are used across multiple products
Each main product has its own Assembly BOM
Same part appears in multiple BOMs
Part has one Collection Year value
Part appears in report once, organized by its Collection Year
Best Practices
When Setting Up New Products with Parts
Maintaining Assembly BOMs
Managing Collection Years
For Inventory Accuracy
Workflow Summary
Quick reference for complete process:
Related Guides
Add Attributes to a New Product - Main product attribute setup
Item Attributes Quick Reference - Understanding attributes in BC
Update Product Attributes - Modifying existing attributes
Add a New Product - SharePoint setup for main products