Results 1 to 4 of 4

Thread: Custom formating of negative numbers in a grid

  1. #1

    Custom formating of negative numbers in a grid


    I am trying to format amounts in a grid so that if they are negative the are encapsulated in parenthesis and red. I am able to change the font no problem using event rules so making it red is not an issue. I do not want to convert to a string because it is a field users filter using QBE ex. >1000. I have seen some mention of doing a data dictionary override and formatting using a business function. Are there any business functions that would format negative numbers this way?

    Thank you!

  2. #2
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Spokane, WA, USA
    Good luck Shack.

    The different numeric formats JDE will display as number as are listed in UDC 98/EC.
    Parens and Colors are not part of that list.

    Curious ... has changing the Font in ER actually worked for you?
    Larry Jones
    E1 9.2 - TR on Win 2016 R2. SQL Server 2016
    Wintel, BI Publisher

  3. #3
    Senior Member
    Join Date
    Mar 2004
    Fort Worth, Texas
    I am not sure of an existing business function but I have written custom ones used as a DD override that format numbers in various ways including things like (1,234.99). If you create a DD format override BSFN you simply need to define a BSFN with the following DS:

    typedef struct tagDSD5800012A
      ID                idBhvrErrorId;                       
      JCHAR              szBehaviorEditString[51];            
      JCHAR              szDescription001[31];                
      MATH_NUMERIC      mnGenericNumeric;                    
    } DSD5800012A, *LPDSD5800012A;
    The number will be passed in mnGenericNumeric and you return the formatted display in szBehaviorEditString. Formatting numbers as (1,234.99) works great for display only. I seem to remember some issues in an editable grid or maybe even in the QBE line... but I can't remember 100%... just seemed like I did run into an issue or two when using some custom number format other than the built in ones?????
    Brian Oster
    Application Development Manager
    E1: 9.0 (TR9.1.5.1) / 9.2 (TR9.2.2.2)
    JAS/BSSV: Weblogic 12.1.2 / Weblogic 12.2
    ES: Win2008 / Win2016
    DB: MSSQL 2014 / 2016
    WebDev Client: Win7Pro / Win10Pro

  4. #4
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Cork, Ireland
    Why don't you give the user the same filter but in the header?

    Then use Grid Records is Fetched to both format your new text column and perform the filtering based what they entered.
    Check if the first digit is > or < etc and perform the event rule filtering in dedicated IFs
    John Danter
    You don't go out looking for a job dressed like that do you, on a weekday?

    E900 TR Unix

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.