Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0002033Openbravo ERP00. Application dictionarypublic2007-10-03 10:402008-06-12 09:43
alostale 
alostale 
normalminoralways
closedfixed 
5
 
2.35 
No
Core
No
0002033: Not possible to have a tax twice in a invoice (bad PK)
Env.: r2.34
Primary key for C_InvoiceTax table didn't enter correctly in the version. Notice that it's correct in the development DB. It is the old one with two fields.

This makes impossible to have a invoice tax twice in the same invoice, which now should be possible for not recalculated taxes.


Work arround:
Execute this script:

alter table C_INVOICETAX drop constraint C_INVOICETAX_KEY;
DROP INDEX C_INVOICETAX_KEY;
alter table c_invoicetax add CONSTRAINT C_INVOICETAX_KEY PRIMARY KEY (C_INVOICETAX_ID);
No tags attached.
Issue History

Notes
(0005622)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1806784 [^]
(0002272)
rafaroda   
2007-10-24 17:30   
(edited on: 2008-06-12 09:22)
Logged In: YES
user_id=1892190
Originator: NO

Verification assigned to rafaroda.