News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP forum I am unable to relate ...

Microsoft Dynamics GP forum

Suggested answer

I am unable to relate between dbo.coAttachmentItems table and db.RM10201 table

(0) Share

Report

Report

Posted on by Community member

In Microsoft Dynamics GP 2013, I attached an image file in window: Cash Receipts Entry>> Note>> Document Attachment Management >> Attach button

I know attachment file's binary data is contained in dbo.coAttachmentItems table

But I am unable to relate between dbo.coAttachmentItems table and db.RM10201 table!

Can anybody help me to find How this DocumentAttached is related to the Note window in Sql tables:

1) RM Cash Receipts Work File (RM10201)
2) Record Notes Master (SY03900)
3) Document Attachment Master (CO00101),CO00102, CO00103, CO00104, CO00105
4) coAttachmentItems

I need to relate between dbo.coAttachmentItems table and db.RM10201 table, Can anyone help?

(in Microsoft Dynamics GP 2013)

Categories:

Development / Customization / SDK

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Lisa at AonC.com 2,994 on at

Like (0)

Report

I am unable to relate between dbo.coAttachmentItems table and db.RM10201 table

I don't believe there is a direct relationship between Notes and Attachments. (You could probably build the relationship through the document.)

Here is a post with a SQL Script for Document Attach:

Dynamics GP Essentials: Dynamics GP 2018 - Attachment Report – All Attachments ( Updated SQL Script ) (mahmoudsaadi.blogspot.com)

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,252 Super User 2024 Season 2

#2

Martin Dráb 228,089 Super User 2024 Season 2

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans