Query Details

The following "corruption" and "subscript out of range" issues have been noted:

Corruption Issues

- Invoicing If the unit and quantity is greyed out when linking an Invoice to an Order, the History lines (ACCHISTL.DAT) file is normally corrupt. Rebuilding this file can solve the problem.

- Reprinting Invoices when reprinting invoices and the lines come out blank, the History lines (ACCHISTL.DAT) file is normally corrupt. Rebuilding this file can solve the problem.

- Last Year Profit and Loss If you receive a report that your last year profit and loss is out of balance, you need to run the Data Integrity with the Verify and Fix option.

- Master File Balance When running the Detailed Ledger and you receive a master file balance with the total, running the Data Integrity with the Verify and Fix option, solves this problem.

- When viewing your Inventory Quantities report and you have quantities under Unposted, you need to run the Data Integrity with the rebuild batch quantities.

Solution

Subscript Out Of Range Issues

- Converting When converting from Version 3 to Version 4 and Version 5 you receive a message " Subscript out of Range" as a result of Open Batches that exist.

- Open Company When opening a company in Version 5, and you receive a message "Subscript out of Range", you can solve this by rebuilding the Open Item file (ACCOI.DAT) for this company.

Delete the default (ACCDFLT.DB0) file. You are trying to open a company that has already been opened in a later version of Pastel.

- Printing When Printing Statements / Remittances for Customers / Suppliers and you receive a message "Subscript out of Range", this is usually a result of Open Item Customers / Suppliers.

You need to change these customers, giving the message, from Open Item to Balance Brought Forward and back to Open item.

- Running a Verify when running a Data Integrity and you receive a message "Subscript out of Range", this indicates a corruption on the transactions. Rebuild the ACCTRN.DAT, ACCHISTH.DAT and the ACCHISTL.DAT files. Alternatively send the data in for a data fix.

This can also indicate the paper size being incorrectly specified.

- Report Writer when you run a report in Report Writer and you receive a message "Subscript out of Range", you need to rebuild the transaction file (ACCTRN.DAT) to solve the problem.

- Inventory Journals When Updating a batch in the Inventory Journals and you receive a message "Subscript out of Range", confirm that under Setup > Entry types > Contra in detail is checked.

- Overflow when receiving an "Overflow" message while processing documents, you need to rebuild the History lines (ACCHISTL.DAT) and History header (ACCHISTH.DAT) files.