Skip to main content
Solved

Where I can Add the translation for UOM - Unit of Measure


Hello,

I am looking for a way to add a translation to my units of measurement.

Example STK (piece) -> PCE (Piece)

Best answer by ernst97

@Laura02 @PatrickSchlenker90 

I have now configured it via an IIf query in the report itself:

=IIf([Customer.LocaleName]<>'de-DE',
     Switch(
     [SOLine.UOM]='STK', 'pce',
     [SOLine.UOM]='KG', 'KG',
     [SOLine.UOM]='M', 'M',
     [SOLine.UOM]='MTR', 'M',
     [SOLine.UOM]='QM', 'QM',
     [SOLine.UOM]='STÜCK', 'pce',
     [SOLine.UOM]='L', 'L',
   ), 
    
   [SOLine.UOM]

 )

 

Thanks for your help / ideas

View original
Did this topic help you find an answer to your question?

7 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3044 replies
  • June 17, 2024

Hello,

Translation from STK piece to PCE piece may be added in Configuration → UOM screen if you want the same translation for all stock items.

If different items have different translation, then add the translation in the Unit of Measure section on General Tab of Stock & Non-Stock Items screens.

Laura


  • Author
  • Freshman II
  • 6 replies
  • June 17, 2024

Hello,

thanks for the answer.

I want to output the unit of measurement STK in the report for a customer from Germany, for customers from English it should then be pce.

Is there a solution for this in the system or is it only possible via IIf queries in the Report Designer?


PatrickSchlenker90
Jr Varsity I
Forum|alt.badge.img+1

@ernst97 or do you mean to translate the UOM Description in a foreign language?


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3044 replies
  • June 17, 2024

I see!  Language translation, not UOM translation!

For Language Translation, we have Translation Dictionaries. Do you have access to Acumatica’s document below, How to localize reports?

 

https://community.acumatica.com/report-designer-237/how-to-localize-the-field-in-the-report-14087

 

Laura


PatrickSchlenker90
Jr Varsity I
Forum|alt.badge.img+1

@ernst97 , @Laura02 the UOM ist not a normal string, it is a KvExt string, which are business data from the customer. Currently is is not possible with Acumatica Vanilla to translate the UOM KvExt string, but Acumatica has a solution in the canadian edition - they plan to integrate it into the core product…

 

Some workaround could be:

you can create a custom table to add ad-hoc localization and join it to the report to display either EN or DE description on the report.

create table INUnitExt(
CompanyID int,
FromUnit nvarchar(6),
DescrDE nvarchar(6),
DescrEN nvarchar(6),
tstamp timestamp
constraint INUnitExt_PK primary key clustered (CompanyID, FromUnit))

 


  • Author
  • Freshman II
  • 6 replies
  • Answer
  • June 17, 2024

@Laura02 @PatrickSchlenker90 

I have now configured it via an IIf query in the report itself:

=IIf([Customer.LocaleName]<>'de-DE',
     Switch(
     [SOLine.UOM]='STK', 'pce',
     [SOLine.UOM]='KG', 'KG',
     [SOLine.UOM]='M', 'M',
     [SOLine.UOM]='MTR', 'M',
     [SOLine.UOM]='QM', 'QM',
     [SOLine.UOM]='STÜCK', 'pce',
     [SOLine.UOM]='L', 'L',
   ), 
    
   [SOLine.UOM]

 )

 

Thanks for your help / ideas


PatrickSchlenker90
Jr Varsity I
Forum|alt.badge.img+1

@ernst97 okay, thats a way to get it, but you have to handle it in all reports this way👍🏻


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