I'm running an older version on productcart (2.71) and cannnot easily update to the newer version due to heavy customization.

Recently I found a bug that is in the RMA area of the version we are using. Now  I'm now trying to fix it so that we can use this function more effectively.

Whenever we try processing a credit for returned merchandise on an order and the amount is not an even dollar amount, when PC updates, it rounds it up or down to the nearest whole dollar. So for instance if an item is returned to us by a customer and that cost $15.75, once you update the order, the credit becomes $16.00. If the item is $15.25, it updates the order and becomes a credit of $15.00

I spent an entire afternoon looking through the code in file modrmaa.asp. I looked at it quite extensively and can't find anything in the code associated with the credit amount that appeared to causing the amount to be rounded. The only thing I found was the use of the trim function, but that is not causing this problem.

I put in a support ticket to EI about two weeks ago and did not hear anything back, so I suspect that they didn't respond because this is an older version they are not supporting any longer. Fair enough, but like I said I can not update to the newer version very easily. I hope to update our cart when I find a spare 80-100 hours to spend re-doing all the mods we have made.

Can anyone give me some help fixing this bug or point me in the right direction to solving the issue ?  I would truly appreciate it !

Nevermind, I figured it out.

Somehow between version 2.62 and 2.71 in the "Orders" table, the field property size for the rma credit field changed from "double" to "long integer". Of course integer implies a whole number and so if you try and save a numerical that has fraction, then it is automatically rounded up or down.

Changing the field property size to "double" and re-uploading the database solved the issue.