Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Unanswered

Rounding issue on SL 2011

Posted on by 30

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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Rounding issue on SL 2011

    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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans