Skip to main content
Question

Change Unit Of Measure on reports


Forum|alt.badge.img+7

Is it possible to change Unit Of Measure on a Customer Invoice depending on language? 

Can i change Unit of Measure depending on which language there is default for the company or customer?

Ex: Currenct functionality - When a Customer Invoice is printed the Unit of Measure on the Customer Invoice is the same Unit of Measure as “Sales UoM” on Customer Order Line. If value in “Sales UoM” is “stk” (danish) how can i change this to “pcs”?.

This can be useful if the customer or company is not speaking same language as the standard for unit of measure. 

5 replies

Forum|alt.badge.img+10
  • Hero (Customer)
  • 101 replies
  • May 16, 2022

Hello @Rasmus Raul ,

 

I had the same problem, and I overcame like below;

 

1- I translated UoM in basic translation data.

 

2- As you can see below, translation works fine.

 

 

3- And last I am using &AO.ISO_UNIT_API.Get_Description(UNIT_CODE,NULL) function in the reports.

 

Hope it helps.

 

Kind Regards

Ozgun Bal


Forum|alt.badge.img+7
  • Author
  • Sidekick (Partner)
  • 13 replies
  • May 18, 2022

Hi @Ozgun BAL 

How are you using this &AO.ISO_UNIT_API.Get_Description(UNIT_CODE,NULL) in the report? 

Is it a custom field or? 


Forum|alt.badge.img+10
  • Hero (Customer)
  • 101 replies
  • May 18, 2022

Hello @Rasmus Raul ,

 

That function get translated description of the UoM.

For example;

If you add a report block with IFS developer like below;

 

You can use this select statement in the report design like below;

 

And your output in report like this;

But adding a select statement with new report block can be a little bit complicated,  please make sure you are doing it right.

 

Hope it helps,

Kind Regards
Ozgun Bal


Forum|alt.badge.img+7
  • Author
  • Sidekick (Partner)
  • 13 replies
  • May 23, 2022

Hi @Ozgun BAL 

Thanks for your reply,


What do you mean with IFS Developer? 

To my knowledge it is not possible to make a "Select/SQL-statement” in Report Designer


Forum|alt.badge.img+10
  • Hero (Customer)
  • 101 replies
  • May 23, 2022
Rasmus Raul wrote:

Hi @Ozgun BAL 

Thanks for your reply,


What do you mean with IFS Developer? 

To my knowledge it is not possible to make a "Select/SQL-statement” in Report Designer

Dear @Rasmus Raul ,

 

Yes you are right, it is not possible to make a "Select/SQL-statement” in Report Designer.

 

You have to do it with IFS developer studio. You can check link below;

https://docs.ifs.com/techdocs/Foundation1/050_development/050_development_tools/002_developer_studio/

 

Kind Regards

Ozgun Bal

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings