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
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
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
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!
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
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.
That's it! Thanks, David. I had thought it would be in the DYNAMICS database...
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.
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?
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,235 Most Valuable Professional
nmaenpaa 101,156