Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

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
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Is there a way to create unseparable units of variable weight?

Subscribe

Get notified when there's activity on this post

This question has been flagged
configuration
2 Replies
1231 Views
Avatar
PK

Hello odooers,

We produce some granulate and fill it into big bags that we want to track. We do not fill big bags exactly 1 ton, but 1.2 tons or 0.89 tons or something like that.

We only want to sell and ship whole big bags. If a customer orders 2 tons of this granulate, we take the first two big bags and ship them. If one big bag contains 1.2 tons and the other 1.11 tons, the customer receives 2.31 tons and is invoiced for these 2.31 tons.

I know three ways to track goods in odoo:

  • serial numbers - do not work because only 1 ton is accepted, variable weight is not allowed.
  • lot numbers - do not work either because odoo takes the exact amount ordered from lots; you can manually adjust the amount taken from a lot, but you must first check the available amount before entering the number which is very cumbersome
  • packages - same behavior as for lot numbers

Ideally, we would use lot numbers (or packages) and check the option "never separate lots", which is not available in odoo.

Is there any other solution for that?

0
Avatar
Discard
Avatar
PK
Author Best Answer

Hello Ray, thank you very much for the detailed solution description. During implementation, I unexpectedly got stuck when modifying the list view of the sub-form. Added columns do not appear when leaving studio:

The studio modification does not work for the sub form as well: The "Example" label remains invisible:

Any ideas, why this is happening for this particular list view?

0
Avatar
Discard
Avatar
Ray Carnes (ray)
Best Answer

You can customize Odoo fairly easily to help manage this.

First, setup your product using a standard weight or volume Unit of Measure. In this example, we have a product Aggregate that we stock in tons. We sell 1 ton bags for $500 but the weight of each can be slightly more or less. 

By using Lots to represent a bag we can reflect each bag we have in Inventory and everyone knows roughly how many bags we have. Here we have three bags in stock, almost 3 tons:


We then sell 2 bags (2 tons) and during quoting our staff can see we have 2.98 tons in stock:


The Delivery Order associated with this Sales Order will automatically reserve all 3 lots because that's the way to get to exactly 2 tons:

You can see our customization here in the red box, a new field showing us the quantity of the Lot, and a button allowing us to replace the quantity Odoo reserves with the full quantity:


In this case, our user would simply delete the second lot and click the arrow to change the quantity of 0.05 to 1.03 (or use whatever other logic to adjust the reserved lot quantities to get close to 2 tons - in our case we get 1.99 and that's OK for us).


The Sales Order will now show we have delivered 1.99 tons and the Customer will be charged $995 when the Invoice is created.


We only needed three quick customizations:

1) a new field on the stock.move.line model (Lot Quantity)


2) a new Server Action to replace the quantity:

for stock_move_line in records:
    stock_move_line['quantity'] = stock_move_line.x_lot_qty


3) a new View to add both things to the popup view on the Delivery Order:

<field name="quantity" position="before">
    <field name="x_lot_qty"/>
    <button name="545" type="action" help="Replace Quantity" icon="fa-arrow-right" invisible="quantity == x_lot_qty"/>
</field>


Note that "545" here is the ID of the Server Action you created. 


You will probably also want to inherit and override stock.view_stock_move_line_detailed_operation_tree in addition to stock.view_stock_move_line_operation_tree (the one I have above) so the same feature is available via the List shown when clicking the Smart Button on the Delivery Order.


Note: this is a prototype, not necessarily a complete solution. If you don't have the technical skills to do this yourself, discuss your needs with an Odoo Partner or Odoo Digital Advisor. It has not been tested in all situations and may need further work before being useful for every scenario.

0
Avatar
Discard
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
¿Cómo puedo hablar con una persona de Vueling?
configuration
Avatar
0
Dec 25
3
how to add landed cost per product, such as adding Customs Tariffs fee on product and other products don't have Customs Tariffs??
configuration
Avatar
0
Dec 25
45
Installation Odoo 17 Community
configuration
Avatar
Avatar
1
Nov 25
1294
Multiple trading names under one legal entity
configuration
Avatar
0
Nov 25
45
Odoo Lot Location Missing After Partial Stock Move
configuration
Avatar
0
Nov 25
3
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now