Skip to Content
Odoo Menu
  • Prihlásiť sa
  • Vyskúšajte zadarmo
  • Aplikácie
    Financie
    • Účtovníctvo
    • Fakturácia
    • Výdavky
    • Tabuľka (BI)
    • Dokumenty
    • Podpis
    Predaj
    • CRM
    • Predaj
    • POS Shop
    • POS Restaurant
    • Manažment odberu
    • Požičovňa
    Webstránky
    • Tvorca webstránok
    • eShop
    • Blog
    • Fórum
    • Živý chat
    • eLearning
    Supply Chain
    • Sklad
    • Výroba
    • Správa životného cyklu produktu
    • Nákup
    • Údržba
    • Manažment kvality
    Ľudské zdroje
    • Zamestnanci
    • Nábor zamestnancov
    • Voľné dni
    • Hodnotenia
    • Odporúčania
    • Vozový park
    Marketing
    • Marketing sociálnych sietí
    • Email marketing
    • SMS marketing
    • Eventy
    • Marketingová automatizácia
    • Prieskumy
    Služby
    • Projektové riadenie
    • Pracovné výkazy
    • Práca v teréne
    • Helpdesk
    • Plánovanie
    • Schôdzky
    Produktivita
    • Tímová komunikácia
    • Artificial Intelligence
    • IoT
    • VoIP
    • Znalosti
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Priemyselné odvetvia
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Reštaurácia
    • Fast Food
    • Guest House
    • Beverage distributor
    • Hotel
    Reality
    • Real Estate Agency
    • Architecture Firm
    • Konštrukcia
    • Property Management
    • Gardening
    • Property Owner Association
    Poradenstvo
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Výroba
    • Textile
    • Metal
    • Furnitures
    • Jedlo
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware and Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Iní
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Komunita
    Vzdelávanie
    • Tutoriály
    • Dokumentácia
    • Certifikácie
    • Školenie
    • Blog
    • Podcast
    Empower Education
    • Vzdelávací program
    • Scale Up! Business Game
    • Visit Odoo
    Softvér
    • Stiahnuť
    • Porovnanie Community a Enterprise vierzie
    • Releases
    Spolupráca
    • Github
    • Fórum
    • Eventy
    • Preklady
    • Staň sa partnerom
    • Services for Partners
    • Register your Accounting Firm
    Služby
    • Nájdite partnera
    • Nájdite účtovníka
    • Meet an advisor
    • Implementation Services
    • Zákaznícke referencie
    • Podpora
    • Upgrades
    ​Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Získajte demo
  • Cenník
  • Pomoc
You need to be registered to interact with the community.
All Posts People Badges
Tagy (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tagy (View all)
odoo accounting v14 pos v15
About this forum
Pomoc

Sales Reporting by Customer

Odoberať

Get notified when there's activity on this post

This question has been flagged
salesreportingdashboard
1 Odpoveď
4520 Zobrazenia
Avatar
Patrick Presto

I am looking for a way to see sales reporting by customer in total by the parent company instead of broken out by company contacts. 

Example:

Customer: ABC Inc.

Contact 1: Jane Doe

Contact 2: John Doe

Sales Order 1: $5,000.00 | Customer: Jane Doe, ABC Inc.

Sales Order 2: $7,500.00 | Customer: John Doe, ABC Inc.

Sales Order 3: $3,000.00 | Customer: ABC Inc.


When I have the data above in my database, anytime I look at sales reporting (either in Reporting within the Sales App or within the Dashbaord App), I see the following reporting data:

Sales History:

ABC Inc: $3,000.00

John Doe, ABC Inc: $7,500.00

Jane Doe, ABC Inc: $5,000.00


I do not mind that it separates it my contact, but I would like the parent company to show the full total of $15,500 for reporting purposes. 

The only way I have found to work around this problem is to force all SO's to be sent at the Parent Company level; but that involves another step of ensuring any relevant contacts are added as followers to that quotation/SO. Not a huge deal, but just seeing if I'm missing anything that can easily aggregate the data in total at the parent company level.

0
Avatar
Zrušiť
Avatar
Balagopal R
Best Answer

Hello,

It is possible to handle the above scenario in Odoo.

First, you need to enable the Customer Address option from Accounting > Configuration > Settings


Create the ABC Inc. as a Company in Sales > Orders > Customers


Add Jane Doe as an Invoice Address in the Contact & Addresses inside the ABC Inc. record.

Now you can create a Quotation or SO as follows:


For the Reporting, select the following Group by options


0
Avatar
Zrušiť
Kiki Klun

Can you explain how to add this group to the search bar using studio? I can't figure out how to add that option. I can add filters, but not groups in Studio.

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

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

Registrácia
Related Posts Replies Zobrazenia Aktivita
How to generate Aggregate Product Quantity Sales Report
sales reporting
Avatar
0
máj 20
4825
What is the difference between Qty Delivered, Ordered and Invoiced?
sales reporting
Avatar
Avatar
1
máj 20
22421
Pie Chart in sales dashboard ?
sales dashboard
Avatar
0
sep 17
803
Sales report (% of business sales)
sales reporting
Avatar
Avatar
3
mar 16
4464
Sales & POS Payment Report
sales pos reporting
Avatar
Avatar
Avatar
Avatar
4
máj 26
3325
Komunita
  • Tutoriály
  • Dokumentácia
  • Fórum
Open Source
  • Stiahnuť
  • Github
  • Runbot
  • Preklady
Služby
  • Odoo.sh hosting
  • Podpora
  • Vyššia verzia
  • Custom Developments
  • Vzdelávanie
  • Nájdite účtovníka
  • Nájdite partnera
  • Staň sa partnerom
O nás
  • Naša spoločnosť
  • Majetok značky
  • Kontaktujte nás
  • Pracovné ponuky
  • Eventy
  • Podcast
  • Blog
  • Zákazníci
  • Právne dokumenty • Súkromie
  • Bezpečnosť
الْعَرَبيّة 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 Svenska ภาษาไทย Türkçe українська Tiếng Việt

Odoo je sada podnikových aplikácií s otvoreným zdrojovým kódom, ktoré pokrývajú všetky potreby vašej spoločnosti: CRM, e-shop, účtovníctvo, skladové hospodárstvo, miesto predaja, projektový manažment atď.

Odoo prináša vysokú pridanú hodnotu v jednoduchom použití a súčasne plne integrovanými biznis aplikáciami.

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