Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Which DYNAMICS table stores the account structure?

Posted on by 1,085

 Hi!  Can anyone tell me the table (I imagine it's in the DYNAMICS database) which GP uses to store the account structure information; specifically, how many digits are in a given account string?

Thanks!

*This post is locked for comments

  • Harold Worby Profile Picture
    Harold Worby 1,325 on at
    RE: Which DYNAMICS table stores the account structure?

    select * from DYNAMICS..SY003001 --Account Definition Header

    select * from DYNAMICS..SY00302 --Account Definition

    select * from CompanyDB..SY00300 --Account Format Setup

    The actual segment lengths are in CompanyDB..SY00300

    The Maximum limits are in DYNAMICS..SY00302

    Maximum Number of Segments in DYNAMICS..SY003001

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: Which DYNAMICS table stores the account structure?

    What has not been said here is the reason you need these tables.  If you are thinking about changing the account structure by modifying the tables directly---DON'T!  There are tools that do this and hit ALL of the other tables (like many of the setup tables in other modules that hold accounts......)  This is not an easy task to do in SQL, trust me, I tried it .... once!

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Which DYNAMICS table stores the account structure?

    Hi Richard without looking for the specific table, In Microsoft Dynamics GP 10.0, on the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to Company, and then click Account Format

  • Verified answer
    winthropdc Profile Picture
    winthropdc on at
    Re: Re: Re: Re: Re: Which DYNAMICS table stores the account structure?

    The system maximum is in the Dynamics database, but the individual Company's settings is stored in the company databases. 

    David Musgrave [MSFT]
    Escalation Engineer - Microsoft Dynamics GP
    Microsoft Dynamics Support - Asia Pacific

    Microsoft Dynamics (formerly Microsoft Business Solutions)
    http://www.microsoft.com/Dynamics

    mailto:David.Musgrave@online.microsoft.com
    http://blogs.msdn.com/DevelopingForDynamicsGP

    Any views contained within are my personal views and not necessarily Microsoft policy.
    This posting is provided "AS IS" with no warranties, and confers no rights. 

     

  • Richard Schultz Profile Picture
    Richard Schultz 1,085 on at
    Re: Re: Re: Re: Which DYNAMICS table stores the account structure?

    That's it!  Thanks, David.  I had thought it would be in the DYNAMICS database...

  • winthropdc Profile Picture
    winthropdc on at
    Re: Re: Re: Which DYNAMICS table stores the account structure?

    Have you looked at the SY_Account_Format_Setup (SY00300) table in the company Database.

    David Musgrave [MSFT]
    Escalation Engineer - Microsoft Dynamics GP
    Microsoft Dynamics Support - Asia Pacific

    Microsoft Dynamics (formerly Microsoft Business Solutions)
    http://www.microsoft.com/Dynamics

    mailto:David.Musgrave@online.microsoft.com
    http://blogs.msdn.com/DevelopingForDynamicsGP

    Any views contained within are my personal views and not necessarily Microsoft policy.
    This posting is provided "AS IS" with no warranties, and confers no rights. 

     

  • Richard Schultz Profile Picture
    Richard Schultz 1,085 on at
    Re: Re: Which DYNAMICS table stores the account structure?

     Thansk, Callen.  I looked at those tables, but they don't tell me anything about the length of the segment.  SY003001 only shows the max segments I could use (not the amount I'm actually using) and SY00302 shows the max length of the segment (but not the actually-used length).

    For example, in the TWO company, we have a max number of segments = 5 (from the SY003001 table) but only 3 are used; the length of all segments (per SY00302) is 9, but TWO only displays 3-4-2.  

    So, according to those tables, the account framework for TWO is 9-9-9-9-9; what actually shows up in the companies is 3-4-2.  Where is that 3-4-2 stored?

  • callen Profile Picture
    callen 4,595 on at
    Re: Which DYNAMICS table stores the account structure?

    To clarify, the DYNAMICS database stores the account framework and each company stores the account format.

    The account framework can be found in SY003001 and SY00302.

    The company's account format can be found in GL00100.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans