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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Balance Sheet Clean Up...
Small and medium business | Business Central, N...
Suggested answer

Balance Sheet Clean Up-Inventory

(2) ShareShare
ReportReport
Posted on by HP-11111426-0 4
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)
  • Suggested answer
    Jainam M. Kothari Profile Picture
    Jainam M. Kothari 13,577 Super User 2025 Season 2 on at
    Balance Sheet Clean Up-Inventory
    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.
  • Suggested answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 2,251 on at
    Balance Sheet Clean Up-Inventory
    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,351

#2
Sumit Singh Profile Picture

Sumit Singh 2,072

#3
YUN ZHU Profile Picture

YUN ZHU 1,807 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans