Skip to main content
Solved

Invoice report truncating text

  • February 21, 2025
  • 2 replies
  • 25 views
jhouser
Captain II
Forum|alt.badge.img+3

Hi everyone,

I have an invoice report that is truncating text for no apparent reason. In screenshot below I blacked everything out except the “NO”. On the actual invoice, transaction description shows “NOV2024”. As you can see, there’s plenty of space for 5 more characters. I set field to “CanGrow” (see settings in second screenshot). Any ideas?

 

 

 

Best answer by jhouser

​@BenjaminCrisman No, using HTML. I figured out the issue. I had this formula in the field and ResourceID field is limited to 15 characters: =IsNull([PMProformaTransactLine.ResourceID],[PMProformaTransactLine.Description])

I added [PMProformaTransactLine.Description] to the Format, and that solved the issue. 

View original
Contract for hire: https://www.linkedin.com/in/jesse-houser-052817b6/
Did this topic help you find an answer to your question?

2 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • 728 replies
  • February 21, 2025

​@jhouser Is the report printing into PDF format? PDF doesn’t really have the ability to use the CanShrink and CanGrow correctly and so the field needs to be as long as the longest text which could populate the field. That’s been my experience at least. Try viewing in HTML and see if it works as expected.

Chris Hackett
jhouser
2 people like this
  • Chris Hackett
    Chris Hackett
  • jhouser
    jhouser
jhouser
Captain II
Forum|alt.badge.img+3
  • jhouser
  • Author
  • Captain II
  • 108 replies
  • Answer
  • February 21, 2025

​@BenjaminCrisman No, using HTML. I figured out the issue. I had this formula in the field and ResourceID field is limited to 15 characters: =IsNull([PMProformaTransactLine.ResourceID],[PMProformaTransactLine.Description])

I added [PMProformaTransactLine.Description] to the Format, and that solved the issue. 

Contract for hire: https://www.linkedin.com/in/jesse-houser-052817b6/
BenjaminCrisman
Chris Hackett
2 people like this
  • BenjaminCrisman
    BenjaminCrisman
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

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
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved