Feature - Add Links Import to System Files Setup

Release date: 5/8/2019

Version 8.5 and up

Added a new menu option, System Utilities-> System File Setup-> Import-> Links.

The menu has three options: Pre-Interface, Interface, and Layout. 
 
The Layout screen has the following columns:

the Pre-interface and Interface have the following fields:

For all fields above, The last used value will be remembered for next-time use, and the user can override it and create the next-time default.

Valid entries for Input File Name are: APOPNFIL, APTRXFIL, APVENFIL, ARCUSFIL, AROPNFIL, BMORDFIL, CPBOLHDR, CPINVHDR, CPINVLIN, CPORDHDR, CPORDLIN, IMINVTRX, IMITMFIL,  IMLSHST, POORDHDR, POORDLIN, POWHRECI

For the Link Type field:
If a link type is entered, the link type must exist in SYLNKTYP. Entry of spaces is not allowed. An F1=Ad Hoc option is available. If the F1 key is pressed, Ad-hoc is displayed. 

Validation of the fields is as follows:

Reference ID
Value is Required.
Must be on file in the input file name provided. 
Value is converted to upper case before processing.
 
File-specific rules for Reference ID:
APVENFIL - Maximum size is 6 characters. 
                    Key is vendor number. 
                    The value will be formatted per vendor number rules. 
APTRXFIL - Maximum size is 6 characters.
                    Key is the voucher number. 
                    The value will be formatted per voucher number rules.
APOPNFIL - Provided key must be 13 characters.
                     Key is "V," Vendor number and voucher number.
AROPNFIL - Provided key must be 27 characters.
                     Key is customer number, document date, document number,  document type,
                     apply-to number.
ARCUSFIL - Maximum size is 6 characters. 
                     Key is customer number. 
                     The value will be formatted per customer number rules. 
BMORDFIL - Provided key must be 7 characters.
                     Key is order type and order number.    
IMITMFIL -   Maximum size is 15 characters. 
                     Key is item number.
CPORDHDR - Maximum size is 6 characters.
                       Key is order number. 
                       The value will be formatted per order number rules.
CPORDLIN - Provided key must be 9 characters.
                      Key is order number and line item sequence number.
CPINVHDR - Maximum size is 6 characters.
                       Key is invoice number. 
                       The value will be formatted per invoice number rules.
CPINVLIN - Provided key must be 9 characters.
                    Key is invoice number and line item sequence number.
CPBOLHDR - Maximum size is 9 characters.
                       Key is bill of lading number.
IMINVTRX - Provided key must be 30 characters.
                    Key is item number, transaction date (YYMMDD format), transaction time,
                    sequence number.
POORDHDR - Maximum size 8 characters.
                        Key is purchase order number and release number. 
                       The value will be formatted per purchase order number rules.
POORDLIN - Provided key must be 11 characters.
                      Key is purchase order number, release number, and line item sequence number.
POWHRECI - Provided key must be 14 characters.
                      Key is purchase order number, release number, line item sequence number,
                      and receiving sequence number.
IMLSHST -  Maximum size of 30 characters.
                    Key is item number and serial number, 15 characters for both values.

Value
Required
Maximum size is 80 characters if a link type was provided.
Maximum size for an ad hoc link value is 256 characters.

Ad-Hoc Desc
Required for Ad-Hoc links. If missing it is an error.
If not using Ad-Hoc link, it should not provided and is a warning.
Maximum size is 30 characters.

The following is a sample of the Pre-interface report:




Modified programs: SYFILMNU, SYLNKIMS (new), SYLNKIMP (new), CSVPA256.WS (new),
                                CSVPA256.PL (new)

DLM

Elliott Version 8.5

  1. V8.5 Alpha Document Number Support
  2. Crystal Report Conversion for V8.5
  3. The Run Local or Hybrid Feature in Elliott 8.5
  4. How to Use EL850DB.EXE Utility to Create PSQL Databases
  5. Showing Document Date in Links After Elliott 8.5
  6. The Lessons We Learned from Upgrading Web Service 8.2 to 8.5 in eStore
  7. Feature - ASCII File Filter Condition in Mass Email and Export Processor
  8. Feature - List Users Acively Logged into Elliott and Optionally Send Email
  9. Feature - Allow Print One Invoice to Print Duplicate Invoices for Order Not Posted
  10. Feature - Print Range of Duplicate Unposted Orders
  11. Feature - Prevent Duplicate Invoice Numbers with Invoice Cross Reference File
  12. Feature - Last Year Net Income Layout Support
  13. Receive Message "Not Found" When Trying to Set Up Run Local
  14. Receive 'Invalid Column Name' Message After Starting to Use Alphabetic Document Numbers
  15. Feature - Invoice Log Report
  16. Feature - Add Sales or Usage to Where-Used inquiry
  17. Feature - Case Size Support for Quantity Per Box
  18. Feature - Exclude Obsolete Customers from Customer Generic Search
  19. Feature - Refresh VICS Bill of Lading
  20. Feature - Support Item Case Size in New Item CSV Import and Change Existing Item Import
  21. Feature - Copy Notes, Attributes, and Links When Copying Item Through the New Item CSV Import
  22. Feature - Enhanced Cash Receipts Processing Apply-To Range
  23. Feature - Add Links Import to System Files Setup
  24. Feature - Shipment Email Acknowledgement for Bill-To Customers
  25. Feature - Restrict Sending Tracking Number to Bill-To Customer in Shipment Email Acknowledgement
  26. Feature - Allow Source Range on Credit Card Log Report
  27. Feature - Indented Bill of Material CSV
  28. Feature - Stock Status Reports Add Include with Alloc or On Order Quantity Option
  29. Feature - Release Manually Held Orders
  30. Feature - Create Shipment Records When Complete Bill Of Lading
  31. Feature - Print Warning Msg for Cancelled PO Line Item
  32. Feature - Export 25-Character PO Number in Expanded Aging Report CSV File
  33. Feature - Show Pending Cash Receipts in Payment History Inquiry
  34. Feature - Show Customer Note Fields in Payment History Inquiry
  35. Receive "Error Getting List of Override Reports" When Printing Report
  36. Feature - Fields Added to User-Defined CSV to Support EDI 846
  37. Feature - Credit Memo Warning When Fully Paid
  38. Feature - Create Shipment Verification Box Records Through Billing CSV Interface
  39. Feature - Show Box ID on Order Inquiry Shipment Data Screen
  40. Feature - Print Error Message If Inventory Transaction Distributions Are Missing
  41. Feature - Customer CSV Import
  42. Feature - Alleviate Error 25 When Two Users Import Sales Orders Simultaneously
  43. Feature - Use Note Type for Special Instructions on VICS BOL
  44. Feature - VICS BOL to Enforce Shipment Verification Before Printing of BOL
  45. Feature - Order/Invoice Inquiry Box Serial Number Drill Down
  46. Feature - Delete Order Tracking Note When Void Completed VICS BOL
  47. Feature - Picking Ticket For Customer 2 Event
  48. Feature - Set All Options to Allow or Disable in User Global Security
  49. Feature - Stock Analysis Creation by Customer Range
  50. Feature - Print Work Order Planned Hours on Plus Work Order Traveler
  51. How to Ensure Local Elliott Folder Is Up to Date
  52. Feature - Global Setup Flag to Update Tracking Note from Box Data Window
  53. Feature - Packing List by Box One Box Per Page
  54. Feature - Move EDI Profile Maintenance Maximum # of Item Per Label
  55. How to Update Elliott 8.5 License Key Code
  56. Installing Elliott 8.5 and Received "PSQL v11, v12 or V13 Is Required" Message
  57. Feature - Warehouse Receiving Missing Item Attribute Event
  58. Feature - Added a Drill Down to Order by Item Inquiry in Newly Received Items Inquiry
  59. Feature - Customer Type Display in Pick Order Processing
  60. Elliott V8.5 Configuration Utility (EL850CF.EXE)
  61. Feature - Add Customer Type to Pick Ticket Selection
  62. Feature - Void Checks after Posting Warning for Multiple Checks
  63. Error 1315 Unable to Write to the Specified Folder When Installing Elliott 8.5

Feedback and Knowledge Base