SQL Query for inserting pdf in CO00101

  • SQL Query for inserting pdf in CO00101

    Posted by DSC Communities on March 31, 2017 at 12:46 pm
    • Jessica Bouchard

      Member

      March 31, 2017 at 12:46 PM

      Is there another way to attach pdf document than manualy ?

      Thank you

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

    • Beat Bucher

      Member

      April 3, 2017 at 7:56 AM

      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

      Member

      April 3, 2017 at 9:20 AM

      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

      Member

      April 3, 2017 at 9:33 AM

      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

      Member

      April 4, 2017 at 2:20 PM

      Merci beaucoup Guillaume!

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

    DSC Communities replied 7 years, 2 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘SQL Query for inserting pdf in CO00101’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!