The field Histtype in the table Rm00104 has two values 0 and 1. When you run a query selecting value of type 0 or 1 could have an effect on total sales or cash. Does anyone know what the difference is between these two? Is there a program that can be run to re-sync the values in this table?
I believe the difference is whether the data is calendar year or fiscal year. They two records would be the same if your fiscal year is the same as the calendar year, otherwise they would (and should) be different.