Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
afreeman 4/2/2019 10:09:10 AM

Organizational Structure - Adding a segment

My client is using organizational structure to prevent certain people from seeing payroll accounts. Since they are using a new six segment account structure the main segment is added more frequently than before and it causes the "edit list" on the GL print out to show the same account description every time versus the correct account description. 

Example:    instead of 10-11111-20000-12-11-10  showing  Accounts Payable like it should it shows the same account number but the description shows Accounts Receivable on all accounts. 


Anyone run into this issue?  Is this a Modified report issue? How did you fix it if so? 


The only solution I have found is to unassign and reassign the "non payroll" user in the Org structure which is not the ideal way to fix this every time. 

This is for GP2018 and it also happened while using GP2015. 

Version: Unknown or N/A
Section: Dynamics GP

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables