While doing data entry in GP2010 we have observed the following error in GP2010:
Due to some error in unit cost in the inventory and sales module, the debit or credit amounts exceeded trillion figures and When we post these transaction into GL account, GP2010 does not post that entry and show ‘cannot inset value nul into column “DEBITAMT” or “CREDITAMT”,
However when we post the same entry in some other month, the same has been posted into the same account but in different month. In this way we have posted our all that transactions into GP by using other months.
Apparently, it seems that debit and credit column for GL account have some length limitation for the period and when transaction in that account exceeded this limit, GP2010 does not allow further entry in that period.
Now, on closing financial year in GL, this problem again appears which restrain us from closing.
One way is we go through the whole GL and identify the GL accounts which does not allow entry in June 2012 because of the reason mentioned above and then create other accounts and transfer the whole balance to that new account and then try to close, which is time consuming exercise.
Please help on the above behavior of GP2010 and how to increase that limitation or how to resolve this issue.
