Skip to main content
Question

How to display all the digits of a Long (AKA Int64) Field in Modern UI?

  • February 22, 2026
  • 2 replies
  • 48 views
T
Freshman I

I’ve got a custom field that is Int64. It’s holding a key value from another application. It’s correctly stored in the DB as 16 digits, but the UI only displays 14. This was the same in Classic UI, but I could force it to use display as a string and all was well (it’s rarely if ever entered by anything than the integration code or an Admin, so digit checking not important.)

I was *hoping* that modern UI would ditch the 14 char limits, but seems like no. How do I make modern UI display all the digits?

Thanks in Advance!

Travis Kleckner

2 replies

R
Jr Varsity II
Forum|alt.badge.img+3
  • Rakshanda
  • Jr Varsity II
  • February 23, 2026

Hi ​@travisk91 ,

Since this is an external key and not meant for calculations, you should store as Int64 but display as string(non db field). Using this you can display 16 digit

#region UsrExternalKeyDisplay
[PXString(20, IsUnicode = false)]
[PXUIField(DisplayName = "External Key", Enabled = false)]
[PXFormula(typeof(Selector<YourDAC.usrExternalKey, YourDAC.usrExternalKey>))]
public virtual string UsrExternalKeyDisplay
{
    get => UsrExternalKey?.ToString();
    set { }
}
public abstract class usrExternalKeyDisplay : PX.Data.BQL.BqlString.Field<usrExternalKeyDisplay> { }
#endregion

  • Hide the Int64 field on the screen

  • Show the string display field instead

Hope above helps!!

Rakshanda D
    T
    Freshman I
    • travisk91
    • Author
    • Freshman I
    • February 23, 2026

    Ah, yes, that’s super helpful!

    Is there a good workaround for the rare occasion that I need to populate that value from the UI?

    Sometimes a value will get out of sync and need attention. Is there a proper method for editing a really big long int?

    Travis Kleckner
      Terms & ConditionsCookie settingsAccessibility 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