Follow

Database Error 12899

Problem Details:

Trying to submit a GL journal entry, this error message (or some variation) appears:

"Database error 12899: value too large for column "AC02_OWNER_01"."GLBATCH"."REFERENCENO" (actual: 45, maximum: 40)

 

Solution:

This may be related to using the reverse date field in the journal entry.  The user will enter data into a field, and the system may combine that value with other data to populate the field in the reversing entry.  The combination of data has caused the value to exceed the maximum limit of the field. The user will need to reduce the amount of characters entered into the original field (in this specific example, the reference field). 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk