You’re offline. This is a read only version of the page.
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 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%'
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.
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
Thanks Mahmoud
I will approach microsoft as in our case we require such SP or API which is critical to business.
Regards
Amit
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.
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
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.
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,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (