Zum Inhalt springen
Menü
Sie müssen registriert sein, um mit der Community zu interagieren.
Diese Frage wurde gekennzeichnet
3 Antworten
1624 Ansichten

Hello, after importing a list of quotations from an Excel sheet to assign the corresponding price list, I need to convert these bulk entries into sales orders or directly into invoices.

The problem is that it is not possible to convert quotations directly into sales orders. Is there any solution to this issue?

Avatar
Verwerfen
Autor Beste Antwort

Thank you 

Avatar
Verwerfen
Beste Antwort

HI,
Either by studio or using server action, you can add the option to multi confirm from the list view to confirm all the quotation at once.

See:  https://www.youtube.com/watch?v=_E-lxkawlbs

Thanks

Avatar
Verwerfen
Beste Antwort

Hello,


To update a quotation to a sale order, you need to execute the following SQL query:

UPDATE sale_order SET state = 'done' WHERE id IN (...);

To create an invoice, you should implement a function like this:

sale_orders = self.env['sale.order'].search([('invoice_status', '=', 'to_invoice')])  

for order in sale_orders:  

    order.action_post()  


Avatar
Verwerfen
Verknüpfte Beiträge Antworten Ansichten Aktivität
1
Dez. 24
1826
2
März 24
2173
2
März 24
2698
0
Sept. 23
1326
1
Sept. 23
1346