web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Employees with Attachm...

Finance | Project Operations, Human Resources, ...

Answered

Employees with Attachments

(3) Share

Report

Report

Posted on by texasbbqribs

172

Greetings.

I'm trying to determine what employees have attachments in Payroll.

I ran a query found elsewhere that provides a table of records, but they refer to a Card/Transaction Number, not the employee. The number highlighted in the image is what appeared in the query results. The tables involved are:
CO00102

CO00105

CO00104

CO00101

The question is: is there another table to reference to identify which employee is record 00000094.

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Lisa at AonC.com 1,109 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If you are comfortable with SQL, you may be able to use this blog post to get the information you need:

Dynamics GP 2018 - Attachment Report – All Attachments ( Updated SQL Script )

It doesn't look like it covers payroll so it would take some tinkering to get the case statement updated. If you have access to run SQL statements but aren't familiar with creating a SQL statement/reviewing table data, I can try to get the specific employee script for you. (It may take me a few days to make time in my schedule.)

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Giorgio Bonacorsi 608

#2

André Arnaud de Cal... 591 Super User 2026 Season 1

#3

CP04-islander 430

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans