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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Inventory Split/combine
Small and medium business | Business Central, N...
Suggested Answer

Inventory Split/combine

(6) ShareShare
ReportReport
Posted on by M0HAN SINGH 366
Hi experts, i need your help to achieve below requirement:
 
i want a split and combine facility for inventory on Advance warehouse enabled location. below are the setups and requirement.
Setup 1: Location is Directed put/pick enabled.
setup 2: Item is Package and Lot tracking enabled
Scenario: 
Item Code        = RM0001
Remaining Qty = 5000 kg.
Package No.     = PK001
Lot No.             = LT001 
requirement (Split 1) : 
Item Code        = RM0001
Remaining Qty = 2000kg.
Package No.     = PK002
Lot No.             = LT003
requirement (Split 2) :
Remaining Qty = 3000kg.
Package No.     = PK003
Lot No.             = LT003
i want to split the same item inventory into 2 different ILE with different pack and lot no. For Similarly for combine. How can i achieve this into Business central.
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 11,612 Super User 2026 Season 1 on at
    Hello,
     
    To split or combine inventory with different lot/package numbers in a Directed Put-away & Pick location, the only standard method is:
    Use Item Reclassification Journal
    Create negative & positive entries
    Assign new Lot No. and Package No.
    Post → BC creates new ILEs + warehouse entries
    This is the only supported way to split or merge inventory tracking in advanced warehouse setups.
     
    Regards,
    Oussama Sabbouh
  • Suggested answer
    Jainam M. Kothari Profile Picture
    Jainam M. Kothari 15,721 Super User 2026 Season 1 on at
    Hello,
     
    Business Central doesn’t allow direct editing of Item Ledger Entries, so to split or combine inventory with different lot and package numbers in a Directed Put/Pick location, you must use Item Reclassification Journals.
     
    These journals let you create multiple lines for the same item with different tracking details, effectively splitting or merging quantities while maintaining audit integrity.
     
    For advanced warehouse setups, ensure warehouse tracking is enabled, and if frequent splits/combines are needed, consider a custom AL solution to automate journal creation and posting.
  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 8,866 Super User 2026 Season 1 on at
    How you are doing the transaction?
    Any ledgers you wont be able to modify directly.
    We may alter some process to achieve the same, so just let us know how you are processing it.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,857 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,047 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 959 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans