SYMENU System Manager Introduction 18


 Application Overview

Links allow you to launch any program in your system to open a file created by that program.  However, that definition understates the power and flexibility of links because you can tie a link to a specific record, create systemwide links available anywhere to all users and custom program links, such as link a customer, ship-to or vendor with Google Maps.

Typical links are images for inventory items, various documents associated with customers or vendors, or useful URL links for these records.  Links are designed for linking external documents and URL resources to Elliott master records, where these type of documents or URLs can't be stored in the Elliott database.  The following are some examples:

  • Item Images, specifications, CAD-CAM drawings
  • Customer or vendor contracts, support documentation
  • Purchase orders from customers
  • AP invoices

Run Instructions

Like other Elliott five amigos features, in order to access or manage links, you should bring up one of the master records -- like customer, vendor, item...etc. Then click on the link icon, which looks like a link on the tool bar.  See sample screen below:

The following link list window will show up:

In the above examples, you can see the following type of links are avalable for this customer:

  • Netcellent Direction & Map: This link points to a URL
  • Edward Dell Vosotro 420: This link points to a PDF file, which is a packing list of the computer hardware.
  • Terminal Servers Listing: This link points to a folder where the RDP (Remote Desktop) connections are stored.
  • Employee Handbook: This link points to a PDF file of the employee handbook.
  • Google Map: This link will bring up Google Maps for this customer. It also has a hot key of Alt-M.  That is to say, when you bring up this customer, you can use Alt-M to bring up the Google Map for this customer without going through the link user interface window.

Link Type

Links are managed mostly by Link Type.  Links that do not have link type are called "add-hoc" links.  We encourage you to use link type whenever possible.  Linking with a link type will be much easier to manage when you decide to change the folders where the link documents are stored.  

To manage Link Type, you can click on the "Types.." button in the above link list window.  You can add, change and delete a link type.  To add a link type, in the "Type" field simply add a link type that does not exist yet.  The maximum value for a link type is 6 digits.

There are three types of link to choose from when you define a Link Type:

  • User Link
  • System Link
  • Program Link

User Link

These are links that attach to a master record, such as the Customer, Vendor and Item File.  Wherever that master record is open (e.g., Inquiries or Maintenance) you have access to all links for that master record.  In the tool bar, a red Link icon designates that a user link is available. The following is an example of a User Link type:

Pay attention to the "Template" field:
  • "m:\elliott7\CONTRACT" indicates the contract documents will be stored in the "M:\ELLIOTT7\CONTRACT" folder.
  • "@@VAR1@@ is the file name you will supply when you create a "Contract" link for a master record.
You could also assign a hot key so you can bring up the Contract Link for the master record (if one exists) without going through the link user interface.

System Link

These are links designated by the user as “System.”  They are automatically available anywhere to all users in Elliott and designated by a yellow Link icon on the tool bar. The following is an example of System Link type:

Once you add a System Link type, it is available everywhere in Elliott.  Above is an example of a System link for an Employee Hand Book, which points to the "m:\elliott7\DOC\EmployeeHandbook.pdf" file.

Program Link

There are two types of Program Links:

  • Programming Link
  • Automatic Program Link

Programming Link

These are links that require program modifications by Elliott or third-party developers.  Elliott currently provides two Programming Links: Google Maps and Weather Channel. See example below:

Generally speaking, you will not be able to add programming links on your own since the special programming is required.  You should not change the "Template" variable in the programming link.  It is possible Elliott may add additional programming links in the future. 

Automatic Program Link

These are the links that get created automatically based on the detection of the existence of a document file. See the following example: 

In the above example, if you have a sales order -- say 123456 -- and you place the file 123456.pdf (or 123456*.pdf) in the m:\elliott7\cus-po folder, then the link is established automatically without needing to add that link manually for the order.

An Automatic Program Link is different from Programming Link in the following ways:

  • You must have a "@@REF-ID@@" in the template for an automatic program link.
  • You must have a @@VAR1@@ (and maybe @@VAR2@@) in the template for a programming link.
  • You must specify "For this File Only" for an automatic program link.  In the above example, the link is designed as the received hard copy PO of the sales order, so it is a link that's related to the sales order header, and the corresponding table name is "CPORDHDR."  To add an automatic program link, you must know the table name of the link you are adding for.  These are the common ones: ARCUSFIL (Customer), APVENFIL (Vendor), IMITMFIL (Item), CPORDHDR (Sales Order), POORDHDR (Purchase Order).

In a way, an Automatic Program Link is similar to a User Link because they are designed to link to documents or URLs from an Elliott master record. The difference is you do not need to add the link manually with an Automatic Program Link. Thus, an Automatic Program Link is easier to use than a User Link.

Generally speaking, an Automatic Program Link detects if the target documents exist.  If they do, then the link is displayed.  In the above example, if the order number is 123456, then Elliott will check if there are any files that exist with "m:\elliott7\cus-po\123456*.pdf."  If one ore more files is found, then they will be displayed as a link in the list.  Elliott links support both drive letter and UNC path.  You can also use http or https in the template for Automatic Program Links. In that case, Elliott does not check if the URL exists and will always display the link. Also, when you use http or https with an Automatic Program Link, the wildcard character "*" or "?" will not work as you would normally expect.

The following is a list of Automatic Program Links created by default with Elliott:

AP Open Invoice Link

The value @@REF-ID(8:6,1:1='V')@@ refers to the AP invoice voucher number. This is because in the APOPNFIL table, the first byte can be "V" (Voucher) or "X"" (Check).  So 1:1='V' will check if the primary key (@@REF-ID@@) of APOPNFIL first byte = "V".. Then the following 6 bytes is the vendor number -- starting from the 8th byte, it is the 6-byte voucher number.  Therefore, the voucher number is from the 8th byte for 6 bytes and hence "8:6." 

The purpose of this link is so that you can scan your AP invoice as a PDF file. Name them as the <voucher-number>.pdf.  With the above example, if your voucher number is 012345, then save 012345.pdf file in the m:\elliott7\apinv folder.  Then in AP Summary Account Inquiry, as you highlight the invoice, you will be able to bring up the invoice image through a links list or the hot key Alt-V.

AP History Invoice Link 

This is similar to an AP Open Invoice Link, except it is applicable to the AP History Table for open invoices that are purged to the history.

AP New Trx Invoice Link

This is the PDF file that's attached to the AP New Trx file before it is posted. Note that the APTRXFIL primary key is the voucher number.

COP Customer PO Link

Customer Info Link

Vendor Info Link

Managing Links

 Since user links are at the master record level, we will go directly to Customer File Maintenance, open a customer file and click the Links Icon.  From here, we will define the Link fields; create User Links and a System Link.

                        A/R Main Menu à Maintenance à Customer file à Change

 Customer File Maintenance for Customer # 300, click the Links Icon to access the screen below.

 Two links currently exist because:

  1. First link is a System Link that is automatically available anywhere to all users in Elliott.
  2. Second link is a Program Link that appears when an address is available in a master record.


Systems Manager

  1. Mapped Drives Disappear After Logoff or Reboot
  2. Using Raw Data Pass Through for Dot Matrix Printer on Windows 10 Does Not Work
  3. How Do I Find The Workstation That's Infected with The Crypto Ransom Ware?
  4. How to Reset the Counter in *.DAT Files After Recovery from Crypto Ransom Ware Attack
  5. Aging Shows Differently After Database Rebuild
  6. What Do I Do When My Anti-virus Software Reports Elliott EXE File as a Virus?
  7. High CPU Usage and Performance Issues After Implementing NTFS Security
  8. "We can't verify who created this file. Are you sure you want to run this file?"
  9. Problem with Printer Configuration If Running Elliott from Multiple Workstations
  10. Inconsistent Elliott Error on Terminal Server
  11. How to Restore Elliott from CryptoWall Ransomware Attack
  12. Clarify Laser Forms Line Item Level Barcode Printing
  13. Is Dot Matrix Printer Still Supported in Elliott with Windows 10?
  14. Should I Install the 32-bit or 64-bit Outlook/Office?
  15. I Receive Error 114 When I Start Up Elliott on the Server
  16. Manage Data Execution Prevention (DEP) Through Registry Editing
  17. Windows Defender May Cause Elliott Start-Up Difficulties
  18. Why Do I Exceed Elliott User License Count When There are No or Very Few Users in Elliott?
  19. What Causes Load Error 198?
  20. How the Windows Scheme You Choose May Affect the Elliott Screen Display
  21. Still Get Error 114 After Adding All Elliott EXE Files to the DEP List
  22. How to Copy Laser Form Templates from Company to Company
  23. Weird Character Displayed for Backslash (\) Character
  24. Does Elliott Support Desktop Virtualization?
  25. Access Is Denied When Launching Elliott V8 Report Viewer
  26. User Cannot See Some Spooled Reports in Elliott V8
  27. Why Does the User List Function Take Forever to Bring Up?
  28. I Am Running Out of Invoice Numbers -- I Need Direction to Archive Invoices
  29. Algorithm to Speed Up eContacts List in Elliott V8
  30. Elliott Requires Volume Supporting 8dot3name
  31. Elliott Running Extremely Slow on Windows 8 with Trend Micro Anti Virus Software Installed
  32. What Causes "File Table Exceed Limit" Error?
  33. Mass Email Time Out
  34. Report Incomplete After 4 Hours: Event Stops Working After Upgrade to Elliott V8
  35. File Created in C:\ Root Directory Disappears
  36. Is There a Way to Create and Distribute Elliott Printer Configurations?
  37. What Are "COBOL Only" or "User Defined" Event Actions? Can We Use Them in Any Way?
  38. How to Purge WSORDHDR.BTR and WSORDLIN.BTR files?
  39. CPORDLS (Order Serial/Lot File) Btrieve Page Size
  40. Create PO Receiving Event to Trap Negative Qty on Hand Problem
  41. Reducing File Sizes for INITLFILE.LOG & SYACTLOG.BTR
  42. Windows 10 and Trend Micro Anti-Virus Software
  43. The Remote Certificate Is Invalid According to the Validation Procedure
  44. Customer Has Multiple Primary Contacts or No Primary Contact
  45. Btrieve Error 46 on S/M Activity Log File
  46. Multi-Currency Workarounds in Elliott
  47. Using the Export Processor to Export Data
  48. Instructions for Importing Laser Form Template
  49. I Am Unable to Post or Enter a Date for the New Year
  50. Does Elliott Work Under Virtualized Desktops Infrastructure (VDI)
  51. Btrieve Error 80 During Defer Processing
  52. Lauch CSV File -- There Was a Problem Sending the Command to the Program
  53. Feature - System Users File Integrity Check
  54. Receive Error in NWSMSCRN for Function Pf-Map-Coordinate-Space
  55. Not Able to Receive Event Emails from Certain Users
  56. Feature - Events for Add Note and Delete Note
  57. When and How to Use DDF2BTR.EXE Utility
  58. Elliott Last Printing Job Overrides Windows Default Printer on Windows 10
  59. Not Able to Change Attributes Added by Other Users
  60. Feature - New Context Menus in v8.0 Spooled Reports Manager
  61. Feature - Automatic Archiving of Spooled Reports in Elliott v8.0
  62. Feature - Enhanced Security for Attributes
  63. Feature - Deferred Processing Multiple Times Per Day
  64. Feature - Ability to Specify User ID in User Search
  65. Feature - Utility to Re-Calculate Item First Received and Last Received Date
  66. NSCTLMN1 Global Setup Time Clock Global Setup
  67. How to Set Up One-to-One Restriction of Customer and Item
  68. Recursion Error When Drill Down to Item File Inquiry
  69. Error Invoking Macro - Cannot Install Hook
  70. Feature - Record Navigation in Attribute Window
  71. Error Connecting VPN from Windows 10 to Windows 2008 Server
  72. How to Stop Users from Sending Elliott Reports through Email
  73. Does Elliott Support Windows 10?
  74. It Is Extremely Slow to Run Elliott over VPN Connection
  75. SYTIMCLK Systems Manager General Time Clock
  76. Feature - Recalculate AP Vendor YTD and Last Year Amount
  77. XCO0100 Systems Manager Design Your Own Order
  78. Feature - Restrict Recurring Event for Number of Times for a Specific Reference
  79. How Do I Limit the Companies for Users?
  80. Feature - Enforced Report Destinations
  81. I Am Unable to Create a New User in Elliott
  82. Feature - PDF Printing in Elliott V8.2
  83. Feature: PDF PostOffice in Elliott V8.2, Introduction
  84. Feature: PDF PostOffice in Elliott V8.2, Part 1
  85. Feature: PDF PostOffice in Elliott V8.2, Part 2
  86. Feature: PDF PostOffice in Elliott V8.2, Part 3
  87. Feature - Added Checkbox and Description to Attribute List and the SPS Commerce Create Attribute Register
  88. Feature - Performance Options for eContact Activity Tab
  89. Feature - Mass Change Salesman Utility
  90. Elliott Installer File-In-Use Warning During Installation
  91. Unable to Run Elliott from UNC Path
  92. V8 Program Desktop Startup Shortcuts - Internal Macro
  93. Event When Order Put On Hold at Invoice Printing
  94. Feature - Time Clock Logoff Type
  95. Feature - Added Distribution to G/L History Files
  96. Feature - Utility to Update eContact PDF PostOffice Flags
  97. Can I Use Elliott for Sales, Telemarketing and CRM Purposes?
  98. Emailing PDF with SSPI Failed After Online Charging Using Credit Card
  99. Can You Explain How Elliott Stores Serial Numbers in Its Database?
  100. Converting Elliott Internal Date to Conventional Date Format in Excel
  101. All of a Sudden, My Terminal Server's Elliott Default Changed to Someone Else's Settings
  102. WannaCry Ransomware Security Recommendation
  103. Symantec Endpoint Protection Versions 12 and 14 Cause Elliott Startup Error
  104. Notes Security - From Global Setup, Note Type to Supervisory Relationship
  105. Remote Desktop Workstation Name
  106. Which Anti-Virus Software Do You Recommend to Installing on the Elliott ERP Server?
  107. Menu Access Error - You Do Not Have Access to CP,INQ, Menu Item 01
  108. Ping Test to Isolate Inconsistent Load Error 198
  109. The Definitions of Extra Flags in System Period Control Setup
  110. How to Use Procdump.exe to Create a Memory Dump for PSQL Engine
  111. Feature - Group Location Security
  112. NSCTLMN4 Global Setup Bill of Lading 1
  113. NSCTLMN4 Global Setup Bill of Lading 2
  114. NSCTLMN4 Global Setup Bill of Lading 3
  115. NSCTLMN4 Global Setup Bill of Lading 4
  116. NSCTLMN4 Global Setup Bill of Lading 5
  117. NSCTLMN4 Global Setup Bill of Lading 6
  118. NSCTLMN4 Global Setup Bill of Lading 7
  119. NSCTLMN4 Global Setup Bill of Lading 8
  120. NSCTLMN4 Global Setup Bill of Lading 9
  121. NSCTLMN4 Global Setup Bill of Lading 10
  122. NSCTLMN4 Global Setup Bill of Lading: Index
  123. Feature - Support 12 Months History in Export Processor
  124. NSCTLMN3 Inventory Management Global Control Setup 1
  125. NSCTLMN3 Inventory Management Global Control Setup 2
  126. NSCTLMN3 Purchase Order Global Control Setup 1
  127. NSCTLMN3 Purchase Order Global Control Setup 2
  128. NSCTLMN3 Bill of Material and Production Order Global Control Setup
  129. NSCTLMN3 Distribution Modules Global Setup: Index
  130. NSCTLMN5 Global Setup Change Quote to Order 1
  131. NSCTLMN5 Global Setup Change Quote to Order 2
  132. NSCTLMN5 Global Setup Change Quote to Order 3
  133. NSCTLMN5 Global Setup Change Quote to Order 4
  134. NSCTLMN5 Global Setup Change Quote to Order 5
  135. NSCTLMN5 Global Setup Change Quote to Order 6
  136. NSCTLMN5 Global Setup Change Quote to Order: Index
  137. I Cannot See the Spooled Reports Even though I Am an Administrator Equivalent User
  138. Multi-Currency Exchange Handling in Elliott
  139. How to be a Good Elliott Citizen
  140. Salesman Security
  141. SYMENU System Manager Introduction 1
  142. SYMENU System Manager Introduction 2
  143. SYMENU System Manager Introduction 3
  144. SYMENU System Manager Introduction 4
  145. SYMENU System Manager Introduction 5
  146. SYMENU System Manager Introduction 6
  147. SYMENU System Manager Introduction 7
  148. SYMENU System Manager - External Macros
  149. SYMENU System Manager - Internal Macros
  150. SYMENU System Manager Introduction 10
  151. Feature - Audit Trail of Accumulator Clearing
  152. SYMENU System Manager Introduction 11
  153. SYMENU System Manager Introduction 12
  154. SYMENU System Manager Introduction 13
  155. SYMENU System Manager Introduction 14
  156. SYMENU System Manager Introduction 15
  157. SYMENU System Manager Introduction 16
  158. SYMENU System Manager Introduction 17
  159. SYMENU System Manager Introduction 18
  160. SYMENU System Manager Introduction 19
  161. SYMENU System Manager Introduction 20
  162. SYMENU System Manager Introduction 21
  163. SYMENU System Manager Introduction 22
  164. SYMENU System Manager Introduction 23
  165. SYMENU System Manager Introduction 24
  166. SYMENU System Manager Introduction 25
  167. SYMENU System Manager Introduction 26
  168. SYMENU System Manager Introduction 27
  169. SYMENU System Manager Introduction 28
  170. SYMENU System Manager Introduction 29
  171. SYMENU System Manager Introduction 30
  172. SYMENU System Manager Introduction 31
  173. SYMENU System Manager Introduction 32
  174. SYMENU System Manager Introduction 33
  175. SYMENU System Manager Introduction 34
  176. SYMENU System Manager Introduction 35
  177. SYMENU System Manager Introduction 36
  178. SYMENU System Manager Introduction 37
  179. SYMENU System Manager Introduction 38
  180. SYMENU System Manager Introduction 39
  181. SYMENU System Manager Introduction 40
  182. SYMENU System Manager Introduction 41
  183. SYMENU System Manager Introduction 42
  184. SYMENU System Manager Introduction 43
  185. SYMENU System Manager Introduction 44
  186. SYMENU System Manager Introduction 45
  187. SYMENU System Manager Introduction 46
  188. SYMENU System Manager Introduction 47
  189. SYMENU System Manager Introduction 48
  190. SYMENU System Manager Introduction 49
  191. SYMENU System Manager Introduction 50
  192. SYMENU System Manager Introduction 51
  193. SYMENU System Manager Introduction 52
  194. SYMENU System Manager Introduction: Index
  195. Elliott V7.0 Release Notes: What's New Since Elliott V6.7
  196. Elliott V7.1 Release Notes: What's New Since Elliott V7.0
  197. Elliott V7.2 Release Notes: What's New Since Elliott V7.1
  198. Elliott V7.3 Release Notes: What's New Since Elliott V7.2
  199. Elliott V8.1 Release Notes: What's New Since Elliott V8.0
  200. Elliott V7.4 Release Notes: What's New Since Elliott V7.3
  201. Elliott V7.5 Release Notes: What's New Since Elliott V7.4
  202. Elliott V8.0 Release Notes: What's New Since Elliott V7.5
  203. Elliott V8.2 Release Notes: What's New Since Elliott V8.1
  204. Drill Down and Receive Message You Do Not Have Access
  205. Problem Running Elliott After Upgrading Windows 10 to Fall Creator Edition
  206. MAPISendMail failed! Not supported [26]
  207. What Information Is Stored in System 12 Months Table (SY12MONS)?
  208. Elliott Telephony Integration - How to Call through My Telephone Set from eContact?
  209. Error Adding Printer Configuration After Latest Windows 10 Update
  210. Anti-Virus Causes PostOffice Emailing Problem
  211. Feature - Equal Sign Support in Export Processor
  212. Running Elliott 8.2 and Up on Windows 2003 Server
  213. How Can I Find Out About New Elliott Events Added or Changed Lately?
  214. Feature - Export Enhanced Attribute Predefined Code Value and Description
  215. Error 114 with GUIUTL32.LBR\ in Defer Processing
  216. EL800.EXE - Bad Image - MSVCRT20.dll Is Either Not Designed to Run on Windows or It Contains an Error
  217. Anti-Virus Caused Failure on Crystal Reports ODBC Access
  218. AVIRA Anti Virus Software Kills Elliott EL800 Executable
  219. Error: Trx Date Outside Date Range (00/00/00 - 00/00/00)
  220. How to Allow User to See All Spooled Reports in One Module
  221. A Support Case of Investigating Elliott Database Performance Problem
  222. Received Error in Macro DEALLOC-SHR-MEM Deallocate Failed - Invalid Pointor
  223. Feature - Added the Ability to Purge the System Activity Log
  224. Sequential File Access Status Code
  225. How to Start Defer Processing Automatically Upon Logging Onto Admin Account
  226. How to Set Up Elliott in Windows Program Menu (Start -> All Programs)
  227. Windows 1809 Update Causes Map Drive to Disconnect After Log Out
  228. CSV Import Supports Both MM/DD/YY and MM/DD/YYYY Date Formats
  229. Feature - Allow Mass Delete of Attribute Records
  230. SYSPASS DDF Shared Memory Not Available When Starting Up Elliott
  231. Do Not Use Extended ASCII Characters
  232. EL850US: Btrieve Error 094 on USERS SY Users Lic. File
  233. EL850CC: Btrieve Error 035 on SYEVTQUE Company File
  234. Feature - Calculate Order Total Sales Amount for Open Non-Picked Orders
  235. Why It's A Bad Idea to Update Elliott Data from External Source
  236. How to Start Elliott and Bypass User ID and Password for Automation
  237. Received Message "Elliott was not completely closed or it was not completely started"
  238. Btrieve Error 035 on XCOFORM D-Y-O-I Form Table File
  239. Inconsistent Error with Sending PDF PostOffice Email Due to Volume (Mass Email)
  240. Kyocera FS 2020D Printer Causes PDF PostOffice Invoice Printing to Crash
  241. Elliott Was Unable to Load the Following Module: EL800B.LBR
  242. Your File System May Lack 8.3 Filename Support
  243. Receive 'Invalid Column Name FILLER_001' After Changing to New Database Connection
  244. Feature - Order Integrity to Check for Kit Components and Support Order Ranges
  245. Does Elliott Support Windows Server 2019?
  246. User Received Lock Message on NSCTLFIL 000000100 in Sales Desk
  247. How to Use Notepad++ to See Special Characters In Your ASCII Import File
  248. What Is the Process for Changing an Existing Workstation's Elliott Workstation ID?
  249. How to Mass Update eContact to Disable from Login
  250. Feature: Print Document and Details from ListView
  251. Exported Tracking Number in CSV Shows Zeroes After the 15th Digit
  252. How to Fix Null Characters in NOTE Table
  253. Error 013 on ASCII File When Importing From CSV
  254. When Using F1 Key to Add-On-the-Fly, Receive "Company File Not Found" Message
  255. Group Policy for Power Management Sleep Settings May Stop Defer Processing from Running
  256. Feature - Disable Changing Contact Password Through Global Setup eContact Manager
  257. Control Ability to Change eContact Web Password
  258. How to Find Out If Elliott Supports a Particular Event
  259. Not Able to Increase or Decrease Elliott Font Size with A+ or A- Buttons
  260. User Is Not Able to Access the Module Even After I Gave Full Access
  261. PDF PostOffice Emails Are Rejected by Server for Some Users
  262. Btrieve Error 012 on SYSPASS Password File When Starting Up Elliott
  263. The Selected Menu Item Could Not Be Launched - Caused by Anti-Virus
  264. Suddenly One User Cannot Run Elliott - Resolved by Recreating User Windows Profile
  265. How do I change the tag on each copy of an invoice or other form? What would prevent them from printing?
  266. Inconsistent File Name in Btrieve Error Window
  267. Elliott Synchronizing to Local Error
  268. Error 037 on GLFSPASS GL Fin Stmnt Pass File

Feedback and Knowledge Base