Hi @Nelson Yip  The BILL To and SHIP To address fields has a iif Condition that controls adding the new line when the Addressline2 line does not have values. Please confirm if you have changed the report to reflect the Addressline 3 field? If so, please review the formula, it should be corrected on the fields.

Thanks

 

Hi @Nelson Yip Also, can please copy the formula on the fields and paste it here.

Hi @ChandrasekharM 

This is the formula in Bill To.

 

=IIf(fBillingAddress.AddressLine1]<>null,lBillingAddress.AddressLine1]+'{br}','')
+IIf(fBillingAddress.AddressLine2]<>null,lBillingAddress.AddressLine2]+'{br}','')
+IIf(fBillingAddress.AddressLine3]<>null,lBillingAddress.AddressLine3]+'{br}','')
+IIf(fBillingAddress.City]<>null,         BillingAddress.City]+', ', '')
+IIf(>BillingAddress.State]<>null,       ÂBillingAddress.State]+' ','')
+IIf(rBillingAddress.PostalCode]<>null,  tBillingAddress.PostalCode],'')
+IIf(bBillingAddress.City]<>null OR tBillingAddress.State]<>null OR tBillingAddress.PostalCode]<>null,'{br}','') 
+IIf(+IIf()BillingContact.Attention]<>null,   '{br}' + 'Attn: ' + +BillingContact.Attention], '')
+IIf('BillingContact.Phone1]<>null, '{br}' + 'Phone: ' + BillingContact.Phone1], '')
+IIf('BillingContact.Fax]<>null, '{br}' + 'Fax: ' + BillingContact.Fax], '')

I guess the IIF statement is not working property on 2021 R2.

This works by replacing null with ‘’, is this new for 2021 R2 or this is a bug?

+IIf(IBillingAddress.AddressLine2]<>’’,;BillingAddress.AddressLine2]+'{br}','')
+IIf( BillingAddress.AddressLine3]<>’’,;BillingAddress.AddressLine3]+'{br}','')

 

@Nelson Yip Its better to check with both Null and empty conditions to avoid the issue in further. 

+IIf(fBillingAddress.AddressLine2]<>’’ OR €BillingAddress.AddressLine2]<>null,;BillingAddress.AddressLine2]+'{br}','')
+IIf(>BillingAddress.AddressLine3]<>’’  OR €BillingAddress.AddressLine3]<>null,tBillingAddress.AddressLine3]+'{br}','')

 

Happy Coding!

Hi @Nelson Yip   We had the same problem in our client report and we resolved it. Please find the formula below for reference.
 

=IIf(IShippingContact.FullName]<> '' , IIf(IShippingContact.FullName]<> null,uShippingContact.FullName]+'{br}','') ,'')
+IIf(IShippingContact.Attention]<> '', IIf(IShippingContact.Attention]<> null,uShippingContact.Attention]+'{br}','') ,'')
+IIf(IShippingAddress.AddressLine1]<> '', IIf(IShippingAddress.AddressLine1]<> null,uShippingAddress.AddressLine1]+'{br}','') ,'')
+IIf(IShippingAddress.AddressLine2]<> '', IIf(IShippingAddress.AddressLine2]<> null,uShippingAddress.AddressLine2]+'{br}','') ,'')
+IIf(IShippingAddress.AddressLine3]<> '', IIf(IShippingAddress.AddressLine3]<> null,uShippingAddress.AddressLine3]+'{br}','') ,'')
+IIf(IShippingAddress.City]<>null, lShippingAddress.City]+' ',' ')
+IIf(IShippingAddress.State]<>null, lShippingAddress.State]+' ',' ')
+IIf(IShippingAddress.PostalCode]<>null, lShippingAddress.PostalCode],'')
+IIf(IShippingAddress.City]<>null OR ShippingAddress.State]<>null OR ShippingAddress.PostalCode]<>null,'{br}','')
+IIf(IShippingAddress.CountryID]<>null, lShippingAddress.CountryID_Country_Description]+'{br}','')

 

Hope this helps!!

Thanks for the help on this @Naveen B  as we also have the same problem.  Now I get to spend the next week making fixes to all our reports (most of them out of the box).

I can’t figure out why acumatica doesn’t have these fixes themselves so the customers don’t have to spend all this extra work and money making fixes like these, that I personally think they shouldn’t have, considering it is supposed to be enterprise software.  I am trying not to vent, but these little things are what I think makes the difference in software that is just trying to get sales rather than trying to be the best in their category. 

Sorry for rant.  This community is the best support and we rely on it heavily as the answer and fix is usually already on here by the members.  Great job.