Description |
I used Fort Books database to get the results below. There are other amount fields that are calculating to the .000000th place or greater than 2 digits.
select strCustomerNumber, dblOverpayment, dtmDatePaid from tblARPayment
inner join tblARCustomer on tblARPayment.intEntityCustomerId = tblARCustomer.intEntityCustomerId
where dblOverpayment <> '0'
order by dtmDatePaid
Here's an example of one record:
strCustomerNumber dblOverpayment dtmDatePaid
PILOTG 119.779999 2015-02-03 00:00:00.000
If you look at GLDetail you will notice the numbers there as well.
select strCustomerNumber, dblOverpayment, dtmDatePaid from tblARPayment
inner join tblARCustomer on tblARPayment.intEntityCustomerId = tblARCustomer.intEntityCustomerId
where dblOverpayment <> '0'
order by dtmDatePaid
strReference ARBalance
PILOTG -204.559998
[~jeffrey.trajano] [~liz.dorado] [~darwin.estrada] [~ruben.escarcha]
I assume this was added becase of inventory cost, price, taxes, etc. But how should this be handled when sending information to other fields and tables that is currency? In the example above, I would think it would be 119.78.
|