I am trying to work out how to handle monetary transactions for purchases where cash is used and the amount needs to be rounded to the nearest 5 cents as Australian currency has no smaller denominations.
For example the following items are purchased
transaction total 2.51 but when they pay cash they would obviously pay 2.50.
Should we round the transaction before its stored in the DB for cash transactions only? or should we round all the reports based on the cash transactions?
I think saving it rounded makes more sense . Is their a way to have the SQL statement that checks the payment type and if payment type "cash" it will round to the nearest 5 cent? If so could someone provide me the statement to do this?