Is there a way to Increase the characters allowed in the Journal Entry Number? We are currently at 8 numbers and need to increase it. Starting the Journal Entry # back to 1 is not an option.
*This post is locked for comments
The GL20000.jrnentry field is defined as a INT so its range is (-2,147,483,648) to (2,147,483,647). It is not a character field with a fixed width. If you want you can prefix it with the year provided you leave enough room for all the ledger entries within a year.
Hi,
You can restart the number whenever you close the year.
This means you make a new counter per year.
Journal Entry field Keyable Length is only 8 character.So it will allow only upto 8 character.If you want to increase,you have to change the Journal Entry field data type and all the reference fields datatype in dex.Also you have to change all the dependent Stored Procedure and tables in sql.This is not a advisable Solution.Better reset the Journal Entry randomly.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (