Viewing fields from both the Basic Table and the Master Data Information

The Information Matrix
Video 1/13
  • Helpful
  • Not helpful
  • Needs update
  • Technical error
Videos with the tag "Commonly Used" describes the functionality that is used by most companies. Commonly Used 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

With the Information Matrix, it is possible to view fields from both, the basic tables, Item, Customers, Vendors, et cetera, and the Master Data Information table.

Transcription of video

Let’s take an example of that. If I go to my Item List, in here, and from my Item List, I’ll go into my Information Matrix. It is a view that combines it all, and here, I can see selected items that I have imported, and I can see the columns that I have defined.

Some of the columns coming from the Item table, in this case the Description from the Item table, the Base Unit of Measure from the Item table, the Unit Price from the Item table, but then, I have the City Bike, the Bike Type from the Configuration value, the Master Data Information table, other fields from the Item table, et cetera.

So it’s possible to mix columns with information from the Item table and the Master Data Information table. In this case, it’s a value from the Wheel Diameter, which is a Master Data Information, and likewise, I can do it on Customers and Vendors, so if I go to my Customer, and view the Information Matrix from Customer perspective, like this, I have my Information Matrix, and again, I can see selected customers that I am viewing.

I have Name for my Customer table. Then I have the Salesperson Codes which is, this case, a Master Data Information table from the Customer table, the Contact from the Configuration table, meaning the Master Data table, and again, back on the Customer table. So it’s possible to mix up different columns from different tables but see them in one view.