Skip to main content
Solved

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

  • 17 June 2024
  • 7 replies
  • 67 views

Hello,

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

Example STK (piece) -> PCE (Piece)

7 replies

Badge +18

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

Userlevel 1

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?

Userlevel 5
Badge +1

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

Badge +18

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?

 

 

Laura

Userlevel 5
Badge +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))

 

Userlevel 1

@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

Userlevel 5
Badge +1

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

Reply