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

Sometimes you want to know how many records you have of a certain type in a list. If I am looking at purchase order lines I might want to know how many open order lines I have per supplier, or how many delayed order lines we have at the moment. If I am working with manufacturing orders I might want to know how many open orders we have in my facility, or how many orders we have of a certain type. How do we show this in a simple way?

The answer is to use the functionality we have in the configurable list standard. You can find all the standard programs where this standard is available in CMS005, but don´t worry, if you can´t find your program in that list you can build your own using CMS010. (If you check my older blog posts you will find information how to do this)

In this blog post I will build a list that shows me how many open purchase order lines I have per buyer/supplier, and how many delayed order lines I have.

I will start my work from CMS005, and the program I want to connect this functionality to is PPS220.




The first thing I need to do is to create a sorting order that suits my needs. In this case I chose a sorting option that sorts on buyer and supplier, and I have entered requested delivery date and status as selection fields. I have also ticked the boxes in the lower left corner to make aggregation possible.


The next step is to create a virtual field that will make it possible for me to calculate the number of lines I have in the different selections I want to do. I chose related option “Virtual fields” from CMS005, and I have named my new field &COUN. The syntax is always & followed by 4 characters.

The type of my new numerical field is logical formula. I have entered a condition that is always true, since I want the number “1” to be entered in this field for all lines.


When the new field is ready, I need to connect it to the view. I have to enter 30 (summarize) as aggregation display rule to be able to get the totals I am looking for.


Now I have a sorting order, my virtual field and my view, time to test! I open PPS220 with my sorting order and view. I enter a status selection that will only show open order lines, and I chose to aggregate on buyer/supplier. Once this is done I have a list where my counter-field shows how many open order lines I have per buyer/supplier!


And if I enter a selection that only shows open lines with a requested date in past time, I get a list showing how many delayed order lines I have per buyer/supplier.


This way of using the virtual fields is really useful! If you have any smart ways of using virtual fields that you want to share, please let me know and maybe we can share your idea on the blog as well! 😊




Discuss this post

Recommended posts

Managing and keeping track of external documents like customer contracts does not have to be difficult. With a simple configuration you can archive customer contracts in Infor Document Management (IDM) and automatically associate the document with a customer record. This way you will always be able to easily find the document, without leaving the M3 user interface.
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.
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down