Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Document attachment do...
Microsoft Dynamics GP (Archived)

Document attachment doesn't work in GP2016 R2

(1) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I can't believe that Microsoft does not pull this version until they have it corrected or at least put it on the known issues page.  We have been paperless for almost a year now.  All our payables invoices from vendors are attached to the document in GP.  We do not keep any paper backup.  Over the weekend we upgraded and now this afternoon I find that you cannot view attached documents in GP2016 R2 unless they were attached using the "note" rather than the paperclip.  A Microsoft blog called "Can't View Payables Document Attachments?? Never Fear, We've Got You Covered!!:" indicates it is no big deal because you can just use the note paperclip to attach until it is fixed.  If you use that note paperclip to attach and you have workflow implemented for payables batches the attachments will not be emailed with the batch to be approved.  Of course if you use the other paperclip and anything happens to the email you will not be able to see the attachments until the bug is fixed.   99% of our AP documents are attached using the paperclip at the top.  We have an audit coming up in a couple of months and now have no backup for payables for the first 10 months of the fiscal year.  We are actually considering reverting back to GP2015 and reentering two days of information.

Has anyone found a way to view these attached documents? 

Thanks,

Marilyn

*This post is locked for comments

  • TD2012 Profile Picture
    TD2012 935 on at
    RE: Document attachment doesn't work in GP2016 R2

    I am applying the 2017 year end update to GP 2016 and my company fails due to this 'fix' for documents attach.  It references this sql statement.  How do I get past this?  I applied the January hotfix and I'm still getting the error.

  • Althea ADS Profile Picture
    Althea ADS 445 on at
    RE: Document attachment doesn't work in GP2016 R2

    Our customer upgrade last month from GP2013 to 16.00.0620 and had this issue and we ran the scripts to remove "history" from path and they can see all historical now.  But they cannot see any attachments in recurring batches that have been there for a long time.  What is the fix for that?  I specifically saw payables recurring batches where they have hundreds of recurring invoices in many different batches and most have attachments and you can see none in any of them.    Please let me know of any fix for this.

  • Terry R Heley Profile Picture
    Terry R Heley Microsoft Employee on at
    RE: Document attachment doesn't work in GP2016 R2

    Great news...thanks for the update Marilyn!

    Terry

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Document attachment doesn't work in GP2016 R2

    Thanks for the reply.  We put this in test yesterday and some production companies last night.  Everything seems to be working now.  

  • Suggested answer
    Terry R Heley Profile Picture
    Terry R Heley Microsoft Employee on at
    RE: Document attachment doesn't work in GP2016 R2

    We are in the process of updating our blog today, but it is not done yet

    community.dynamics.com/.../payables-document-attachments-missing-how-to-get-them-back

    Once you apply the mid year update 16.00.0620 there is a change in functionality where

    ALL payables documents with attachments (regardless of if they are in OPEN or HISTORY) have a BusObjKey beginning as follows:

    0\PM\Payables Transaction\

    Overall, this is fine for transactions you enter going forward. You’ll be able to see all of the attachments without a problem

    However, this change in functionality, will cause an issue for any attachments sitting in the CO00102 table for historical payables documents that were present prior to the upgrade. This is because Microsoft Dynamics GP is now looking for a BusObjKey beginning with 0\PM\Payables Transaction\ instead of 0\PM\Payables Transaction History\.

    WORKAROUND:

    Test the following as a possible resolution

    UPDATE CO00102 SET BusObjKey = REPLACE (BusObjKey,' History','') WHERE BusObjKey LIKE ('%Payables Transaction History%')

    Verify you can now view historical payables ‘document attachments’

    Backups are always encouraged and run this in a test company first :-)

    Thanks

    Terry

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Document attachment doesn't work in GP2016 R2

    We applied the July payroll update and we can now see the attachments to unpaid AP invoices.  We cannot however see hundreds of other attachments from several months ago.  I do see them in SQL in CO00101, CO00102 and CO00104, but they cannot be viewed in GP.  This happened around the time we applied the update, but not sure if it is the cause.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Document attachment doesn't work in GP2016 R2

    Terry - will this hotfix also allow documents to be attached after the invoice has posted?  I honestly have never worked with a system that will not allow you to go back in and add a document after an invoice has posted.  It seems a little backwards that everything has to be done prior to batching.

  • TB Sparks Profile Picture
    TB Sparks 80 on at
    RE: Document attachment doesn't work in GP2016 R2

    Thanks Terry! 

    Support said all workaround information available is in this thread.

  • Suggested answer
    Terry R Heley Profile Picture
    Terry R Heley Microsoft Employee on at
    RE: Document attachment doesn't work in GP2016 R2

    This is Terry from Microsoft, just want to respond to this thread this it is our top priority to get this fixed what is referenced in Andrea's blog,

    https://community.dynamics.com/gp/b/dynamicsgp/archive/2017/03/06/payables-document-attachments-missing-how-to-get-them-back

    I'm very sorry you are experiencing this issue.

    I think Tim posted the blog as well.

    The plan is to have something in our July hotfix for this, which should be due to release the end of June, 2017.

    There is also an issue with some scanners not working with document attach and we hope to have that addressed as well in this mid year update.

    Further questions, let me know, thanks

    Terry Heley
    Microsoft
    theley@microsoft.com

  • TB Sparks Profile Picture
    TB Sparks 80 on at
    RE: Document attachment doesn't work in GP2016 R2

    Marilyn,

    We are having the same issue. I am going to open a case with Microsoft to see if there is an update on the hotfix. I'll update here.

    Thanks,

    Tim

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

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans