Skip to main content
Solved

Invoice report truncating text

  • February 21, 2025
  • 2 replies
  • 113 views
  • Translate All
jhouser
Captain II
Forum|alt.badge.img+7

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/

2 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4

​@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.

Translate
    jhouser
    Captain II
    Forum|alt.badge.img+7
    • jhouser
    • Author
    • Captain II
    • 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. 

    Translate
    Contract for hire: https://www.linkedin.com/in/jesse-houser-052817b6/
      Terms & ConditionsAccessibility statement
      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