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

Balance Sheet Clean Up-Inventory

(5) Share

Report

Posted on by HP-11111426-0

We currently break our business up between two divisions (701,702) Originally we coded everything in the system to 701 and slowly started to allocate items into 702. I have cleaned up every Balance Sheet category other than inventory. I cannot figure out how to correctly break out what belongs in 701 and what belongs in 702. i have pulled the inventory valuation and i have pulled it by division and blanks but when i pull separate reports for each division plus blanks i cannot get it to add up to what pulls on the inventory valuation. My question is, what is my best option making sure I pull everything in inventory and separating it out between the divisions.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Jainam M. Kothari 15,732 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,

To accurately split inventory between divisions, the best approach is to use Item Ledger Entries filtered for open quantities, as these drive the Inventory Valuation report. Include the division code (701, 702, or blank) and sum the Cost Amount (Actual) by division.

For blanks, allocate based on location, item category, or historical usage. This method ensures your totals reconcile with the valuation report and gives a clear breakdown.

Going forward, enforce division tracking via mandatory fields or dimensions for all inventory transactions.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 12,766 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

Use the Item Dimensions – Detail (7150) report to list inventory by division dimension (701, 702).

Run Adjust Cost – Item Entries and Post Inventory Cost to G/L first for accuracy.

Reclassify blank dimensions through an Item Journal to fix missing values.

Regards,

Oussama Sabbouh

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

Like (0)

Report
Copy link

Link copied!

Hi

You could rely on the dimensions

Work with dimensions to track and analyze data - Business Central | Microsoft Learn

Business Central Inventory/Sales Analysis – Item Group Dimension Code❓︎

How to Set up an Inventory Analysis Report in Business Central - Boyer & Associates

Best

Gr

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,152 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Do you mean that when you run separate Inventory Valuation reports for Division 701, Division 702, and for blank divisions, the combined total doesn’t match the total shown when you run the report without any division filters?

That doesn't make much sense. Do you have transactions with divisions other than 701 and 702?

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

Rishabh Kanaskar 6,219 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

That happens because the Inventory Valuation report calculates totals based on item cost layers, not strictly on dimensions. When you filter by dimension, the report excludes entries without that dimension, and blanks often include adjustments or revaluations that affect the overall total. So the sum of filtered reports might not equal the unfiltered total.
Best approach:

> Use Item Ledger Entries joined with Dimension Set Entries to build a custom report or query that includes all entries (701, 702, and blanks) and reconciles to the valuation.
> Alternatively, use Inventory Valuation by Dimension in Analysis Views.
Ensure all historical entries have correct dimension values, blanks will always cause mismatches unless corrected.

Thanks

Rishabh

Was this reply helpful? Yes No