Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
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
Nav2009 W1 LS Retail Classic Client.
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?
Nav, T-SQL.
: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.
Nav, T-SQL.