Has anyone experienced any rounding issues with the "CurySlsPrice" column in the “SOHeader” and/or “SOLine” tables (or with any other float columns for that matter)? We've seen this happen intermittently on SL 2011, where the number rounds up (e.g., 14.56 rounds to 15.00). We have 2 SL databases hosted on the same SQL Server that point to separate instances of Process Manager running on different boxes.
The only pattern we've been able to discern is, if an order is placed in one database and another order or two is submitted to the other database a few minutes later, we see the rounding issue in the latter order(s). Again, this is intermittent (so nearly impossible to reproduce), and the problem goes away after a few minutes.
We suspect that perhaps even though there are separate Process Managers for each database, if they are running concurrently against the same SQL Server instance, maybe a cursor isn't closing properly and the Process Manager thinks the column is an int instead of a float? Setting up a SQL Profiler trace shows the values getting written to the tables correctly upon order creation, and Process Manager updates the tables soon thereafter--and that's where the problem appears to be.
Thanks for any advice.
A service request has been created to follow this issue.
In our early reviews of thiss, a 3rd party software that is bringing data into the database may be involved.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics