mibuso.com
Home› NAV Three Tier
Options

Displaying a Negative Value with Brackets

sabzamsabzam Member Posts: 1,149
edited 2011-10-05 in NAV Three Tier
Hi All,

I have been searching and wondering (maybe not enough :-) ) on how to display negative values with the brackets symbol rather than the negative sign, i.e., (123.45) instead of -123.45. I want to produce an account schedule report in that format.

Thought about coding the format of the textbox in the report accordingly but am not sure whether it's appropriate or not. I have also tried to change the regional settings of the machine but again with no success at all. Any ideas? Unfortunately there isn't much help online #-o

Thanks in advance

Comments

  • Options
    David_SingletonDavid_Singleton Member Posts: 5,479
    Unfortunately there is no simple global way to do this. You need to go in and format every field that you need like this. Its very easy, its just that you have to do it in a lot of places. In most cases I talked the client out of it, but I did have one client that needed all accounting data in accounting format, like journals, Chart of accounts etc.
    David Singleton
  • Options
    SavatageSavatage Member Posts: 7,142
    Have you tried changing your regional settings in control panel?

    region & language -> Additional Settings -> Negative Number Format
    Change to (1.1) from -1.1
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
Sign In or Register to comment.