Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0035567 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 07. Sales management | major | always | 2017-03-20 10:52 | 2017-03-28 16:57 | |||
| Reporter | ngarcia | View Status | public | |||||
| Assigned To | mcobas | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 3.0PR17Q2 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 42faf5fdec47 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | aferraz | |||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | 45956 | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0035567: Sales Invoice Dimensional Report is showing Invoice Address instead of Shipment Address when exporting to XLS | |||||||
| Description | Sales Invoice Dimensional Report is showing Invoice Address instead of Shipment Address when exporting to XLS | |||||||
| Steps To Reproduce | As 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 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0095573) mcobas (viewer) 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 (developer) 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 (viewer) 2017-03-27 13:35 |
Code review + Testing OK |
|
(0095610) hudsonbot (viewer) 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 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2017-03-20 10:52 | ngarcia | New Issue | |
| 2017-03-20 10:52 | ngarcia | Assigned To | => Triage Finance |
| 2017-03-20 10:52 | ngarcia | OBNetwork customer | => Yes |
| 2017-03-20 10:52 | ngarcia | Modules | => Core |
| 2017-03-20 10:52 | ngarcia | Support ticket | => 45956 |
| 2017-03-20 10:52 | ngarcia | Resolution time | => 1491775200 |
| 2017-03-20 10:52 | ngarcia | Triggers an Emergency Pack | => No |
| 2017-03-20 10:52 | ngarcia | Issue Monitored: networkb | |
| 2017-03-20 19:25 | markmm82 | Assigned To | Triage Finance => luisrs8608 |
| 2017-03-22 22:10 | collazoandy4 | Assigned To | luisrs8608 => collazoandy4 |
| 2017-03-22 22:11 | collazoandy4 | Status | new => scheduled |
| 2017-03-23 15:45 | markmm82 | Assigned To | collazoandy4 => mcobas |
| 2017-03-24 18:30 | mcobas | Note Added: 0095573 | |
| 2017-03-27 13:33 | hgbot | Checkin | |
| 2017-03-27 13:33 | hgbot | Note Added: 0095587 | |
| 2017-03-27 13:33 | hgbot | Status | scheduled => resolved |
| 2017-03-27 13:33 | hgbot | Resolution | open => fixed |
| 2017-03-27 13:33 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/42faf5fdec47abc9d1afb5b548ce04622208002c [^] |
| 2017-03-27 13:35 | aferraz | Review Assigned To | => aferraz |
| 2017-03-27 13:35 | aferraz | Note Added: 0095588 | |
| 2017-03-27 13:35 | aferraz | Status | resolved => closed |
| 2017-03-27 13:35 | aferraz | Fixed in Version | => 3.0PR17Q2 |
| 2017-03-28 16:57 | hudsonbot | Checkin | |
| 2017-03-28 16:57 | hudsonbot | Note Added: 0095610 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |