Problem with "Sales Since" in Customer Info?

[Melvyn]

Hi Dale/Andrew,

I am using the "sales since" option to pull data from customer info. Noticed that when I select "this customer", the figure is correct, but when I select "all customers", some records (particularly a section of about 20 customers), show $0 sales since.

Could this be a corruption of my customer database?

Thanks for your advice,
Melvyn

[ChrisKraus]

Well, I think its just a bug and your Customer Database is fine. But I am not sure about it, I think it might need to be looked into a little more.

- Chris

[Andrew]

What date are you entering for sales since? The date you enter is the earliest date for which you want to include sales in the totals.

So when POS searches it uses the criteria: Include all sales from the date RIGHT NOW back to (the date you enter). So if you enter today's date, or a date in the future, you won't have much luck.

[Melvyn]

Hi Andrew,

The date is not the problem (I entered dates in 2003 and used the same date for both options of "this customer" and "all customers"). But since the problem affects only a section of my customer info i.e. about 20 records in the middle of the database, I suspect it may be a corruption.

Any thoughts on this?

Thanks
Melvyn