<img src="https://secure.leadforensics.com/133892.png" alt="" style="display:none;">

In Infor M3 13.4 there is a new possibility, you can build your own list program. This blog post will show you how to do that.

In version 13 of M3 the new list standard came, and there are a lot of programs where you can use the new list standard with all its functions around related tables, related options, virtual fields etc. But sometimes you still miss the program you really want to change in CMS005 (the place where you can see all programs where the new list standard is available).

For example, I got a question if we could add some item related information in the view of PMS100, manufacturing orders. The first check in CMS005 gave us that PMS100 didn´t have the new list standard.1_CMS005

But in 13.4 there is a new possibility, you can build your own list program! The function is available in earlier 13.x-versions as well, but in the earlier versions you have to use a mashup to show the list, in 13.4 that is no longer necessary.

You build the list in CMS010, start by adding a new information category. In my case the table I want to use as the base is MWOHED, manufacturing order header information. Since CMS010 is used for both custom lists in mashups, CMS100MI-programs, ad hoc reporting etc it is smart to use a naming standard when you create new records. In my case I have chosen to use prefix LIST_.

2_InfCategory

Once the information category is created and activated (set to status 20) I use option 24 to go to the panel where I can configure my list.

3_CMS010

From the designer screen you can create your sortering orders and views, and also add related tables, options and virtual fields. In my example I want to add fields from MITMAS and MITFAC to the view, so I start by clicking the related tables button and add these two tables to the list.

4_RelatedTables

The information I want to show in the view that doesn´t exist in PMS100 is:

  • Item group
  • Name of the item group
  • Remaining quantity
  • Cost price

Cost price is easy since that field is available in MITFAC, and item group can be found in MITMAS. But for the name of the item group and remaining quantity I need to create virtual fields. I click the button for virtual fields, and start by creating the field for item group name.

I call the field &ITGR, the fields must be named using syntax &XXXX. The type in this case is name from CSYTAB, and M3 helps me with the input that is needed.

5_VirtualFieldITGR

The next field is remaining quantity on the order, which is a simple calculation in this case.

6_VirtualFieldREMQ

The next step is to make sure I have all the related options I use in PMS100 in my custom list as well. I add all the relevant options, just by adding the number of the option, and the program where the option is available. To make this work you just need to make sure the key values are in the view, in my case facility, manufacturing order number, product number.

7_RelatedOptions

Then I need to create a sorting order that gives me the correct possibilities to sort, filter and select records. I have chosen to filter on facility, and then have the possibility to add selections for status, product and finish date.

8_SortingOrder

The last step is to create the view. I add the fields I need from MWOHED, MITMAS and MITFAC, and my virtual fields.

9_View

And now I am done! I bookmark the page using the sorting order and view what I have created, and then I can add the link to my new list program as a shortcut on the canvas, as a favorite or as a shortcut in the toolbox area forexample. More about how you get the bookmark-links for Smart Office, H5 and for homepages will follow in my next blogpost.

When the user opens the list it will look like a normal M3 program, all basic options are there, the related options I have added are there – and with some nice personalizations we have created a new user friendly program, without any coding at all!

2_PMS100_Wish

Subscribe to the M3 Usability Blog

Discuss this post

Recommended posts

Sometimes you need a simple way of following changes of values for certain fields in M3. By using the event log in M3 you have a handy solution 😊 Follow the steps below and you will have a log of changed values for supplier bank accounts in just a few minutes!
In this blog post I describe how to get your item names in the language connected to the user when using custom lists in Infor M3.
If you are running Infor OS/H5 you have the possibility to create really nice homepages for your users. The homepages are the starting points for all roles, and one of the widgets you probably want to have on your homepage is the menu-widget. On the menu widget you can add links to M3 programs for example, but by using bookmarks you can make the links smart, and let them open the programs with predefined selections and searches.
In this blog post I'm describing how to create bookmarks in M3. Since we are moving towards Infor OS and H5, we need to handle that there are some differences in how you manage bookmarks in the different user interfaces for M3.
I have talked about personalizations many, many times – and I am still convinced that there is a lot left to do in this area for most M3 users. Recently we have done some M3 installations for new customers, and in that kind of projects the need for a smooth navigation in M3 becomes very clear. It is not easy to run M3 the old-fashioned way.
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down