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
    • Sociale 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

Create an invoice from a sales order using XML-RPC (Python)

Inschrijven

Ontvang een bericht wanneer er activiteit is op deze post

Deze vraag is gerapporteerd
many2manysales.orderjournal_entry
2 Antwoorden
9921 Weergaven
Avatar
Ahmad S

Hi, I'm following the external APIs documentation : https://www.odoo.com/documentation/13.0/webservices/odoo.html

to implement our companies requirements. I'm required to create a sales order and automatically create an invoice after that. The sales order part is done but I cant seem to be able to attach the Invoice to the Sales order

I've tried linking it via the 'invoice_ids' field but the documentation does not mention how to provide a many2many field in it. here is the code:


    many2manyInvoice =  [(4, invoice_id)]   

    common = xmlrpc.client.ServerProxy('{}/xmlrpc/2/common'.format(url))
    print(common)

    #Admin user Id
    uid = common.authenticate(db, username, password, {})
    
    models = xmlrpc.client.ServerProxy('{}/xmlrpc/2/object'.format(url))

    models.execute_kw(db, uid, password, 'sale.order', 'write', [[sales_order_id],     {'invoice_ids':many2manyInvoice}])


The response returned is 200 , but nothing is happening on the sales order level. I think its the way. I think its the way that I defined the field that might be incorrect.

Can someone help with this issue ? Thanks in advance




0
Avatar
Annuleer
Avatar
Aditya Irri
Beste antwoord

This might help you

@app.route('/createInvoice', methods=['POST'])
def createInvoice():
    try:
        models = xmlrpc.client.ServerProxy('{}/xmlrpc/2/object'.format(url))
        data = request.get_json()
        if not data:
            return jsonify({'message': 'No data received.'}), 400
        
        sale_order_id = int(data.get('sale_order_id'))
        product_id = int(data.get('product_variant_id'))
        
        if not sale_order_id or not product_id:
            return jsonify({'message': 'Invalid input data.'}), 400
        
        # Fetch data related to the sale order
        sale_order_data = models.execute_kw(db, uid, password, 'sale.order', 'read', 
                                            [sale_order_id], 
                                            {'fields': ['partner_id', 'invoice_status', 'name', 'order_line', 'picking_ids']})
        
        if not sale_order_data:
            return jsonify({'message': 'Sale order not found.'}), 404
        
        invoice_id = None
        
        # Iterate through each picking related to the sale order
        for picking_line in sale_order_data[0].get('picking_ids', []):
            picking_line_data = models.execute_kw(db, uid, password, 'stock.picking', 'search_read', 
                                                [[['id', '=', int(picking_line)],['product_id','=', int(product_id)]]], {})
            # If picking data is found
            if picking_line_data:
                stock_picking_validate = models.execute_kw(db, uid, password, 'stock.picking', 'button_validate', [[picking_line]])
        
        # Iterate through each line of the sale order
        for lineId in sale_order_data[0].get('order_line', []):
            sale_order_line = models.execute_kw(db, uid, password, 'sale.order.line', 'search_read', 
                                                [[["id", "=", lineId],['product_id','=', product_id]]], {})
            if sale_order_line:
                # Generate invoice for the sale order line
                current_date = datetime.now().strftime('%Y-%m-%d')
                context = {
                    'move_type': 'out_invoice',
                    'partner_id': sale_order_data[0]['partner_id'][0],
                    'invoice_origin': sale_order_data[0]['name'],
                    'invoice_date': current_date,
                    'partner_bank_id': 164, #Keep your bank ID
                    'l10n_in_gst_treatment': 'consumer', #Keep your GST treatment (Consumer or Supplier)
                    'ref': '',
                    'l10n_in_type_id': 1, #Eway Bill Document type - ID
                    'l10n_in_mode': '1', #Mode Of Transport - ID
                    'l10n_in_distance': 11, #Distance travelled by vehicle
                    'l10n_in_vehicle_type': 'R', #Vehicle Type - Char
                    'l10n_in_vehicle_no': 'AP00AA0000' #Vehicle Number - Char
                }
                # Create invoice in the system
                invoice_id = models.execute_kw(db, uid, password, 'account.move', 'create', [context])
                invoice_lines = []
                # Populate invoice lines
                for lineId in sale_order_data[0].get('order_line', []):
                    sale_order_line = models.execute_kw(db, uid, password, 'sale.order.line', 'read', [lineId], {})
                    invoice_lines.append((0, 0, {
                        'move_id': int(invoice_id),
                        'product_id': int(sale_order_line[0]['product_id'][0]),
                        'quantity': float(sale_order_line[0]['product_uom_qty']),
                        'price_unit': float(sale_order_line[0]['price_unit']),
                        'name': sale_order_line[0]['name']
                    }))
                # Write invoice lines to the invoice
                models.execute_kw(db, uid, password, 'account.move', 'write', [invoice_id, {'invoice_line_ids': invoice_lines}])
                # Post the invoice
                models.execute_kw(db, uid, password, 'account.move', 'action_post', [invoice_id])
                # Find the invoice line ID
                inv_line_id = models.execute_kw(db, uid, password, 'account.move.line', 'search', 
                                                 [[['product_id', '=', sale_order_line[0]['product_id'][0]], 
                                                   ['move_id', '=', invoice_id], 
                                                   ['quantity', '=', sale_order_line[0]['product_uom_qty']]]])
                # Update sale order line with invoice line and invoice status
                models.execute_kw(db, uid, password, 'sale.order.line', 'write', 
                                  [lineId, {'invoice_lines': [(4, inv_line_id[0])], 'invoice_status': 'invoiced'}])
                # Update sale order with invoice ID and invoice status
                models.execute_kw(db, uid, password, 'sale.order', 'write', 
                                  [[sale_order_id], {'invoice_ids': [(4, invoice_id)], 'invoice_status': 'invoiced'}])
                # Return response based on whether invoice was created or not
                if invoice_id:
                    return jsonify({'invoice_id': invoice_id, 'message':'Invoice created successfully.'}), 200
                else:
                    return jsonify({'message': 'No invoice created for the given conditions.'}), 200
        
        # If no invoice was created
        return jsonify({'message': 'No invoice created.'}), 404
        
    except Exception as e:
        print(f"An error occurred: {e}")
        return jsonify({'message': 'An error occurred while processing the request.'}), 500


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

Hi Ahmad,

invoice_id = 279777

sale_id = 16


sale_id = models.execute_kw(db, uid, password, 'sale.order', 'search_read', [[

['id', '=', 16]]], {'fields': ['order_line']})



for line in sale_id[0]['order_line']:


sale_line_id = models.execute_kw(db, uid, password, 'sale.order.line', 'search_read', [[

['id', '=', line]]], {'fields': ['product_template_id', 'product_uom_qty']})


product_id = models.execute_kw(db, uid, password, 'product.product', 'search', [[

['product_tmpl_id', '=', sale_line_id[0]['product_template_id'][0]]]])


inv_line_id = models.execute_kw(db, uid, password, 'account.move.line', 'search', [[

['product_id', '=', product_id[0]], 

['move_id', '=', 279777], 

['quantity', '=', sale_line_id[0]['product_uom_qty']]]])

if inv_line_id:

models.execute_kw(db, uid, password, 'sale.order.line', 'write', [line,

{'invoice_lines':[(4, inv_line_id[0])]}])

Regards,




Email:      odoo@aktivsoftware.com  

Skype: kalpeshmaheshwari

   

0
Avatar
Annuleer
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
Adding Multiple products in Sales order line?
many2many sales.order
Avatar
2
dec. 18
10442
(((Oficial~ C.O.P.A!@!Ecuador)))¿Cómo puedo llamar a Copa Airlines desde Ecuador?
sales.order
Avatar
0
dec. 25
43
Best Way To Journal Employee Capital Investment
journal_entry
Avatar
Avatar
Avatar
2
jul. 25
2307
Transform Quotations to sales orders or invoices in a bulk action
sales.order
Avatar
Avatar
Avatar
3
feb. 25
3523
Orden de venta borrada por error
sales.order
Avatar
Avatar
1
dec. 24
2944
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