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

Notifications

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 5,798 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,639 Super User 2025 Season 2 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,602 Super User 2025 Season 2 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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,064

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,568 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,063 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans