March 1, 2007 at 7:12 pm #11647JGaskaParticipant
Error message “The system ledger has reached its limit” appears when trying to post to a small cross account
I had this problem in a set of books years ago and can’t remember the reason or the fix.March 2, 2007 at 12:09 am #13595TThibodeauParticipant
An account can only hold about 64000 entries.
Create a new account or journal
ThomasMarch 2, 2007 at 1:02 am #13596JGaskaParticipant
Thank you for the response. This account has only 70 items in it and the cross account approximately 8000. Well short of 64000 entries. As an interim measure a new account will be created, but I am still concerned that this error message has appeared and no entries were allowed to a 70 item account.March 2, 2007 at 2:43 am #13597HMahParticipant
Backup your data and run Reorganize. It is probably the size of the books. If it is a ledger size, NV stores more info on Ledgers than the number of entries shown. Re-organize will clean up the data.March 2, 2007 at 3:48 am #13598BHalpinParticipant
Henry’s got the solution right. Here are the details of what you’ve run into.
Every account stores a number to be assigned to the next transaction to be added to the account’s ledger.
This “next transaction number” starts at zero when the account is created.
Every time a ledger item is added to the account (either directly by adding an item to that ledger, or by posting an item from another account) the counter is incremented by one and the transaction is ‘stamped’ with the new number.
The number maxes out at 64k – once the next transaction number reaches that point then no further transactions can be added to the account.
The next transaction number is *NOT* decremented when you delete or purge transactions.
So, why would you get that error if there are only 70 or 8,000 ledger items in it? It’s because over the life of that account 64k items have been added – whether they are still there or not does not matter. Look at it this way: Say you you create a new account. Then you insert a ledger item and then delete it. Repeat the insert and delete 64k times and you would get the ledger item limit exceeded error even though the account is empty.
Fixing it, as Henry suggested, it straightforward. Backup the books and then run Reorganize Books. In this process all accounts are newly created (with the next transaction number at zero) and it will only be incremented as many times as there are ledger items added to the account when the books are rebuilt.
The end result will be you account’s next transaction number will be reset to whatever count of items are currently in the account (70 or 8,000) and you can continue posting to/from the account.
- You must be logged in to reply to this topic.