Hello,

I use Payables 8.0A (060626), and when i try to find a vendor, inside the Vendor code window by pushing F6, and i type in the new screen Vend # containing , .i.e... WA,, the following message appears...
Internal Error: field number is out of range

Thank you in advance

Andreas

Hi Andreas,

An error message that contains something like 'field number is out of range' typically has to do with a mismatch between the data and the dictionary used for reading the data.

If you look in the \softrak\dict directory, you can find the Adagio Payables 8.0A dictionary files @P80AI.SSI and @P80AR.SSI. They should both have a file date of Apr 10, 2006. If they do not then you may want rename what you have and re-install Adagio Payables.

Have you installed any other upgrades apart from Receivables?

The problem could have happened if you installed an update for Adagio OLEDB, as this put in an incorrect Adagio Payables dictionary. If this was the case for you, you can either re-download the OLEDB upgrade or contact Softrak for a new set of fixed AP dictionaries that will address this problem.

For some reason we cannot print standard detail transactions.

Any ideas?

Are you refering to the Vendor transaction Listing? Run \SOFTRAK\SYSTEM\CHKSYS.EXE and post what it reports.

Thank you for the help. Here are the results from the dialog window.

======= Checking Special System Configurations ======
. . . No unusual NT network configuration detected.

========== Checking 32-bit System Status ==========
--- OK ---
========== Checking 16-bit System Status ==========
--- No 16-bit programs installed on this workstation ---

======= Checking Report Tables Configuration =======
*** NOTE: Report Tables drive for 32-bit products is: [M:].
*** NOTE: No Report Tables drive for 16-bit products.

=============== Checking Products ==============
Adagio Invoices Status:
*** Configuration error - missing entry in M:\qrasp\qrtables.ini.
Adagio Invoices Status:
*** Configuration error - missing entry in M:\qrasp\qrtables.ini.
M:\qrasp\QRTQIW80.qrw
Date: [09/08/2006] OK.
M:\qrasp\QRTQIZ80.qrw
Date: [09/15/2006] OK.
M:\qrasp\QRTQIB80.qrw
Date: [12/06/2005] OK.

Adagio Ledger Status:
M:\qrasp\QRTALW65.qrw
Date: [03/26/2003] OK.
M:\qrasp\QRTALZ68.qrw
Date: [09/17/2002] OK.
M:\qrasp\QRTALZ80.qrw
Date: [04/28/2006] OK.
M:\qrasp\QRTMCW80.qrw
Date: [08/12/2003] OK.

Adagio Payables Status:
M:\qrasp\QRTAPW68.qrw
Date: [03/17/2006] OK.
M:\qrasp\QRTAPZ80.qrw
Date: [10/05/2005] OK.
M:\qrasp\QRTAPB68.qrw
Date: [07/07/2004] OK.
M:\qrasp\QRTAPT68.qrw
Date: [12/27/2002] OK.
M:\qrasp\QRTAPJ68.qrw
Date: [09/13/2004] OK.

Adagio Receivables Status:
M:\qrasp\QRTARW10.qrw
Date: [11/24/2006] OK.
M:\qrasp\QRTARB68.qrw
Date: [11/13/2003] OK.
M:\qrasp\QRTARZ80.qrw
Date: [11/30/2006] OK.
M:\qrasp\QRTMCW80.qrw
Date: [08/12/2003] OK.


. . . . 1 Error(s) and 0 Warning(s) Reported.
================== Finished ===================


Do you want the detailed log instead?

Howdy! I was hoping to hear back today on this issue because we still cannot get this report and this is becoming a tad important!

Also note that their is an error in the Invoices module...

Hey, any help would be really appreciated!!!

Cheers, JK!

Hi JK,

We need to know which report you are referring to (specifically). There are several Payables reports that show transactions. Also, can you preview it? Can you print the report from the sample data?

Hi JK,

We need to know which report you are referring to (specifically). There are several Payables reports that show transactions. Also, can you preview it? Can you print the report from the sample data?

Hi Andrew and thanks for getting back to us.

The report is: Reports/Transaction and Analysis Reports/Vendor Transactions

The reports works fine for the other companies that we maintain.

We just ran a data integrity check and got ?Application integrity skipped due to errors in File Integrity? The last integrity check was Dec 4.

Any idea as to what could have caused this problem and more importantly, how to resolve the issue?

With thanks as usual and,

Cheers, JK!

OK - it appears to be data related.

How about making a backup of your data, running the integrity check and selecting Rebuild and then running the integrity check again.

You should make a note to check out anything that is "fixed" during the rebuild process.

Thank you Andrew.

I will tackle this tomorrow (Sat) and post up the results.

Cheers, JK

Hi JK,

Start a new thread if you need more help.

Hi JK:

At this point your choices are:

1) Rebuild: After you are told that the Integrity Check fails, you will see a "Rebuild" button available on that screen. It will try to repair the damaged data. If it completes successfully, immediately run Data Integrity Check again then check the key reports. NOTE: YOU MUST BACKUP YOUR DATA BEFORE RUNNING A REBUILD.

2) Restore: Using your backups, restore the most recent good dataset. Copy then delete the current files first. Then re-enter any entries made since then. If you are uncertain which files to restore, talk with your Adagio reseller.

3) Data Repair: Send your data to Softrak. They can fix the data. This is a billable service.

Thank you Andrew for your assistance.

Cheers, JK!