QUALITY PATCH

ACSD-49179: The orders report shows incorrect amounts in case of different currencies for different…

The orders report shows incorrect amounts in case of different currencies for different stores. Quality patch ACSD-49179 for magento/module-reports applies to Magento Open Source and Adobe Commerce 2.4.2 to 2.4.6-p15.

Categories: Reports
Components: magento/module-reports
Origin: adobe-commerce-support
Since QPT: 1.1.28

Issue

The orders report shows incorrect amounts in case of different currencies for different stores.

Steps to reproduce

1. Go to Stores > Config > Catalog > Price and set Catalog Price Scope = Website. 1. Create an additional website, store, and store view. 1. Go to Stores > Config > General > Currency Setup > Currency Options and set: * Default Config: * Base Currency: USD * Default Display Currency: USD * Allowed Currencies: EUR, USD and THB (Thai Baht) * Main Website: * Base Currency: EUR * Default Display Currency: EUR * Allowed Currencies: EUR * Additional new Website: * Base Currency: THB (Thai Baht) * Default Display Currency: THB (Thai Baht) * Allowed Currencies: THB (Thai Baht) 1. Go to Stores > Currency > Currency Rates and set the empty conversion rates for the THB (set rates to 1.0000). 1. Create a product, assign it to both websites, and place an order with this product in the additional website previously created. 1. Make sure that the order is in Processing status (invoice it). 1. In the backend, go to Reports > Sales > Orders. 1. Click on the Yellow warning to refresh the statistics. 1. Set the scope of the report on the additional website previously created and set the filter as follows: * Date Used: Created * Period: Day * From and To: The same day when the test order was placed * Order Status: Any * Empty rows: No * Show Actual Values: No

Adobe's page lists 2.4.2 - 2.4.6 as compatible; the versions below are resolved from the current QPT constraints and are the ones the tool will offer.

Adobe scheduled the permanent fix for 2.4.7.

Install

Install the Quality Patches Tool with composer require magento/quality-patches, apply the prerequisites listed for all files applicable to your distribution and version first, then run vendor/bin/magento-patches apply ACSD-49179. On Cloud, add ACSD-49179 under stage.build.QUALITY_PATCHES in .magento.env.yaml.

For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its ACSD-49179/ folder into patches/composer/, merge composer.patches.json into composer.json, then run composer install. Bundle prerequisites the same way and list them first. Paths are relative to each package root, using the default -p1 level. Prefer local files when configuring composer-patches; a remote URL can change.

Patch files and compatible versions

magento/magento2-base >=2.4.2 <2.4.7

Magento Open Source: 2.4.6-p15, 2.4.6-p14, 2.4.6-p13, 2.4.6-p12, 2.4.6-p11, 2.4.6-p10, 2.4.6-p9, 2.4.6-p8, 2.4.6-p7, 2.4.6-p6, 2.4.6-p5, 2.4.6-p4, 2.4.6-p3, 2.4.6-p2, 2.4.6-p1, 2.4.6, 2.4.5-p17, 2.4.5-p16, 2.4.5-p15, 2.4.5-p14, 2.4.5-p13, 2.4.5-p12, 2.4.5-p11, 2.4.5-p10, 2.4.5-p9, 2.4.5-p8, 2.4.5-p7, 2.4.5-p6, 2.4.5-p5, 2.4.5-p4, 2.4.5-p3, 2.4.5-p2, 2.4.5-p1, 2.4.5, 2.4.4-p18, 2.4.4-p17, 2.4.4-p16, 2.4.4-p15, 2.4.4-p14, 2.4.4-p13, 2.4.4-p12, 2.4.4-p11, 2.4.4-p10, 2.4.4-p9, 2.4.4-p8, 2.4.4-p7, 2.4.4-p6, 2.4.4-p5, 2.4.4-p4, 2.4.4-p3, 2.4.4-p2, 2.4.4-p1, 2.4.4, 2.4.3-p3, 2.4.3-p2, 2.4.3-p1, 2.4.3, 2.4.2-p2, 2.4.2-p1, 2.4.2
Adobe Commerce: 2.4.6-p15, 2.4.6-p14, 2.4.6-p13, 2.4.6-p12, 2.4.6-p11, 2.4.6-p10, 2.4.6-p9, 2.4.6-p8, 2.4.6-p7, 2.4.6-p6, 2.4.6-p5, 2.4.6-p4, 2.4.6-p3, 2.4.6-p2, 2.4.6-p1, 2.4.6, 2.4.5-p17, 2.4.5-p16, 2.4.5-p15, 2.4.5-p14, 2.4.5-p13, 2.4.5-p12, 2.4.5-p11, 2.4.5-p10, 2.4.5-p9, 2.4.5-p8, 2.4.5-p7, 2.4.5-p6, 2.4.5-p5, 2.4.5-p4, 2.4.5-p3, 2.4.5-p2, 2.4.5-p1, 2.4.5, 2.4.4-p18, 2.4.4-p17, 2.4.4-p16, 2.4.4-p15, 2.4.4-p14, 2.4.4-p13, 2.4.4-p12, 2.4.4-p11, 2.4.4-p10, 2.4.4-p9, 2.4.4-p8, 2.4.4-p7, 2.4.4-p6, 2.4.4-p5, 2.4.4-p4, 2.4.4-p3, 2.4.4-p2, 2.4.4-p1, 2.4.4, 2.4.3-p3, 2.4.3-p2, 2.4.3-p1, 2.4.3, 2.4.2-p2, 2.4.2-p1, 2.4.2
Patch file: patches/os/ACSD-49179_2.4.3-p3_v2.patch

vendor/magento/module-reports/Block/Adminhtml/Grid/Column/Renderer/Currency.php