When you look at the customer purchase history and you add up all the individual items that they purchase, It doesn't match with the sales total box. Example: I have a customer brought 5 items in the past at $1 dollar each and you can see the each purchases under the "Purchase History" tab, but the total sales doesn't match and which shows Total Sales of $35. Is there a SQL statement to get the "Total Sales box updated correctly?
Thanks for your help Dave
Sorry it took so long to reply back. I just got back from vacation. Anyways, I'm not sure if I an explaining the issue correctly. When you look up a customer in the POS and go to the "Purchase History" tab. You can see individual item purchases on what they brought in the past. When you add them up by calculator(Manual) it gives total of $500.00. When you look at the "sales total" box above. It has a total of $1000 which is not correct. I run customer report which shows the correct $500 sales total. What I don't understand is how the higher amount $1000 is coming from, and can I run some sql statement to update "Sales Total" correct amount.
Thanks Dave
"Rick@ASP" wrote:
Did anyone at Microsoft ever give you an answer to this? I have the same exact problem, and I think it happened when we transitioned to HQ. I would be curious if this was ever addressed.
Joel, This issue you're reading is about you. Nobody had a real answer except for 2 reasons this might possibly happen. One is the "sale totals" could of been imported into the database from a previous system or excel sheet. The second reason would be if you deleted a item from the database that was sold in the past that would remove the the item sales history.
Dave
"Joel Richman" wrote:
Have something to add? Share your thoughts — no account required.
Ask the community — no account required