ÃÛ¶¹ÊÓƵ

DocumentationCommerceTools

ACSD-62118: sales_order_tax_item table not fully updated for B2B orders placed using the Purchase Order method

Last update: Wed Jan 22 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • Experienced
  • Admin
  • Developer

The ACSD-62118 patch fixes the issue where the sales_order_tax_item table doesn’t fully update when a B2B order is placed using the Purchase Order method. This patch is available when the Quality Patches Tool (QPT) 1.1.58 is installed. The patch ID is ACSD-62118. Please note that the issue is scheduled to be fixed in ÃÛ¶¹ÊÓƵ Commerce 2.4.8.

Affected products and versions

The patch is created for ÃÛ¶¹ÊÓƵ Commerce version:

  • ÃÛ¶¹ÊÓƵ Commerce (all deployment methods) 2.4.6-p3

Compatible with ÃÛ¶¹ÊÓƵ Commerce versions:

  • ÃÛ¶¹ÊÓƵ Commerce (all deployment methods) 2.4.6 - 2.4.7-p3
NOTE
The patch might become applicable to other versions with new Quality Patches Tool releases. To check if the patch is compatible with your ÃÛ¶¹ÊÓƵ Commerce version, update the magento/quality-patches package to the latest version and check the compatibility on the Quality Patches Tool: Search for patches page. Use the patch ID as a search keyword to locate the patch.

Issue

When B2B orders are placed using the Purchase Order method, the sales_order_tax_item table is not fully updated. This issue affects tax calculations and order processing. Specifically, the applied_taxes array is empty when querying the order via the API, and both tax_item_amount and tax_item_percent are NULL.

Steps to reproduce:

  1. Add tax rules for both Product and Shipping.
  2. Enable the Purchase Order method in the Company settings.
  3. Log in as a Company Admin User.
  4. Place a Purchase Order using an offline payment method.
  5. After the Purchase Order is auto-approved and converted to an order, check the tax data in the sales_order_tax_item table and through the REST API.

Expected results:

  • The sales_order_tax_item table should contain tax_item data.
  • The applied_taxes array should display the correct tax information in the API response for purchase orders, similar to other payment methods (e.g., Check/Money Order).

Actual results:

  • The sales_order_tax_item table does not contain any tax_item data.
  • The applied_taxes and item_applied_taxes arrays are empty in the API response for the Purchase Order.
  • No tax data is displayed when using the Purchase Order payment method.

Apply the patch

To apply individual patches, use the following links depending on your deployment method:

To learn more about Quality Patches Tool, refer to:

recommendation-more-help
c2d96e17-5179-455c-ad3a-e1697bb4e8c3