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

How to get the cost of products on analytic account?

Subscribe

Get notified when there's activity on this post

This question has been flagged
analytic
5 Replies
8726 Views
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
Discard
Endian Solutions B.V.
Author

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
Discard
Avatar
Endian Solutions B.V.
Author Best Answer

Anyone, please?

0
Avatar
Discard
Avatar
Igor MF
Best Answer

Same question here! Anyone?

0
Avatar
Discard
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
Discard
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
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
Replacing the analytic fields with Sales Order number
analytic
Avatar
0
Apr 24
2043
Analytic Account Distribution Process
analytic
Avatar
0
Feb 23
4539
multiple analytic plans
analytic
Avatar
Avatar
2
Jan 16
13541
How I can register a payment of selling invoice in an analytical account
analytic
Avatar
0
Mar 15
3806
How-to use Multi-currency in Analytic Accounts
analytic
Avatar
1
Jun 24
6588
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