I know that the table named CPY10100 have ALMOST all employee information. But the Location field is not there. The Location field is located on the main Employee creation dialog right under the Position field.
Thank you.
*This post is locked for comments
Your table structure may be different, because I assume you are using Canadian payroll, however, the location ID field (LOCATNID) should be in the PAYROLL MASTER table. In my database, that is table UPR00100.
If you go to Microsoft Dynamics GP >> Tools >> Resource Descriptions >> Tables, you should be able to find the relevant table. Begin by clicking the ellipse button (looks like three dots ...) to open the TABLE NAMES lookup.
Next, change your "Series" to PAYROLL. You can change the "View by" option to whatever is easiest for you. I usually use Table Physical Name but you may prefer the Display Name.
Once you find the table you think is correct, you can double-click it so that it loads into the "Table Descriptions" window. This will show a list of every field in the table.
These two screens are extremely helpful when trying to understand the table structure of Dynamics GP.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
