Topic Options
#5903 - 05/03/06 04:33 PM data integrity check in payables
Holquist Offline
Adagio Guru

Registered: 09/20/02
Posts: 121
I got a weird access violation when I was posting a manual check. So, I did a data integrity check and it showed 8 errors where computed balance does not match stored balance on two vendors. I did a backup and then told it to rebuild and it indicates that it fixed the 8 errors. But, when I run a data integrity check again the same 8 errors come up.

Top
#5904 - 05/03/06 09:46 PM Re: data integrity check in payables
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4509
Loc: Wynnewood, PA
Cycle through rebuild and recheck until the errors go away. Sometimes it can take three cycles.

If they still don't go away, let us know.


Top
#5905 - 05/04/06 10:18 AM Re: data integrity check in payables
Holquist Offline
Adagio Guru

Registered: 09/20/02
Posts: 121
I cycled through about 10 times and they are still there. The two vendors that have the 8 errors (4 errors each) are two vendors which have appeared on my open payables report since 2003. They each have an invoice and then an adjustment was made to reverse the invoice but instead of "going away" 3 years ago, they continue to be on my open payables report showing the invoice and the adjustment and a zero current amount. Any suggestions??

Top
#5906 - 05/04/06 11:52 AM Re: data integrity check in payables
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hello Holquist,

Could you ZIP up and send me the data to look at?

Thanks


Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (Lauren Stief), 60 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14458 Topics
70633 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30