Re: BillMax questions -- Monthlysale Nightly Reporting Errors

["Bill Max" <chicagobearsfootball@gmail.com>]

To answer my own question, using "delete from monthlysale where payhist=408457;" (for example) fixed the problem.

On 1/20/06, Bill Max <chicagobearsfootball@gmail.com> wrote:

When running /usr/local/billmax/bin/dbck -v, I receive the following errors (there are no other errors):

 

Checking Table 'monthlysale'
    ERROR: 11400...monthlysale(monthlysale.payhist=408457): Sum of monthlysale records do not match payhist record (FIX MANUALLY)
    ERROR: 11400...monthlysale(monthlysale.payhist=409074 ): Sum of monthlysale records do not match payhist record (FIX MANUALLY)
    ERROR: 11400...monthlysale(monthlysale.payhist=424558): Sum of monthlysale records do not match payhist record (FIX MANUALLY)
    ERROR: 11400...monthlysale( monthlysale.payhist=409078): Sum of monthlysale records do not match payhist record (FIX MANUALLY)
 

Per the BillMax documentation, I ran:

/usr/local/billmax/bin/create_monthlysales -a (account number)

 

The errors still exist.  Should I delete the above entries from the MySQL database directly?  Otherwise:

 

delete from monthlysale where payhist=408457;

 

I'm running the latest version on BillMax.

 

Thank you.