Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Document Management feature allows users to attach bitmap (.BMP) files to records.  The The bitmap images can be saved with the record and viewed by selecting the attached image button. If The button shows a paper clip if the record does not have documents attached, the button shows a paper clip. When documents are attached, the button shows a paper clip attached to a piece of paper.With the Advanced Document Management feature, you can attach numerous file formats (e.g., .DOC, .BMP, .XLS, .TIF, .WAV). See Advanced Document Management.

Table of Contents

Setting the Default Document Storage Location

You can also set a default document storage location in the Document Storage Setup window. This new window is found

  • When Copy File, Attach File, or Copy To Database is set as the default storage location, this option is marked for your users in the Document Maintenance window when uploading an attachment, however, users can select a different option if needed. 
  • When the default option is set to Cloud Storage, the storage location cannot be changed in the Document Maintenance window.

To see the default storage location:

  1. Access the Document Storage Setup window in Service Management settings (Service Management > Module Setup > Document Storage Setup) or Job Cost settings (Job Cost > Job Cost Settings > Document Storage Setup).  
  2. In the Default Storage Location section, select one of the following options:
    • Copy File
    • Attach File
    • Copy To Database
    • Cloud Storage
  3. Select Save.

Setting up Document Management

Setting up document management involves creating an attachments folder and mapping the attachments folder to the server. For information on setting up physically stored Service Management attachments, see Setting up physically stored document attachments.

Step 1: Create an Attachments Folder

Complete the following steps to create a folder to hold your attachments.

Note

Before performing this procedure, make sure no one is logged into Microsoft Dynamics GP or Service Management or Job Cost.

Create a \docs folder under the \Microsoft Dynamics GP folder on the shared server. 

...

Create the following folders under \docs:

...

Service Management

  • \customer
    • \location
    • \equip
    • \contract
    • \calls
    • \subloc
    • \equtype
    • \model
    • \quote
    • \appointments 

...

Step 2: Map the Attachments Folder to the Server

Add the following line to the DEX.INI file on each client workstation:

  • WS_DocRoot=H:\GP\docs\ (must end in backslash)
    • H is a shared mapped drive
    • GP is the name of the Microsoft Dynamics GP folder on the shared SQL server
    • docs is a folder in the Microsoft Dynamics GP folder

Step 3: Map the Temporary Folder Location

You must specify a temporary folder to be used when viewing attachments that were copied to the database. Add the following line to the DEX.INI file on each client workstation.
Note: This temporary folder is emptied when you log out of the system. Do not use the folder for data storage.

  • WS_TempDir=C:\temp\ (must end in backslash)
    • C is the local drive
    • temp is the name of the folder that will hold the attachments

Using Document Management

Attaching a Document

...

  • Copy File
    Saves the file to the directory specified in your pathname setup. The file name is automatically generated by Service Management and appears in the non-editable Document ID field in the upper portion of the window. The complete filename will contain the appropriate format extension.
  • Attach File
    Saves the path to the file. You will use less hard disk space by attaching the file, but risk losing the path if the file is ever moved.
  • Copy to Database

    • Copying the file to a Microsoft SQL database offers a more secure connection to the documents and makes the documents easier to manage. When selecting the file to attach to the appointment, in the Source Documentation section select Copy To Database.

    • Copy to Database is the only option available if you are attaching a file when using the Web Client. You can only view an attached file if it has been saved to the Microsoft SQL database.
  • Cloud Storage
    Saves the file to the Azure Cloud. This option must be set up in the Documentation Storage Setup window before you can store attachments.

...

up the default document storage location option so that when users add an attachment, the storage location radio button defaults to what you've selected in the Document Storage Setup window. See Setting Up the Default Document Storage Location (Optional).

Note

Files must be physically located on the device used to attach the file. For example, if you are using OneDrive to store your images, you will need to download the image to your computer or phone before you can attach this to a service call.


Info

The optional Advanced Document Management module allows users to:

  • Attach files of various formats including four-character file extensions (e.g., .DOC, .BMP, .XLS, .TIF, .WAV)

...

  • Internet/Extranet Access 
    Allows you to enter a URL of a file that is located online.
  • Select File
    Select this button to locate the file you want to attach.
  • Send Notification
    Currently not in use.

...

Viewing an Attached Document

  1. Select the attached image button to open the Document List window.
  2. Select the document in the scrolling window and select Display to view the attachment.

Editing an Attached Document

  1. Select the attached image button to open the Document List window.
  2. Select the document in the scrolling window and select Display.
  3. Edit the document.
  4. Save the document with a new name by choosing _File > Save As >_ \[new document name\].
  5. Re-attach the document.

Deleting an Attached Document

  1. Select the attached image button to open the Document List window.
  2. Select the document in the scrolling window and select Edit.
  3. In the Document Maintenance window, select Delete.

...

The ability to physically store attachments in a user-defined location has been added to Service Management for a select number of attachments. In Service Management, attachments are added by choosing the paper clip icon. This method of attaching documents is the same method introduced in Microsoft Dynamics GP 2013. MobileTech reports are added automatically when generated.

Note
For document attachments to be written to a physical file location, WRITE permission must be given to the folder(s) where the attachments will be copied for all users who will be attaching files.

To set up the additional Document Attachment Management Setup window:

  1. Go to Microsoft Dynamics GP > Tools > Setup > Company > Document Attachment Setup.
  2. Mark Allow Document Attachments.
  3. Select Additional, and then select:
    • Service Management Attachments
      Enter the file locations the attachments should be saved to for each of the attachment areas.
    • Equipment Management Attachments
      Enter the file locations the attachments should be saved to for each of the attachment areas.
  4. Select OK.

Tables and Fields

The following table lists Service Management windows and fields with attached image buttons. New windows may also have the attachments button available.

Service Management

...

Customer

...

Customer ID

...

Location

...

Customer
Address ID

...

Maintenance Contract

...

Customer
Location
Contract Number

...

Equipment

...

Location
Equipment ID
Equipment Type
Model Number
Sublocation ID

...

Service Call

...

Customer
Location
Service Call ID

...

Service Appointment

...

Appointment

...

Equipment Type Setup

...

Equipment Type
Equipment Model Number

...

Contract Quote

...

Customer
Location
Quote Number

...

Service Call Quote

...

Service Call ID

...

Master Contract

...

Customer

...

Maintenance Contract History

...

Customer
Location
Contract Number

Job Cost

...

Job Number
Project Number

...

Job
Job Vendor

...

  • to Service Management and Job Cost records.
  • Use Microsoft Azure cloud storage as a storage option instead of Copy File, Attach File, or Copy to Database.
  • You can link to Microsoft Office SharePoint documents. Users do this by copying and pasting the link to a SharePoint document within the attachment. Attachments can be saved with the record and viewed using the attached image icon. The icon displays a paperclip if a record does not have documents attached. When documents are attached, the icon displays a paperclip attached to a piece of paper. For purchasing information, contact WennSoft Sales.


Child pages (Children Display)