Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0051708Openbravo ERP07. Sales managementpublic2023-02-27 15:442023-03-22 13:41
Reporteraxelmercado 
Assigned Tofrancisco_ofarril 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionPR22Q3.2Fixed in VersionPR23Q2 
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
Summary0051708: BUG in Dimensional Purchasing Invoices
DescriptionWhen we launch the purchase invoice dimensional filtering by category of some of the products that have been purchased, the Total value of the same is incorrect, it shows the total of the purchases when it should be the total of the filtered category.
Steps To Reproduce1 - Enter an invoice with two lines, one for each product category.
2 - The invoice must be in a different currency from the organization (for example USD).
3 - Add a specific conversion for that invoice in the "Exchange rate" tab of that invoice.
4 - Launch the purchase invoices dimensional filtering by one of the two categories of that invoice.
5 - Note that the amount displayed is the total of the document and not of the chosen filter.

Video with the steps: https://drive.google.com/file/d/1XgS4hy27-dUrk7rg-_HEe0H0cIjq3co4/view [^]
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0051814 closed francisco_ofarril Modules Error Dimensional Invoice Reports 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-02-27 15:44axelmercadoNew Issue
2023-02-27 15:44axelmercadoAssigned To => Triage Omni OMS
2023-02-27 15:44axelmercadoModules => Core
2023-02-27 15:44axelmercadoTriggers an Emergency Pack => No
2023-03-20 10:39aferrazAssigned ToTriage Omni OMS => francisco_ofarril
2023-03-20 13:17francisco_ofarrilStatusnew => scheduled
2023-03-21 04:25hgbotNote Added: 0147728
2023-03-22 13:26francisco_ofarrilNote Added: 0147837
2023-03-22 13:41hgbotResolutionopen => fixed
2023-03-22 13:41hgbotStatusscheduled => closed
2023-03-22 13:41hgbotNote Added: 0147840
2023-03-22 13:41hgbotFixed in Version => PR23Q2
2023-03-22 13:41hgbotNote Added: 0147841
2023-03-22 17:21aferrazRelationship addedrelated to 0051814

Notes
(0147728)
hgbot   
2023-03-21 04:25   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/840 [^]
(0147837)
francisco_ofarril   
2023-03-22 13:26   
Proof of Test: https://docs.google.com/spreadsheets/d/1oeM8fTrmoSO-vhcPfqIdk8O_MPN5vijCSIZmO_9Di7M/edit?usp=sharing [^]
(0147840)
hgbot   
2023-03-22 13:41   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/840 [^]
(0147841)
hgbot   
2023-03-22 13:41   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: a2b5aa6bd3ebc0a5f07a7ce923e1e15d28f6e2ff
Author: Francisco Javier Deler O'Farril <francisco.ofarril@openbravo.com>
Date: 22-03-2023 12:41:42
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/a2b5aa6bd3ebc0a5f07a7ce923e1e15d28f6e2ff [^]

Fixed ISSUE-51708: BUG in Dimensional Purchasing Invoices.

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR_data.xsql
---