<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.

 

CMS005

 

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.

SortingOrder

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.

VirtualField

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.

View

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!

OpenOrders

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.

LateOrders

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

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.
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.
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down