From the Microsoft Dynamics GP Blogs: Payables doc attachments; Remove Range operation; Payment register report; Batch control totals

From this week's Microsoft Dynamics GP blogs:

• Can't View Payables Document Attachments?? Never Fear, We've Got You Covered!!
• A Remove Range Operation on Table ‘SY_Current_Activity' Failed Accessing SQL Data
• SQL Script to Update EFT Payment Register Report
• SQL Script to Verify Dynamics GP GL Batch Control Totals

Can't View Payables Document Attachments?? Never Fear, We've Got You Covered!!

On the Dynamics GP Support and Services Blog, Andrea Melroe asks this question: Are your payables Doc Attach documents missing? Then she offers some information about why they might be missing and what you can do to ensure that users are able to "view" documents in the future.

Melroe writes that there was known issue in which the following occurs on GP versions < 16.00.0552 and => 12.00.1295:

Users cannot view documents attached via Doc Attach (paper clip at the top of the window) for the following payables document types once they've moved to history (basically once they've been fully applied): credit memos; returns; payments

But, if you're on version 16.00.0552 or above, you'll run into this known issue:

Users can no longer view documents added with Doc Attach for any open payables documents posted via a payables batch.

However, once the document has been "fully applied" and moves to history, users can see the attachment again, writes Melroe.

She describes another way to attach payables documents until this gets fixed so users can see all the documents attached no matter where they're located, i.e., work, open, history.

You can read about this method ...