Skip to main content
Answer

Not able to display Bill to address when Override = True

  • March 14, 2024
  • 4 replies
  • 109 views

Forum|alt.badge.img+3

Hello community,

I have not been able to display the address under Bill - to - Address section of the Invoices & Memos form, whenever the Override checkbox is active. I am able to display the values when it is inactive. i am currently using the following syntax:

the invoice report displays blank but for the invoices with Override checkbox not selected, the invoices displays correct values.

Best answer by darylbowman

...whenever I add the State description line it prints out blank results.

Maybe the State description is null. That would break the whole text area. Maybe try using IsNull([BillingAddress.State_description], '')  (I think I got that syntax right).

4 replies

Forum|alt.badge.img+3
  • Author
  • Captain II
  • March 14, 2024

Hello team,

Any suggestions/updates. I tried it out from my end, but whenever I add the State description line it prints out blank results. But when I remove this State Description, it prints the address correctly, except for the State description.


darylbowman
Captain II
Forum|alt.badge.img+15
  • Answer
  • March 14, 2024

...whenever I add the State description line it prints out blank results.

Maybe the State description is null. That would break the whole text area. Maybe try using IsNull([BillingAddress.State_description], '')  (I think I got that syntax right).


Forum|alt.badge.img+3
  • Author
  • Captain II
  • March 14, 2024

...whenever I add the State description line it prints out blank results.

Maybe the State description is null. That would break the whole text area. Maybe try using IsNull([BillingAddress.State_description], '')  (I think I got that syntax right).

Hey @darylbowman ,I tried this, but now it is not printing the state description.
 

 


Forum|alt.badge.img+3
  • Author
  • Captain II
  • March 14, 2024

...whenever I add the State description line it prints out blank results.

Maybe the State description is null. That would break the whole text area. Maybe try using IsNull([BillingAddress.State_description], '')  (I think I got that syntax right).

Hey @darylbowman , it got fixed. Had to use State instead of State Description along with your syntax. Thanks a lot for your help !!