• tymberwyld (11/10/2008)


    Basically what's going on here is that someone is looking at some wireframes of the UI and that's getting translated directly into a database design. If they want to give users an easy way to enter Postive / Negative amounts, by all means, give them a stupid designator / operator selector. However, that should not be how it's stored in the database. As far as accounting goes, I understand your point, but I would think that all Credits would be stored as Negative amounts, yes?

    whatever the value and the operator the user selects. you multiply that value by -1.

    for example

    user entered 100 and selects '-'

    the output would be: 100 * -1 = -100

    or 100 * 1 =100 or no change

    am i correct?

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com