Skip to Content
Odoo Menu
  • Prijavi
  • Try it free
  • Aplikacije
    Finance
    • Knjigovodstvo
    • Obračun
    • Stroški
    • Spreadsheet (BI)
    • Dokumenti
    • Podpisovanje
    Prodaja
    • CRM
    • Prodaja
    • POS Shop
    • POS Restaurant
    • Naročnine
    • Najem
    Spletne strani
    • Website Builder
    • Spletna trgovina
    • Blog
    • Forum
    • Pogovor v živo
    • eUčenje
    Dobavna veriga
    • Zaloga
    • Proizvodnja
    • PLM
    • Nabava
    • Vzdrževanje
    • Kakovost
    Kadri
    • Kadri
    • Kadrovanje
    • Odsotnost
    • Ocenjevanja
    • Priporočila
    • Vozni park
    Marketing
    • Družbeno Trženje
    • Email Marketing
    • SMS Marketing
    • Dogodki
    • Avtomatizacija trženja
    • Ankete
    Storitve
    • Projekt
    • Časovnice
    • Storitve na terenu
    • Služba za pomoč
    • Načrtovanje
    • Termini
    Produktivnost
    • Razprave
    • Odobritve
    • IoT
    • Voip
    • Znanje
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industrije
    Trgovina na drobno
    • Book Store
    • Trgovina z oblačili
    • Trgovina s pohištvom
    • Grocery Store
    • Trgovina s strojno opremo računalnikov
    • Trgovina z igračami
    Food & Hospitality
    • Bar and Pub
    • Restavracija
    • Hitra hrana
    • Guest House
    • Beverage Distributor
    • Hotel
    Nepremičnine
    • Real Estate Agency
    • Arhitekturno podjetje
    • Gradbeništvo
    • Estate Management
    • Vrtnarjenje
    • Združenje lastnikov nepremičnin
    Svetovanje
    • Računovodsko podjetje
    • Odoo Partner
    • Marketinška agencija
    • Law firm
    • Pridobivanje talentov
    • Audit & Certification
    Proizvodnja
    • Tekstil
    • Metal
    • Pohištvo
    • Hrana
    • Brewery
    • Poslovna darila
    Health & Fitness
    • Športni klub
    • Trgovina z očali
    • Fitnes center
    • Wellness Practitioners
    • Lekarna
    • Frizerski salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Sistemi sončne energije
    • Izdelovalec čevljev
    • Čistilne storitve
    • HVAC Services
    Ostali
    • Neprofitna organizacija
    • Agencija za okolje
    • Najem oglasnih panojev
    • Fotografija
    • Najem koles
    • Prodajalec programske opreme
    Browse all Industries
  • Skupnost
    Learn
    • Tutorials
    • Dokumentacija
    • Certifikati
    • Šolanje
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Prenesi
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Dogodki
    • Prevodi
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Sklici kupca
    • Podpora
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Določanje cen
  • Pomoč

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

  • CRM
  • e-Commerce
  • Knjigovodstvo
  • Zaloga
  • PoS
  • Projekt
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
Pomoč

How to get the cost of products on analytic account?

Naroči se

Get notified when there's activity on this post

This question has been flagged
analytic
5 Odgovori
8732 Prikazi
Avatar
Endian Solutions B.V.

I have created an analytic account for an installation project. The analytic account of the sale order with all products and fixed hours are reflected on invoice and become income on the analytic account. This is perfect.

For the spend hours the employees enter their time sheet and this is added as cost on the analytic account. Also perfect.

But...The products come from stock. So we can't connect the analytic account to the purchase of the products.

So how to get the cost of the products to the analytic account? Is there a way to make 2 analytic entries on sale invoice? 1 for the income=qtysale price and 1 for cost=qtycost price?

0
Avatar
Opusti
Endian Solutions B.V.
Avtor

Anyone an idea?

Avatar
matt crouch
Best Answer

There is no way in stock Odoo to do this, at least not that I could find. However,  we can create a solution.

My solution was to add on to my existing (custom) accounting module. It was quite some hassle to figure out the best way to do this, but I managed a solution, although I am not sure if it is elegant.

Background:

Journal Entries are created in the accounting account (distinct from an analytic account) by the system for outgoing stock moves for delivery orders (in the default setup, anyway). Each of these journal entries can optionally have an associated analytic _distribution_. In turn, this distribution can be associated with a specific analytic account (Ugh).

I have modified the python method used to create these such that the accounting entry will inherit the analytic account from the sale order (if one is specified). In addition, I have a procedure for automatically creating analytic Distributions linked to the appropriate analytic accounts at the level of a job (in my instance, we use Opportunities). If you do not have the ability to create a custom module, you can also perform the same functionality by creating an automated action triggered on creation.

Note that it is also possible to set an analytic account by default for each product sold - so, for example, a purchase of an 'Airfare' product would automatically be appended to an 'Airfare' analytic account. This might conflict with any automated rule, so a custom module is the best option.

I consider the lack of this feature in stock Odoo to be a pretty big gaping hole. I imagine most people don't use the analytics, then, or most companies that use them are service companies. O I missing something big (very very possible, but I couldnt figure out a better way in the existing codebase after some searching... :( )

Sorry, looks like I cant post screenshots, but I'll make a post to the OCA, and anyone interested in this in more detail can contact me privately.

0
Avatar
Opusti
Avatar
Endian Solutions B.V.
Avtor Best Answer

Anyone, please?

0
Avatar
Opusti
Avatar
Igor MF
Best Answer

Same question here! Anyone?

0
Avatar
Opusti
Avatar
francis hwenha
Best Answer

same question here , but am thinking the only was is to run a custom report thats the only solution


0
Avatar
Opusti
Avatar
Claudio Candito
Best Answer

Hi, 

a custom solution is necessary. Please pay attention to do not post cost twice, i.e. at consumption and at vendor invoice posting. Unfortunately in odoo it is possible to buy a storage item on stock by entering an analytic account also. therefore we have the item on stock and its analytic cost posted also.

Regards

Claudio Candito

0
Avatar
Opusti
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Prijavi
Related Posts Odgovori Prikazi Aktivnost
Replacing the analytic fields with Sales Order number
analytic
Avatar
0
apr. 24
2046
Analytic Account Distribution Process
analytic
Avatar
0
feb. 23
4551
multiple analytic plans
analytic
Avatar
Avatar
2
jan. 16
13552
How I can register a payment of selling invoice in an analytical account
analytic
Avatar
0
mar. 15
3807
How-to use Multi-currency in Analytic Accounts
analytic
Avatar
1
jun. 24
6591
Community
  • Tutorials
  • Dokumentacija
  • Forum
Open Source
  • Prenesi
  • Github
  • Runbot
  • Prevodi
Services
  • Odoo.sh Hosting
  • Podpora
  • Nadgradnja
  • Custom Developments
  • Izobraževanje
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Sredstva blagovne znamke
  • Kontakt
  • Zaposlitve
  • Dogodki
  • Podcast
  • Blog
  • Stranke
  • Pravno • Zasebnost
  • Varnost
الْعَرَبيّة 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