|
Author
|
Topic: Report Error
|
Chuck Gahr
Member
|
posted 07-01-2003 08:00 PM
  
I am on Windows XP Prof SP1, FN 8.1.2, 10 entities. When I ask for a reconcillation report for all accounts, I get the error message: Subscript out of range, Line 4800, with no option but to exit back to Windows. I have tried to check this out by running the recon report on each journal account, which all work. I have also run the check utility and it does not find any errors.
IP: Logged |
John
Administrator
|
posted 07-03-2003 08:21 AM
Let's try to isolate the problem.Does it happen with the Transaction Register report for the Category for All Accounts? A) If the problem does occur then try to isolate which month. B) If not then the problem is probably with the outstanding transactions from last year from some journal. If all outstanding transactions from last year have clear then backup the data and run Utilities | System Reconfiguration | Delete Last Year's Transactions. Run the Reconcilation Report again and see if the problem is solved.
IP: Logged |
Chuck Gahr
Member
|
posted 07-04-2003 04:16 PM
I have done what you suggested and find that the problem has improved to where only my Jan (2003) Reconcillation Report, all accounts still fails. There were some year 2002 transactions removed by the utility.
IP: Logged |
John
Administrator
|
posted 07-08-2003 08:11 AM
Ok, the problem still exists after deleting last years transactions. But the problem does not exist for the transaction register for all accounts.
Have you run Test & Correct for the Transaction file? If not then run it.Does the Transaction with Distribution report for the Category "All Accounts" run correctly? Does the Transaction by Payee report for all Payees and Payors run correctly? Does the Summary Trial Balance run correctly? Does the Detail Trial Balance report run correctly? As for the Reconcilation Report, run it for each account separately. Select each category and select each account. I know you said it ran correctly for the normal checking journals. The problem is with some other journal that has some transactions in it such as Unrealized Gains or Losses.
IP: Logged |
Chuck Gahr
Member
|
posted 07-08-2003 10:57 AM
I'll try to give all the details of the problem:
1) First I have run the test & correct for the transaction file; it comes back with all correct message. (Also all the other tests in test & correct come back OK)
2) Second, when Jan is included in the month range, all 5 of the reports in the Reconcillation, All Accounts category fail. When Jan is not in the range all five run OK.
3) I should state too, in passing, that I have renamed a great many accounts using a combination of caps and small letters. I only include this info because I notice that when I redo the starting balances for 2003, using 2002, the changed account names cannot be found between the two years -- this makes sense I think.
4) I ran Trans w/ distr for all accounts -- ran OK, even when Jan was included.
5) I ran Trasn by Payee/Payor for all Payees/Payors -- ran OK, incl Jan.
6) Ran Summary Trial Balance, incl Jan -- ran OK.
7) Ran Detail Trial balance, incl Jan -- ran OK.
8) Ran Recon for each account, in each category, incl Jan, ie, for all accounts in the COA -- all ran OK; some (many) had no transactions.
9) The problem is isolated to year 2003, month Jan in one of my entities; all else runs OK.I hope this helps you to get an idea of the status of this file. I sort of think the problem has to do with my renaming of the accounts, and some memory of the old year 2002 names still residing in year 2003. I intend to complete my account renaming this year, so that my account names will change between year 2002 and 2003, but not beyond that. My concern is that, when I start a new year, in a few months, for year 2004, that I will carry this problem forward. If that does not happen, then I don't think that this Jan problem in year 2003 will really matter much, since, in 2003, everthing works from Feb on to Jun, ie I can still get my year 2003 work done OK. What do you think?
IP: Logged |
John
Administrator
|
posted 07-09-2003 11:22 AM
Yes, you can still get your 2003 work done. The problem is with some deleted transactions in Jan with invalid data(journal#). It will not affect the reports.
It will not roll over to 2004 since the transactions are not outstanding.
Thanks for you help in isolating this problem with the invalid data.
IP: Logged | |
Navigator User Forums
UBBFriend: Email This Page to Someone! 
