Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0051814ModulesReportingpublic2023-03-08 17:262023-03-22 17:28
Reportersofidossant 
Assigned Tofrancisco_ofarril 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0051814: Error Dimensional Invoice Reports
DescriptionWhen we have an invoice (either sales or purchase) and we add a specific exchange rate to it, the invoice dimensional report does not take into account the invoice exchange rate, but the currency rate.
Steps To Reproduce- Do a sales invoice and add Exchange rate.
- Do the Sales Invoice Dimensional Report with the currency that you add in the step 1.

Checked the exchange rate that used the report.
Proposed SolutionAttache diffs
Additional Information
TagsNo tags attached.
Relationships
related to defect 0051708PR22Q3.2 closed francisco_ofarril Openbravo ERP BUG in Dimensional Purchasing Invoices 
Attached Filesdiff ReportInvoiceCustomerDimensionalAnalysesJR_data.diff (4,694) 2023-03-08 20:22
https://issues.openbravo.com/file_download.php?file_id=18235&type=bug
diff ReportInvoiceVendorDimensionalAnalysesJR_data.diff (3,495) 2023-03-08 20:22
https://issues.openbravo.com/file_download.php?file_id=18236&type=bug
? ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql (107,842) 2023-03-08 20:23
https://issues.openbravo.com/file_download.php?file_id=18237&type=bug
? ReportInvoiceVendorDimensionalAnalysesJR_data.xsql (20,949) 2023-03-08 20:23
https://issues.openbravo.com/file_download.php?file_id=18238&type=bug
Issue History
Date ModifiedUsernameFieldChange
2023-03-08 17:26sofidossantNew Issue
2023-03-08 17:26sofidossantAssigned To => Triage Omni WMS
2023-03-08 19:57PracticsIssue Monitored: Practics
2023-03-08 20:22sofidossantProposed Solution updated
2023-03-08 20:22sofidossantFile Added: ReportInvoiceCustomerDimensionalAnalysesJR_data.diff
2023-03-08 20:22sofidossantFile Added: ReportInvoiceVendorDimensionalAnalysesJR_data.diff
2023-03-08 20:23sofidossantFile Added: ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
2023-03-08 20:23sofidossantFile Added: ReportInvoiceVendorDimensionalAnalysesJR_data.xsql
2023-03-20 10:42aferrazAssigned ToTriage Omni WMS => francisco_ofarril
2023-03-21 19:57francisco_ofarrilStatusnew => scheduled
2023-03-21 22:06hgbotNote Added: 0147788
2023-03-22 17:21aferrazRelationship addedrelated to 0051708
2023-03-22 17:28hgbotResolutionopen => fixed
2023-03-22 17:28hgbotStatusscheduled => closed
2023-03-22 17:28hgbotFixed in Version => PR23Q2
2023-03-22 17:28hgbotNote Added: 0147850
2023-03-22 17:28hgbotNote Added: 0147851

Notes
(0147788)
hgbot   
2023-03-21 22:06   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/844 [^]
(0147850)
hgbot   
2023-03-22 17:28   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 82cef5a1ba9d97d56c0455f199e2ce2c8783ae87
Author: Francisco Javier Deler O'Farril <francisco.ofarril@openbravo.com>
Date: 22-03-2023 16:28:23
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/82cef5a1ba9d97d56c0455f199e2ce2c8783ae87 [^]

Fixed ISSUE-51814: Error Dimensional Invoice Reports

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR_data.xsql
---
(0147851)
hgbot   
2023-03-22 17:28   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/844 [^]