Page 1 of 1

Duplicate/Triplicate Records - Vendor Activity Summary

Posted: Thu May 17, 2012 5:46 pm
by R.V.Fagan
I am lost to understand why I'm seeing duplicate and triplicate records in my "Vendor Activity Summary Report". Some records only have a single entry. The subtotal for each vendor includes all records, meaning they are sometimes double or triple the actual activity.

I ran a cheque register report, and each cheque is only there once.

Comments or opinions?

Re: Duplicate/Triplicate Records - Vendor Activity Summary

Posted: Thu May 17, 2012 6:27 pm
by tborgal
The first thing I would do is to reindex. This can be found under the Utilities menu.

Re: Duplicate/Triplicate Records - Vendor Activity Summary

Posted: Thu May 17, 2012 8:02 pm
by R.V.Fagan
tborgal - Thanks for that suggestion. I completed a re-index, however, I still have the problem. I'm still open to suggestions.

Re: Duplicate/Triplicate Records - Vendor Activity Summary

Posted: Thu May 17, 2012 10:01 pm
by NeilZ
R.V.Fagan wrote:tborgal - Thanks for that suggestion. I completed a re-index, however, I still have the problem. I'm still open to suggestions.
Unfortunately, it sounds like a corrupted database .. you may have to call Powerchurch directly on this one.