• Community
  • Blog
  • Contact
  • Customer Downloads

After Upgrade to Oracle R12 Get Balance is incorrect

5 June 2008
After upgrading to Oracle release 12 your Get Balance formulas may start giving an incorrect balance. The reason is that there is a new balance option in release 12. In the past you could report on "Entered" or "Translated" balances. In R12 you can report on "Entered", "Translated" or "Total". GL Wand supports this new "Total" option. For all Get Balance calculations where you want to see the full balance on the account you should now use the "Total" option. You can do a find and replace on your reports to replace "E" with "Total" to fix the Get Balance formulas in existing reports.
  • "We saved about 50 hrs. a month on intercompany reconciliations thanks to faster data compilation using GL Wand"

    Michelle Wallace, Arbonne International, LLC

  • "It’s great to work with a group so committed to providing not only a great product but stellar service as well."

    J Raffensberger (MBA), Corporate Controller, Glatfelters

  • "GL Wand is a fabulous tool, we love it."   

    Donna Holley, Spectranetics

  • "This has to be the quickest ROI we've had on any software investment."

    J Raffensberger (MBA), Corporate Controller, Glatfelters

  • “GL Wand has been a big hit with Cairn’s Finance team."

    Chris Hebden, Cairn Energy PLC

  • "It took less than two hours to train report users. The time savings for everyone is incredible."

    Francis Nocom, Applications Manager, Cochlear

  • “GL Wand has proven extremely valuable in accessing our Oracle data with Excel."

    Michael Hinck, Finance Systems Project Manager, HBO

  • "GL Wand has given our finance users the freedom to think outside the box and be more innovative with performance metrics."

    Martin Stanton, Chief Information Officer, Destination Hotels & Resorts

  • "GL Wand has given our finance users a very flexible tool."

    Paul Simpson, Lancashire County Council