The total sales doesnt match the product revenue on daily sales report. Please see the screenshot attached Product revenue only shows 18,453 but the total sales shows 18,533
- JCAnswered
Any solution to this yet? Thank you
- MSAnswered
Hello,
The calendar sales are calculated from
sma_sales
table while the profit and loss is calculated from thesma_costing
table. I can see that you don’t have any order related tax/discount. I am not sure what caused this but the values in both tables are different that caused this. Was there any edit to sales made or any other action that can help me rectify the cause? - JCAnswered
There were no edits made to the sale. Sales tax is also set to 0 and no discount.
I dont understand why I am getting a different value of the total sales.
In my understanding, The total sales should match the products revenue as I have no discount or tax, they are all 0
- JCAnswered
update please?
- MSAnswered
Hello,
Yes, if there is no order related discount/tax then the values should match. I have no clue what cause this but you can backup your database and attach with private reply. I can try to check which products caused this and you can investigate further.
Thank you
- JCAnswered
Sure. Please see attached
https://drive.google.com/file/d/14EtEFbOVgKl1R1JgiP_-ioHmdqow1Fll/view?usp=sharing
- Login to Reply