JC
Asked
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
- JCAnsweredAny solution to this yet? Thank you
- MSAnsweredHello,
The calendar sales are calculated from `sma_sales` table while the profit and loss is calculated from the `sma_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? - JCAnsweredThere 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 - JCAnsweredupdate please?
- MSAnsweredHello,
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 - Login to Reply