How TO insert PDF in CO00101 /CO00102 Document Attachement GP2013 R2

(0) Share

Report

Posted on by Amit Thakkar

Hi Everyone GP2013 R2 Does anyone knows how to insert Image/PDF from SQL.If anyone has SQL Query please share . As get most of AP invoices 3000 to 5000 and using Integration Manager we load invoice but no option of PDF/Doc attachment in IM. Only way to bulk insert as manually will be more difficult and time consuming. If anyone has SQL Query for inserting PDF . Please share the same. Thanks Amit

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
Hello Amit

Document attachments in Dynamics GP consider SQL Server solution to store files and documents in the database. They are converted into binary large objects and stored accordingly in CO00101 and CO00102, as well as both CO00104 and CO00105.

CO00101 | Document Attachment Master

CO00102 | Document Attachment Reference

CO00104 | Document Attachment Status

CO00105 | Document Attachment E-mail

If you do a simple test for attaching a file which size is 100 MB, the database size will increase accordingly with 100 MB. Therefore, it is not as simple as throwing a record in the database.

An alternative solution which I have already tested is to create a macro which will open the "Saved" document and click on "Attach" then picking the specific associated file and save it. It would take a matter of few hours and get you to the final target safely without consuming a lot of time on testing several back end approaches which may not be effective.

Let us know if you need any further assistance,

Was this reply helpful? Yes No
Amit Thakkar on at

Like (0)

Report

Thanks Mahmoud

As we dont find any attachment through IM and AP Invoices(Unposted) loaded in GP2013 R2. We need to load images but did not find any eConnect or API available anywhere. Also entity relationship between these tables

Hope Microsoft will help to develope SP or SQL Query? shall we reach out them ?Do their Incident charges ($259.00) applied?

Thanks

Amit

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (1)

Report

I don't know whether Microsoft would do such an integration since there is no such eConnect adapter supporting document attachment.

Hopefully one of the great support engineers will intrude in this case to provide further comprehensive information regarding your request.

Thomas Newcomb Joshua Page

Was this reply helpful? Yes No
Amit Thakkar on at

Like (0)

Report

Thanks Mahmoud

I will approach microsoft as in our case we require such SP or API which is critical to business.

Regards

Amit

Was this reply helpful? Yes No
Thomas Newcomb 1,810 on at

Like (0)

Report

Hi Amit and Mahmoud!

I have been researching this however I have not been able to find any information on if it is possible to integrate Document attachments. If you create a case with us in which this does not exist at this time it could be transferred into an Advisory Services case. This all depends on what the engineer finds during their research.

Sorry I don't have any other information on this issue.

Hope this helps!

~Thomas Newcomb

------------------------------------------

Microsoft Dynamics GP Support

------------------------------------------

This posting is provided "AS IS" with no warranties, and confers no rights

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello,

I was wondering if anyone knew how to generate the "BusObjKey" field on table dbo.CO00102 or where it comes from?

Thanks in advance for the help.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

I believe it is just a matter of converting the NOTEINDX to an int, then to a hexidecimal, then to a varchar. Below is an example for Payables:

select convert(varchar(max), CONVERT(VARBINARY(8), CONVERT(int, NOTEINDX)), 2), * from PM10000 where VCHRNMBR like '%TEST-VOUCHER%'

Was this reply helpful? Yes No