Limitation of Auto Split Key in D 365 Business Central.

Limitation of Auto Split Key in D 365 Business Central.

All Dear Readers,

Hope you are all doing great!

Let’s start with another useful article! Limitation of Auto Split Key in D 365 Business Central.

Note: – This document contains the solution for Dynamics 365 Business Central Standard Errors, the line cannot be split and there is not enough space to insert the correction line.

The First error occurs when adding a new line such as adding a sales line.

1. To Solve any of the errors we first debug the error and find the problem, but in this case when we debug the code, the debugger doesn’t stop at the error because the first error is thrown by the platform and isn’t written in any code.

The Second error occurs when we undo a posted document as undo posted sales shipment.

1. In this second error if we debug the code then the debugger stopped at the error because Microsoft has optimized the error handling message to make the system throw an error that is easier to understand.

As shown in the debugging result, this is caused by ‘Line No.’.

Both errors occur because of a single property which is an automatic numbering feature in Business Central.

[AUTOSPLITKEY Property: – Sets whether a key automatically

created for a new record placed between the current record and the previous record.

To use this property the following condition must be fulfilled.

• The current key must be the primary
• The last field in the primary key must be an integer, Biginteger, GUID or Decimal Data ]

When we add a new record between the current record and the previous record, new numbers are automatically generated with this property.

For Example, If the Line No. starts from 10000.

And the next Line No. is 20000.

When we add a new line between these two lines, The autosplitkey property will automatically create in between No. for the new line.

The Line No. is 15000.

Furthermore, if we continue to add new lines, the number will be automatically assigned by the autosplitkey property like 15000 -> 12500 -> 11250 -> 10625 -> 10312 -> 10156 -> 10078 -> 10039 -> 10019 -> 10009 -> 10004 -> 10002 ->10001 -> After that the error occurred because we added new Lines 13 times in the same direction.

This does not mean that we can only add 13 times in the same direction, it depends on the margin between the current and previous record.

But we should remember that adding lines between two records will not be unlimited.

This is almost the same in posted sales shipment because when you undo the post-sales shipment the system will automatically add a new line with -1 quantity, if the number is no longer then the error will be prompt.

If we use system functionality in a normal way, then these two errors occur rarely. But if we create or import data through a configuration package, It may cause a problem.

If we face this issue anywhere then we can: –

1. If we are facing this issue while adding new lines, then we should add new lines line at the end of the page.
2. To avoid this issue with the posted data, we can delete all the lines and re-enter or import.

We hope this write up will help you to grow!

Stay connected with us to learn more!

 For more details, pls visit our website www.madhda.com or contact us on sales@madhda.com

Thanks to all.

Madhda Team