Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
jmcfarland 3/23/2019 2:28:07 PM

Access OLE Notes Attachments From Outside GP

I have a client using the OLE Notes window to attached documents to PM Transactions.  They are using GP2016.  I believe that when they attach a Word document or PDF document it is stored somehow in the database on the more recent releases of GP.  It seems like it stores this information in the CO00101 through CO00105 tables.  I was able to locate these records and link back to the PM transaction records.  GP somehow allows the user to open the attachments via the user interface from the Inquiry screens.  Is there a way to open these attachments via a web browser via an SSRS report or through a URL?



Version: GP 2015
Section: Dynamics GP, SQL Scripts, SSRS

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables