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

Feedback and Knowledge Base