Back

How to set up Logical Dependencies for Master Data Information

Logical dependencies for limited lookup and selections
Video 2/3
Play
Close
  • Helpful
  • Not helpful
  • Needs update
  • Technical error
An intermediate video requires some previous experience with Business Central, but it is still easily accessible to most people. Intermediate Watch "the details", if you need detailed knowledge about a specific topic. These videos are only relevant for particular users. The Details This video includes functionality from the app "Master Data Information" which is available at Microsoft AppSource. Click to visit AppSource. Master Data Information

Playlists  Manage

Log in to create a playlist or see your existing playlists.

Open Playlist
Presenter: Sune Lohse, Chief Strategy Officer

Logical dependencies can be used everywhere.

You have master dates information.

So it’s not only an item thing, it applies only to the master dates.

Information logic.

This means if you set it up for customers and vendors or documents, it also applies.

And basically when you set it up, you have to set it up on each information code so it can apply it per information code.

This means if on my Citi bike I have a logic saying that if some other master data is already selected, I can only select whatever information in here.

This logic applies to the information code bike type, whereas on my gear, if I have logic saying that the gear needs to be a short down list, depending on other master data information, it’s set up on the information code gear and therefore you do the setup directly from the information code.

And this is also what determines that you’re using logical dependencies.

So from bike type, you can enter in the information code list, you can enter the logical dependencies.

So just go to the information code list, logical dependencies, these are all the ones working for bike type.

And you can see here that you select your information code, you select for which information value or value.

Do we have some dependencies?
What is the related information code that we want to look at and what do we want to check in here? So this means if my bike type is a city bike, the gear has to defer from qua 20.

If a bike type is a C bike, the gear has to defer from qua 21.

So in the test type, you can select equal different from or can be So different Form means that it cannot be whatever the related information value is.

Can be means that it has to be or could be one of those.

So it’s like a dropdown list and if you select that it’s equal to, you can only select one list.

So you cannot make, um, set up which conflicts.

This you cannot say on the calibra bike that you add a new line for calibra where the gear can be whatever or differ equals uh, some other stuff because once you select it, one of the type it needs to be consistent for all that information value.

So with this way, it is an either or situation you can set up.

And if you want to see all your logical dependencies, you can view the filter.

You will have to show system filters and then you can remove the information code.

Then you see across all information code, all of your logical information setup.

So on the gear that we looked at, you can see down here that if a gear is a next to seven, the bike type can be city bike or Cori.

If the gear is a
Ra, the bike type has to be equal to a mountain bike.

And this also tells me that if the gear type is not an extra seven or RA 20 or 21, we could select all bike types because there’s no other restrictions.

So if we’re looking back on the item list and we select if right now if we look into the bike type, there was some restrictions, but if we look at gear types, which is not next to seven or the 21 or 20 gear, now we should expect to be able to select between all my bikes because there’s no restrictions.

So entering the information code list either ding down from the information code here, or searching information code list in the header like this, selecting the information code.

You’re looking at finding logical dependencies that you do the setup.

939474429-IVNJ4K50wao-ENG24032869