Finance | Project Operations, Human Resources, ...

How do I know which records have attachments

(0) Share

Report

Posted on by Jozy

393

Dear Community,

How do we know which record have attachment and which do not have for all module as we have multiple transaction which do not have attachment but we need know know this detail for all module.

Thanks

Jozy

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Derek Albaugh on at

Like (1)

Report

If you look at the CO00101 and CO00102 company tables, you can use the Attachment_ID value on the two tables, to get the attachment file name from the first table, and then the 2nd table will tell you what record it is attached to, i.e. the BusObjKey (for example 0\PM\Purchase Order\PO0997 ).

There may be other ways of doing so, and you could potentially generate a script that shows this type of information, pulling from these tables and other related tables.

Thanks

Was this reply helpful? Yes No
Jozy 393 on at

Like (0)

Report

But I only need to know the without having attachments transaction only so we can add attachment to thos transaction.

Was this reply helpful? Yes No
Suggested answer

Lisa at AonC.com 937 Super User 2025 Season 2 on at

Like (0)

Report

We had a client request a similar report. TI was pretty difficult to create, but we started with the script found in this community post by Mahmoud Saadi:

:

community.dynamics.com/.../dynamics-gp-2018-attachment-report-all-attachments-updated-sql-script

Was this reply helpful? Yes No
Beat Bucher GP Gee... 28,058 Moderator on at

Like (1)

Report

Jozy,

Keep in mind that the COxxxxx tables might allow you to identify the documents back to the original transaction if it was done thru the new 'clip' icon in GP.

If you attach a document by using the clip from the sticky 'notes' icon, then your attachment will refer back to the Notes Index #, and then it will be much more difficult to track back to the original transaction.

Was this reply helpful? Yes No