Skip to main content

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(mVendor.AcctName]<>null,&Vendor.AcctName] , '')) +'{br}'
+IIf(rVendorAddress.AddressLine1]<>null,&VendorAddress.AddressLine1] + '{br}','')
+IIf(rVendorAddress.AddressLine2]<>null,&VendorAddress.AddressLine2] +'{br}','')
+IIf(rVendorAddress.AddressLine3]<>null,&VendorAddress.AddressLine3]+'{br}','')
+IIf(rVendorAddress.City]<>null, gVendorAddress.City]+' ', '')
+IIf(rVendorAddress.State]<>null, gVendorAddress.State]+' ','')
+IIf(rVendorAddress.PostalCode]<>null, gVendorAddress.PostalCode],'')
+IIf(rVendorAddress.City]<>null OR ;VendorAddress.State]<>null OR ;VendorAddress.PostalCode]<>null,'{br}','') 
+IIf(bVendorAddress.CountryID]<>null,   tVendorAddress.CountryID_Country_description],'')

 

 

Acumatica version
Acumatica Cloud ERP 2021 R2
Build 21.219.0019

Thanks in advance.

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

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

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

Reply


Terms & ConditionsCookie settings