Increase the Journal Entry Number Field

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (0)

Jeyakumar 592 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Imad Kassoumah 3,235 on at

Like (0)

Report

Hi,

You can restart the number whenever you close the year.

This means you make a new counter per year.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi,

According to the Global Resource report, Data Type LI8_U0 is used 615 times in the core dictionary. Quite a job to change it.

Leslie

Was this reply helpful? Yes No