WMS managing one SKU that has multiple packages.

David_Singleton
Member Posts: 5,479
This seems like a fairly simple requirement, but I would like to hear other ideas on how to implement it.
The scenario is that the client purchases and sells bulky items. The item is a single SKU with an associated cost. But the item is delivered in multiple packages. Typically one item may come in 17 boxes, all differing in shape and size. The smallest might contain nuts and bolts, the largest might be a 2m x 1.5m x 0.1m box. The issue is that the boxes need to be split over multiple bins in the warehouse, but the item is bought and sold as one SKU. So pick pack place operations need to provide details of the bin where each box is stored. But only one line will be shipped to the customer.
Imagine something like an IKEA flat pack furniture scenario.
The first suggestion was BOMs, break the item into a BOM made of the packages so that you have an individual ILE for each box so it can be managed in the warehouse. But this introduces many issues, form costing and pricing through to the sheer volume of data of assembling and disassembling BOMs. Eg if an item is transferred from one warehouse to another, it would be picked as 17 lines of packages, a BOM assembled, then shipped and received, then dissembled, and placed in Bins.
Ideally we would create warehouse transactions that are not directly linked to a ILE, and one ILE would be stored in 17 biins.
Thanks in advance.
The scenario is that the client purchases and sells bulky items. The item is a single SKU with an associated cost. But the item is delivered in multiple packages. Typically one item may come in 17 boxes, all differing in shape and size. The smallest might contain nuts and bolts, the largest might be a 2m x 1.5m x 0.1m box. The issue is that the boxes need to be split over multiple bins in the warehouse, but the item is bought and sold as one SKU. So pick pack place operations need to provide details of the bin where each box is stored. But only one line will be shipped to the customer.
Imagine something like an IKEA flat pack furniture scenario.
The first suggestion was BOMs, break the item into a BOM made of the packages so that you have an individual ILE for each box so it can be managed in the warehouse. But this introduces many issues, form costing and pricing through to the sheer volume of data of assembling and disassembling BOMs. Eg if an item is transferred from one warehouse to another, it would be picked as 17 lines of packages, a BOM assembled, then shipped and received, then dissembled, and placed in Bins.
Ideally we would create warehouse transactions that are not directly linked to a ILE, and one ILE would be stored in 17 biins.
Thanks in advance.
David Singleton
0
Comments
-
FYI
Nav2009 W1 LS Retail Classic Client.David Singleton0 -
Shift+F12 I guessDavid Singleton0
-
We had this problem with telecom equipment.
There are several ways to implement this requirements, can you clarify more details:
Does any SKU contains same packages (number of packages, size, shape .. etc) for every receipt?Looking for part-time work.
Nav, T-SQL.0 -
rmv_RU wrote:Does any SKU contains same packages (number of packages, size, shape .. etc) for every receipt?
:thumbsup:
I already had the client agree that if the packages change then it becomes a new SKU with a new BOM/Package list. It would be way to complex to allow different packages for the same SKU.David Singleton0 -
It seems strange, but try to disassemble BOMs in ItemTrackingMgt.SplitWhseJnlLine function first, it ensure you that there are no way to post the SKU in the warehouse ledger entry without disassembling . Next step is modifing picking routine.Looking for part-time work.
Nav, T-SQL.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions