Microsoft Dynamics Forums Homepage

Forum Home Forum Home > Microsoft Dynamics RMS & Microsoft Dynamics POS > Retail Management System (RMS)
  New Posts New Posts RSS Feed - Rounding in RMS Reports
  FAQ FAQ  Forum Search   Register Register  Login Login


Rounding in RMS Reports

 Post Reply Post Reply
Author
Message
7notrumps View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: February 04 2009
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote 7notrumps Quote  Post ReplyReply Direct Link To This Post Topic: Rounding in RMS Reports
    Posted: June 04 2014 at 6:53am
Hi - has anyone ever found a way to correctly round and total RMS reports - specifically the Detailed Sales Report?

Thanks
George
Back to Top
Sponsored Links


Back to Top
arunj View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: July 06 2014
Location: Kerala
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote arunj Quote  Post ReplyReply Direct Link To This Post Posted: July 06 2014 at 4:03am
I would say you need to do that from SQL query used in TablesQueried variable like SELECT ROUND(123.9994, 3).

eg. Select IsNull(Round([Total],2),0) from [Transaction]

Hope this helps you.
Back to Top
SpencerPrime View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: July 07 2014
Location: United States
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote SpencerPrime Quote  Post ReplyReply Direct Link To This Post Posted: July 07 2014 at 1:35pm
There is a formula line under each column in the .qrp report files that I've used in the past for things like truncating datetime data. I'm sure you could round in a similar manner by putting a sql function there. As for totaling, I've typically done this via column grouping.  
What data in particular are you attempting to round?
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down


Copyright 2013 microsoftdynamicsforums.com. All rights reserved. MicrosoftDynamicsForums.com is an independent non-Microsoft website.
Email: contact AT microsoftdynamicsforums DOT com