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

Odoo16: how to add further Child Lines for every Order Line? is it workable?

Inschrijven

Ontvang een bericht wanneer er activiteit is op deze post

Deze vraag is gerapporteerd
order.linesodoo16features
2 Antwoorden
3158 Weergaven
Avatar
SmithJohn45

in Sales -> Quotation - New we can see a Master-Detail form view which contains Order Lines tab below where user can input item-wise Details, here is a requirement each item can contain more underlying data related to each item and we want to add this functionality in View to get user input after each Order Line (Item). if Order Line have 3 items then all 3 items should have own underlying data which should be related to each Line (item). --in oracle we say it master-detail-detail like: country->state->city--

is it possible in Odoo using BUG ICON on top in Developer mode? if yes how to?

i have to create a separate table OR i can add those fields in sale.order.line ? 

please help, guide or provide a link to the guide.

regards


0
Avatar
Annuleer
Avatar
Jainesh Shah(Aktiv Software)
Beste antwoord

Hello SmithJohn45,


We can't add child lines to sale order lines. We can add this extra fields to sale.order.line model or we can also create a new model. It's totally depends on your requirement. It's possible in both ways. 


We've achieve a similar functionality in past. In which, we've' added a new button to each sale order lines. This button will pop-up an form view where a user can add the extra details. We can also make system to automatically add and update the note under each sale order line to display the values configured in the extra details form. We're providing you a screenshot for better understanding. Kindly let us know if have any further questions.

I hope this will help you.
Thanks & Regards,
Email:    odoo@aktivsoftware.com     

Skype: kalpeshmaheshwari

1
Avatar
Annuleer
SmithJohn45
Auteur

thank you @Jainesh, for what you have achieve i asked for here but topic closed by me because i was unable to make a relationship with the model in popup window (form view) and nobody Answer to that topic. after reading your Answer now i thought it can be done but still as of my knowledge level i am not able to achieve what you had, if there is an example link i will be much grateful as this is very important for me. ( i am from Oracle and there is no problem creating Child of a Child in very old Oracle Forms and currently in Oracle Apex, Oracle ADF etc. you just have to have PK & FK relationship ).
thanks again.
regards

SmithJohn45
Auteur

to clear any confusion because of what i wrote, here is may be, more clearer
- i failed to create relationship with popup form view where i want an editable tree view as Child of Order Line.

regards

Jainesh Shah(Aktiv Software)

Hello @SmithJohn45,
It we'll not possible to develop this requirement from UI side. But here is the mind-map to achieve this.

1: Create a new model. In this example we'll named is 'specification.sheet'.
2: Now we need to link this model with 'sale.order.line' and to achieve this we'll extend the 'sale.order.line' model and add Many2one field named specification_sheet_id. But we also need to link the 'sale.order.line' to 'specification.sheet'. So, we'll add new Many2one field named sale_line_id.
3: Now, add a object type button in sale order line. Once we add a button in xml file we need to write the logic for this button which is as follow.

def action_open_specification_sheet(self):
"""
Used to open specification sheet pop-up.

Note:
1: If the sale line has specification_sheet_id field populated then we'll open the same record in pop-up window by using 'res_id' in action.
2: When we're using this button for newly created sale order line, We'll not have specification_sheet_id field populated. So in this case system will create a new record of 'specification.sheet' and we need to set default value of sale_line_id field for this record with the help of 'context' in action.
"""
self.ensure_one()
return {
'name': _('Specification Sheet'),
'view_mode': 'form',
'res_model': 'specification.sheet',
'res_id': self.specification_sheet_id.id,
'view_id': False,
'type': 'ir.actions.act_window',
'context': {
'default_sale_line_id': self.id,
},
'target': 'new'
}
4: After adding a button in view, We'll define a action confirm of the specification sheet's pop-up window. In which, we need to do two things.

A: We need to set specification_sheet_id field of sale order line (We can use sale_line_id field to identify the sale line).
B: We'll prepare a string which contains all the impotent information and create a note in 'sale.order.line'. We also need to link this line with 'specification.sheet'. So, in future we can easily modify the value of this line. To achieve this we can add a new field named custom_sol_note_id in 'specification.sheet'.

Feel free to reach out to us if you have any further questions.

SmithJohn45
Auteur

huge thanks @Jainesh for very detailed explaination and guidance, will check what i can achieve from it. i really impressed with your deep concern to help us.

kind regards

Avatar
Syed Muneeb
Beste antwoord

Each line that you create in an order is saved in the database in the model 'sale.order.line' you can create its own view and add more details by creating more fields in the model.

0
Avatar
Annuleer
SmithJohn45
Auteur

thanks, but what i asked is another question. is it possible, if yes, how to?

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
DeprecationWarning: The longpolling-port is a deprecated alias to the gevent-port option, please use the latter Opgelost
odoo16features
Avatar
Avatar
Avatar
Avatar
Avatar
5
sep. 25
24611
How to Add wizard under print button inside the form view.
odoo16features
Avatar
Avatar
Avatar
Avatar
3
aug. 25
3756
How to add @api.onchange in _get_view() method odoo 16
odoo16features
Avatar
Avatar
1
mei 25
3660
get all partners which are internal users or portal users odoo16
odoo16features
Avatar
Avatar
1
apr. 25
4506
How to add decoration color green with bold to a record with a single conditon
odoo16features
Avatar
Avatar
1
apr. 25
5356
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