Table of Contents

Runtime error 9-subscript out of range

Legacy KB ID: 3314

Question

When creating a POS database (PDB) or performing a Transfer in QuickPOS Administrator, the following error appears:

Runtime error 9 - Subscript out of range

Answer

This error is typically caused by corrupted or misaligned data in one of the lists within the associated Reckon Accounts data file.

Step 1: Identify the Affected List

  1. When the error appears in POS Administrator, take note of which list is being processed at the time (e.g., Items, Customers, etc.).
  2. The most common list causing the issue is the Item List.

Step 2: Export the Affected List from Reckon Accounts

  1. Open the company file in Reckon Accounts.
  2. Go to: File > Utilities > Export > Lists to IIF Files.
  3. Select the affected list (e.g., Item List) and click OK.
  4. Name and save the file to a known location.

Step 3: Open and Review the IIF File in Excel

  1. Open Microsoft Excel.
  2. Open the exported .IIF file. In the Open dialogue, change the file type to All Files (.)
  3. Use the Text Import Wizard:
    1. Choose Delimited, then click Next.
    2. Select Tab as the delimiter, click Next, then Finish.
    3. If prompted about conversion, click Don't Convert.
    4. Scroll to the right so you can see the right-most column data.

Step 4: Find Corrupted or Misaligned Data

  1. Ignoring the first 10 or so rows, slowly scroll downwards from the top until you see one or more data rows where the data is shifted to the right or is empty, before you get to a row of headings.
  2. Scroll to the left to see the name of the problem item (usually in the 'B' column). Take note of where the data gets out sequence in that row. It will usually be after the 'Desc' (description') column.

Step 5: Fix Problematic Items in Reckon Accounts

  1. In Reckon Accounts, open the relevant list (e.g., Item List).
  2. Locate and edit the affected items.
  3. Re-type the value in the field that corresponds to the last correct column before the data becomes misaligned (usually the sales description or purchase description).
  4. Save the changes.

Step 6: Retry the Operation

  1. If the error occurred during a Transfer, try the Transfer again in POS Administrator.
  2. If the error occurred during POS database creation, follow the additional step below.


If you were creating a New POS Database:

  1. Delete the Current POS Database File
    • Locate and delete the file: QBPOS.pdb
  2. Create a New POS Database
    • Open POS Administrator and create a new POS database.


Need more help?

Ask the Reckon Community at: https://community.reckon.com/categories/reckonaccounts

Or Log a Support Ticket: https://www.reckon.com/au/support/

How did we do?

Reckon Desktop POS: Messaging system not working

Error message: 'Communications Port not available' when opening POS

Related Articles

Reckon Accounts Personal Range: Runtime 1517 Error
Internet Explorer v11 crashes when Reckon Accounts Personal range is launched in Windows8.1
How to restore a backup file (RKN) in Reckon Accounts Personal Range
Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)