We are in the metal industry and produce a certain number of product profiles. The profiles can be any custom length. We are looking for a Odoo solution where we can enter the product unit quantity and the custom length. Odoo would then keep track of the two quantities to manage raw material orders, production tickets, and ship tickets.
Example:
Name : Unit Quantity x Length = Total Quantity
Product-A: 20 units x 10.375 Feet = 207.50 Feet
We would need to order 207.5 feet of raw material
We would need to produce 20 components at 10.375 Feet each
We do not want to create a database of every possible length, but instead only have a database of 10 profiles that we can select from and in our sales order, select a profile, enter quantity and custom length. Then go to next line and do the same. For products that do not require a length, then the default value would be "1".
Thank you for your help.
Geoff
have you checked MRP module ?
We have tried many different scenarios with the MRP module, but it does not seem to exactly support our needs.
Image you are building a house. You may only need two types of studs, but have many quantities at various lengths.
We want to allow people to enter order from eCommerce or allow staff to import a .CSV file into a Sales Order. The information of each type, quantity, and length would carry through the entire ERP process (Sales-Invoice-PO-MO-Delivery).
Sales Order Entry would be:
Product: 2x4 Quantity: 35 pcs Length: 121 in
Product: 2x4 Quantity: 38 pcs Length: 124.75 in
........
I hope this better clarifies the goal of the module.
Geoff