Question: Total Sales From Daily Sales Report Is Incorrect

Total Sales From Daily Sales Report Is Incorrect

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

JC

John Guilbert Caringal

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

  • JC

    John Guilbert Caringal

    Answered

    Any solution to this yet? Thank you

  • MS

    Mian Saleem

    Answered

    Hello,

    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?

  • JC

    John Guilbert Caringal

    Answered

    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

  • JC

    John Guilbert Caringal

    Answered

    update please?

  • MS

    Mian Saleem

    Answered

    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

  • JC

    John Guilbert Caringal

    Answered
  • Login to Reply