Conversation
supportThe calculated tax amount for one country (NL) is wrong. Is there a way to see the orders on which the calculation is based one? Because if I export all payed orders from that country (with an export plugin) I get different values. Thank you for your help
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.
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.