Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Doc attach options

(0) ShareShare
ReportReport
Posted on by 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?

Categories:
  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Doc attach options

    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

  • Deanne CWCO Profile Picture
    Deanne CWCO 250 on at
    RE: Doc attach options

    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?  

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Doc attach options

    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.

  • Suggested answer
    RE: Doc attach options

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans