R6.4 Technical

Release 6.4 Technical

0001.00 -----------------------------------------------------------------------         
0002.00 Notes for Release 6.4   Jan 01, 2022                      rel_6.4.doc           
0003.00 -----------------------------------------------------------------------         
0004.00                                                                                 
0005.00 01) K3S_APIGET - New parameter to pass FTP site to pull updates.                
0006.00     K3S_APIIN    User/password change. Use new SAVF K3SAPISOBJ in QGPL.         
0007.00     K3S_APIUPD                                                                  
0008.00                                                                                 
0009.00 02) K3S_CVRT22 - Changes to table code records/New table code records:          
0010.00                                                                                 
0011.00                     API - Setup values and info for APIs & Night Job            
0012.00                                                                                 
0013.00                         NIT - Night Job schedule display on login               
0014.00                                                                                 
0015.00                         HIDEARRIVE - Hide PO Arrival date on PO approval screen 
0016.00                                                                                 
0017.00                     APP - Application codes                                     
0018.00                                                                                 
0019.00                         NOTE_DSPLY - Control note sequence in R6                
0020.00                                                                                 
0021.00                     BTN - R6 display of buttons                                 
0022.00                                                                                 
0023.00                         QUICKORDER - Quick Adjust Product Button                
0024.00                         YWALLPROD  - Your Window for All Locations for a product 
0025.00                         YWAPRORDR  - Your Window for Approve Order               
0026.00                         YWDETAILS  - Your Window For Product Details / History   
0027.00                         YWORDER    - Your Window for Supplier Suggested Order    
0028.00                         YWPOLIST   - Your Window PO Header                       
0029.00                         YWPRDORD   - Your Window for Products on Order           
0030.00                         YWPRODSET  - Your Window for Product Settings            
0031.00                                                                                  
0032.00                     RET - Retain records # of days                               
0033.00                                                                                  
0034.00                         K_INTDALY - change default to 365 days                   
0035.00                         K_DLYPROD - change default to 365 days                   
0036.00                         K_INVPROD - change default to 730 days                   
0037.00                         K_INVSUPL - change default to 730 days                   
0038.00                                                                                  
0039.00                     SEM - Security For Viewing Menu Options                      
0040.00                                                                                  
0041.00                         AAX - Authority to Purchase Orders Controller            
0042.00                         AAY - Authority to Inventory Metrics ReStore             
0043.00                                                                                  
0044.00                     SWT - Do not allow change supplier with this       JOB       
0045.00                           supplier ID                                            
0046.00                                                                                  
0047.00                     YSW - Your Window                                            
0048.00                                                                       
0049.00                         TEMPLATE - Template for Your Window           
0050.00                                                                       
0051.00 03) K3S_FX640A - Adjust RET tablcode for K_INVSUPL and K_INVPROD      
0052.00                  to allow Supplier Orders to show last year purchase  
0053.00                  totals with retain set at 730 days.                  
0054.00                                                                       
0055.00 04) K3S_INVCMP - metrics cleanup GH827                                
0056.00          - Force service level to 100% when demand = 0                
0057.00          - Increase workfield sizes                                   
0058.00          - Do not need to check if buy group is excluded from         
0059.00          metrics as K_INVPROD will not have any data for buygrp       
0060.00                                                                       
0061.00 05) K3S_INVLOCN - metrics cleanup GH827                               
0062.00          - Force service level to 100% when demand = 0                
0063.00          - Increase workfield sizes                                   
0064.00          - Do not need to check if buy group is excluded from         
0065.00          metrics as K_INVPROD will not have any data for buygrp       
0066.00                                                                       
0067.00 06) K3S_INVPRD  - metrics cleanup GH827                               
0068.00        - Force service level to 100% when demand = 0                  
0069.00        - Increase workfield sizes                                     
0070.00        - key list fix to make sure we are grabbing flag               
0071.00        to see if this buy group should be bypassed from metrics       
0072.00        - Use the same cost for across all calculations                      
0073.00                                                                             
0074.00 07) K3S_INVSPL - metrics cleanup GH827                                      
0075.00        - Force service level to 100% when demand = 0                        
0076.00        - Increase workfield sizes                                           
0077.00                                                                             
0078.00 08) K3S_LTFIX  - Optional use; patch K_PRODLTM when assign to               
0079.00     K3S_LTFIX1   K3S supplier is used and SUPL/SUPLSUB are not synced.      
0080.00                                                                             
0081.00 09) K3S_PO_IGN - Optional use; ignore transfer POs from K_INTORDL           
0082.00                  for multi location customers.                              
0083.00                                                                             
0084.00 10) K3S_R6HOT  - New parameter to pass FTP site to pull updates.            
0085.00     K3S_R6HOTI   User/password change. Use new SAVF K3SHOTFIX in QGPL.      
0086.00                                                                             
0087.00 11) K3S_X310CL - Remove the call to AC_CPOAPOR                              
0088.00                - Add CLRPFM to 4 Dynamic List files                         
0089.00                                                                             
0090.00 12) K3S_1500   - Legacy green screen comment out logic to lock order   just 
0091.00                  when user is in F21=Start mode on K3S_1010 and             
0092.00                  recalculating orders and do not set busy flag.             
0093.00                - If a supplier has been organized at least once in the      
0094.00                  past and now the order cycle is > 6 months old, and        
0095.00                  all the prodcucts are Manual and/or discontinued, do       
0096.00                  do not prompt the buyer to re-organize it,                   
0097.00                  until at least 1 product is to be replenished again.         
0098.00                                                                               
0099.00 13) K3S_3026   - Look for suppliers to be included in the process to adjust   
0100.00      (04/14/19)  products Line Cost. Suppliers that have                      
0101.00     K3S_3026CL   SP_GROUP4 = 'MINSPREDxx' are in this group.                  
0102.00                                                                               
0103.00                                                                               
0104.00 14) K3S_3027   - Retrieve Order Point and Order Up To per Line Cost for       
0105.00      (04/16/19)  one product.                                                 
0106.00                                                                               
0107.00 15) K3S_3030   - Legacy green screen. Change to allow creation                
0108.00     K3S_3031     of seasonal profile with a 0.00 factor.                      
0109.00     (01/09/18)                                                                
0110.00                                                                               
0111.00 16) K3S_3158   - Add hold outs from an external source daytime         e      
0112.00     K3S_3158CL   and log the add.                                             
0113.00                                                                               
0114.00 17) K3S_3220   - Improvment; when buyer creates customer usage batch   e      
0115.00      (03/28/19)  and uses the Freeze Forecast Until feature, we need to       
0116.00                  log to K_PRODLOG to show the Freeze Forecast Until           
0117.00                  field changed.                                               
0118.00                                                                               
0119.00 18) K3S_3340   - Theoretical Inventory calculation now understands the        
0120.00      (09/07/18)  inclusion of both Supplier Add Days and Product Add Days. 
0121.00                                                                            
0122.00                                                                            
0123.00 19) K3S_3361   - Purchase adjustments report must consider cost divisor    
0124.00     K3S_3362     if > 1; previously it was fixed at 1.                     
0125.00     K3S_3363                                                               
0126.00     K3S_3364                                                               
0127.00      (01/07/18)                                                            
0128.00                                                                            
0129.00 20) K3S_3439   - Weekly pattern checks to understand new 'F' type in       
0130.00      (01/15/21)  K_SUPLVOC for fresh suppliers.                            
0131.00                                                                            
0132.00 21) K3S_3940   - Logic added to understand customers who send K3S          
0133.00      (09/05/18)  Period-to-date information, instead of Daily              
0134.00                  Information. This is known by the field LC_DAILY.         
0135.00                                                                            
0136.00 22) K3S_5080  - Identify and update products that have become              
0137.00     K3S_5081    unattached to their deal. Also identify                    
0138.00     K3S_5082    new products that need                                     
0139.00     K3S_5085    to be attached to a deal.                                  
0140.00     K3S_5080CL                                                             
0141.00     K3S_5085CL                                                             
0142.00                                                                            
0143.00 23) K3S_9100  - Do not error when only 1 good records sent from            
0144.00                 diverter                                                
0145.00                                                                         
0146.00 24) TS_LTMAPOR- Optional use; used to patch past PO statuses based     e
0147.00                 on value in tablecode.                                  
0148.00                                                                         
0149.00 ----------------------------------------------------------------------- 
0150.00 Physical & logical files added/changed/deleted in release for K3S_5DTA  
0151.00 ----------------------------------------------------------------------- 
0152.00                                                                         
0153.00 There are 6 new Physical files and 2 new Logical files added in this    
0154.00 release. There is 1 physical file changed.                              
0155.00                                                                         
0156.00 New files:                                                              
0157.00   K_ALLWORK  PF  Work File - All                                 AW     
0158.00   K_INTHLDD  PF  Interface for Product Hold Out records Daytime  IT     
0159.00   K_INTHLDDA LF  Interface for Product Hold Out LOCN,SUPL,SUB,PROD      
0160.00   K_INTSDIS  PF  Interface for Supplier Discount Brackets        IK     
0161.00   K_INTSDISA LF  Interface for Supplier Disc Brkt - SUPL,SUB,BKT        
0162.00   K_PRDWORK  PF  Work File - Products                            RW     
0163.00   K_PROWORK  PF  Work File - Products                            OW     
0164.00   K_SPLWORK  PF  Work File - Suppliers                           SW     
0165.00                                                                         
0166.00 Files changed:                                                          
0167.00   K_INVRLOG                                                             
0168.00                                                                            
0169.00 After this release installed,  there should be exactly 519 objects         
0170.00 in library K3S_5DTA (data files library) (Rel 6.3  had 511 objects)        
0171.00                                                                            
0172.00 -----------------------------------------------------------------------    
0173.00 Programs and Files in library K3S_5OBJ                                     
0174.00 -----------------------------------------------------------------------    
0175.00                                                                            
0176.00 -- RPGLE                                                                   
0177.00 K3S_1500    Create Supplier Suggested Orders                               
0178.00 K3S_3026    Look for Suppliers/Products to adjust Line Cost                
0179.00 K3S_3027    Retrieve OPNT & OUTL per Line Cost for 1 product               
0180.00 K3S_3030    Product history                                                
0181.00 K3S_3031    Product history use with K3S_8000                              
0182.00 K3S_3220    Customer usage log when freeze forecast used                   
0183.00 K3S_3340    Ranking reports - get totals K_RANKSPL/K_RANKPRD               
0184.00 K3S_3361    Purchase adjustments - Report results Buyer                    
0185.00 K3S_3362    Purchase adjustments - Report results Locations                
0186.00 K3S_3363    Purchase adjustments - Report results Top Supl's               
0187.00 K3S_3364    Purchase adjustments - Report results Hub Supl's               
0188.00 K3S_3439    Weekly distribution - generate weekly exceptions               
0189.00 K3S_3940    Accumulate daily product information to K_DLYSVCE              
0190.00                                                                            
0191.00 -- CLLE                                                                    
0192.00                                                                         
0193.00 ----------------------------------------------------------------------- 
0194.00 Programs and Files in library K3S_5MOD                                  
0195.00 ----------------------------------------------------------------------- 
0196.00                                                                         
0197.00 -- RPGLE                                                                
0198.00 K3S_CVRT22  New Table Code entries                                      
0199.00 K3S_FX640A  Write last period stats by COMP to K_INVCOMP                
0200.00 K3S_INVCMP  Write last period stats by COMP to K_INVCOMP                
0201.00 K3S_INVLCN  Write last period stats by LOCN to K_INVLOCN                
0202.00 K3S_INVPRD  Write last period stats by PROD to K_INVPROD                
0203.00 K3S_INVSPL  Write last period stats by SUPL to K_INVSUPL                
0204.00 K3S_LTFIX   Patch SUPL & SUPLSUB on K_PRODLTM                           
0205.00 K3S_LTFIX1  One time patch past K_PRODLTM records                       
0206.00 K3S_PO_IGN  Auto ignore Transfer POs in K_INTORDL                       
0207.00 K3S_3158    Load product hold outs - Daytime                            
0208.00 K3S_5080    Identify supplier switch, reconnect deal                    
0209.00 K3S_5081    Look for K_PRODUCT records missing deal info                
0210.00 K3S_5082    Patch K_PRODUCT records missing PR_DEAL* info               
0211.00 K3S_5085    Identify new products that need deal reattached             
0212.00 K3S_9100    Do not error when only one good record sent from diverter.  
0213.00                                                                         
0214.00 -- CLLE                                                                 
0215.00 K3S_3026CL  Process Suppliers with SP_GROUP4 = MINSPREDxx               
0216.00 K3S_3158CL  Load product hold outs - Daytime external load                
0217.00 K3S_5080CL  Identify supplier switch and came back                        
0218.00 K3S_5085CL  Identify new product reattaching to a deal                    
0219.00 K3S_X310CL  Exit***Before Final program end                               
0220.00 TS_LTMAPOR  R6.4 used to clean up PO stats                                
0221.00                                                                           
0222.00 -----------------------------------------------------------------------   
0223.00 Changes for library QGPL/QCLSRC                                           
0224.00 -----------------------------------------------------------------------   
0225.00                                                                           
0226.00 K3S_APIGET   K3S API: Get API programs from FTP site                      
0227.00 K3S_APIIN    K3S API: Input                                               
0228.00 K3S_APIUPD   K3S API: run both K3S_APIGET and K3S_APIXCL                  
0229.00 K3S_R6HOT    K3S R6 Hotfix: Pull K3SHOTFX SAVF & restore                  
0230.00 K3S_R6HOTI   K3S R6 HotFix: Input                                         
0231.00                                                                           
0232.00 -----------------------------------------------------------------------   
0233.00 Special instructions for all customers                                    
0234.00 -----------------------------------------------------------------------   
0235.00   -Scheduled job K3S_5RFRSH will need a 2nd parm added to specify         
0236.00    ftp site ('K3S.FILES.COM')                                             
0237.00   -Setup tablcode type API, value NIT to contain night job schedule       
0238.00    for display upon login.                                                
0239.00   -Object and source for fix programs starting with K3S_FX6* removed      
0240.00    from 5MOD and object placed into 5OBJ; should not have been in 5MOD    
0241.00    to begin with.                                                         
0242.00   -Data will be saved and added back to the PF changed K_INVRLOG.         
0243.00   -Note:old patches are being redistributed to catch up all               
0244.00    environments and core code to same release; these are noted with       
0245.00    a date.                                                                
0246.00 -----------------------------------------------------------------------   
0247.00 Special instructions for some customers                                   
0248.00 -----------------------------------------------------------------------   
0249.00   -Customers with large databases may consider indexing large             
0250.00    files (K_INTDALY, K_DLYPROD)                                           
0251.00   -Consider cleanup of PO statuses using TS_LTMAPOR process.              
0252.00   -If K_PRODLTM has many records with PL_USEFLAG = 4, consider use        
0253.00    K3S_LTFIX and K3S_LTFIX1 to clean up past records and add to           
0254.00    K3S_NIGHT process.                                                     
0255.00   -If the customer does transfer orders, consider adding call from        
0256.00    K3S_X310CL to K3S_PO_IGN to ignore transfer orders.                    
0257.00   -If the customer uses diverters consider change for K3S_9100            
0258.00    when only one valid entry sent.                                        
0259.00 -----------------------------------------------------------------------