Quote Originally Posted by OldNGrey View Post
Aaargh.
Code:
AND ot.orders_id = 1GROUP BY o.orders_id ORDER BY orders_id ASC ==> (as call
There is a space missing from the front of the GROUP statement.
I have updated the GitHub file https://github.com/OldNGreyBMR/expor....7/files/admin

Please let me know if you have any other problems with this. I couldn't operate without it for monthly reconciliations.
Great it works now for the blank options too! Yes this program helps a lot with accounting :)

However I looked at the exported data more closely just now for '1 Order per row', i think there is some errors in the exported data.
Some orders are duplicated. I couldn't possibly run the whole years check now but I did quick random 2024 checks.
Once the duplicated orders are removed, the sums & orders tallied.
Any idea where is the bug?

Thanks again for your quick resolution.

Noi