Anchor
shared_advanced_document_managem_3042 shared_advanced_document_managem_3042

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) to Service Management Job Cost records. In addition, 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. If a record does not have documents attached, the icon displays a paperclip. When documents are attached, the icon displays a paperclip attached to a piece of paper.

Table of Contents

The following tables lists all windows and fields with attached image buttons.

Setting up Advanced Document Management

Setting up the Advanced Document Management module involves creating an attachments folder and mapping the attachments folder to the server.

Note
For information on setting up service call task code attachments, see Adding service call task attachments.

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.

1. Create a \docs folder under the \Microsoft Dynamics GP folder on the shared server. The attachments folder must be created on the shared server so everyone can access the attachments.

2. Create the following folders under \docs:

   Service Management	Job Cost
   \customer \location \equip \contract \calls \subloc \equtype \model \quote	\job \project \changeOd \subctr \costcode \forecast

   
   

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)

• where H is a shared mapped drive
• where GP is the name of the Microsoft Dynamics GP folder on the shared SQL server
• where docs is a folder in the Microsoft Dynamics GP folder

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:

*WS_TempDir=C:\temp*
(must end in backslash)

• where C is the local drive
• where temp is the name of the folder that will hold the attachments

Update the next document number (optional)

If you have multiple companies that are using document attachments, the "Copy File" method saves attachments for all companies to the same shared location. You will receive an error when saving an attachment if the next document number that defaults has already been used by another company.

You can set the next document number to be different for each company by updating the WSDOCS field in the WSSEQ table. The maximum document attachment number is 2,147,843,648; determine how you want to divide this number based on the number of companies you have.

For example, if you have three companies, you may choose to start Company A with the next number of 1, but perform the following two SQL actions to update the next number for the other two companies: Company B: UPDATE WSSEQ SET WSDOCS = 715947882 Company C: UPDATE WSSEQ SET WSDOCS = 1431895766

Create the pathname to the document-viewing application

If a file extension association was established in Windows Explorer, the system uses that association when viewing document files. You must create a pathname to the document-viewing application only if a file extension association does not exist in Explorer, or if you want the ability to override the association in Explorer.

To create the pathname to the document-viewing application:

1. Choose Microsoft Dynamics GP > Tools > Setup > Service Management > Module Setup > Document Viewers.

2. Enter a three or four-character document type in the Type field.
3. In the View Path field, enter the location of the application's executable file. This must be entered in the following format: :c:directory/XXXX.exe
4. Choose Save.

Using Advanced Document Management

Attaching a document

1. Choose the attached image button in any field. The Document List window opens.
2. Choose Add to open the Document Maintenance window.
3. Enter a format in the Format field if you want to use a file extension association that was set up in the Document Viewers window. If the Format field is blank, the system uses the file extension association established in Windows Explorer.
4. Enter a description for the file. The description will display in the Document List window. The system date defaults in the Date field.
5. Choose the Select File... button to locate the file you want to attach.
6. Choose a radio button:
   • 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. 

     Note
     Copy to Database is the only option available if you are attaching a file when using the Web Client. You are also only able to view an attached file if it has been saved to the Microsoft SQL database.

     
     

   • Internet/Extranet Access: Allows you to enter a URL of a file that is located online.
7. Choose Save .
8. Close the Document Maintenance window to return to the Document List window. Your attachment appears in the scrolling window.

Anchor
shared_using_advanced_document_m_773 shared_using_advanced_document_m_773

Viewing an attached document

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

Anchor
shared_using_advanced_document_m_5410 shared_using_advanced_document_m_5410

Editing an attached document

1. Choose the attached image button to open the Document List window.
2. Select the document in the scrolling window and choose 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.

Anchor
shared_using_advanced_document_m_5409 shared_using_advanced_document_m_5409

Deleting an attached document

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