Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035567Openbravo ERP07. Sales managementpublic2017-03-20 10:522017-03-28 16:57
Reporterngarcia 
Assigned Tomcobas 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q2 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035567: Sales Invoice Dimensional Report is showing Invoice Address instead of Shipment Address when exporting to XLS
DescriptionSales Invoice Dimensional Report is showing Invoice Address instead of Shipment Address when exporting to XLS
Steps To ReproduceAs group admin role:
   Modify the address of Hoteles Buenas Noches, S.A. business partner, set it as Invoicing Address = 'N'
   Create a new address to that customer with Shipping Address = 'N' and Invoicing Address = 'Y'
   Create a Sales Order for that business partner
   Create a Goods Shipment from it. Check the first address is used
   Create a Sales Invoice from it. Check the second address is used
   Launch the Sales Invoice Dimensional Report adding the following dimensions:
      Ship to Address
      DocumentNo
   Check in HTML and PDF the goods shipment address is shown
   Check in XLS the invoice address is shown
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-03-20 10:52ngarciaNew Issue
2017-03-20 10:52ngarciaAssigned To => Triage Finance
2017-03-20 10:52ngarciaModules => Core
2017-03-20 10:52ngarciaResolution time => 1491775200
2017-03-20 10:52ngarciaTriggers an Emergency Pack => No
2017-03-20 10:52ngarciaIssue Monitored: networkb
2017-03-20 19:25markmm82Assigned ToTriage Finance => luisrs8608
2017-03-22 22:10collazoandy4Assigned Toluisrs8608 => collazoandy4
2017-03-22 22:11collazoandy4Statusnew => scheduled
2017-03-23 15:45markmm82Assigned Tocollazoandy4 => mcobas
2017-03-24 18:30mcobasNote Added: 0095573
2017-03-27 13:33hgbotCheckin
2017-03-27 13:33hgbotNote Added: 0095587
2017-03-27 13:33hgbotStatusscheduled => resolved
2017-03-27 13:33hgbotResolutionopen => fixed
2017-03-27 13:33hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/42faf5fdec47abc9d1afb5b548ce04622208002c [^]
2017-03-27 13:35aferrazReview Assigned To => aferraz
2017-03-27 13:35aferrazNote Added: 0095588
2017-03-27 13:35aferrazStatusresolved => closed
2017-03-27 13:35aferrazFixed in Version => 3.0PR17Q2
2017-03-28 16:57hudsonbotCheckin
2017-03-28 16:57hudsonbotNote Added: 0095610

Notes
(0095573)
mcobas   
2017-03-24 18:30   
1. Go to Business Partner window, modify the address of Hoteles Buenas Noches, S.A. business partner.
    1.1. Unselect Invoicing Address.
    1.2. Add a new address to the customer with unselect Shipping Address and select Invoicing Address.
 2. Create a Sales Order for that business partner.
 3. Create a Goods Shipment from it and Process. Check the first address is used.
 4. Create a Sales Invoice from it and Process. Check the second address is used.
 5. Launch the Sales Invoice Dimensional Report adding the following dimensions:
    5.1. Ship to Address.
    5.2. DocumentNo.
 6. Notice that in HTML, PDF and XLS the goods shipment address is shown correctly.
(0095587)
hgbot   
2017-03-27 13:33   
Repository: erp/devel/pi
Changeset: 42faf5fdec47abc9d1afb5b548ce04622208002c
Author: Miguel <martencobasmiguel <at> gmail.com>
Date: Fri Mar 24 09:53:48 2017 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/42faf5fdec47abc9d1afb5b548ce04622208002c [^]

Fixes issue 35567: Sales Invoice Dimensional Report shows incorrect address

When launch Sales Invoice Dimensional Report and export to XLS, is showing
Invoice Address instead of Shipment Address, because in the query in charge
of obtaining the data, the address information is being retrieved through the
relationship between the C_BPARTNER_LOCATION and C_INVOICE table.

Now to retrieve the correct address, the relationship between
the C_BPARTNER_LOCATION and M_INOUT tables was established.

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
---
(0095588)
aferraz   
2017-03-27 13:35   
Code review + Testing OK
(0095610)
hudsonbot   
2017-03-28 16:57   
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/b8f24f04c24b [^]
Maturity status: Test