Potential data corruption when transaction fails after prepare and before complete documents

Description

In several projects I have noticed sporadically the presence of strange records - is notorious mostly on Invoices that have a C_DocTypeTarget_ID>0 and C_DocType_ID=0.

These records would be discoverable with the queries:
select * from c_invoice where processed='Y' and c_doctype_id<=0 and docstatus in ('CO','CL') order by 1 desc;

NOTE that the invoices hit with this problem cannot be reversed, and also not shown in Payment Allocation.

Regards,

Carlos Ruiz

Environment

None

Activity

Anton Mostovenko 
August 20, 2018 at 2:54 PM

Now I understand it. Sorry.

Anton Mostovenko 
August 20, 2018 at 1:58 PM

Hi, Carlos!
Can you give any details about commit you did for solving this issue, please?
How does it help? Looks pointless from my point of view.

Fixed

Details

Assignee

Reporter

Priority

Created September 27, 2016 at 8:57 PM
Updated August 20, 2018 at 2:54 PM
Resolved September 27, 2016 at 8:59 PM