Pretty surprised I haven't run into this before. We have a purchase product that is measured and used in feet. This is steel used for weldments. The inventory says we have 12 feet OH, and I need 9 feet for a job. The issue is the 12 feet is actually 4 3 foot long pieces. Is there any more granularity that can be had for inventory items such as this? something like qty 1 6 feet, qty 4 3 feet etc?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
1
Reply
291
Views
I assume you get your raw material in large volumes? We track steel coils that are 4000 feet long and used by the foot. If that's the case, I would suggest tracking it by Lot/Serial Numbers. It will let you see how much is in each lot as well as an overall total linear feet.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
|
1
Jul 21
|
3324 | ||
|
|
1
Jul 25
|
3384 | ||
|
|
2
Oct 24
|
3522 | ||
|
|
3
Nov 25
|
18115 | ||
|
Inventory adjustment error
Solved
|
|
3
Jul 22
|
7557 |
Odoo's standard inventory management lacks the granularity to track individual pieces of materials like steel with varying lengths. To address this, you can use lots/serial numbers, where each lot represents a specific length, enabling tracking of individual pieces but potentially becoming cumbersome with many pieces. Alternatively, the packages feature can track bundles of steel, useful if received in predefined bundles, but less ideal for individual piece tracking.
A simpler approach involves creating a custom field on the product form to manually update available lengths, though this lacks detailed tracking. For a tailored solution, a custom Odoo module can be developed to manage steel pieces, their lengths, and locations, offering seamless integration but requiring development effort. The best approach depends on your needs and budget, with lots/serial numbers suitable for basic tracking, packages for bundled items, and a custom module for sophisticated requirements.