0007801: Wrong calculation for total net/vat of order

ID	Project	Category	View Status	Date Submitted	Last Update

0007801	OXID eShop (all versions)	1.03. Basket, checkout process	public	2025-06-12 19:53	2025-06-23 10:06

Reporter	anton.fedurtsya	Assigned To
Priority	normal	Severity	major	Reproducibility	always
Status	acknowledged	Resolution	open
Product Version	7.1.2

Summary	0007801: Wrong calculation for total net/vat of order
Description	Net and vat calculation is done for every OrderArticle, but those values are not used during the order finalization, instead, brutto sum for specific vat is taken, and Vat value + Net value is calculated from the sum instead. This makes inconsistency which is critical when you need to list items with its total net and vat values line by line.
Steps To Reproduce	We need two products, with brutto prices: A - 24,95 and B - 29,95; Default VAT 19%. Brutto prices in the frontend. Add one item A, and 2x item B to the basket. Now we have 71,30 as total net + 13,55 as total Vat, in total its 84,85. Everything sounds fine. But, after the order, in OrderArticles, we get: 20.97+50.34=71.31 as Net and 3.98+9.56=13.54 as VAT. This doesn't match up with totals calculated for the order.
Additional Information	It happens because the final net/vat is calculated from the brutto total of items grouped by specific vat, instead of using already calculated order articles.
Tags	No tags attached.
Attached Files	Screenshot from 2025-06-12 20-31-24.png (11,274 bytes) Screenshot from 2025-06-12 20-31-24.png (11,274 bytes) Screenshot from 2025-06-12 20-52-05.png (10,410 bytes) Screenshot from 2025-06-12 20-52-05.png (10,410 bytes)

Theme	Not defined
Browser	Not defined
PHP Version	Not defined
Database Version	Not defined

QA 2025-06-13 14:11 administrator ~0017977	- es -

SvenBrunk 2025-06-18 08:37 administrator ~0017981	According to the law this is not really incorrect. But it would be nice to have an option to switch this, because also ERP systems differ in the way how they calculate this and this can lead to issues when syncing orders.

anton.fedurtsya 2025-06-23 10:06 administrator ~0017991	The problem is - numbers like this will not go through ZUGFeRD validation, as the totals should match (Business rule BR-CO-10), and then, its really huge issue to make this part valid, as you need to adjust/recalculate the net prices for items dynamically, by every VAT. It would be theoretically doable, but everything else in the shop will still rely on what's calculated in the shop, and it's an issue, as it will not be matching whats recalculated for us, for our case, in the module. Touching the order finalization process in every module that needs those net's correct is too much. Even if it was "correct" by the law when this was implemented, maybe that second option, where the totals will match, would be more correct as a default behaviour. Also, if there would be an option, let it be for turning on the current way of calculation, instead of the matching totals one.

View Issue Details

Relationships

Activities