Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

How do I know which records have attachments

(0) ShareShare
ReportReport
Posted on by 385

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

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: How do I know which records have attachments

    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.

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 3,141 on at
    RE: How do I know which records have attachments

    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

  • Jozy Profile Picture
    Jozy 385 on at
    RE: How do I know which records have attachments

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

  • Suggested answer
    RE: How do I know which records have attachments

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans