web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Which DYNAMICS table s...
Microsoft Dynamics GP (Archived)

Which DYNAMICS table stores the account structure?

(0) ShareShare
ReportReport
Posted on by Richard Schultz 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

I have the same question (0)
  • callen Profile Picture
    callen 4,595 on at

    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.

  • Richard Schultz Profile Picture
    Richard Schultz 1,085 on at

     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?

  • winthropdc Profile Picture
    winthropdc on at

    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

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

  • Verified answer
    winthropdc Profile Picture
    winthropdc on at

    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. 

     

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    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!

  • Harold Worby Profile Picture
    Harold Worby 1,331 on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans