Wrong calculation

Hi there,

you might activate extended logging and start the report again to generate the log files which may be accessed via WooCommerce > Status > Logfiles

https://gist.github.com/vendidero/0f7658a9ba175b75fb96759409eef104

Cheers

Thank you.

I activated extended logging. you can see the log-file here:
https://drive.google.com/file/d/1QZxSjD8uCMBAj_myxs9buw9MM7PPl9Zm/view?usp=sharing

I exported every Order from NL to an excel file.
https://docs.google.com/spreadsheets/d/1HRdGu3jWZz7R2z2lgf68fKGi68G9t2Q3/edit?usp=sharing&ouid=102640938292344730840&rtpof=true&sd=true

But your plugin provides different values:
https://drive.google.com/file/d/1Qj0cofp_WUreSBYnJsBE38COC3usxEMs/view?usp=sharing

I do not really know how to help you out on this as you might need to investigate that but as far as I can see, there exists a discrepancy between the orders found by the OSS tool and your export file. #14135 is not included in your export file but included in the logs. What is your current base country?

#14135 is an order from DE not NL.

If you look closely you will see that your plugin found the very same 17 orders from NL as my export.

BUT your plugin calculates the sum wrong.

The base country is Austria (AT)

#14135 is an order from DE not NL.

And why would this order not be included in the report? It’s a valid OSS order and will therefor be included within the OSS report. You might need to check for refunds too (which might not be included within your custom export file).

From the log file:

2022-04-27T09:50:23+00:00 INFO Processing order #13370 (shop_order_refund) based on taxable country NL
2022-04-27T09:50:23+00:00 INFO Tax total 21 = -459.24
2022-04-27T09:50:23+00:00 INFO Net total 21 = -2186.8571428571

Cheers

Thank you very much.

this was MY mistake.