Skip to Content
Menu
This question has been flagged
3 Replies
4428 Views

V.10

Here in Czech Republic the invoices have 3 dates.

  • Invoice Date

  • Payment Date

  • Tax Due Date

The third one is the date when the sale was made (as I understand right from the accountant) so it would be the Sale Confirm date.

Is there an option or a module that does this or it takes customization?

Thanks


Avatar
Discard
Best Answer

Before you start customizing, you should know what this is all about and what your accountant tries to explain to you.

This issue is about VAT and the system how tax is calculated, applied and tax returns are created and filed. All EU countries have the same VAT rules based on the EU Directives on VAT, but also most other countries with a VAT system have more or less the same rules.

The rule relevant here is about the time, when a tax position has to be posted. The relevant time for a taxable event in the case of a delivery of goods or services for example is usually the time of the delivery. This time may be different from the time of the invoice and in some cases, these two may not fall into the same tax period. The technical term for this is "time of chargeable event".

Example:

Delivery of goods: 31 August 2018
Date of Invoice: 1 September 2018
VAT Tax Period: monthly

In this case the the tax on the invoice has to be filed (and therefore is due) in the tax return for the month August and not in September.

How to handle this in Odoo?

It must be ensured that the posting (accounting) date of the journal entries of the invoice is the time of the delivery in our example, means a different accounting date (31 August) from the invoice date (1 Sept). In Odoo 8.0 you can do that in the invoice form on the tab "Other info" and there you can force the proper accounting (=tax) period.

From Odoo 9.0 on there is no accounting period anymore, so you have to set a different accounting date than the invoice date. In the community editions I can remember that this field "accounting date" was available also on the tab "Other info", but meanwhile it has disappeared. The field "date" in the model account.invoice (with the description "accounting date") was made read-only and is not displayed anymore in the form view in the "Other info" tab. Maybe somebody knows when and why this regression happened.

According to my knowledge and experience, but I'm not a developer, you should create a little module which makes this field editable and displays it again in the "Other info" tab. By default, the accounting date should be the same as the invoice date. By this I assume that the journal entries of the invoice posting are still posted on the date of the field "date" and not on the date of the field "date_invoice" of the account.invoice model.

This is the correct way to ensure that your tax accounting and filing is handled properly.

And if you are a nice guy and want to give something back to the community, please make a pull request for such a module on the OCA github repository.

Avatar
Discard
Author

This is such an exhaustive answer. Thank you so much. Actually I am a developer somewhat but I was missing the theory behind this part of the accounting. I will post again when I have a concrete solution :)

Author

Actually the field 'date' is NOT readonly in a draft state. Probably that's correct, you should set the accounting date before validating. So I just added the field to the Other info Tab. Well I'm a nice guy but not too nice so I would post the code here ;)

<record id="psfarm_account_invoice_form" model="ir.ui.view">

<field name="name">psfarm.account.invoice_form</field>

<field name="model">account.invoice</field>

<field name="inherit_id" ref="account.invoice_form"/>

<field name="arch" type="xml">

<xpath expr="//page[@name='other_info']/group/group[2]" position="inside">

<field name="date"/>

</xpath>

</field>

</record>

Best Answer

OK, so you have "Confirmation Date" in Sales Orders (field: confirmation_date). You can create a related field in the Accounting. Once you done it you can make it visible on the Invoice Form and on the Invoice Print (QWEB). 

Avatar
Discard

This answer does not solve the problem laying behind.

Related Posts Replies Views Activity
3
May 24
4142
0
Aug 23
1148
1
Jan 22
849
2
Jul 18
2473
0
Aug 17
2435