Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

1

Automatically generate invoices

By
Robin Dierckx
on 7/1/16, 12:17 PM 378 views

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 !

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

Ermin Trevisan
on 7/2/16, 2:24 AM

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

Robin Dierckx
on 7/5/16, 4:20 AM
1
Dilip Dabhi
On 7/2/16, 3:52 AM

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.


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?

Robin Dierckx
on 7/5/16, 4:45 AM
0
Robin Dierckx
On 7/5/16, 4:16 AM

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

 

0

Fabien Pinckaers (fp)

--Fabien Pinckaers (fp)--
6598
| 6 8 8
fsdsdfsdf, Belgium
--Fabien Pinckaers (fp)--

Odoo Founder & CEO

Fabien Pinckaers (fp)
On 7/2/16, 10:06 AM

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.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 7/1/16, 12:17 PM
Seen: 378 times
Last updated: 7/5/16, 4:16 AM