Would like to get the data from Wrkw2letter Table ( Letter/Other Info of Employee W2 history ), But query return with no data ???
Select * from Wrkw2letter
Any idea why there is no data when there are 2 letters set up for an employee?
*This post is locked for comments
Ginny, tables that begin with wrk in Dynamics SL are typically working tables that are only populated during a process and cleared when the process completes. If you are trying to retrieve W2 letter codes for employees then you should be using the W2Federal table and looking at the LtrAmts or LtrAmts_Descr fields.
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,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156