Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0047773Openbravo ERP07. Sales managementpublic2021-09-28 18:442021-10-21 09:37
Reporterlbressan 
Assigned Tofernando_merino 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutioninvalid 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in VersionPR22Q1 
Merge Request Statusapproved
Review Assigned Tovmromanos
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket29272
Regression level
Regression date2021-11-01
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0047773: Sales dimensional report - shipping address
DescriptionA customer report that in Sales dimensional report when selecting the dimension 'Shipping address' the report data shows the order address instead of the delivery address.
Steps To Reproduce1 - Create an address to the Business Partner, the Active check-in "Invoicing Address" and we remove the check "Shipping Address"
2 - In the standard address we change the check "Shipping Address" and we remove the check "Invoicing Address"
3- Create sales order indicating a different delivery address than the order address
4 - In the tab "Lines" we add two randoms products
5 - Select the process a dimensional sales report by selecting the dimensions 'Shipping address' and 'Product'
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files? ticket29272.mp4 (3,546,616) 2021-09-28 18:44
https://issues.openbravo.com/file_download.php?file_id=16230&type=bug
Issue History
Date ModifiedUsernameFieldChange
2021-09-28 18:44lbressanNew Issue
2021-09-28 18:44lbressanAssigned To => Triage Finance
2021-09-28 18:44lbressanFile Added: ticket29272.mp4
2021-09-28 18:44lbressanOBNetwork customer => No
2021-09-28 18:44lbressanModules => Core
2021-09-28 18:44lbressanSupport ticket => 29272
2021-09-28 18:44lbressanRegression date => 2021-10-12
2021-09-28 18:44lbressanTriggers an Emergency Pack => No
2021-10-08 14:44vmromanosNote Added: 0132276
2021-10-08 15:07aferrazRegression date2021-10-12 =>
2021-10-08 15:07aferrazAssigned ToTriage Finance => fernando_merino
2021-10-13 11:50hgbotMerge Request Status => open
2021-10-13 11:50hgbotNote Added: 0132315
2021-10-14 11:25hgbotMerge Request Statusopen => approved
2021-10-14 11:26hgbotResolutionopen => fixed
2021-10-14 11:26hgbotStatusnew => closed
2021-10-14 11:26hgbotFixed in Version => PR22Q1
2021-10-14 11:26hgbotNote Added: 0132344
2021-10-14 11:26hgbotNote Added: 0132345
2021-10-19 19:47lbressanStatusclosed => new
2021-10-19 19:49lbressanNote Added: 0132466
2021-10-20 19:12aferrazOBNetwork customerNo => OBPS
2021-10-20 19:42lbressanRegression date => 2021-11-01
2021-10-20 19:42lbressanNote Added: 0132507
2021-10-21 09:37vmromanosReview Assigned To => vmromanos
2021-10-21 09:37vmromanosNote Added: 0132516
2021-10-21 09:37vmromanosStatusnew => closed
2021-10-21 09:37vmromanosResolutionfixed => invalid

Notes
(0132276)
vmromanos   
2021-10-08 14:44   
Proposed solution: rename report's dimension from "Ship to address" to "Partner Address", which reflects the current report's behavior.
(0132315)
hgbot   
2021-10-13 11:50   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/440 [^]
(0132344)
hgbot   
2021-10-14 11:26   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: ad287eb6150fd7b28cbda7b837eab9b184ea8e21
Author: fernando_merino <fernando.merino@openbravo.com>
Date: 2021-10-14T11:24:32+02:00
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/ad287eb6150fd7b28cbda7b837eab9b184ea8e21 [^]

Fixes ISSUE-47773: Rename Sales Dimensional Report dimension from 'Ship to Address' to 'Partner Address'

Renamed the 'Ship to Address' dimension of the Sales Dimensional Report to 'Partner Address' as it reflects
better the report's behavior. The report groups by the order address, equivalent to the Business Partner
Address, so the 'Partner Address' name is more suitable than the 'Ship to Address' name for this dimension.

---
M src-db/database/sourcedata/AD_REF_LIST.xml
---
(0132345)
hgbot   
2021-10-14 11:26   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/440 [^]
(0132466)
lbressan   
2021-10-19 19:49   
Dear,
After the client tried the patch, it did not solve the problem
(0132507)
lbressan   
2021-10-20 19:42   
The report "Dimensional Analysis of Sales Orders" continues to fail because when selecting the "Shipping Address" field as one of the available dimensions, it continues to be displayed in the Address field in the header of the Sales Orders, when The logical thing is that it shows the Delivery Address field that appears within the submenu and also in the Orders header

1- Create sales orders indicating a delivery address different from the order address

2- List a dimensional analysis of sales orders by selecting the dimensions 'Shipping address' and Product.

3- Check that the report groups by order address instead of by shipping address.
(0132516)
vmromanos   
2021-10-21 09:37   
The report has always shown the Partner Address. The problem was in the dimension name when launching the report, which was wrongly labeled as 'Ship to Address'.

The fix properly changes the dimension's name from 'Ship to Address' to 'Partner Address', which clearly represents the current behavior. You can check it in live builds.

Not sure what you're really expecting by reopening the issue. If you want to implement a new dimension 'Ship to Address', this would be a feature request.