0050642: Incorrect <PrezzoTotale> when a return invoice contains a discount

Description

The total price of a return invoice (see the tag <PrezzoTotale> in the XML) is incorrectly calculated when the transaction contains a discount.

Then, the validator raises an error: "PrezzoTotale non calcolato secondo le specifiche tecniche"

Find two examples attached (IT06026940012_0lfva has discount and IT06026940012_0lfv8 has NO discount).

Steps To Reproduce

-Login an italian terminal
-Do a sales invoice including a discount
-Return the previous invoiced sale
-Run the export XML process in the backoffice
-Get the XMLs generated as attachment in the Sales Invoice window
-Repeat the same process by using the same product with no discount now
-Submit both XML files in the https://www.fatturacheck.it/ [^] web validator and check that the first of the files gets the error message while the second one normally is OK

Proposed Solution

Below the current result:

<DettaglioLinee>
        <NumeroLinea>1</NumeroLinea>
        <CodiceArticolo>
          <CodiceTipo>EAN</CodiceTipo>
          <CodiceValore>0000003475614</CodiceValore>
        </CodiceArticolo>
        <Descrizione>FAROL ESQ H4 VALEO</Descrizione>
        <Quantita>1.00</Quantita>
        <PrezzoUnitario>44.60</PrezzoUnitario>
        <ScontoMaggiorazione>
          <Tipo>SC</Tipo>
          <Importo>7.00</Importo>
        </ScontoMaggiorazione>
        <PrezzoTotale>51.60</PrezzoTotale>
        <AliquotaIVA>22.00</AliquotaIVA>
        <AltriDatiGestionali>
          <TipoDato>SCONTRINO</TipoDato>
        </AltriDatiGestionali>
      </DettaglioLinee>

Below the expected result:

<DettaglioLinee>
        <NumeroLinea>1</NumeroLinea>
        <CodiceArticolo>
          <CodiceTipo>EAN</CodiceTipo>
          <CodiceValore>0000003475614</CodiceValore>
        </CodiceArticolo>
        <Descrizione>FAROL ESQ H4 VALEO</Descrizione>
        <Quantita>1.00</Quantita>
        <PrezzoUnitario>51.60</PrezzoUnitario>
        <ScontoMaggiorazione>
          <Tipo>SC</Tipo>
          <Importo>7.00</Importo>
        </ScontoMaggiorazione>
        <PrezzoTotale>51.60</PrezzoTotale>
        <AliquotaIVA>22.00</AliquotaIVA>
        <AltriDatiGestionali>
          <TipoDato>SCONTRINO</TipoDato>
        </AltriDatiGestionali>
      </DettaglioLinee>

The <PrezzoUnitario> must be:
[c_invoice.c_invoiceLine.PriceActual] + [c_invoice.c_invoiceLine.c_InvoiceLine_Offer.Amtoffer]

Tags

No tags attached.

Attached Files

IT06026940012_0lfva.xml [^] (2,948 bytes) 2022-10-26 10:15

IT06026940012_0lfv8.xml [^] (2,948 bytes) 2022-10-26 10:16

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0051030

closed

jetxarri

Incorrect <Importo> when more than one unit per line

Notes
(0142630) hgbot (developer) 2022-10-27 07:31	Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.localization.italy.einvoice/-/merge_requests/22 [^]

(0142635) hgbot (developer) 2022-10-27 10:58	Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.localization.italy.einvoice [^] Changeset: 0e9b7fa2d20cb1b6d09bf953863bfc7ddd74d6ce Author: Javier <javieretxarri@ekinbe.com> Date: 27-10-2022 08:58:19 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.localization.italy.einvoice/-/commit/0e9b7fa2d20cb1b6d09bf953863bfc7ddd74d6ce [^] Fixes ISSUE-50642: Incorrect <PrezzoTotale> when a return invoice contains a discount --- M src/org/openbravo/localization/italy/einvoice/xmlengine/document/ItalyDettaglioLinee.java ---

(0142636) hgbot (developer) 2022-10-27 10:58	Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.localization.italy.einvoice/-/merge_requests/22 [^]

Issue History
Date Modified	Username	Field	Change
2022-10-26 10:15	ucarrion	New Issue
2022-10-26 10:15	ucarrion	Assigned To	=> psanjuan
2022-10-26 10:15	ucarrion	File Added: IT06026940012_0lfva.xml
2022-10-26 10:16	ucarrion	File Added: IT06026940012_0lfv8.xml
2022-10-26 15:59	ucarrion	Proposed Solution updated
2022-10-26 16:13	psanjuan	Assigned To	psanjuan => jetxarri
2022-10-27 07:31	hgbot	Note Added: 0142630
2022-10-27 10:58	hgbot	Resolution	open => fixed
2022-10-27 10:58	hgbot	Status	new => closed
2022-10-27 10:58	hgbot	Note Added: 0142635
2022-10-27 10:58	hgbot	Note Added: 0142636
2022-11-29 12:22	ucarrion	Relationship added	related to 0051030