MS Connect Suggestion: Allow File and Folder Shortcuts to be Attached in DocAttach

Microsoft Dynamics GPDocAttach was introduced in Microsoft Dynamics GP 2013 and replaced the ole OLE Notes functionality in all areas of Dynamics GP 2013 R2.

You can attach all types of files to DocAttach including web links, except you cannot include shortcuts to files or folders on your network. While the intention of DocAttach is to be able to attach files and have them stored in the database.

However, if you deal with a substantial number of fixed assets and need images of the condition, or deal with technical diagrams, these files are often between quite and very large. As files are stored in the database as BLOBs (Binary Large OBjects) they are the same size in the database as they were originally; this can mean the database size will grow very quickly as files are added.

I have submitted a suggestion on Microsoft Connect asking that file and folder shortcuts be an allowed file type for Doc Attach.

You can vote for this suggestion here.

MDGP 2018 RTM Feature of the Day: Document Attachment Unplugged

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 RTM; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily as well as adding my won commentary.

The series index for this series of posts is here.

This Feature of the Day post from Pam is not itself a new feature, but is a round up of all of the functionality offered by DocAttach since its introduction in Microsoft Dynamics GP 2013 and the enhancements in the versions since.

The whole post can be read here.

Click to show/hide the MDGP 2018 RTM Feature of the Day Series Index

MDGP 2018 RTM Feature of the Day: DocAttach Security Setup

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 RTM; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily as well as adding my own commentary.

The series index for this series of posts is here.

The fourth Feature of the Day is the security setup around allowing users to add document attachments via inquiry/enquiry windows.

The third Feature of the Day post, yesterday, covered the enquiry windows which had been updated to allow notes to be added via DocAttach.

The feature today is the security around this new capability; you need to mark the Allow attachments to be added in inquiry windows for users to be able to use the new functionality to add notes.

There is also a password field which can be set to allow users to use the new functionality when enabled; this allows you to retain some control over which users can add an attachment:

Document Attachment Setup

I like the ability to add attachments to enquiry windows, but I’m not sure that it needed separate security in this way; it’s yet one more checkbox to enable when implementing the feature.

The password may be useful, but I think, for most of my clients at least, anyone with access to the enquiry window would be able to add attachments anyway.

That said, each site using Dynamics GP is different and I am sure some users will like the flexibility of both of the security options which have been introduced.

Click to show/hide the MDGP 2018 RTM Feature of the Day Series Index

MDGP 2016 R1 Feature of the Day: Manage or Edit Attachment Flows

Document Attachment was introduced in Microsoft Dynamics GP 2013 R1, was improved in subsequent versions and is being improved again in Dynamics GP 2016 R1 to allow attachments to be managed after they have flowed down to the transaction:

Document Attachment Management

The main features are:

  • Edit attachment information that flowed from master record.
  • Enable Flow and email checkboxes for flow attachment options.

Click to show/hide the MDGP 2016 R1 Feature of the Day Series Index

MDGP 2016 R1 Feature of the Day: Payroll Document Attach

There are quite a few of the new features in Microsoft Dynamics GP 2016 R1 which are building on features introduced since GP 2013.

This feature adds the ability to use the Document Attachment feature, introduced in Dynamics GP 2013 R1 on the PTE Employee Expenses window and Employee Expense Entry windows:

Project Accounting Document Attach

The main features of are:

  • Use the Document Attachment feature in PTE Employee Expenses and Employee Expense Entry
  • Header and line attachments such as receipts can now be added to an employee expense
  • Attachments will flow from PTE to Project Accounting to Payables

I love the Document Attachment feature as it makes it so easy to store documents in Dynamics GP without having to maintain a network share so it is nice to see it being rolled out to the action pane on more windows.

Click to show/hide the MDGP 2016 R1 Feature of the Day Series Index

MDGP 2013 R2 Feature of the Day: OLE Notes Migration Utility

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog started a series of Microsoft Dynamics GP 2013 R2 Feature of the day posts the other day. As they did with the Microsoft Dynamics GP 2013 Feature of the Day posts they are doing them as short posts containing a PowerPoint slide show. I am translating these from the PowerPoints into posts; you can find my series index here.

The thirty-third Feature of the Day covered is OLE Notes Migration Utility. The ability to attach documents to record level notes has been available in Microsoft Dynamics GP for a long time. The record notes were always stored as OLE attachments until now; in Microsoft Dynamics GP, the OLE Notes have been replaced with the Document Attachment functionality which stores the notes directly in the Microsoft SQL Server Database.

To facilitate this, a Migration Utility, which runs as a separate application, can be obtained from PartnerSource/CustomerSource. The utility will allow existing users to migrate the files that have already been attached to Notes using the existing OLE functionality into the new Document Attach functionality:

OLE Notes Migration Utility

I’ve never liked the OLE Attachment available in record level notes; if one client had a different path defined in the ini file and the user opened and saved a window the attachments then they would get corrupted. Using Document Attachment functionality removes this risk of data corruption and provides functionality which is much more robust.

This feature is targeted at the following roles:

  1. Administrators
  2. System Implementers

Click to show/hide the Microsoft Dynamics GP 2013 R2 Feature of the Day Series Index

Click to show/hide the Microsoft Dynamics GP 2013 R2 Feature of the Day Series Index

Microsoft Dynamics GP 2013 R2 Feature of the Day
MDGP 2013 R2 Feature of the Day: SmartList Designer Go To's
MDGP 2013 R2 Feature of the Day: Identity Management - Login
MDGP 2013 R2 Feature of the Day: Purchase Requisitions
MDGP 2013 R2 Feature of the Day: Copy And Paste To General Ledger Transaction Entry
MDGP 2013 R2 Feature of the Day: Workflow
MDGP 2013 R2 Feature of the Day: Workflow Types
MDGP 2013 R2 Feature of the Day: Workflow User Delegation
MDGP 2013 R2 Feature of the Day: Default Fixed Asset ID From The Asset Class
MDGP 2013 R2 Feature of the Day: Identity Management - Scalability Groups
MDGP 2013 R2 Feature of the Day: Workflow Calendar
MDGP 2013 R2 Feature of the Day: Reprint Outstanding Transaction in Bank Reconciliation
MDGP 2013 R2 Feature of the Day: Requisition Management Integration Points
MDGP 2013 R2 Feature of the Day: Default Sort Order for Checks
MDGP 2013 R2 Feature of the Day: Document Attach - Scan
MDGP 2013 R2 Feature of the Day: Workflow History
MDGP 2013 R2 Feature of the Day: Workflow Email Notifications
MDGP 2013 R2 Feature of the Day: Azure Backups
MDGP 2013 R2 Feature of the Day: Suggested Item Enhancements - Analysis and Assignment
MDGP 2013 R2 Feature of the Day: Suggested Item Enhancements - Sales Script and Additional Information
MDGP 2013 R2 Feature of the Day: Dashboards
MDGP 2013 R2 Feature of the Day: Management Reporter Web Viewer
MDGP 2013 R2 Feature of the Day: Take Company Offline
MDGP 2013 R2 Feature of the Day: Encumbrance SQL Reporting Services Reports
MDGP 2013 R2 Feature of the Day: Email Or Print Any Report In Word Format
MDGP 2013 R2 Feature of the Day: Reverse Year End Close
MDGP 2013 R2 Feature of the Day: Document Attachment On Payables Transactions
MDGP 2013 R2 Feature of the Day: Roll Down Segment Changes
MDGP 2013 R2 Feature of the Day: Assign An Item To Multiple Sites
MDGP 2013 R2 Feature of the Day: Replace OLE Note With Document Attachment
MDGP 2013 R2 Feature of the Day: OLE Notes Migration Utility
MDGP 2013 R2 Feature of the Day: Purchase Order Prepayment Additions
MDGP 2013 R2 Feature of the Day: Print Remaining Documents
MDGP 2013 R2 Feature of the Day: Email By Document Type

MDGP 2013 R2 Feature of the Day: Document Attachment On Payables Transactions

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog started a series of Microsoft Dynamics GP 2013 R2 Feature of the day posts the other day. As they did with the Microsoft Dynamics GP 2013 Feature of the Day posts they are doing them as short posts containing a PowerPoint slide show. I am translating these from the PowerPoints into posts; you can find my series index here.

The twenty-eighth Feature of the Day covered is Document Attachment On Payables Transactions. The same Document Attachment functionality that was added to Sales and Purchasing in prior Microsoft Dynamics GP 2013 releases has now been added to Payables Transactions.

Documents can be placed directly on the Payables Transaction or they can be set to flow from the selected Vendor; these documents can be viewed from the entry window or inquiry window.

To add a document attachment open the Payables Transaction Entry window (Purchasing ¯ Transactions ¯ Transaction Entry ) and click the Attach button on the ribbon:

Payables Transaction Entry

Continue reading “MDGP 2013 R2 Feature of the Day: Document Attachment On Payables Transactions”