0044286: "Correct duplicate invoice error (background)" process doesn't populate field em_aeatsii_insiidate in C_Invoice table

Description

When an invoice is registered successfully in the SII, then the SII_Status is set to "CO" and the em_aeatsii_insiidate db field is populated.
If an error ocurrs during the process that sends the invoices to the SII (i.e. connectivity lost), then when you try to register the same invoices again, the SII system response with a "Duplicated invoice" error.

To resolve this, you need to run the process "Correct duplicate invoice error (background)", which sets the status to "CO".
However, this process doesn't set the correct date to the em_aeatsii_insiidate db field, producing incomplete data if the field is used for reports.

Steps To Reproduce

- Generate an invoice that has to be sent to the SII.
- Start the process to send the pending invoices to the SII.
- In the middle of the process, disable the internet connection.
- Check that the invoice hasn't changed status.
- Try to send the invoice manually.
- Check that the SII respond with "Duplicated invoice" message.
- Run the "Correct duplicate invoice error (background)" process.
- Check that the invoice changed status.
- Check that the em_aeatsii_insiidate date hasn't been populated.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0122932) Mery Anelo (developer) 2020-09-11 03:50	We have not been able to reproduce with the indicated steps. Could you specify what kind of invoices this problem has (sales or purchase)? Could you give us examples of this (Failed invoices) and if there was any failure in the SII registration process that day? Be as specific as possible with the steps to reproduce the problem.

Issue History
Date Modified	Username	Field	Change
2020-06-04 14:47	etarajano	New Issue
2020-06-04 14:47	etarajano	Assigned To	=> Jorge Bravo
2020-06-04 14:51	Jorge Bravo	Assigned To	Jorge Bravo => Mery Anelo
2020-09-11 03:50	Mery Anelo	Note Added: 0122932
2020-09-11 03:50	Mery Anelo	Status	new => acknowledged
2020-10-28 08:22	Jorge Bravo	Status	acknowledged => scheduled
2020-10-28 08:22	Jorge Bravo	Status	scheduled => resolved
2020-10-28 08:22	Jorge Bravo	Resolution	open => fixed
2020-10-28 08:22	Jorge Bravo	Status	resolved => closed