Create Invoice from Sales Order via xmlrpc

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

CRM
e-Commerce
Księgowość
Zapasy
PoS
Project
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

Create Invoice from Sales Order via xmlrpc

invoice xmlrpc sales.order

2 Odpowiedzi

5246 Widoki

Friedrich

I created sale order in odoo 15:

custom_sale_order_id = models.execute_kw(db,uid, password,'sale.order', 'create',

[{

'company_id': int(custom_company_id),

'create_date': custom_actual_date,

'create_uid': custom_create_uid,

'currency_id': custom_currency_id,

'date_order': custom_actual_date,

'partner_id': custom_partner_id,

'payment_term_id': int(custom_payment_term_id),

'pricelist_id': int(custom_pricelist_id),

'team_id': int(custom_crm_team),

'state': custom_sale_order_state,

'invoice_status': custom_sale_order_invoice_status,

'warehouse_id': custom_warehouse_id,

}])

and

custom_sale_order_line_id = models.execute_kw(db,uid, password,'sale.order.line', 'create',

[{

'create_date': custom_actual_date,

'create_uid': custom_create_uid,

'currency_id': custom_currency_id,

'order_partner_id': custom_partner_id,

'product_id': custom_product_id,

'product_uom': int(custom_product_uom),

'product_uom_qty': custom_product_qty,

'qty_delivered': custom_product_qty,

'order_id': custom_sale_order_id,

'state': custom_sale_order_state,

'invoice_status': custom_sale_order_invoice_status,

}])

I’m struggling to automatically create the corresponding invoice to that sales order via xmlrpc. From sale order there is no method to create invoices.

Amr Abd-Alkrim (FireBits)

There is 2 options to do it:

1) Call the same method that Odoo uses when you press the "Create Invoice" Button on and already created sales order. (Recommend)

2) Insert the data manually through the 'env' object in 'self' (You will have to do everything by your own throw a method in your model and call it from a button)

move_dict = {
    'narration': "Name",
    'ref': name,
    'journal_id': journal_id.id,
    'date': date,
}
line_ids = []

debit_line = {
    'name': "Name",
    'partner_id': partner_id.id,
    'account_id': debit_account_id.id,
    'journal_id': journal_id.id,
    'date': date,
    'debit': round(amount if amount > 0.0 else -amount),
    'credit': 0.0,
    'analytic_account_id': analytic_account_id,
    'tax_line_id': tax_account_id,
}

credit_line = {
    'name': "Name",
    'partner_id': partner_id.id,
    'account_id': credit_account_id.id,
    'journal_id': journal_id.id,
    'date': date,
    'debit': 0.0,
    'credit': round(amount if amount > 0.0 else -amount),
    'analytic_account_id': analytic_account_id.id,
    'tax_line_id': tax_account_id.id,
}

line_ids.append(debit_line)
line_ids.append(credit_line)
move_dict['line_ids'] = line_ids
move = self.env['account.move'].create(move_dict)
move.post()

Happy to help :) an upvote will be awesome

Cédric ATANANE

I encountered the same issue, and here's my solution.

I understand that you want to achieve the equivalent of the following code using the XML-RPC API:

payment = self.env ["sale.advance.payment.inv"].create ({})
payment.with_context (active_ids = sale_id).create_invoices ()

1) Creating the payment:
payment = models.execute_kw(db, uid, password, 'sale.advance.payment.inv', 'create', [{
    'advance_payment_method': 'delivered',
    'create_uid': custom_create_uid,
    'currency_id': int(custom_currency_id),
    'deduct_down_payments': True,
    'deposit_account_id': False,
    'fixed_amount': 0.0,
    'has_down_payments': False,
    'write_uid': custom_create_uid,
}])

2) Creating an invoice:
payment_id = 111  # Replace with the payment ID
order_id = 222  # Replace with the sale.order ID

context = {'active_ids': [order_id]}
result = models.execute_kw(db, uid, password, 'sale.advance.payment.inv', 'create_invoices', [payment_id], {'context': context})

I hope you solved your problem beforehand or that it will help other people.

Friedrich

Autor

Thanks a lot for your answer. I tried option 1, also to automatically create a reference from the invoice to the underlying sales order:

First I create a “sale_advance_payment_inv” record:

payment = models.execute_kw(db,uid, password,'sale.advance.payment.inv', 'create',

[{

'advance_payment_method': 'delivered',

'create_uid': custom_create_uid,

'currency_id': int(custom_currency_id),

'deduct_down_payments': True,

'deposit_account_id': False,

'fixed_amount': 0.0,

'has_down_payments': False,

'write_uid': custom_create_uid,

}])

Second I wanted to create an invoice from that record but it doesn’t work:

models.execute_kw(db, uid, password, 'sale.advance.payment.inv', 'create_invoices', [payment],{'context': action['context']})

I got the following error message and I´m not able to fix the error:

xmlrpc.client.Fault: ...

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Connect sales order with already confirmed invoice Rozwiązane invoice sales.order	2 gru 22	3201
Get Orders Via XML-RPC Call Odoo 11.00 xmlrpc sales.order	1 lip 18	5236
stock.invoice.onshipping object has no attribute onchange_journal_id invoice sales.order	0 cze 15	3515
merge invoice lines by product when convert from multiple sales orders invoice invoice.line sales.order	4 lut 25	7244
Modify invoice content make it disconnect with its sales order sales invoice sales.order	1 sty 25	1473

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!