Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023086Openbravo ERP09. Financial managementpublic2013-02-15 13:292013-04-19 12:53
Reportermirurita 
Assigned Topramakrishnan 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023086: Amount (or Quantity) column in breakdown tables must be mandatory in database and application dictionary
DescriptionAmount (or Quantity) column in breakdown tables must be mandatory in database and application dictionary

See attached screenshot.

Fix this for all the breakdown tables.
 - Sales/Purchase order
 - Sales/Purchase invoice
 - Goods Shipment/Receipt
 - ...
Steps To Reproduce1) 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
7) See attached screenshot.

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 0023099 closed pramakrishnan API Change: Amount (or Quantity) column in breakdown tables must be mandatory 
Attached Filespng Screenshot from 2013-02-15 13:28:35.png (17,648) 2013-02-15 13:29
https://issues.openbravo.com/file_download.php?file_id=5986&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2013-02-15 13:29miruritaNew Issue
2013-02-15 13:29miruritaAssigned To => dmiguelez
2013-02-15 13:29miruritaFile Added: Screenshot from 2013-02-15 13:28:35.png
2013-02-15 13:29miruritaModules => Core
2013-02-15 13:29miruritaOBNetwork customer => No
2013-02-15 13:29miruritaTriggers an Emergency Pack => No
2013-02-17 06:37pramakrishnanAssigned Todmiguelez => pramakrishnan
2013-02-17 06:37pramakrishnanStatusnew => scheduled
2013-02-17 06:37pramakrishnanfix_in_branch => pi
2013-02-19 04:58pramakrishnanRelationship addedrelated to 0023099
2013-02-19 05:12pramakrishnanNote Added: 0056534
2013-04-18 09:55hgbotCheckin
2013-04-18 09:55hgbotNote Added: 0058008
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/pi/rev/319dfb6a0181dfe068ac39557f4e7947a9ce30ff [^]
2013-04-18 16:35dmiguelezNote Added: 0058024
2013-04-18 16:35dmiguelezStatusresolved => closed
2013-04-19 12:53hudsonbotCheckin
2013-04-19 12:53hudsonbotNote Added: 0058046

Notes
(0056534)
pramakrishnan   
2013-02-19 05:12   
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 and Go to database and realize that the column is not null
(0058008)
hgbot   
2013-04-18 09:55   
Repository: erp/devel/pi
Changeset: 319dfb6a0181dfe068ac39557f4e7947a9ce30ff
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Tue Feb 19 09:32:10 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/319dfb6a0181dfe068ac39557f4e7947a9ce30ff [^]

Fixes Issue 23086: Amount/Quantity column in breakdown tables must be mandatory

---
M src-db/database/model/tables/A_AMORTLINE_ACCTDIMENSION.xml
M src-db/database/model/tables/C_INVOICELINE_ACCTDIMENSION.xml
M src-db/database/model/tables/C_ORDERLINE_ACCTDIMENSION.xml
M src-db/database/model/tables/M_INOUTLINE_ACCTDIMENSION.xml
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0058024)
dmiguelez   
2013-04-18 16:35   
Code Review + Testing Ok
(0058046)
hudsonbot   
2013-04-19 12:53   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/872081925d42 [^]

Maturity status: Test