Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
invoiceaccount.invoiceduplicate
1 Odgovori
5221 Prikazi
Avatar
Carlos DuAl
Hello,

I'm trying to multiplicate/duplicate invoices because I want to stress-test it paying simultaneously a lot of them. I can duplicate an invoice from inside the actual invoice, but since I want to have 100-200s, there must be a more efficient way than duplicating them one by one. Is there a way to do so by code?
I've tried using
invoices = call('account.invoice','search_read', [('type','ilike',"out_invoice")])
for invoice in invoices:
    call('account.invoice', 'create', invoice)
But I'm getting this error

Traceback (most recent call last):  File "/home/carlos/Odoo/odoo/custom-addons/tests/test-seq-create-course-sessions/test.py", line 30, in <module> [ ... ]  File "/usr/lib/python2.7/xmlrpclib.py", line 794, in close    raise Fault(**self._stack[0])xmlrpclib.Fault: <Fault invalid input syntax for integer: "Sales Journal - (test) (EUR)"LINE 1: ...11', '0.00', NULL, NULL, 'SAJ/2016/008', ARRAY[1, 'Sales Jou...                                                                                                                                       ^

I'm assuming the error is that I'm duplicating an invoice with a previously used id (SAJ/2016/008) . I've tried changing the id but I'm still getting the exact same mistake.
invoices = call('account.invoice','search_read', [('type','ilike',"out_invoice")])
for invoice in invoices:
  replace='SAJ/2016/010' # new Id
  invoice['internal_number']=replace
  invoice['number']=replace
  call('account.invoice', 'create', invoice) 
 Any ideas on how to multiply/duplicate invoices?

Thank you
Avatar
Opusti
Avatar
Juan
Best Answer

Try use the erppeek library



import erppeek
import functools
SERVER = 'http://localhost:8069'
DATABASE = 'DB'
USERNAME = 'admin'
PASSWORD = 'admin'
client = erppeek.Client(SERVER, DATABASE, USERNAME, PASSWORD)
invoices=client.search('account.invoice',[('type','ilike',"out_invoice")])
for i in range(len(invoices)):
 client.copy('account.invoice',invoices[i])


Avatar
Opusti
Related Posts Odgovori Prikazi Aktivnost
Duplicate Key Violates Unique Constraint "Account_Invoice_Number_Uniq"
invoice account.invoice duplicate key
Avatar
Avatar
Avatar
2
jun. 16
17181
Base Report Designer and Invoice File not working
invoice account.invoice
Avatar
Avatar
Avatar
3
mar. 15
5706
How to set default bank account for Customer on Invoices
invoice customer account.invoice
Avatar
Avatar
Avatar
3
nov. 24
5820
setting default value for account (invoice) Solved
invoice account.invoice odoo8.0
Avatar
Avatar
Avatar
3
dec. 22
6862
Best way to warn user a supplier invoice is already entered (match on supplier invoice number) Solved
invoice v7 duplicate
Avatar
1
sep. 25
9728