Unable to load deposits & cheques in the bank reconciliation Module due to an error message stating “The length of the string is 21, but it must be less than or equal to 20 Characters” Un-applying & Reversing the identified Value does not solve issue.
*This post is locked for comments
Hi jerry,
I am glad we are on the same page...
When we post any journal in NAV, it is posted to the equivalent Ledger which is like the Main Table of any Transaction(holds all the related primary or secondary values). If you want to modify any ledger then you will have to cancel the transaction(by entering negative transaction which will nullify last transaction) and re-post another journal.
****
Modifying ledger directly is not an option in NAV. It is there to protect the transacted values and maintain the consistent data.
Note: Though if you want to modify certain value from development environment with Developers license on, then it can be achieved, but this is not recommended...
***
For second part, even if you enter any value manually or load any value manually , if the recipient fields value is 20, then it is impossible(i don't like using this word) to push a value larger than 20 into it... this is like you want to put 2 liter milk into 1 liter container...
****
SOLUTION
****
So the solution i see is either try to shorten the length of that field (you were mentioning), or report the journal....
Hi Rabindra
Thank you for your help.
The value generating the error is from a Payment Journal's External Document No. field. In the Payment Journal we were able to post a value longer than 20 characters, however it seems like the Bank Reconciliation can only contain a maximum of 20 characters. Therefore when trying to use the Suggest Lines function to load the bank reconciliation lines, the error appears.
Are you aware of the possibility of either of the following:
1) adjusting the value of a Posted Payment Journal's External Document No. field
2) manually loading the bank reconciliation line even though it exceeds the 20 character limit
Thanks
Jerry
Hi jerry,
This error occurs when the length of the Value/Date is greater than the capacity of the field where it is to be filled in...
For Example in your case: you are trying to load "Deposits & cheques" into the Bank reconciliation, here probably, the length of Some code that will be eventually be populated in the Bank reconciliation page is larger than the field...
The simplest solution i see here is to check the length of each field from Deposit and Cheque and try to adjust within lenght 20...
Technically you can debug the transaction and see which is the value where system is generating the error...
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (