Document attachment doesn't work in GP2016 R2

(1) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (17)

Answers (1)

Tim Wappat 5,711 on at

Like (0)

Report

I am unfamiliar with this issue.

Does anyone reading this know what the technical issue is around this?

I'm guessing the path to the document row in the DB gets changed as the GP document changes state and thus it can't be found in the database, oversight by the software devs?

Marilyn - I think its a safe assumption that the documents are there in the database.

It sounds like it is the pointer that points from the window to the database record that breaks in payables, when the document goes through its various states. If that is the case, then I would have thought a "patch" solution could be created to find the documents when needed, even if it was an external to GP, windows application.

Unfortunately I don't know enough about to bug to advise further at this time.

For reference the document referred to is:
community.dynamics.com/.../payables-document-attachments-missing-how-to-get-them-back

Tim.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have figured out what is happening, now if I just knew what to do with the information. When the invoice is posted it is creating lines in SQL that have "Payables Transaction History" in the BusObjKey. Before the upgrade it created lines in SQL that had "Payables Transaction" in the BusObjKey. If I do the following I am able to see the attachment before the invoice is paid:

In CO00102: Remove "History" from the BusObjKey

In CO00104: Two lines were created by posting, delete the line with "History" in the BusObjKey

In CO00105: Two lines were created by posting, delete the line with "History" in the BusObjKey

I believe we are going to turn off workflow until we get a fix for this, which is a real pain because we upgraded to GP2016 R2 because it had a fix for a bug with workflow! So that bug is fixed and replaced by one that is even worse.

Was this reply helpful? Yes No
Tim Wappat 5,711 on at

Like (0)

Report

Thank you for investigating further.

Interesting issue. I might go and poke this with a stick to see what is going on.

Tim.

Was this reply helpful? Yes No
Tim Wappat 5,711 on at

Like (0)

Report

Sorry only just had a chance to look at this tonight.

So if I understand this correctly, for the current R2 version of GP, the only problem is that "history" is incorrectly added to the key when they are posted by batch?

If this is the case, is it not possible to simply create a SQL job to run every 1min to execute the following SQL, that will remove the "History" from the key? I've made the SQL verbose so that it does not accidentally update anything else by including the full front end of the path in the replace.

UPDATE CO00102

SET BusObjKey=REPLACE(BusObjKey,'0\PM\Payables Transaction History\','0\PM\Payables Transaction\')

WHERE BusObjKey Like '0\PM\Payables Transaction History\%'

I'm thinking that this would make the attachment available and patch the issue? I've only quickly looked at this quickly, so I might have over simplified the issue?

Let me know I'm interested!

Tim.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Thanks for looking at it. The problem is that only the invoices that are still in a "Work" or "Open" state need "history" removed from the busobjkey. Once it is paid, the busobjkey does properly have "history" in it. Also, in CO00104 and CO00105 there are two lines created for each attachment. It should only create one line. The line with "history" needs to be deleted, but again only for invoices that have not been paid.

I spoke to Microsoft about this issue. They said I had found the two workarounds (deleting lines in the "CO" tables and using the note field to attach instead of the paperclip in the ribbon) that they are giving customers. They assured me it is a high priority to get this fixed. They are targeting the midyear tax update to include a fix. I certainly hope they meet that target as it is requiring us to change our processes.

Thanks,

Marilyn

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

We are trying to move to paperless and this is the reason we upgraded to this version of GP. Glad to know that I wasn't losing my mind when the attachment disappeared after it was scanned and saved. Using Notes as the way to attach documents is not great solution.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It is not a great solution since we use workflow for payables transactions. When the documents are attached using the note they do not get emailed with the approval request. If you are also having this problem you might try using the tool below. It doesn't work if you use the paperclip to attach, but it does give users an easier way to view the attachments before approving a batch.

jamesdlyn.wordpress.com/.../tool-to-browse-attached-files-stored-in-gp-server-via-document-attach

Was this reply helpful? Yes No
TB Sparks 80 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Terry R Heley Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
TB Sparks 80 on at

Like (0)

Report

Thanks Terry!

Support said all workaround information available is in this thread.

Was this reply helpful? Yes No