Overslaan naar inhoud
Odoo Menu
  • Aanmelden
  • Probeer het gratis
  • Apps
    Financiën
    • Boekhouding
    • Facturatie
    • Onkosten
    • Spreadsheet (BI)
    • Documenten
    • Ondertekenen
    Verkoop
    • CRM
    • Verkoop
    • Kassasysteem winkel
    • Kassasysteem Restaurant
    • Abonnementen
    • Verhuur
    Websites
    • Websitebouwer
    • E-commerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Bevoorradingsketen
    • Voorraad
    • Productie
    • PLM
    • Inkoop
    • Onderhoud
    • Kwaliteit
    Personeelsbeheer
    • Werknemers
    • Werving & Selectie
    • Verlof
    • Evaluaties
    • Aanbevelingen
    • Wagenpark
    Marketing
    • Social media Marketing
    • E-mailmarketing
    • SMS Marketing
    • Evenementen
    • Marketingautomatisering
    • Enquêtes
    Diensten
    • Project
    • Urenstaten
    • Buitendienst
    • Helpdesk
    • Planning
    • Afspraken
    Productiviteit
    • Chat
    • Goedkeuringen
    • IoT
    • VoIP
    • Kennis
    • WhatsApp
    Apps van derden Odoo Studio Odoo Cloud Platform
  • Bedrijfstakken
    Detailhandel
    • Boekhandel
    • kledingwinkel
    • Meubelzaak
    • Supermarkt
    • Bouwmarkt
    • Speelgoedwinkel
    Food & Hospitality
    • Bar en Pub
    • Restaurant
    • Fastfood
    • Gastenverblijf
    • Drankenhandelaar
    • Hotel
    Vastgoed
    • Makelaarskantoor
    • Architectenbureau
    • Bouw
    • Vastgoedbeheer
    • Tuinieren
    • Vereniging van eigenaren
    Consulting
    • Accountantskantoor
    • Odoo Partner
    • Marketingbureau
    • Advocatenkantoor
    • Talentenwerving
    • Audit & Certificering
    Productie
    • Textiel
    • Metaal
    • Meubels
    • Eten
    • Brewery
    • Relatiegeschenken
    Gezondheid & Fitness
    • Sportclub
    • Opticien
    • Fitnesscentrum
    • Wellness-medewerkers
    • Apotheek
    • Kapper
    Trades
    • Klusjesman
    • IT-hardware & support
    • Zonne-energiesystemen
    • Schoenmaker
    • Schoonmaakdiensten
    • HVAC-diensten
    Andere
    • Non-profitorganisatie
    • Milieuagentschap
    • Verhuur van Billboards
    • Fotograaf
    • Fietsleasing
    • Softwareverkoper
    Browse all Industries
  • Community
    Leren
    • Tutorials
    • Documentatie
    • Certificeringen
    • Training
    • Blog
    • Podcast
    Versterk het onderwijs
    • Onderwijs- programma
    • Scale Up! Business Game
    • Bezoek Odoo
    Download de Software
    • Downloaden
    • Vergelijk edities
    • Releases
    Werk samen
    • Github
    • Forum
    • Evenementen
    • Vertalingen
    • Word een Partner
    • Services for Partners
    • Registreer je accountantskantoor
    Diensten
    • Vind een partner
    • Vind een boekhouder
    • Een adviseur ontmoeten
    • Implementatiediensten
    • Klantreferenties
    • Ondersteuning
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Vraag een demo aan
  • Prijzen
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Boekhouding
  • Voorraad
  • PoS
  • Project
  • MRP
All apps
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Alle posts Personen Badges
Labels (Bekijk alle)
odoo accounting v14 pos v15
Over dit forum
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Alle posts Personen Badges
Labels (Bekijk alle)
odoo accounting v14 pos v15
Over dit forum
Help

Uos coefficient standard functionality

Inschrijven

Ontvang een bericht wanneer er activiteit is op deze post

Deze vraag is gerapporteerd
uosuom
1 Beantwoorden
15442 Weergaven
Avatar
Elie H. Nassif

Hi All,

Can someone help me in understanding how Uos coefficient functionality works in OpenERP v7.

2
Avatar
Annuleer
Avatar
Med Said BARA
Beste antwoord

let's say you bought two rolls of a product P (Tissue or Paper ....) (the unit of measure UoM when purchasing this product is a Roll or Unit ).

Known that, each roll is 2 meters large and 100 meters long.

Now you want to sell it with a another unit (like Meter), this is your UoS.

What you have to do, is to convert the original UoM to the new UoS before the sale.

1 Roll = 1 Unit = 100 meters, 100 is your Coefficient " Unit of Measure -> UOS Coefficient "

Now you can choose the unit meter as your UoS with a coefficient = 100, and begin selling this product in meter.

Another example is, when you purchase a Pallet of a Product B (In your Purchase invoice you get a purchase line like: Description = Product B ---- Quantity = 1 Pallet ---- Unit Price = 1000 € ---- Total Price = ......).

Known that each Palette contains 10 Boxes and each box contains 6 unit of this Product.

Now you have 60 unit of the product B to sell.

Your UoM to Uos coefficielt is 60.

Just fill the UoS and the Coefficient in your Product Form and begin selling this Product.

UoM to UoS or UoS to UoM, the UoS = UoM * Coefficient or UoM = UoS / coefficient

The long Answer

There are three parameters, which you can use:

The UoM, it's the unit of measure you specified when creating the product.

The UoS, it's the unit of sale (if any), you use for selling the product.

The UoP, it's the unit of purchase ( if any), used when purchasing the product.

Generally, UoM, UoS and UoP use the same unit of measure. But it happen that it uses different units, for the following reasons:

  • Your Supplier(s) use another unit

  • Your Customer(s) use a different unit

  • You use different units, before and after manufacturing (if you are a manufacturer)

  • You can also use different units, because of the packaging unit, and so on ...

In OpenERP those three units defaults to the unit "Unit" (also known as PCE) unless otherwise explicitly specified (e.g meter: m, Litre : L, Square meter : m², .....).

The default UoM "Unit": means 1 piece, or 1 item, or quantity = 1, of the related product. It's a generic unit of measure. It is used as UoM for products which not need to have a specific unit of measure in trading operations (e.g when selling, Hard Drive, egg, umbrella,...., we don't have to specify a unit of measure from The International System of Units).

What we should remember is:

That all those units are there as a mean of counting (quantification), and the important thing is the "Conversion Coefficient", when moving from one unit to another.

Let's take an example:

I've purchased 10 barrels of Wine, each barrel contain 500 liters.

My purchase order is labeled as follows:

  • Product: Super Wine V7.0

  • Quantity: 10

  • Unit: Barrel

  • Unit Price: 500 €

  • Taxes: 0 %

  • Total price: 5000 €

Now, i want to sell this product to my customers at 620 € the Barrel.

My first customer, needs 2 Liters (just enough for one night!).

I will sell to my customer 0.004 Barrel: 2 Liters = (1 barrel / 500) * 2 = 0.004 Barrel, keeping the same Unit of Measure (Barrel).

UoS = UoM * Coefficient

UoM = UoS / coefficient

Then i will use 500 as my Unit of Measure -> UOS Coeff

I have to fill this Coeff into the Unit of Measure -> UOS Coeff in the sales Tab of the product Form.

 

--------------------------------------------------------------

And now you can see the result on runbot:

------------------------------------------------------------

The new unit - Category

https://www.dropbox.com/s/k3o7lrw8wbhwrek/New%20Unit-%20Categ.png?dl=0

Product sale price & UoM

https://www.dropbox.com/s/iswyowq64qh9a3q/Product%20%20Price%20UoM.png?dl=0

 

Product UoS & Coeff.

https://www.dropbox.com/s/v6n6f5skn7zodjo/Product%20UoS%20Coeff.png?dl=0

 

The Purchase Order

https://www.dropbox.com/s/jnrkozcxi8n95tv/Purchase%20order.png?dl=0

The Sale Order

https://www.dropbox.com/s/ms051mhz0rgbjda/Sale%20Order.png?dl=0

Where is the difference when using or not the UoS ?

---------------------------------------------------------------------------

https://www.dropbox.com/s/ioi357n16xxwcuf/The%20Difference.png?dl=0

 

5
Avatar
Annuleer
Elie H. Nassif
Auteur

Thank you for your answer Said. I created a product A with :
- Purchasing Unit of Measure = Unit - Uos = m - Unit of Measure -> UOS Coeff = 100 Creating a sales order of 1 Product A gives : - Quantity = 1 unit - Quantity Uos = 100 m - Unit Price = 50. So on the sales order line i have product A -- quantity = 1 --Uom = unit -- unit price = 50. After posting the sales order the invoice created shows : Prodcut A -- quantity 100 -- unit price = 0.5 -- total price = 50. I am satisfied with the result,except i need the unit price to remain 50. Is this doable ??

Med Said BARA

The "Purchasing Unit of Measure" must be the UoM (the base "Unit" or "Roll"),

Med Said BARA

UoS = UoM * Coefficient or UoM = UoS / coefficient. You have to use 100 or 1/100 = 0.01 and 60 or 1/60 = 0.0167

gunnar

so sorry, I just wanted to correct a typo and it seems this has messed up the whole answer (pictures vanished).

Med Said BARA

I've re-uploaded the deleted files.

gunnar

@Said: I still don;t see any way to have a conversion between buying Barrels (UoP) and using or storing them internally as L (UoM). So as far as I see it there is missing the possibility to apply a Coefficient between purchase and internal use/storage. Do you have any solution or workaround for that?

Med Said BARA

Could you be more explicit ?

PY

That is a usefull answer !

Marcio Valenzuela

I dont see this option in Odoo v8, is it still available?

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden
Gerelateerde posts Antwoorden Weergaven Activiteit
Sell product in different unit from purchases
uos uom
Avatar
Avatar
1
jun. 23
6240
How to sell products in different units of measure?
product uos uom
Avatar
Avatar
1
aug. 17
13570
cannot change uom
uom
Avatar
Avatar
Avatar
Avatar
4
sep. 25
2946
UOM - Unique barcode and internal reference with related scanning
uom
Avatar
1
okt. 24
2596
Error 400 Uom in e-commerce in shop/payment after form of delivery adress
uom
Avatar
0
sep. 23
2127
Community
  • Tutorials
  • Documentatie
  • Forum
Open Source
  • Downloaden
  • Github
  • Runbot
  • Vertalingen
Diensten
  • Odoo.sh Hosting
  • Ondersteuning
  • Upgrade
  • Gepersonaliseerde ontwikkelingen
  • Onderwijs
  • Vind een boekhouder
  • Vind een partner
  • Word een Partner
Over ons
  • Ons bedrijf
  • Merkelementen
  • Neem contact met ons op
  • Vacatures
  • Evenementen
  • Podcast
  • Blog
  • Klanten
  • Juridisch • Privacy
  • Beveiliging
الْعَرَبيّة 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 een suite van open source zakelijke apps die aan al je bedrijfsbehoeften voldoet: CRM, E-commerce, boekhouding, inventaris, kassasysteem, projectbeheer, enz.

Odoo's unieke waardepropositie is om tegelijkertijd zeer gebruiksvriendelijk en volledig geïntegreerd te zijn.

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