By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Generic Inquiries & Pivot Tables
3
Posts
2
Users
1
Reactions
906
Views
June 13, 2024 12:17 pm
Hello, I am trying to create a GI where I link the "Comment" in the file attachment to a GI with other AP information.
Anyone know how to link the "Comment" noted in the File attachment to the AP Tran table? I realize I may need to join some additional tables to do this.
It looks like the Data Class is UploadFileRevisionNoData and the Data Field is Comment but I am unsure how to join to APTRAN.
2 Replies
June 13, 2024 3:25 pm
Join ARTRAN to NOTEDOC on the noteid fields
Join NOTEDOC to UploadFileRevisionNoData on the file id fields.
June 14, 2024 9:19 am
Thanks, I will try that!