Good day everyone...
The Round function has problem, I do not know any want knew about this.
I discovered the problem when I do the query and sum by the amount by the Group.
Let say the amount of selling price is $47.23... and quantity is 1
GrossAmount=Round(SellingPrice*Quantity,2)
The Gross Amount show as: 47.230000000000400
I entered the selling price as $49.12
The Gross Amount show as: $49.1200000000050
I have email to AwareIM support but no response from them yet...