I have a decimal precision issue that is causing me grief. I'm using Sage 100 with a third party add-on for multi-currency. In the AR_TransactionPaymentHistory table there is a numeric field for the currency exchange entry rate. This field typically has a lot of decimal places. When included in any container, SI is rounding the number of decimal places.
An example is .0379550 is returned by SI as .038. This is happening with all values for this field. I've tried changing the data types, but no luck. Any suggestions would be appreciated.
Thanks in advance
Where do you see the rounding happening, in the source data pulled via the connector or in Excel? I just want to make sure that it's not Excel that's doing the rounding...
Its happening in the source container, prior to going to Excel.
What add-in are you using for this? Can you please provide an image of the base amount in 100 and show how it's pulling through in the Connector. I'm not familiar with any decimal type fields in 100 so it's difficult for me to test. Also I assume you went through all the possible data types?
You can email me directly if you want.
Can you please tell us what the third party add-in is and give us a sample of the source code?
Thank you, Sandra.
Hi Karl. I've replied to you directly via email.