We have customers who monthly import large bank statement files into cash receipt journals. These files typically contain around 520,000 rows, with each row adding a corresponding entry in the journal. The "Line No." starts at 10,000 and increments by 10,000 for each new entry.
When the line number exceeds approximately 214,748, the process stops with the error message: "Arithmetic operation resulted in an overflow."
If the "Line No." started at a lower value and incremented by a smaller amount, we would be able to accommodate customers with larger bank statement files.
Comments
I think this is not a good idea, to have this global setting, because it would reduce the number of possible lines to be inserted in worksheets and document lines.Nobody stops you to reduce the line number increment while importing the lines into the journal, but i would not generally reduce the line number inclement.
Category: Financial Management
Great idea. Tangicloud will add this as an option in our Excel,Import App.
Category: Financial Management
I think a global setting which allowed you to set the "line number increments". By default, its 10k increments, so that you can add lots of lines in-between rows. For some businesses, this may be overkill and increments of 100 lines could be more suitable.
Category: Financial Management
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team