Here is a solution to add columns to a list of an M3 panel in Smart Office without doing any M3 Java modifications and without writing any scripts. The advantage is zero programming. In addition, this technique is interesting when it’s not possible to create custom Sorting Orders (QTTP) nor custom Views (PAVR) for an M3 program (for example Stock Location – MMS010). This technique uses a new feature of M3 called Custom Lists. To create custom lists you will need the Industry Enrichment Package IEP F09201M306 in MNS096.
In this example I will add three columns Geo code X, Y, and Z to the list of Stock Location – MMS010/B1. The values come from the fields GEOX, GEOY, and GEOZ of MMS010/F. This solution is an alternative to the solution of my previous post where I illustrated how to programmatically add columns to a list by writing a script.
The desired result is the list Stock Location – MMS010/B1 with three new columns Geo code X, Y, and Z.
To create this custom list I follow these steps:
- First, I create a new Information Browser Category in CMM310, GEOCODES in this example:
- Then, I create a new View in CMM315 where I include the desired new columns, MSGEOX, MSGEOY, and MSGEOZ in this example:
- Then, I simulate the list to select the columns to display and to select the order of the columns:
- Finally, I add the Custom List to a Mashup where List type = Custom:
With the new IEP feature and with Mashups we can now create Custom Lists in M3 by configuration only, i.e. without any programming.
For more information
To learn this technique and more, refer to the Mashup Designer Advanced training (code SMMA2) from the Lawson Learning courses.