Daily and monthly production reports don't match

[drtmz]

Here is the problem.
I printed out a Daily Production and Income report as I do every day for December 1, 2 and 3.
According to the reports the Total Production (Production + Adjustments - Writeoffs) for
12/1/08 is $769.00
12/2/08 is $1432.00
12/3/08 is $12.40
Total $2,213.40

The Annual Production and Income report shows a total of $650.00 for the month of December.

We are on version 6.1.12

Anyone else notice this?

[jordansparks]

So the daily and monthly reports match, but it's the monthly value on the annual report that's wrong, right? Make a backup of your database as it is now. We will need that backup folder in order to debug it on our end. You've run the db maint tool, right? And it's for the same providers, right?

[drtmz]

Yes to db maint tool. Everything is the same.
I will run the tool again, double check the results and make another backup before calling.

Daily does not match monthly or annual.
The monthly totals of production and income for 12/01/2008 to 12/31/2008 say;
12/01/2008 -769.00
12/02/2008 1432.00
12/03/2008 -12.40

[nathansparks]

check to make sure that you are not comparing production with total production (total production include adjustments and writeoffs)

[drtmz]

We have it isolated to the error on 12/01/2008 because today was fine and I randomly checked other days from previous months with no errors.

I will dig into 12/1 again to see what happened.