Skip to Content
Mar 13, 2009 at 06:23 PM

Different results for decimal values between SQL and B1 RecordSet


Hi Experts,

This is really a strange one. I have the query below:

SELECT Amount, TaxPrcnt FROM [@Table] WHERE ORDER# = '20246' AND ItemCode = '112488'

The same query gives me 0.085 for TaxPrcnt if I run it in SQL Management Studio, but gives me 8.5 if I run it in B1 Query Generator, and the same if I use RecordSet object in DI. The actual value in the table is 0.085. Anyone know why B1 is multiplying the value by 100?