>Hi Brad ---
>
>I think I resolved that issue by putting in the max decimal places I could in the tables and using SET DECIMALS TO 6 or 7. This was, rounding was not that much of an issue and I could always use the Format (this was FPD/FPW days) to show it however I wanted to anyway.
>
>
>>I'm happy it can help someone. I've received all kinds of help from this site. Glad to be able to help others, too. Now all I have to do with the above situation is get my rounding to come out to the penny. We have multiple charges, sometimes 10,000, individually being converted, and the total always comes out slightly off, due, I think, to rounding. After all, the rate is 4 decimals, we charge to 3 decimals, etc... I'm still researching for a way. Normally I would have stored each charge, and then converted the whole, but the system doesn't allow it, and I couldn't rewrite the thing, as much as I wanted to.
>>
>> Brad
I pretty much came to the same idea, but the problem lies with the system applications. I couldn't be sure exactly what would happen with all the other reports and invoices that are run from those tables. That's what I meant when I said I wanted to rewrite the whole thing, so I wouldn't have to piece it together. Normally I would just go through each one, but the system is being redeveloped in PB, so the time would be wasted at this point (sigh).
Thanks,
Brad
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement