Tag: App Development

How to Create Unique Keys in AL Development/Business Central

Spring Release 2019 of business central comes up with new features for creating unique keys

Today we will see how to create unique keys in table

While creating second keys you can add an additional parameters said ‘Unique’. This will not allow duplicate values in the field where unique parameter is mentioned.

Now we will see this validation works on business central. Here we are trying put same description which is throwing error because of unique key.

You can define multiple unique keys in one table.

Points to Remember

  • Field can have empty value that means empty value is also value.
  • Not supported in table extensions.

Hope this will help you ..

What’s new in the Spring 2019 release of Dynamics 365 Business Central?

With the release of spring version new features added/updated in Dynamics Business Central.

  • Application Enhancements
    • Longer name and descriptions across business central . It is increased from 50 characters to 100 characters.
    • Multiple Item selections for Sales & Purchase documents.
    • Merge Duplicate customers, Vendors and contacts.
    • Bulk Import of Item Pictures.
    • View Item ,customer and vendor descriptions in Ledger entries.
  • Save and Personalized List views
  • Focus mode on document pages.
  • AutoSave Indicator
  • Page Inspector.
  • Improvements in Scrolling lists.
  • Customize the theme
  • Application as an App
  • Force Sync when deploying applications
  • Multiple objects ID Ranges in app.json
  • Multiple unique keys
  • Increased Maximum length of texts and code fields, variables and text constants.
  • Event Runtime optimization :- It is now 1.5. to 2.5 times faster

Many more features are there in this new version.

Stay tuned for more.