Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040167Openbravo ERP07. Sales managementpublic2019-02-06 18:132019-02-12 15:38
ReporterAtulOpenbravo 
Assigned ToAtulOpenbravo 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR19Q2 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0040167: API Change - Modify CREATEFROMORDERS, CREATEFROMINOUTS columns configuration in C_Invoice
DescriptionNOT NULL constraint not required for CREATEFROMORDERS and CREATEFROMINOUTS columns in C_Invoice, it can have null value, so no need to set default value.

Risk is low as these columns are used for button which uses Process Definition and their values either Y or N is not used.

Steps To ReproduceN/A
Proposed Solution
Additional Information
TagsApproved
Relationships
blocks defect 0040119 closed AtulOpenbravo Set two new columns in C_Invoice as nullable and do not set a default value 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-02-06 18:13AtulOpenbravoNew Issue
2019-02-06 18:13AtulOpenbravoAssigned To => Triage Finance
2019-02-06 18:13AtulOpenbravoOBNetwork customer => No
2019-02-06 18:13AtulOpenbravoModules => Core
2019-02-06 18:13AtulOpenbravoTriggers an Emergency Pack => No
2019-02-06 18:14AtulOpenbravoRelationship addedblocks 0040119
2019-02-07 00:06AtulOpenbravoAssigned ToTriage Finance => dmitry_mezentsev
2019-02-07 00:06AtulOpenbravoDescription Updatedbug_revision_view_page.php?rev_id=18295#r18295
2019-02-07 00:07AtulOpenbravoDescription Updatedbug_revision_view_page.php?rev_id=18296#r18296
2019-02-07 00:11AtulOpenbravoSummaryAPI Change: Set CREATEFROMORDERS and CREATEFROMINOUTS columns as not required in C_Invoice => API Change Modify CREATEFROMORDERS and CREATEFROMINOUTS columns in C_Invoice
2019-02-07 00:11AtulOpenbravoDescription Updatedbug_revision_view_page.php?rev_id=18297#r18297
2019-02-07 09:27AtulOpenbravoSummaryAPI Change Modify CREATEFROMORDERS and CREATEFROMINOUTS columns in C_Invoice => API Change - Modify CREATEFROMORDERS, CREATEFROMINOUTS columns configuration in C_Invoice
2019-02-11 10:28dmitry_mezentsevTag Attached: Approved
2019-02-11 10:28dmitry_mezentsevAssigned Todmitry_mezentsev => AtulOpenbravo
2019-02-11 10:35AtulOpenbravoStatusnew => scheduled
2019-02-12 13:30hgbotCheckin
2019-02-12 13:30hgbotNote Added: 0109722
2019-02-12 13:30hgbotStatusscheduled => resolved
2019-02-12 13:30hgbotResolutionopen => fixed
2019-02-12 13:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/api-checks/rev/362e37efe2352a85b8d26978e8cf1f2d8b42bd19 [^]
2019-02-12 15:37SandrahuguetNote Added: 0109736
2019-02-12 15:38SandrahuguetReview Assigned To => Sandrahuguet
2019-02-12 15:38SandrahuguetStatusresolved => closed
2019-02-12 15:38SandrahuguetFixed in Version => 3.0PR19Q2

Notes
(0109722)
hgbot   
2019-02-12 13:30   
Repository: erp/devel/api-checks
Changeset: 362e37efe2352a85b8d26978e8cf1f2d8b42bd19
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Tue Feb 12 13:16:55 2019 +0530
URL: http://code.openbravo.com/erp/devel/api-checks/rev/362e37efe2352a85b8d26978e8cf1f2d8b42bd19 [^]

Fixes Issue 0040167:API Change - Modify CREATEFROMORDERS,
CREATEFROMINOUTS columns configuration in C_Invoice

**Set required as false & no default value
**Set IsMandatory as No
**Remove check constraint for either Y or N value.

---
M model/src-db/database/model/tables/C_INVOICE.xml
M model/src-db/database/sourcedata/AD_COLUMN.xml
---
(0109736)
Sandrahuguet   
2019-02-12 15:37   
API Change PR19Q2.5 in:
http://wiki.openbravo.com/wiki/API_changes#PI [^]