250
Currently using Papersave - just to attach documents to GP transactions
If we turn on the doc attach function in GP, is there a way to identify the attachments from Papersave and what happens to the original doc attach links?
(there are many years worth - but it seems crazy to pay for a 3rd party when GP has this functionality already built in)
We're on GP2018
Anyone ever encounter this?
Your 3rd-party tool like DocuSave or Kwiktag are likely to store their data in a dedicated file system or database (KwikTag uses SQL Express to manage their documents). A procurement system like eRequester pro stores attachments in a file/folder structure per company.
As an example, I've a customer that has 50+ GP companies.. not all are using Doc Attach, but here are a few data samples to compare:
about 2k docs = 3GB of data (just for the coAttachmentItems table which is the blob storage)
about 3,1k docs = 1.7GB of data (depends vastly on doc type, but PDF & XLS mostly)
about 3.3k docs = 890Mb
As you can see, just based on those 3 samples, it can't really be calculated how much space you're going to waste in each company. Setting a max size default value else then 1GB might sure help to keep size growth in control:
Administration >> Setup >> Company >> Document Attachment Setup
thank you for the info! Are you saying that it's better to have a 3rd party store the documents? How badly will GP be affected if doc attach is turned in within GP?
Deanne,
Think twice before you ditch your Papersave add-on for GP... I don't know how many documents you might have linked to GP over the years, but to my knowledge, PaperSave stores all the documents in a separate location (not in the GP company).
I've seen customers that started using heavily Doc Attach in GP see their company DB double or triple in size over the course of a few years because users are not aware of the impact that attaching documents has to GP.. It might be free, but it comes with it's own (hidden) costs on the long-run.
These tables hold the Document Attachments in GP:
CO00101 Document Attachment Master
CO00102 Document Attachment Reference
CO00103 Document Attachment Properties
CO00104 Document Attachment Status
CO00105 Document Attachment Email
coAttachmentItems coAttachmentItems
None of these tables have a column for product id or dictionary id specifically, but with the information they do show, you should be able to determine which attachments are from Papersave and GP, I would think, but I can't guarantee.
Thanks
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...
290,532
Super User 2024 Season 2
#2
Martin Dráb
228,501
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (