krayknot (11/10/2008)

---

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