How to fix GLJrnHed Msg: Journal is too large for its format of '>>>>>>9'

[thanvanhai (Thân Văn Hải)]

I get this error when DMT or create new GLJrnHed
SDDK Opening Balance Table: GLJrnHed Msg: Journal is too large for its format of ‘>>>>>>9’
Journal is too large for its format of ‘>>>>>>9’

[fakhruddin (fakhruddin husain)]

JournalNum is an integer value in Epicor, Try to add an integer value.

[thanvanhai (Thân Văn Hải)]

@fakhruddin

JournalNum is an integer value in Epicor, Try to add an integer value.

When creating a new number, this number is automatically generated, there is no place to enter it

[thanvanhai (Thân Văn Hải)]

@thanvanhai

GLJrnHed

The error was caused by someone affecting the GLJournalNum of GLJrnHed, so it was necessary to update the CurrentValue to be able to add a new GLJrnHed

select * from  erp.GLSequence where key1='01 '
update  erp.GLSequence set  CurrentValue=5000000 where key1=01 and Key3='GJ' and Key4='2022'

Thank you! Have a nice day!