Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023099Openbravo ERP03. Procurement managementpublic2013-02-18 11:472013-04-18 16:35
Reporterpramakrishnan 
Assigned Topramakrishnan 
PriorityhighSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS30OS VersionCommunity Appliance
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023099: API Change: Amount (or Quantity) column in breakdown tables must be mandatory
DescriptionAmount (or Quantity) column in breakdown tables must be mandatory.
Fix this for all the breakdown tables.
  - Sales/Purchase order
  - Sales/Purchase invoice
  - Goods Shipment/Receipt
  - Amortization

This API Change does not have any risk as this field is not associated with any process. Since this field already has default value, the standard operations such Insert, update, delete is also working without any errors.
Steps To Reproduce 1) Login as System Administrator
 2) Go to Purchase Order || Accounting dimension tab and change:
   - UI Pattern: Standard
   - Active: true
 3) Login as F&B International Group Admin
 4) Create a new Purchase Order header
 5) Create a new line
 6) Create a new breakdown record an realize that the amount is not mandatory
 
 1) Go to database and realize that the column is nullable
 2) Go to application dictionary an realize that the column is not mandatory
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0023086 closed pramakrishnan Amount (or Quantity) column in breakdown tables must be mandatory in database and application dictionary 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-02-18 11:47pramakrishnanNew Issue
2013-02-18 11:47pramakrishnanAssigned To => iciordia
2013-02-18 11:47pramakrishnanWeb browser => Google Chrome
2013-02-18 11:47pramakrishnanModules => Core
2013-02-18 11:47pramakrishnanTriggers an Emergency Pack => No
2013-02-18 13:15iciordiaNote Added: 0056518
2013-02-18 13:15iciordiaAssigned Toiciordia => pramakrishnan
2013-02-19 04:58pramakrishnanRelationship addedrelated to 0023086
2013-02-19 04:58pramakrishnanStatusnew => scheduled
2013-02-19 04:58pramakrishnanfix_in_branch => pi
2013-03-28 11:27pramakrishnanNote Added: 0057530
2013-04-18 09:55hgbotCheckin
2013-04-18 09:55hgbotNote Added: 0058007
2013-04-18 09:55hgbotStatusscheduled => resolved
2013-04-18 09:55hgbotResolutionopen => fixed
2013-04-18 09:55hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/api-checks/rev/d8eb74c1d36246566450ac00f8437c6a879830fa [^]
2013-04-18 10:56hgbotCheckin
2013-04-18 10:56hgbotNote Added: 0058010
2013-04-18 16:35dmiguelezNote Added: 0058023
2013-04-18 16:35dmiguelezStatusresolved => closed

Notes
(0056518)
iciordia   
2013-02-18 13:15   
Approved.

Ismael
(0057530)
pramakrishnan   
2013-03-28 11:27   
Test Plan:
1) Login as System Administrator
2) Go to Purchase Order || Accounting dimension tab and change:
   - UI Pattern: Standard
   - Active: true
3) Login as F&B International Group Admin
4) Create a new Purchase Order header
5) Create a new line
6) Create a new breakdown record an realize that the amount is mandatory
 
1) Go to database and realize that the column is not null
2) Go to application dictionary an realize that the column is mandatory
(0058007)
hgbot   
2013-04-18 09:55   
Repository: erp/devel/api-checks
Changeset: d8eb74c1d36246566450ac00f8437c6a879830fa
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Tue Feb 19 09:25:12 2013 +0530
URL: http://code.openbravo.com/erp/devel/api-checks/rev/d8eb74c1d36246566450ac00f8437c6a879830fa [^]

Fixes Issue 23099: API Change: Amount (or Quantity) column in breakdown tables must be mandatory

---
M model/src-db/database/model/tables/A_AMORTLINE_ACCTDIMENSION.xml
M model/src-db/database/model/tables/C_INVOICELINE_ACCTDIMENSION.xml
M model/src-db/database/model/tables/C_ORDERLINE_ACCTDIMENSION.xml
M model/src-db/database/model/tables/M_INOUTLINE_ACCTDIMENSION.xml
---
(0058010)
hgbot   
2013-04-18 10:56   
Repository: erp/devel/api-checks
Changeset: 5ee7409183a1c12947a016348015beaf1f2a38f6
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Thu Apr 18 10:56:48 2013 +0200
URL: http://code.openbravo.com/erp/devel/api-checks/rev/5ee7409183a1c12947a016348015beaf1f2a38f6 [^]

Related to Issue 23099. Fixes API-Checks.

---
M model/src-db/database/sourcedata/AD_COLUMN.xml
---
(0058023)
dmiguelez   
2013-04-18 16:35   
Code Review + Testing Ok