There is no tool to extract them from GP per se, but there is a stored procedure that I found on this blog post that will extract a single document if you know the ID # of the document in the database. You will have to modify the stored proc for GP as the stored proc references a generic table:
Essentially the documents are stored in a table called coAttachmentItems in each GP company database.
You'll need to change the columns in the stored proc, the docID column in the stored proc would need to be changed to Attachment_ID
The docname column should be changed to filename
I'm not sure what this proc is using doctype for, GP doesn't have it
Change the name "doc" to binaryblob because that's the column name in the GP table for it
Exporting Binary Files To The File System
------------------------------
Rob Klaproth
Dynamics Certified Professional
(GP Install & Configure)
Sr. GP Consultant
Armanino, LLP
San Diego, CA
------------------------------
Original Message:
Sent: 12-12-2018 05:04 PM
From: Samantha Suire
Subject: Exporting Document Attached Files
I'm trying to figure out how to export the documents in GP that are attached to Customer Cards without saving them one by one? We are moving to a new sales tax software and in need to upload all our tax certificates. Currently, we attach them in GP to the Customer Card Note. I need to export all of these and mass import them into our new Tax Certification Manager system. Anyone ever done this before?
------------------------------
Samantha Suire
Financial Systems Manager/ Consultant
------------------------------