@lubos@shahabb@Tut@Joe91@Patch
In custom report, i noticed that the quantity on the cost of sales has caused the total qty to increase (3 times) falsely. find the below example:
The first 2 rows represent the cost of sales which the AMOUNT offset each other but that is not the case under QTY because they are adding up which automatically increase the Total qty.
If my analysis is right, i want to suggest that the cost of sales rows be removed outrightly OR negative be introduced into the 2nd row of cost of sales qty so that they can offset each other just like the AMOUNT.
This is how I generate my sales report by exporting to excel. I get a very detailed sales report. Sales report by: customer, qty they bought, total amount, inventory they bought, etc, at just a glance. This is a “all in one” sales report for me.
Also select General Ledger Account as column and look to which account these rows belongs. Filter accounts which you are not interested in.
Btw if you are just after Sales and not interested in Cost of goods sold also add this
