Document Attach for Journal Entry

(0) Share

Report

Posted on by ARand

122

I have a client that is on GP 2015 and wants to know which journal entries have attachments. Since the attachments are on the notes in GL I am having a hard time finding a table that connects the note index to the document attach. Can you tell me if there is a table that connects the two fields?

Thank you,

Angie

*This post is locked for comments

All responses (3)

Answers (0)

ARand 122 on at

Like (0)

Report

RE: Document Attach for Journal Entry

I saw the same post and already had the same tables it did not help for GL. I cannot see a link between them. If I find a way I will post it.
L Vail 65,271 on at

Like (0)

Report

RE: Document Attach for Journal Entry

Hi Angie,

Good question :)

The database table that stores the attachment is coAttachmentItems. This is no help at all because there isn't a readable reference that you can use to join to the GJ table. I should say that I do not know how to read any kind of relationship in it anyway.

Kind regards,

Leslie
Suggested answer

babubaskaran@outloo... 6 on at

Like (0)

Report

RE: Document Attach for Journal Entry

Hi Angie,

I am not sure whether its possible to find which journal entries has attachments directly. But there is very good post by Mahmoud about document attachment tables. Please click here to have look at this.