Topic Options
#30508 - 01/17/12 06:09 AM 1,126 Application Integrity Errors in AR
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
What is this??????

-----------------------------

Data Integrity of:
Located on: I:\data\ with extension: DAT
Started at: 2012.01.16 23:00 by Susan Tennier
Job: ALL

Adagio Receivables: Application Integrity

Checking Terms... OK
Checking Account Set... OK
Checking Billing Cycle... OK
Checking Transactions... OK
Checking Customers... OK
Checking Ship To/Contacts ... OK
Customer Filters ... Checked OK
Checking Customer Alerts ... OK
Checking Customer Alert Details ... OK
Checking Contact Alerts ... OK
Checking Contact Alert Details ... OK
Checking Transaction GL Details ... OK
Orphan records for A/R Invoice 1 found.
Orphan records for A/R Invoice 2 found.
Orphan records for A/R Invoice 3 found.
Orphan records for A/R Invoice 4 found.
...
Orphan records for A/R Invoice 449 found.
Orphan records for A/R Invoice 450 found.
Invoice Batch ... 438 error(s) found
Orphan records for A/R Cash 1 found.
Orphan records for A/R Cash 2 found.
Orphan records for A/R Cash 3 found.
...
Orphan records for A/R Cash 726 found.
Orphan records for A/R Cash 727 found.
Cash Batch ... 688 error(s) found
Checking Adjustment Batch ... Checked OK

Summary

Application Integrity ... 1126 error(s) found .................................. FAILED

Finished at: 2012.01.16 23:56

Data Repair Phase

Orphan records for batch 1 removed.
Orphan records for batch 2 removed.
Orphan records for batch 3 removed.
Orphan records for batch 4 removed.
...
Orphan records for batch 449 removed.
Orphan records for batch 450 removed.
Orphan records for batch 1 removed.
Orphan records for batch 2 removed.
Orphan records for batch 3 removed.
...



Edited by Andrew Bates (01/17/12 07:12 AM)
Edit Reason: Removed redundant cut & paste info,
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top
#30512 - 01/17/12 07:10 AM Re: 1,126 Application Integrity Errors in AR [Re: SusanTennier]
Retired_Guy Offline
Adagio Master

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

You said that you installed AR 9.0C yesterday. From the A/R 9.0C Release Note:
Quote:

  • When the batch status information is cleared after printing the Batch Status report or by Period End, batch records for the associated batches are now also deleted. This may take a few minutes on a large database across a network. A progress bar is shown during this time. If the entire ranges is selected and there are no open batches this process will be instantaneous. When the batch status information is cleared at year end this process is also instantaneous. The Data Integrity Check now detects and removes orphan batch records for which there is no corresponding batch status record.

_________________________
Andrew Bates

Top
#30513 - 01/17/12 07:14 AM Re: 1,126 Application Integrity Errors in AR [Re: Retired_Guy]
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
So, nothing to worry about then? Everything looks fine in general.
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (AudreyQuick), 62 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14458 Topics
70634 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