Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[12.0][l10n_it_edi] Wrong Untaxed, Tax, Total calculation? #41511

Open
GSLabIt opened this issue Dec 8, 2019 · 4 comments
Open

[12.0][l10n_it_edi] Wrong Untaxed, Tax, Total calculation? #41511

GSLabIt opened this issue Dec 8, 2019 · 4 comments

Comments

@GSLabIt
Copy link

GSLabIt commented Dec 8, 2019

Impacted versions: 12.0

Importing Electronic invoice we get wrong Untaxed Amount, Tax and Total values.

Steps to reproduce:

  1. Upload attached file from Invoicing -> Bills -> UPLOAD

Current behavior:
If set Round per line, you get:
Schermata 2019-12-08 alle 11 30 07

If you set Round Globally:
Schermata 2019-12-08 alle 11 32 04

Expected behavior:
It's expected to have same value as in Electronic Invoice (validated by authority):

      <DatiGeneraliDocumento>
        <TipoDocumento>TD01</TipoDocumento>
        <Divisa>EUR</Divisa>
        <Data>2019-11-30</Data>
        <Numero>12009/A</Numero>
        <ImportoTotaleDocumento>622.60</ImportoTotaleDocumento>
        <Causale>Vendita articoli</Causale>
      </DatiGeneraliDocumento>

      <DatiRiepilogo>
        <AliquotaIVA>22.00</AliquotaIVA>
        <ImponibileImporto>510.33</ImponibileImporto>
        <Imposta>112.27</Imposta>
        <EsigibilitaIVA>I</EsigibilitaIVA>
      </DatiRiepilogo>

File to test:
IT09252150017_0FWKC.xml.zip

Any hint?

Video/Screenshot link (optional):

@GSLabIt GSLabIt changed the title [12.][l10n_it_edi] Wrong Untaxed, Tax, Total calculation? [12.0][l10n_it_edi] Wrong Untaxed, Tax, Total calculation? Dec 8, 2019
@pedrobaeza pedrobaeza added 12.0 Localization about adapting the content to a specify country (usually chart of accounts) labels Dec 8, 2019
@GSLabIt
Copy link
Author

GSLabIt commented Dec 9, 2019

@pedrobaeza i think issue could be related to tax calculation in account, rather than localization itself

@mart-e mart-e added Accounting and removed Localization about adapting the content to a specify country (usually chart of accounts) labels Mar 9, 2020
@jco-odoo
Copy link
Contributor

jco-odoo commented Mar 8, 2021

@GSLabIt The system uses the price unit and the quantity to calculate the total amounts, and if you use fuel with a lot of decimals, rounding errors will occur. Did you try adjusting the decimal precision on quantity and price?

Of course, it is easy to say that the user can adapt the correct numbers afterwards as normally you will still check the invoice imported. Maybe there is a way to import in a more stable way, but I don't see it immediately honestly.

@GSLabIt
Copy link
Author

GSLabIt commented Mar 8, 2021

@GSLabIt The system uses the price unit and the quantity to calculate the total amounts, and if you use fuel with a lot of decimals, rounding errors will occur. Did you try adjusting the decimal precision on quantity and price?

Of course, it is easy to say that the user can adapt the correct numbers afterwards as normally you will still check the invoice imported. Maybe there is a way to import in a more stable way, but I don't see it immediately honestly.

Yes, and it doesn't work properly, sometimes it works sometimes not. You also have issues with less decimal but discounts as discount is monetary instead of float. There are a lot of issues like this one need to be addressed.

So at the end of the day, you see that collaboration will be quite useful on both ways; making things auto install doesn't help to get it sorted out.

@parchanco
Copy link

Any solution or workaround for this? we are having the same issue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

5 participants