Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013655Openbravo ERP02. Master data managementpublic2010-06-14 19:252010-09-13 12:38
Reporternetworkb 
Assigned Tosivaraman 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP18 
Target Version2.50MP21Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0013655: Missing field in Import Orders window
DescriptionWhen adding an order from Import Orders window you can not specify Product Attribute field, which is en essential field for defining an order (as for example, price list or quantity which are present in this window)

Due to that, you can not synchronize order from POS using attributesetinstance
Steps To Reproduce1. Master Data Management || Import Data || Import Orders: create new record an realize that Attribute is not present in Product definition section
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-06-14 19:25networkbNew Issue
2010-06-14 19:25networkbAssigned To => adrianromero
2010-06-14 19:25networkbOBNetwork customer => Yes
2010-06-16 13:02adrianromeroStatusnew => scheduled
2010-06-16 13:02adrianromerofix_in_branch => pi
2010-08-16 07:45sivaramanAssigned Toadrianromero => sivaraman
2010-08-16 07:56hgbotCheckin
2010-08-16 07:56hgbotNote Added: 0029972
2010-08-16 07:56hgbotStatusscheduled => resolved
2010-08-16 07:56hgbotResolutionopen => fixed
2010-08-16 07:56hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/905bba2e13c21e136afe784dd4a8bc924b3c620e [^]
2010-08-16 08:23sivaramanNote Added: 0029975
2010-08-16 15:33hudsonbotCheckin
2010-08-16 15:33hudsonbotNote Added: 0030024
2010-08-23 11:10sureshbabuNote Added: 0030220
2010-08-23 11:10sureshbabuStatusresolved => closed
2010-09-13 12:38anonymoussf_bug_id0 => 3065153

Notes
(0029972)
hgbot   
2010-08-16 07:56   
Repository: erp/devel/pi
Changeset: 905bba2e13c21e136afe784dd4a8bc924b3c620e
Author: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com>
Date: Mon Aug 16 11:24:47 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/905bba2e13c21e136afe784dd4a8bc924b3c620e [^]

Fixes issue 13655: Missing field in Import Orders window

Solution:
Attribute field has been implemented in Import Order window. In order to import attribute value data from csv file, an attribute identifier field also additionaly implemented. This required two more columns in I_ORDER table and they add configure in Import Order window. The attribute values can be attained from the identifier by parsing the value using underscore character.

Impacts:
It is verified that the change causes no impacts.

---
M src-db/database/model/tables/I_ORDER.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src/org/openbravo/erpCommon/ad_process/COrderLine_data.xsql
M src/org/openbravo/erpCommon/ad_process/ImportOrder.java
M src/org/openbravo/erpCommon/ad_process/ImportOrder_data.xsql
---
(0029975)
sivaraman   
2010-08-16 08:23   
Steps to test:

Before start testing, please ensure that the product that we import, is associated with attribute set and we following the proper syntax (i.e, Medium_LLot_#422_10-08-2010) in attribute identifier as per the attribute set.
if product is not associated with any attribute set, attribute identifier will omitted.

Kindly test the following scenarios.

1. Import new order without attribute identifier and verify if it is successfully processed
2. Import new order with any valid & existing attribute value(i.e, Medium) in attribute identifier field and verify if order is successfully processed
3. Import new order with any new attribute value(i.e, Mini) in attribute identifier field and verify if order is successfully processed and also the value is added into corresponding attribute.
4. Import new order with built-in attribute values(i.e, Lot, Serial No, Guaranteed date) and verify if it is successfully processed
5. Import new order with built-in attribute values(i.e, Lot, Serial No, Guaranteed date) and also assigned attribute values and verify if it is successfully processed
(0030024)
hudsonbot   
2010-08-16 15:33   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/905bba2e13c2 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/d05f23849910 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18157.obx [^]
(0030220)
sureshbabu   
2010-08-23 11:10   
Verified now i can find attribute field in the import orders screen