Incorrect handling of VAT on FPT Surcharge deduction

[rhengeveldbordex]

There appears to be a discrepancy in how the Fixed Product Tax (FPT) surcharge is handled when processing orders from external marketplaces. Specifically, the VAT on the FPT surcharge is not being correctly subtracted from the product price, leading to a mismatch in the order totals (Magento <-> Marketplace).

Steps to Reproduce
Internal Order Configuration:

Subtotal (Excl. FPT and VAT): €72.10
FPT (Excl. VAT): €6.56
Grand Total (Excl. VAT): €78.66
VAT (21%): €16.52
Grand Total (Incl. VAT): €95.18

Marketplace Order Configuration:

Order Total (Incl. VAT): €93.80

Expected Behavior:

The product price on the marketplace should have the FPT surcharge correctly subtracted, ensuring that the internal and external order totals match (both should be €93,80).

Actual Behavior:

The VAT on the FPT surcharge is not correctly subtracted. This results in an incorrect product price being calculated, leading to a difference between the marketplace order total (€93.80) and the Magento order total (€95.18).

Analysis
It looks like the issue occurs because the VAT on the FPT surcharge (€1.38) is not being correctly handled during the deduction process. This leads to an incorrect calculation of the product price in Magento.

[Frank-Magmodules]

Hi There @rhengeveldbordex,
Thanks for bringing this issue to our attention. I’m working on reproducing it now and will get back to you shortly.

[Frank-Magmodules]

Hi @rhengeveldbordex,

I wasn't able to reproduce the issue on my end using the import simulator and your data. Could you please contact us directly so we can check this on your development/staging environment if possible?

Thanks a lot!

[Frank-Magmodules]

Hi @rhengeveldbordex, We haven’t received any updates from you on this issue yet. Is it still relevant, and can we assist you further? Feel free to reach out, and we’ll be happy to take a look with you.

[Frank-Magmodules]

Hi @rhengeveldbordex,

We’ve pushed a fix to this branch: https://github.com/magmodules/magento2-channable/tree/release/1.20.0. It appears that this issue only occurs when recalculating prices on products (specifically when prices are set as excluding tax in the Magento admin).

Could you let us know your findings?
If everything meets your requirements, we’ll proceed with pushing this to an official release!

[rhengeveldbordex]

Hi @Frank-Magmodules,

Thanks for the update! I appreciate the quick fix. I will test the changes and provide feedback shortly. From the initial review, it looks promising. If there are any issues, I'll let you know. Otherwise, it seems good to go for an official release!

[mikemoooo]

Hey @Frank-Magmodules ,
Do you know when the 1.20 update will be released?
We would need this fix for calculation as well.
Cheers,
Mike

[rhengeveldbordex]

Hi Frank,

Just a quick update from our side. We are now on the branch with the fix for this issue. We're no longer experiencing any problems, so as far as we're concerned, it can be included in the next release.

[Frank-Magmodules]

Perfect, @rhengeveldbordex! Thank you for confirming this. We’ll update the issue as soon as the release is live!

[Frank-Magmodules]

Hi All!

I’m happy to announce that we’ve just released our new 1.20.0 version, which finally addresses VAT calculations in combination with FPT.

I’ll be closing this ticket for now, but feel free to reopen it or leave a comment if there’s anything else you need.

Thanks!