+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, [SIMS] Rounding Error in SIMS .net - patch for Spring Update in Technical; ...
  1. #1

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,782
    Thank Post
    715
    Thanked 1,438 Times in 1,191 Posts
    Rep Power
    359

    [SIMS] Rounding Error in SIMS .net - patch for Spring Update

    Hi, just a heads up.
    We got notification today about an issue in SIMS with a rounding error.

    We have found a potential error with Charge Code rounding calculations, and we would like you, please to check by doing the following:

    Please unzip the attachment OSBalanceCheck.zip to the desktop on the server.

    Now go to C:\Program Files\SIMS\SIMS.net and run an executable file called DBDiagnose

    You will need to log in with the SIMS net login and password.

    Click the Add button, and select the file from the attachment called OSBalanceCheck.sql

    Click the Run button.

    You will see the results will look something like this:

    Server Information
    ==================

    Edition Version Level Engine SIMS Schema Version
    ------- ------- ----- ------ -------------------
    Express Edition 10.0.2531.0 SP1 Unknown 3.61.642



    OSBalanceCheck.sql
    ==================

    Column1 ControlAccOldBalance ControlAccNewBalance
    ------- -------------------- --------------------
    Control Account Adjustment 0.00 -3199.93 -3199.93

    The line which says Control Account Adjustment should have the figure 0.00 next to it, and the next two Balance figures should be the same.

    If the Control Account Adjustment is not 0.00 you will need to contact us for a patch.

    Otherwise, you are OK.

    We have also produced a patch to correct the problem for the Spring release, and we would like you to apply it, please, even if you donít have the problem.

    The patch is the second attachment, called Rounding Patch.zip

    Unzip it to the desktop of the server and use DBUpgrade to run it.

    **Please make sure you have a backup first**
    I haven't run it yet, only just got the attachments out of quarantine, will probably do the diagnostic this weekend.

    I don't think it's linked to the other error mentioned regarding Spring Update about an error in Fees Billing as this appears to affect pre Spring release too.

  2. Thanks to vikpaw from:

    danrhodes (26th May 2010)

  3. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,445
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Looks like it just affects people who have bought the Fees module.

    Another reason why you shouldn't charge for education lol

  4. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,782
    Thank Post
    715
    Thanked 1,438 Times in 1,191 Posts
    Rep Power
    359
    We have to, i don't get paid, if we don't collect fees! :P

  5. #4
    Sarconia's Avatar
    Join Date
    Mar 2010
    Location
    London
    Posts
    315
    Thank Post
    15
    Thanked 34 Times in 31 Posts
    Rep Power
    16
    Quote Originally Posted by vikpaw View Post
    We have to, i don't get paid, if we don't collect fees! :P
    It funds all of those ice cubes in the swimming pool!

    Still, I'm rather glad that I no longer have to deal with the Fees Module. All of those headache issues of trying to delete students who still had weird Fees data lingering around.

  6. #5

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,445
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Quote Originally Posted by vikpaw View Post
    We have to, i don't get paid, if we don't collect fees! :P
    You should feel honoured to be allowed to work for your employer, so much in fact that you should feel obligated to pay them for allowing you to work for them.

    At least that's what they'll say when you ask for a pay rise

  7. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,782
    Thank Post
    715
    Thanked 1,438 Times in 1,191 Posts
    Rep Power
    359
    Quote Originally Posted by matt40k View Post
    You should feel honoured to be allowed to work for your employer, so much in fact that you should feel obligated to pay them for allowing you to work for them.

    At least that's what they'll say when you ask for a pay rise
    That's nearly what SIMS say when i ask about a discount for support!

SHARE:
+ Post New Thread

Similar Threads

  1. sims.net patch
    By Avalon in forum MIS Systems
    Replies: 1
    Last Post: 30th November 2009, 10:13 AM
  2. SIMS.net Error
    By techie08 in forum MIS Systems
    Replies: 5
    Last Post: 9th September 2009, 11:19 PM
  3. SIMS.net July update?
    By kingswood in forum MIS Systems
    Replies: 12
    Last Post: 10th July 2007, 11:54 AM
  4. SIMS.net September Update - Do you dare!
    By NetworkGeezer in forum MIS Systems
    Replies: 16
    Last Post: 10th October 2006, 10:06 PM
  5. Sims.net May Update
    By Sylv3r in forum MIS Systems
    Replies: 14
    Last Post: 5th June 2006, 08:17 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •