Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0012310Openbravo ERP08. Project and service managementpublic2010-02-16 23:562011-09-15 23:18
aguilarc 
jonalegriaesarte 
urgentmajorunable to reproduce
closedunable to reproduce 
30Professional Appliance
2.50MP9 
 
Core
No
0012310: Error null value in column "c_tax_id" violates not-null constraint on Multiphase Project
When I try to execute the process "Create Sales Order from Project Phase" (Project & Service Management || Transactions || Multiphase Project || Multiphase Project >> Project Phase )

I have this error "Error null value in column "c_tax_id" violates not-null constraint"
1. Create a new organization, OrgA.
2. Create a new multiphase project, complete all the required data and launch the Generate Orders process (on the project phase tab).
3. A message "null value in c_tax_id column violates the not null constraint" is shown. See attach.
I don´t know how to resolved this, in the last issue (https://issues.openbravo.com/view.php?id=7820 [^]) the admin have to configure the locations for organizations correctly but in this case my locations are correct
No tags attached.
jpg Error - Sales Order Generation from Multiphase Project.jpg (167,674) 2010-02-16 23:56
https://issues.openbravo.com/file_download.php?file_id=2227&type=bug
jpg
Issue History
2010-02-16 23:56aguilarcNew Issue
2010-02-16 23:56aguilarcAssigned To => adrianromero
2010-02-16 23:56aguilarcFile Added: Error - Sales Order Generation from Multiphase Project.jpg
2010-02-24 10:59jbelizonIssue Monitored: jbelizon
2010-02-24 11:00jbelizonIssue End Monitor: jbelizon
2010-02-24 11:02jbelizonNote Added: 0024774
2010-02-24 12:50jbelizonNote Edited: 0024774bug_revision_view_page.php?bugnote_id=0024774#r67
2010-02-24 18:23jbelizonNote Added: 0024797
2010-02-24 23:32aguilarcNote Added: 0024800
2011-06-03 11:00dalsasuaAssigned Toadrianromero => dalsasua
2011-07-20 18:11dalsasuaAssigned Todalsasua => jonalegriaesarte
2011-09-15 23:18psarobeStatusnew => closed
2011-09-15 23:18psarobeResolutionopen => unable to reproduce

Notes
(0024774)
jbelizon   
2010-02-24 11:02   
(edited on: 2010-02-24 12:50)
I don´t know how to resolved this, too.

The locations are correct.
When I delete the locations, It generate order but with number reference NULL.

(0024797)
jbelizon   
2010-02-24 18:23   
It worked.

The problem was that the Localization Pack version 1.30 had TAX BUGS for Spain.

I installed the 1.42. And all ok


http://forge.openbravo.com/projects/localizationpackspain/module [^]
(0024800)
aguilarc   
2010-02-24 23:32   
ok jbelizon,

let me check,
thanks