Simple Invoices logo
    • CommentAuthor3cwired_com
    • CommentTimeOct 21st 2006 edited
     permalink
    Ok for these two reports I get two completely different values. An example of the values are:

    Sales in total
    4842.33

    Sales in total by customer
    1,745.98

    Why is there a difference in the calculations?
    • CommentAuthorseesaw
    • CommentTimeFeb 2nd 2008 edited
     permalink
    I had this problem, it's due to the database having sample data in it. Use phpMyadmin to edit your database directly and remove any items in si_invoiceitems that you have not created. Do the same in si_payments and si_invoices. Make sure you do a backup of your database first.

    It will leave a few gaps in your invoice numbering, but your sales figures will add up correctly.
    • CommentAuthorjustin
    • CommentTimeFeb 3rd 2008 edited
     permalink
    Thanks for the update Chris,

    note: we have had a few issues in the past of similar reports saying different stuff - due to sql issues - but all is well now (last time i checked anyway :) )

    Cheers

    Justin