Actions
ClientProject #3723
open[TAM TRADING FZ LLC] - Product, Packaging & UoM Model Setup in Odoo
Status:
In Progress
Priority:
High
Assignee:
Target version:
Start date:
11/25/2025
Due date:
% Done:
20%
Estimated time:
6:00 h
Description
Goal / Story:
As TAM SCM, I want a correct product + packaging + UoM structure so that purchasing, stock, bagging, FEFO, and HS-code-based compliance can work correctly across all chemicals.
Key points:
- Multiple packaging types per product (jumbo bags, 25kg bags, gallons, fiberglass rolls) and custom packing per customer
- Bulk → bags conversion, with standard loss % to be tracked at bagging & delivery
- Need UoM conversion MT → bags → pallets and packaging compatibility rules (e.g. soda ash → jumbo / 25kg)
- Batch/lot & FEFO based on expiry; HS code per material
Tech Tasks:
- Configure Units of Measure:
-
- Base UoM: MT.
-
- Secondary UoM categories for bags, jumbo bags, pallets, etc.
-
- Define conversion ratios (e.g. X bags per MT, Y MT per pallet).
- Extend Product Template:
-
- Enable Lots/Expiration tracking where required.
-
- Fields for HS Code, standard loss %, packaging type(s) allowed.
-
- Flag for FEFO applicable.
- Create Packaging Master:
-
- Define “Packaging Type” master (Jumbo, 25kg, Gallon, Roll, etc.).
-
- Many2many relation: Product ↔ Allowed Packaging Types.
- Add Customer-specific packaging option:
-
- On Sales Order line: packaging type selection limited by product rules, but override allowed when needed (configurable).
Acceptance Criteria:
- User can create Soda Ash product with:
-
- HS code, FEFO enabled, expiry duration.
-
- Allowed packagings: Jumbo, 25kg.
-
- UoM conversion from MT → bags visible & working in a test SO/PO.
- System prevents selecting an invalid packaging for a product unless explicitly overridden by an admin.
- Test scenario: 1 MT → correct number of bags / pallets shown on documents.
Actions