[Jessica Bouchard]

Is there another way to attach pdf document than manualy ?

Thank you

——————————
Jessica Bouchard
Cedrom-SNi
——————————

[Beat Bucher]

Hi Jessica,
What do you have in mind ?
The new document attachement feature starting with GP 2013 is a blob insertion into the SQL database.. not just a reference link like it used to be with the OLE doc attach from the past GP versions.

——————————
Beat Bucher
Business Analyst, Dynamics GP MVP
Ultra-Electronics Forensic Technology Inc.
Montreal QC/Canada
+1-514-489-4267
@GP_Beat http://dyngpbeat.wordpress.com/
Montreal QC GPUG Chapter Leader
GP2013R2 / MR2012 CU14
——————————
——————————————-

[Jessica Bouchard]

Hi !

We want to attach a pdf version of our contracts with the ar invoices. I know there’s an add-in for the payable module. Is there something similar for the receivables ?

Thank you
Jessica

——————————
Jessica Bouchard
Cedrom-SNi
——————————
——————————————-

[Guillaume Simard]

You can insert an attachment using SQL but for each file that you want to attach, several tables are concerned:
CO00101, CO00102, CO00104, CO00105, coAttachmentItems

The content of your file will go to the [BinaryBlob] column of [coAttachmentItems] table.
Here’s how you can get content from one file : 

    DECLARE @BinaryBlob varbinary(max)
    SELECT @BinaryBlob = BulkColumn FROM OPENROWSET(BULK N’C:ABC.txt’ ,SINGLE_BLOB) AS Document

——————————
Guillaume Simard
Negotium Technologies Inc.
Montréal QC
——————————
——————————————-

[Jessica Bouchard]

Merci beaucoup Guillaume!

——————————
Jessica Bouchard
Cedrom-SNi
——————————
——————————————-