That is because it only is calculating on the orders in total, it does not look at any statusses.
You need to delete an order to get it removed from the totals.
You need to delete an order to get it removed from the totals.
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
I think it needs a lot of coding for that.RajaA wrote:Is there no way of putting the order status check into the equation when its calculating the Total Sales?
Have a look at Full report.. !!.
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
What I did was create a product for my refunds and gave it a -1.00 price. Made a category named refund. Then I made sure that both refund category and the refund product are disabled for obvious reasons.
Now say you have a product that the cost was $4.95 you would make the tax be 395%
Then that would be -1.00 X 3.95 = -3.95
-3.95 + -1.00 = -4.95
Ta-da you can now add that product in the admin for any refunded products and your total will be right.
May not be optimal but it works and you get to show the refunded amount on the invoice as well.
Now say you have a product that the cost was $4.95 you would make the tax be 395%
Then that would be -1.00 X 3.95 = -3.95
-3.95 + -1.00 = -4.95
Ta-da you can now add that product in the admin for any refunded products and your total will be right.
May not be optimal but it works and you get to show the refunded amount on the invoice as well.
you can add it to model/sale/order.php in the getTotalSales and getTotalSalesByYear functions, in the WHERE part of the query clauseRajaA wrote:Is there no way of putting the order status check into the equation when its calculating the Total Sales?
This issue still exists in version 1.5.4 please fix because it affect our taxes we have to pay!
True!ironspeeder wrote:This issue still exists in version 1.5.4 please fix because it affect our taxes we have to pay!
You can still filter on order-status.
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
I have this bodge that works really well.
Make a product that has a price of minus $1.00. product ID "rebalance dashboard"
Work out how much your dashboard is out by e.g.Adjustment = Dashboard sales - Total completed sales
On a test account purchase Adjustment x "rebalance dashboard"
Set the sale to canceled and you are done. The dashboard total will now match completed sales.
Don't forget to make sure to set the product ID "rebalance dashboard" to disabled when you are done. You dont want your customers to buy this item!
Make a product that has a price of minus $1.00. product ID "rebalance dashboard"
Work out how much your dashboard is out by e.g.Adjustment = Dashboard sales - Total completed sales
On a test account purchase Adjustment x "rebalance dashboard"
Set the sale to canceled and you are done. The dashboard total will now match completed sales.
Don't forget to make sure to set the product ID "rebalance dashboard" to disabled when you are done. You dont want your customers to buy this item!
Who is online
Users browsing this forum: No registered users and 71 guests