Skip to main content
Solved

Truncate field length - Report Designer

  • Jul 29, 2023 4:13 AM UTC
  • 2 replies
  • 142 views
  • Translate All
Freshman I

Looking for a way to decrease the length of the SOShipLine.InventoryID_description field on a pick list.  Currently prints the entire value (up to 250 characters but only want it to print the first 50 characters.  Have “Can Grow” set to False.

 

Best answer by Laura03

Hello @rruff74 ,

Please try using the LEFT function. =LEFT( [SOShipLine.InventoryID_description],50)

Acumatica Report Writer

 

View original

    2 replies

    Laura03
    Captain II
    Forum|alt.badge.img+20
    • Laura03
    • Captain II
    • Answer
    • Jul 29, 2023 10:38 AM UTC

    Hello @rruff74 ,

    Please try using the LEFT function. =LEFT( [SOShipLine.InventoryID_description],50)

    Acumatica Report Writer

     

    Translate
    ~ Laura Barber, WM Synergy
      Freshman I
      • rruff74
      • Author
      • Freshman I
      • Jul 29, 2023 1:22 PM UTC

      Thank you...worked perfectly once I figured out where to insert it in the  existing formula.

      Translate
        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