Passa al contenuto
È necessario essere registrati per interagire con la community.
Tutti gli articoli Persone Badge
Etichette (Mostra tutto)
odoo accounting v14 pos v15
Sul forum
La domanda è stata contrassegnata
importcsvinvoices
4 Risposte
11953 Visualizzazioni
Avatar
Robin Dierckx

Hi there,

My company is sending hundreds of invoices a month. Clients are recurent, and on a monthly basis quantities and products are changing.

I explored the import button, managed to create a draft invoice with the following CSV (sorry for ugly formatting, i don't manage to get it right) :

account_id/id,company_id/id,currency_id/id, invoice_line_ids/account_id/id,invoice_line_ids/nameinvoice_line_ids/quantity,    invoice_line_ids/price_unit, journal_id/idpartner_id/idreference_type
__export__.account_account_156, base.main_companybase.EUR,__export__.account_account_156, Bonne Action10.69 __export__.account_journal_1, __export__.res_partner_136

none

However, I expected standard information such as taxes, invoice number, dates, payement terms, etc. would be filled in automatically (as when creating the invoice manually) but it doesn't. All those fields are empty in my draft invoice. It seems like I am not in the same workflow as when I am creating the invoice manually.

Is there a way to be in the same workflow so that odoo calculates taxes, dates, etc. automatically as it usually does ?

I am using Odoo 8 and I am new to Odoo.

Thanks !

Avatar
Abbandona
Ermin Trevisan

Sorry, this is unreadable. Please find another way to provide the information.

Robin Dierckx
Autore

I got a 403 error when trying to edit message above. Here is a better overview of the imported fields:

company_id/id base.main_company

currency_id/id base.EUR

invoice_line_ids/product_id/id __export__.product_product_2

invoice_line_ids/account_id/id __export__.account_account_156

invoice_line_ids/name Bonne Action

invoice_line_ids/quantity 1

invoice_line_ids/price_unit 0.69

partner_id/id __export__.res_partner_136

reference_type none

Avatar
Dilip Dabhi
Risposta migliore

When you create invoice manually then conform and follow below steps :

  ->  Taxes and payment terms you have to set in related customer that you have selected in invoice.

  ->  Invoice date will be set automatically when you click on validate button, it will not set automatically in draft state (means at time of creation)

  ->  Invoice Number will be set automatically when you validate invoice, for invoice number if you want to see in detail can go in  Settings -> Accounting -> eInvoicing & Payment. In that you can see Next Invoice Number (for both supplier invoice and customer invoice).   and for more detail you can go in Settings - > Sequences & Identifiers -> Sequences.


Avatar
Abbandona
Robin Dierckx
Autore

Step 1 is true when creating the invoice manually, but not when creating the invoice with csv import. Am I not importing all necessary fields for the taxes and payment terms to be filled in automatically? Or am I doing something else wrong?

Avatar
Robin Dierckx
Autore Risposta migliore

I got a 403 error when trying to edit message above. Here is a better overview of the imported fields:
 

company_id/idbase.main_company
currency_id/idbase.EUR
invoice_line_ids/product_id/id__export__.product_product_2
invoice_line_ids/account_id/id __export__.account_account_156
invoice_line_ids/nameBonne Action
invoice_line_ids/quantity1
invoice_line_ids/price_unit0.69
partner_id/id__export__.res_partner_136
reference_typenone

 

Avatar
Abbandona
Avatar
Fabien Pinckaers (fp)
Risposta migliore

Did you check the Subscription module of Odoo 9 Enterprise. It allows to manage contracts & plans and automate invoicing (as well as payments if you support credit cards).

In addition to automating billing and payments, it provides great dashboards for recurring business: mrr, churn, cltv, ...

We use this module to manage thousands of our customers with complex offers: monthly, yearly, multi-year, options, ability to switch plans, customer portal...

All you have to do is to import quantities to bill on each contract periodically.

Avatar
Abbandona
Post correlati Risposte Visualizzazioni Attività
Import Invoices - Invoice Address?
import invoices
Avatar
Avatar
Avatar
2
ott 23
4174
Disable automatic follow when importing res.partner csv
import csv
Avatar
Avatar
Avatar
3
giu 20
4989
Enable/disable import rights?
import csv
Avatar
Avatar
1
nov 18
10467
'utf8' codec can't decode byte error when importing a list of products as a CSV file Risolto
import csv
Avatar
Avatar
Avatar
Avatar
Avatar
11
feb 17
65025
Import contacts through CSV Risolto
import csv
Avatar
Avatar
2
mar 15
12117