Top 5 This Week

Related Posts

Autosplit Key Feature In Navision

Creates Line No. automatically for new new record

Navision can automatically assign Line No. to a new record if the Line No. is part of the primary key fields. This can be done by setting the AutoSplitKey property in the Form to Yes. By default the AutoSplitKey property is set to No.

Let’s consider the following example. When I enter a new sales line record in Sales Order form, Navision will automatically assign Line No. = 10000 to the first Sales Line record. Now, if I enter the 2nd Sales Line record, Navision will automatically assign Line No. = 20000 to the new record. If I insert a new record between the 1st and 2nd record, Navision will automatically assign Line No. = 15000 to the new record.

All this can happen because Autosplitkey property in Form 46 – Sales Line is set to Yes. In order for AutoSplitKey feature to work, the last field in the primary key must be an integer, BigInteger, GUID or decimal field. If you look at the Sale Line table, the Primary key is ‘Document Type,Document No.,Line No.’, where Line No. is an integer field.

Jubel Thomas Joy, a 16+ year Microsoft Dynamics 365 Business Central/NAV/Navision expert, founded "Navision Planet" in 2009. Certified in Business Central , D365 - Commerce and many more. He blogs on the latest updates and various modules of Business Central & LS Central, showcasing expertise in SQL, Microsoft Power Platforms, and over 150 organizations of work experience.


Please enter your comment!
Please enter your name here

Popular Articles