Custom Trial Balance

  • Custom Trial Balance

    Posted by kchambers@trosainc.org on August 21, 2019 at 7:24 am
    • Kim Chambers

      Member

      August 21, 2019 at 7:24 AM

      When I go to Financial>Reports>Trial Balance>Detail, I get a GL detail that includes the JE Reference; however, nobody else in my department has this report….how do I give all access?

      Thanks,

      ——————————
      Kim Chambers
      TROSA
      Durham NC
      ——————————

    • Steve Erbach

      Member

      August 21, 2019 at 11:23 AM

      ,

      ??The Financial Trial Balance Reports are resources assigned to the RPT_FIN_004 Security Task. That Task is usually part of just a few Security Roles:

      ACCOUNTING MANAGER*
      AP CLERK*
      BOOKKEEPER*
      CERTIFIED ACCOUNTANT*

      If your users don’t belong to any of those roles, you may add the RPT_FIN_004 Security Task to the Roles to which your users have been assigned.

      If you don’t have GP Administrator rights, then you’ll need to have your GP Admin make the Security Task assignment.

      Sincerely,

      ——————————
      “Sparkly” Steve Erbach – Green Bay, WI
      Co-Chair, GPUG WI (Green Bay) Chapter
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: twitter.com/serbach

      —————
      Excel Webinar List as of 22-Mar-2019
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      August 21, 2019 at 11:37 AM

      ,

      It also sounds like it’s a modified GP report. The ?other users may not be assigned the proper Alternate/Modified Forms and Reports Task.

      Look under Microsoft Dynamics GP >> Tools >> Setup >> System >> Alternate/Modified Forms and Reports, and look at the list of IDs available.


      This shows that the Modified Trial Balance Detail report is selected for the DEFAULTUSER. However,

      … the CNV_SLA_GLC ID shows that the default (Microsoft Dynamics GP) version of the Trial Balance Detail report is selected.

      I think this is your issue.

      Sincerely,

      ——————————
      “Sparkly” Steve Erbach – Green Bay, WI
      Co-Chair, GPUG WI (Green Bay) Chapter
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: twitter.com/serbach

      —————
      Excel Webinar List as of 22-Mar-2019
      ——————————
      ——————————————-

    • Kim Chambers

      Member

      August 21, 2019 at 3:59 PM

      That worked!Ā  Thanks so much

      ——————————
      Kim Chambers
      TROSA
      Durham NC
      ——————————
      ——————————————-

    kchambers@trosainc.org replied 7 years, 2 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Custom Trial Balance’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!