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

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.

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!


Subscribe to the M3 Usability Blog


Discuss this post

Recommended posts

How does your food company manage climate change, globalisation and stricter regulatory requirements? One thing is for sure, it has never been more important to have a business system that can manage different types of parameters in your food production chain.
If a problem were to be detected in one of the foodstuffs sold by your company, how long would it take for you to check every product affected? With a traceability solution you can do it in just minutes.
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 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?
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!
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down