Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008498Openbravo ERP02. Master data managementpublic2009-04-08 09:182009-07-08 07:00
Reportersureshbabu 
Assigned Toalostale 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version
Product Version2.50beta 
Target VersionFixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0008498: while creating a new volume discount BP's are wrongly added from the old volume discount to the new one.
Descriptionwhile creating a new volume discount in the Business partner's tab, Business partners are wrongly added from the old volume discount to the new volume discount

Steps To Reproducesteps which i used to reproduce the issue,

created a volume discount1 ( Master Data Management || Business Partner Setup || Volume Discount || Volume Discounts )
Name: <enter a valid name >
Scaled: Un check
Included Product: All selected
Included Product categories: Not selected

Step 2: Move to Product tab and
product: Hammer
and click new
Product: Paint



step 3: Move to volume discount parameters tab
Discount % : 10 (10%)
Min Amount : 10000

Move to Business partners tab
Business partner: McGiver supplies
Valid from date: <today's date>
Sales Transaction: checked
and click new and enter
Business partner: Red bunny
Valid from date: <today's date>
Sales Transaction: checked


Then i tried to create a new Volume discount to test the scaled functionality so i clicked new and entered all the required details and then i moved to Business partner tab.

Actual result: Both BP's Red Bunny & MC Giver Supplies are wrongly added to the list.

 
Proposed Solution
Additional Information
Tags250 final review, 250 QA
Relationships
related to defect 0008501 closed jayakumar In volume discount settlement tab displays invoice details of all Business partners. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-04-08 09:18sureshbabuNew Issue
2009-04-08 09:18sureshbabuAssigned To => rafaroda
2009-04-08 09:18sureshbabuRegression testing => No
2009-04-08 09:18sureshbabuTag Attached: 250 final review
2009-04-08 09:52psarobePrioritynormal => immediate
2009-04-08 09:52psarobeSeverityminor => major
2009-04-08 09:52psarobeStatusnew => scheduled
2009-04-08 09:52psarobeTag Attached: 250 QA
2009-04-08 10:10rafarodaAssigned Torafaroda => sathiyan
2009-04-08 10:43sathiyanAssigned Tosathiyan => jayakumar
2009-04-08 12:27psarobeAssigned Tojayakumar => iperdomo
2009-04-08 13:26iperdomoAssigned Toiperdomo => alostale
2009-04-08 16:36alostaleNote Added: 0015289
2009-04-08 16:47hgbotCheckin
2009-04-08 16:47hgbotNote Added: 0015290
2009-04-08 16:47hgbotStatusscheduled => resolved
2009-04-08 16:47hgbotResolutionopen => fixed
2009-04-08 16:47hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9968db2e63b03c665b24a5b108df10715a8ee1f4 [^]
2009-04-14 12:36psarobeRelationship addedrelated to 0008501
2009-04-14 16:23psarobeStatusresolved => closed
2009-04-15 12:00anonymoussf_bug_id0 => 2764978
2009-07-03 13:13hgbotCheckin
2009-07-03 13:13hgbotNote Added: 0017842
2009-07-03 13:13hgbotStatusclosed => resolved
2009-07-03 13:13hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/9968db2e63b03c665b24a5b108df10715a8ee1f4 [^] => http://code.openbravo.com/erp/devel/pi/rev/f544940c086d28b0e8e85fb4ce1d4cbae50e8635 [^]
2009-07-08 07:00sureshbabuStatusresolved => closed
2009-07-08 07:00sureshbabuNote Added: 0017984
2009-07-08 07:00sureshbabuFixed in Version2.50MP1 => pi

Notes
(0015289)
alostale   
2009-04-08 16:36   
This bug is applicable to all sub tabs with used to have isParent='Y' and it has been removed because they do not define business objects.

They can be obtained with this query:

 select w.name win, t1.name child_tab, tb1.tablename child_table, t.name parent_tab, tb.tablename parent_tab, t1.whereclause, t1.ad_tab_id
         from ad_window w, ad_tab t, ad_tab t1, --t1 is the tab to look for parents
              ad_Table tb, ad_table tb1
        where t1.ad_window_id = t.ad_window_id
         and t.ad_window_id = w.ad_window_id
         and tb.ad_table_id = t.ad_table_id
         and tb1.ad_table_id = t1.ad_table_id
          and t.seqno < t1.seqno
          and t.tablevel < t1.tablevel
          and t.seqno = (select max(t2.seqno)
                           from ad_tab t2, ad_tab t3
                          where t3.ad_window_id = t2.ad_window_id
                            and t3.ad_tab_id = t1.ad_tab_id
                            and t2.seqno < t3.seqno
                            and t2.tablevel < t3.tablevel)
          and not exists (select 1 from ad_column c, ad_column c2
                           where c.ad_table_id = t1.ad_table_id and c.isparent = 'Y' and c2.ad_table_id = t.ad_table_id and c2.columnname = c.columnname)
          and not exists (select 1 from ad_column c, ad_column c2
                           where c.ad_table_id = t1.ad_table_id and c.iskey = 'Y' and c2.ad_table_id = t.ad_table_id and upper(c2.columnname) = upper(c.columnname))
          and w.isactive = 'Y'
          and t1.isactive ='Y'
          order by t1.whereclause;
(0015290)
hgbot   
2009-04-08 16:47   
Repository: erp/devel/pi
Changeset: 9968db2e63b03c665b24a5b108df10715a8ee1f4
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Apr 08 16:43:13 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/9968db2e63b03c665b24a5b108df10715a8ee1f4 [^]

fixed bug 0008498: while creating a new volume discount BP's are wrongly added from the old volume discount to the new one.

---
M src-db/database/sourcedata/AD_TAB.xml
---
(0017842)
hgbot   
2009-07-03 13:13   
Repository: erp/devel/pi
Changeset: f544940c086d28b0e8e85fb4ce1d4cbae50e8635
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Apr 08 16:43:13 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f544940c086d28b0e8e85fb4ce1d4cbae50e8635 [^]

fixed bug 0008498: while creating a new volume discount BP's are wrongly added from the old volume discount to the new one.

---
M src-db/database/sourcedata/AD_TAB.xml
---
(0017984)
sureshbabu   
2009-07-08 07:00   
Tested working fine.