Open Forum

Expand all | Collapse all

GL Account Index

  • 1.  GL Account Index

    Posted 11 days ago
    We recently installed Rockton Auditor and I'm working on setting up the audits. I'm auditing GL account additions and noticed the audit is providing the account index instead of what we see as the account number. For example, our account number looks like this:  010-8300-4506-0000 but the account index is 13981. Does anyone know of a report or Smartlist that lists the account number and index?

    Thanks!
    Denise

    ------------------------------
    Denise Lewis
    Finance Systems Manager
    Folience
    Cedar Rapids IA
    ------------------------------


  • 2.  RE: GL Account Index

    TOP CONTRIBUTOR
    Posted 11 days ago

    Have access to SQL?  You could quickly get this info from the GL00105 table.

    It may exist but I'm not sure that the account index is available within any report inside GP. You could use SmartList Builder and/or SmartList Designer to deploy a new SmartList report (you'd probably want the GL00100 table as well).



    ------------------------------
    Kyle Malone, CPA
    GP Admin - CGB Enterprises, Inc.
    Lead Consultant/Blogger - http://ALaCarteGP.com
    Chapter Leader - Louisiana (New Orleans)
    ------------------------------



  • 3.  RE: GL Account Index

    TOP CONTRIBUTOR
    Posted 11 days ago
    Denise,
    You can add the account index to almost any of the financial smartlists by just adding a column.  I am on accounts and just added the account index.
    Tanya


    ------------------------------
    Tanya Henderson
    Senior Consultant
    S2 Technology
    Park City UT
    ------------------------------



  • 4.  RE: GL Account Index

    GPUG ALL STAR
    Posted 11 days ago
    Edited by Beat Bucher 11 days ago
    Hi @Denise Lewis
    you can leverage the built-in SQL views that Microsoft provides out-of-the-box for the Excel & SSRS reports..
    There is one called 'Accounts' in each company DB.

    So here it goes :

    SELECT
    [Account Number]
    ,[Account Description]
    ,[Posting Type]
    ,[Account Category Number]
    ,[Account Alias]
    ,[Account Index]
    ,[Account Type]
    ,[Active]
    FROM [TWO].[dbo].[Accounts]​

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)

    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role