|
Author
|
Topic: Error #63
|
DaleB
Member
|
posted 09-19-2002 12:31 PM
 
I was attempting a test and correct and for the following message:Bad Record # (Error #63) In line 51100 using file z:\Frank\02\act2.dat and them it shut me out of the program. What is this?
IP: Logged |
Pamela
Member
|
posted 09-20-2002 07:17 AM
Please see the post Error 63;ACT.2 problemPlease reply to THIS post if you are still experiencing problems.
IP: Logged |
DaleB
Member
|
posted 09-20-2002 04:15 PM
I did this and for Account 32767 not in indes, run rebuild account index, which I did. I then tried to run test and correct again after testing the chart of account idex which was correct I received the following: This transaction is under journal #2 Delete the transaction & re-enter 148 November 30 00 Record Petty Cash Disbursement 238 Use change review for month of 0 in account general journal. I clicked ok and got the same message except re-enter 149 then
Bad Record number (Error #63) in line 51100 and then it took me back to windows out of FN. In the year 2000 I did make two journal entries described above, but how did this get here and what do I do?
IP: Logged |
Pamela
Member
|
posted 09-24-2002 10:46 PM
Let's try and narrow down the problem:1. What version of FN are you using? (8.0.X?)
2. What Windows application are you using? (98, 2000, XP?)
3. Did you recently Begin a New Year?
4. You indicated the problem entries were 2000 entries. What year are the data files you are experiencing the problem in? 2001 or 2002?
IP: Logged |
DaleB
Member
|
posted 10-03-2002 08:12 AM
I am using fn 8.07 and Windows 2000. I did not recently begin a new year and the problem I describe with the test and correct situation (bad record number error #63)is occurring in 2002 and the 32767 not in index message was also in 2002. I was getting the journal entry messages in 2001 but I could not figure out the problem then either. It did not interfere with my 2001 files.[This message has been edited by DaleB (edited 10-03-2002).]
IP: Logged |
Pamela
Member
|
posted 10-04-2002 01:56 PM
Lets try and isolate this problem a little bit more. Back up your data files prior to following these steps.Re-run test and correct menu choices individually and locate where the error occurs. Make a note of the exact error message. If the following steps do not resolve your problem, please advise the exact wording of the error message and in which test and correct menu choice it occured in a reply to this post. If the error occurs in the Transaction file: - Determine the bad transaction and fix it. (Run transactions by account report to locate the problem once the transaction is identified in the error message.)
- If it is in the "Month 0" then it is a problem with last year's data.
- If you have cleared all transactions from last year, select Utilities | System Reconfiguration | Delete Last Years Transactions.
(Run a Reconcile report for January for the specific category or for All Accounts to determine if all outstanding transactions from last year have been cleared.)If the error occurs in the Account Alphabetical Index menu, rebuild the Account Index from Test Mode:
- Select Help | About FN.
- Press the letter "T".
- Select OK to the prompt "set to test mode".
- Select OK to the "About FN" dialog box and return to the FN menu.
- Select Utilities | Test & Correct Files | Rebuild Account Index. This will rebuild the account index file.
If the error occurs in the Chart of Accounts Index menu, rebuild the Chart of Accounts files:
- Print out a Chart of Accounts report so you have a reference.
- Set to Test mode (if not already).
- Select Utilities | Test & Correct Files | Rebuild Chart of Accounts files.
Note: this will change the group and category names back to the original FN default names. So if any group or category names were customized then they will need to be re-customized. If there is a duplicate account name in the chart of accounts then one of the accounts needs to be renamed using Accounts | Change or Delete Account Names from the FN menu. [This message has been edited by Pamela (edited 10-04-2002).]
IP: Logged |
DaleB
Member
|
posted 01-10-2003 12:58 PM
I referred to the fix for Act2. dat and did everything you said under Error 9 and found nothing. I ran rebuild account index, the ran the transaction entry report for Jan-Dec and got the message Account -32767 no in index, run rebuild account index. This was after I had already run rebuild account index, but I ran it again. I tried again and got the same message Account -32767 not in index run rebuild account index. I tried the range of months jan-june and them july -december and did not get the message. Only when I run the jan-Dec report, but I still can not roll over to 2003. This is critical for me now. Please respond to me at dbarnes@sterling-group.com as soon as possible. I need to use 2003.
IP: Logged |
DaleB
Member
|
posted 01-10-2003 01:16 PM
I forgot to mention in the prior posting that after everything else I did, I ran the test and correct utility again and when it came to accounts I got the message Bad Record Number, Error #63 in line 51100 using file z:\Frank02\act2.dat Just add this to my last posting. [This message has been edited by DaleB (edited 01-10-2003).]
IP: Logged |
fni_support
Moderator
|
posted 01-13-2003 12:52 PM
It sounds like you have an blank account recorded in one of your transactions. This account will show up as “Invalid Account #-32767” on a report for the transaction journal that it was recorded in. As a result, you probably have a “Change in Account Balance” line added to your Cost Basis Balance sheet from the month that this blank account was first recorded. Run a Cost Basis Balance sheet in December and work your way backwards until you find the month that it first occurs in. The best way to solve this problem is to find when and where this transaction occurs and select a valid account for it.Start with the month that your Change in Account balance first occurs. Run a Transaction by Account report (Report Group: Trans by Account) one by one for each of your journal accounts and look for the amount reported in your Change in Account Balance. You can also search for the account “Invalid Account”. This will tell you where the transaction occurred, and then you can fix it in Transaction Entry. If you’ve gone through all of your journal accounts and everything seems to be in order then it is likely that this transaction is in a Multiple Distribution. Run a Transactions with Distributions report (Report Group: Transaction Entries) one by one for all of your journal accounts and look for the amount reported in your Change in Account Balance. You can also search for the account “Invalid Account”. This will tell where this transaction occurred and then you can fix it in Transaction Entry. You can quickly tell if the Transactions with Distributions report for your journal account is correct by comparing the Total by Account line with the Total of Distributions line. If these two numbers do not match, than the invalid account is somewhere in the report. When you first change the blank account to another valid account, you will be prompted with “Invalid Account #-32767”. Simply click OK to continue and the system will accept your new account. Then, run Test & Correct Files for “All of the Above”. George Szundi
Technical Support
Financial Navigator Int’l
IP: Logged |
Navigator User Forums
UBBFriend: Email This Page to Someone! 
