Subscript Out of Range
3.35 Rating/ 3 Voters
AuthorJohn North Article Reference NumberAA-00106 Views303 2009-09-25 14:00:00 2009-09-26 08:18:21

CERTAIN CIRCUMSTANCES WHEN THIS OCCURS AND HOW TO FIX IT

ISSUE:
Subscript Out of Range is a Visual Basic error message; the most common reason for a
Subscript Out of Range error message appearing is data corruption.

Note it is essential that backups be made before proceeding with any of the steps below
 

EXAMPLE 1: SUBSCRIPT OUT OF RANGE IN INVENTORY JOURNALS
When you enter inventory batches, Pastel does not use Btrieve to write the batch files. This means that these batch files are more liable to corruption than most of the Pastel data files. In the unlikely event that an inventory batch file corrupts, you will encounter a "Subscript out of Range" error when you attempt to enter data in or Update the batch. In order to continue working, you need to delete the batch files and then re-enter the information.
 
To delete a corrupt inventory journal batch:
 
Using Windows Explorer locate the directory in which your Pastel company data exists (e.g. P:\PAS60)
Locate inventory journal batch files for your user ONLY (inventory journal batch file names have the following format):
ACCBSJ.uuu, ACCSJCTL.uuu, ACCTGRID.uuu
where uuu is the user number (0-099).
You can obtain the user number from the Setup...Users/Passwords menu option.
3.   Right click on the appropriate file and click Delete

You need to delete each of the above 3 files for the user number where there is a corruption. You will also have to re-enter the batch information itself.

Rss Comments(0)
There are no comments for this article.
Info Add Comment
Nickname: Email (will not be shown): Subject: Question:
Subscribe to updates Subscribe to Updates
Email to a frien Email to a Friend
Print Print Article
Info Rate it!