DATA RECOVERY: Error *overflow* appears in reports or the Chart of Accounts List screen

  • 1
  • Article
  • Updated 4 weeks ago
When viewing the Chart of Accounts list screen or any report if you see *overflow* instead of the amount it means that the value exceeds 4,294,967,295.99

In the example screenshot below, you can see that the Accounts Payable account is showing overflow in the Balance Total column.





This is a limitation of the software.

The reason that the value exceeds 4,294,967,295.99 could be due to:

a) one or more damaged transactions

b) the cumulative total of undamaged transactions that have large values



You will need to perform a file maintenance procedure (Verify Data) to confirm what errors are present in the data file.

DATA RECOVERY: Important Recommendations for password, backup and file maintenance on the Reckon Accounts desktop platform

DATA RECOVERY: Important Recommendations for password, backup and file maintenance on the Reckon Accounts Hosted platform


Performing the Verify Data procedure will generate an error log of what has been detected.

The QBWIN.LOG (error log) will indicate whether there are damaged transactions that are contributing to the overflow issue.







Solution / Workaround 1:

Export the report to Excel where the value will be shown instead of the *overflow*


Solution / Workaround 2:

Locate the transaction(s) that have very large values that are in the millions to determine which are contributing to the very large total.

- if the transactions are not supposed to have such a large value, then they may be damaged

* Delete the transaction and confirm whether the *overflow* no longer appears

* Re-enter the transaction with its correct amount and confirm whether the *overflow* re-appears



Solution / Workaround 3:

Locate the transaction(s) that have very large values that are in the millions to determine which are contributing to the very large total.

- if the transactions are supposed to have such a large value, test to confirm whether deleting them will resolve the *overflow* issue

* Delete the transaction(s) one at a time and confirm whether the *overflow* no longer appears

* This may require the deletion of a large number of transactions, depending on the large value in each


Solution / Workaround 4:

Locate the transaction(s) that have very large values that are in the millions to determine which are contributing to the very large total.
- if the transaction is supposed to have such a large value, then consider re-assigning it to a different account temporarily

* Create a new account(s)



* Edit the transaction and change the existing account to reference the new account(s)

* Confirm whether the *overflow* no longer appears

* Repeat this process on as many of the transactions that have a large value until the original account no longer shows the overflow text






You can also consider submitting a data file to undergo analysis.

We will ask you to provide a copy of the current data file and the QBWIN.LOG to confirm you have performed the Verify Data process.

DATA RECOVERY: How to submit a Reckon Accounts business range desktop data file for analysis

DATA RECOVERY: How to submit a Reckon Accounts Hosted data file for analysis



Regards,

Data Recovery Team





Photo of Data Rec

Data Rec, Employee

  • 7,796 Points 5k badge 2x thumb

Posted 4 weeks ago

  • 1

Be the first to post a reply!