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

How to convert prices and discounts to other currencies.

A while ago I visited a user group meeting in Germany, and the topic was mashups, jscripts and other usability solutions. A lot of nice solutions were shared between the participants, and this inspired me to create some new blog posts for the iStone usability blog! It is good for all of us when we share our solutions and ideas!

When you look at your purchase order lines in the purchase order line program (PPS220) in M3, you see the price in the currency used by the supplier. But what if you want to see the price converted to your own currency, or if you want to see the price minus discounts in the list?

If you are running M3 13.3 you can use the new list standard and create columns for this in the view in PPS220, if you are running 10.1 you need to create a mashup, and show the purchase order lines in a custom list.

This post will explain how to do a currency conversion in PPS220 in 13.3, and my next post will describe how to create a calculated field that shows purchase price minus discount.

In version 13 there is a new program called CMS005, and here you can find all programs with the new list standard. I position myself on PPS220, and chose the option virtual fields.

Note! You can use this way of creating virtual fields for all programs available in CMS005!

6_1_CMS005.pngPicture 1: Related option 12 takes you to virtual fields.

The first thing we are going to do is to create a field that shows the purchase price in SEK. I have to name the field using syntax &XXXX, in my example &PSEK. The field type is currency conversion.

6_2_VirtualFieldsSEK.png
Picture 2: A new field, &PSEK, of type currency conversion will be created

When you chose currency conversion M3 helps you with the fields you need to enter to get a correct conversion.

Note! Since purchase price currency is found on the PO header, you need to connect MPHEAD as a related table to PPS220 in CMS005 before you can create the virtual field!

Below you can see how you configure CMS012 to get a correct conversion of the purchase price to SEK. The calculation is based on the purchase price from the line, and the currency from the header. I have chosen to use currency rate 01, and todays date as the date for the rate.

6_3_VirtualFieldsSEK_2.pngPicture 3: Configuration in CMS012

Once this is done, I just add the new field to the view, and the price is shown in SEK, and in the currency of the supplier.

6_4_View.png
Picture 4: The view

In the program the view looks like this, I can see the price both in the supplier currency, and in SEK!

6_5_View2.png

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