re: Payables 8.04 - Reports/Transaction and Analysis Reports/Vendor Transactions - more data integrity problems!!!

Hi Andrew,

As per your request I have started a new thread on this topic.

Problem: Suddenly the Vendor Transaction report show no data for any & all ranges.

Actions taken: At this stage we have performed the standard Integrity Check (IC) and Verify (V) and Rebuild (RB) procedures including a back up to provide a roll back position and to that end, please find all the log activity towards the end of this posting.

After the IC/RB/V/IC cycle was completed we ran the report once again and found no data at all for any vendor. This is the same problem that we had at the outset as we are certain that data should be reported.

Clearly, I beleive that we once again have a database integrity issue as the software reports perfectly well on other databases.

As we have had an occurence of this type late last year and as we have followed all the documented networking protocdols (including the registry entries) we are very interested in not only a recovery but in determining the causational factor(s) so as to avoid this occuring in the future.

I thank you in advance for your help and,

Cheers, JK!

//----------------------------------------------------------
Data Integrity of:

Located on: K:\SNL\ with Extension: SNR

Started at: 2007.01.27 12:06:02 by DOUG HAAGENSON

File Integrity Phase



A/P Batch Status Control ... Checked OK
A/P Control Account Sets ... Checked OK
A/P Bank Account Sets ... Checked OK
A/P Bank Account Options ... Checked OK
A/P Bank Account Sets Extension ... Checked OK
A/P Distribution Codes ... Checked OK
A/P Distribution Sets Header ... Checked OK
A/P Distribution Sets Detail 65 ... Checked OK
A/P Vendor ... 1 error(s) found
A/P Vendor Extension ... Checked OK
A/P Vendor Payee ... Checked OK
A/P Vendor Notes Header ... Checked OK
A/P Vendor Notes Detail ... Checked OK
A/P Vendor Alerts ... Checked OK
A/P Terms ... Checked OK
A/P Tax Descriptions ... Checked OK
A/P System Check Paylist ... Checked OK
A/P Check Reconciliation Header ... Checked OK
A/P Check Reconciliation Detail ... Checked OK
A/P Check Reconciliation Pending ... Checked OK
A/P Transactions ... Checked OK
A/P Transaction History ... Checked OK
A/P Transaction Matching ... Checked OK
A/P Retainage File ... Checked OK
A/P Revaluation Criteria ... Checked OK
A/P G/L Disbursements ... Checked OK
A/P Profiles ... Checked OK
A/P Smart Finder Control ... Checked OK
A/P Import Defaults Field Values ... Checked OK
A/P Import Export File header ... Checked OK
A/P Import Export file Details ... Checked OK
A/P Manual Check Batch Header 1375 ... Checked OK
A/P Manual Check Batch Detail 1375 ... Checked OK

Application Integrity skipped due to errors in File Integrity
Finished at: 2007.01.27 12:19:42

//----------------------------------------------------------
Started at: 2007.01.27 12:22:25 by DOUG HAAGENSON

Data Repair Phase

Rebuilding ...
Rebuilding A/P Vendor ... Done

Finished rebuilding File Integrity errors. Please repeat Data Integrity Check.

Finished at: 2007.01.27 12:22:41


//----------------------------------------------------------
Data Integrity of:

Located on: K:\SNL\ with Extension: SNR

Started at: 2007.01.27 12:24:41 by DOUG HAAGENSON

File Integrity Phase

A/P Batch Status Control ... Checked OK
A/P Control Account Sets ... Checked OK
A/P Bank Account Sets ... Checked OK
A/P Bank Account Options ... Checked OK
A/P Bank Account Sets Extension ... Checked OK
A/P Distribution Codes ... Checked OK
A/P Distribution Sets Header ... Checked OK
A/P Distribution Sets Detail 65 ... Checked OK
A/P Vendor ... Checked OK
A/P Vendor Extension ... Checked OK
A/P Vendor Payee ... Checked OK
A/P Vendor Notes Header ... Checked OK
A/P Vendor Notes Detail ... Checked OK
A/P Vendor Alerts ... Checked OK
A/P Terms ... Checked OK
A/P Tax Descriptions ... Checked OK
A/P System Check Paylist ... Checked OK
A/P Check Reconciliation Header ... Checked OK
A/P Check Reconciliation Detail ... Checked OK
A/P Check Reconciliation Pending ... Checked OK
A/P Transactions ... Checked OK
A/P Transaction History ... Checked OK
A/P Transaction Matching ... Checked OK
A/P Retainage File ... Checked OK
A/P Revaluation Criteria ... Checked OK
A/P G/L Disbursements ... Checked OK
A/P Profiles ... Checked OK
A/P Smart Finder Control ... Checked OK
A/P Import Defaults Field Values ... Checked OK
A/P Import Export File header ... Checked OK
A/P Import Export file Details ... Checked OK
A/P Manual Check Batch Header 1375 ... Checked OK
A/P Manual Check Batch Detail 1375 ... Checked OK

Application Integrity Phase

Checking Terms... ... Checked OK
Checking Distributions... ... Checked OK
Checking Account Sets... ... Checked OK
Checking Banks... ... Checked OK
Checking Transactions... ... Checked OK
Checking Retainage Transactions... ... Checked OK
Checking Vendors... ... Checked OK
Checking Temporary Files... ... Checked OK
Checking APM1375 ... ... Checked OK

Data integrity check was complete with no errors.

Finished at: 2007.01.27 12:46:43

Pray tell, what is with the clock on this forum???

John:

If it is not a database issue then it could be one of either a temp file specific to this database that did not get deleted or it could be an invalid range selection on the report filters.

Often the problem can be as simple as setting a filter from <blank> to <blank>. This means to start and stop before the first record so no records will be returned.

To eliminate the first go to the users c:\documents and settings\%userprofile%\local settings\temp folder and delete the contents.

To eliminate the second;
a. open this database
b. under the edit menu select Company Profile
c. on the system report options tab look for and deselect 'remember report settings' (about 2/3 of the way down).
d. click OK and close the database. This will reset all of the report filters back to the default.
e. reopen the database and try the report again without changing any of the filters (click on preview so that you do not eat up a ream of paper).

If the report works then re-apply any filters you were trying to use. If the report stops working again then it is your filter(s) that are a problem. Use the finder to validate any filters you are trying to use.

Doug! You are a good man sir!

I'll give it the old college try and thank you in advance for your troubles!

Cheers, JK!

Doug! Thank you so much sir! That did it.

The problem was very close to what you indicated but I beleive to be related to the fact that there was an old profile in the users folder that translated (you know: from USERNAME.DOMAIN to USER~.DOM~ that contained some files as well and as soon as I toasted that unused folder, the report printed.

Weird...

Now, I'll go and do the same fix elsewhere...

Thanks again for the tip "you are GREAT!" and,

Cheers, JK!