Skip to main content

Hello,

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

Example STK (piece) -> PCE (Piece)

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


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?


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


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


@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))

 


@Laura02 @PatrickSchlenker90 

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

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

 )

 

Thanks for your help / ideas


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


Reply