Skip to main content
Solved

Formating issue in report when using multilingual


Forum|alt.badge.img

Hi i’m trying to add address details in report , in english version the details are as expected but when i try to print it in french verson the format is changing.
This is in english 

 

 

This is in french

 

 

here is the code i used for it.
 

 

=IIf([RemitContact.FullName]<>null,[RemitContact.FullName], iif([Vendor.AcctName]<>null,[Vendor.AcctName] , '')) +'{br}'
+IIf([VendorAddress.AddressLine1]<>null,[VendorAddress.AddressLine1] + '{br}','')
+IIf([VendorAddress.AddressLine2]<>null,[VendorAddress.AddressLine2] +'{br}','')
+IIf([VendorAddress.AddressLine3]<>null,[VendorAddress.AddressLine3]+'{br}','')
+IIf([VendorAddress.City]<>null, [VendorAddress.City]+' ', '')
+IIf([VendorAddress.State]<>null, [VendorAddress.State]+' ','')
+IIf([VendorAddress.PostalCode]<>null, [VendorAddress.PostalCode],'')
+IIf([VendorAddress.City]<>null OR [VendorAddress.State]<>null OR [VendorAddress.PostalCode]<>null,'{br}','') 
+IIf([VendorAddress.CountryID]<>null,   [VendorAddress.CountryID_Country_description],'')

 

 

Acumatica version
Acumatica Cloud ERP 2021 R2
Build 21.219.0019

Thanks in advance.

Best answer by BenjaminCrisman

Hi @DineshJ! For this issue it is related to your translation dictionary and collecting the string for {br}.

Here is an example I saw recently:

You will need to navigate here and either change the translation so it ={br} or select it not to translate

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

3 replies

Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 18 replies
  • February 13, 2023

Hi @Chris Hackett  @BenjaminCrisman , could you please help me with the above question. 


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 631 replies
  • Answer
  • February 13, 2023

Hi @DineshJ! For this issue it is related to your translation dictionary and collecting the string for {br}.

Here is an example I saw recently:

You will need to navigate here and either change the translation so it ={br} or select it not to translate


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 18 replies
  • February 14, 2023

Your awsome!! @BenjaminCrisman, that worked as expected. 😊 


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