R4.38 Technical

Release 4.38 Technical Notes

0001.00 -----------------------------------------------------------------------
0002.00 Notes for Release 4.38  Jul 1st, 2006                     
0003.00 -----------------------------------------------------------------------
0004.00                                                                        
0005.00 01) K3S_CVRT22 - Changes to table code records:                        
0006.00                                                                        
0007.00                     APP Applications Control                           
0008.00                                                                        
0009.00                                                 Default these 3 APP    
0010.00                                                 records for K3S_3600   
0011.00                                                 to TA_FLAG = 1         
0012.00                          K3S_3600  PR_BUYMULT - Include Buy Multiple   
0013.00                                                  in test?              
0014.00                          K3S_3600  PR_MAMINIU - Include Man Min Units  
0015.00                                                  in test?              
0016.00                          K3S_3600  PR_MINQTY  - Include Minimum Qty    
0017.00                                                  in test?              
0018.00                                                                        
0019.00                          K3S_3050  CHANGE_PO# - Allow changing of      
0020.00                                                  PO#?                  
0021.00                                                                        
0022.00                     RET Retain records # of days                       
0023.00                          K_INTDEAL record added with 60 days           
0024.00                                    for deal interface                  
0025.00                          K_PRODAPP record added with 3,650 days        
0026.00                                    for Prod Approved/Adjusted orders   
0027.00                                                                        
0028.00                     TLE Title of screens                               
0029.00                          K3S_3054FM1C  Product Hold Out by PO#         
0030.00                                                                        
0031.00 02) K3S_FX438A - Add new K3S message with message ID of K3_9017 to be  
0032.00                   used in K3S_1020 for canceling orders.               
0033.00                                                                        
0034.00 03) K3S_FX438B - Set the three APP records TA_FLAG1 value to 1 for     
0035.00                       K3S_3600  PR_BUYMULT                             
0036.00                       K3S_3600  PR_MAMINIU                             
0037.00                       K3S_3600  PR_MINQTY                              
0038.00                                                                        
0039.00 04) K3S_FX438C - Clean up K_SUPLLTM file.                              
0040.00                       1. Lead time before = 0, then delete record      
0041.00                       2. Duplicate records in file, then delete record 
0042.00                       3. Supplier no longer in database, delete record 
0043.00                       4. Buy group blank, update from supplier record  
0044.00                                                                        
0045.00 05) K3S_LOGREL - Needed to be recompiled with change to file           
0046.00                   K_PHLDLOG where field H0_PO# added.                  
0047.00                                                                        
0048.00 06) K3S_MSGADD - Add new K3S message with message ID of K3_9017 to be  
0049.00                   used in K3S_1020 for canceling orders.               
0050.00                                                                        
0051.00 07) K3S_M070   - Fix when Off Invoice is using % and customer has      
0052.00                   Cost Divisors > 1, result for dollar value now       
0053.00                   correct.                                             
0054.00                                                                        
0055.00 08) K3S_0010   - K3S Main Menu to show new Release 4.38 Jul-01-2006    
0056.00     K3S_0010FM - Change function key text with F10= and F11= to have   
0057.00                   new 'F18=Product interface log'                      
0058.00                                                                        
0059.00 09) K3S_1020   - When user presses F13= to cancel an order, an         
0060.00     K3S_1020FM    confirmation message now states to press F13=        
0061.00                   a second time to cancel, or F12= to return           
0062.00                  When user performs a CMB Combined or LOC Location     
0063.00                   split, the text does not disappear to understand     
0064.00                   each section.                                        
0065.00                                                                        
0066.00 10) K3S_1021CL - PARM of &SOQSEQ# should be *DEC LEN(3 0), and not     
0067.00                   *CHAR.                                               
0068.00                                                                        
0069.00 11) K3S_1040   - Product not yet received -is a new message that       
0070.00     K3S_1041      can be displayed for a customer based upon a new     
0071.00                   APP record 'K3S_1500  MUST_RECV'                     
0072.00                - When F8= exit point used, rebuild vary text line      
0073.00                   upon return from exit.                               
0074.00                - When F11=Products used, rebuild vary text line        
0075.00                   upon return from K3S_3000.                           
0076.00                                                                        
0077.00 12) K3S_1100   - Add of PO# to Hold Out Log file                       
0078.00                                                                        
0079.00 13) K3S_1101   - Add of PO# to Hold Out Log file                       
0080.00                                                                        
0081.00 14) K3S_1500   - For P2 Permanent Deal of Off Invoice and Factor Typ $ 
0082.00                   the PQ_COSTEAC value needed to be calculated properly
0083.00                - Ensure proper setting for PQ_SOQSSO, now required by  
0084.00                   new program K3S_1540                                 
0085.00                - For Daily Replenishment, map values for Expected      
0086.00                   Stock Out values for new program K3S_1540            
0087.00                                                                        
0088.00 15) K3S_1540   - New program to capture supplier suggested order       
0089.00                   information and place into file K_SUPLDLY.           
0090.00                                                                        
0091.00 16) K3S_2000   - When F6=Add pressed two records written to file       
0092.00                   K_SUPLLTM, where 1st one has 'before' value of 0.    
0093.00                   No longer writting that 1st invalid record.          
0094.00                - Field SL_BUYR was not being populated at all.         
0095.00                - Fix program K3S_FX438C will clean up file K_SUPLLTM.  
0096.00                                                                        
0097.00 17) K3S_3Q01   - Out of stock and none on order. This is a template    
0098.00                   program going into K3S_MOD, that customers can use   
0099.00                   as a proto-type for building Qxx batches.            
0100.00                                                                        
0101.00 18) K3S_3030   - When F8= exit point used, rebuild vary text line      
0102.00     K3S_3031      upon return from exit.                               
0103.00                - When F11=Products used, rebuild vary text line        
0104.00                   upon return from K3S_3000.                           
0105.00                                                                        
0106.00 19) K3S_3034   - Fix where records of 0's in K_PRODHIS being read      
0107.00                   further back than starting year and period should    
0108.00                   when re-averaging through batch process.             
0109.00                                                                        
0110.00 20) K3S_3037   - Logic added to make sure that only PH_HISTYPE = 0     
0111.00                   records are used to determine information, and not   
0112.00                   PH_HISTYPE > 0. (Same true for PW_HISTYPE weekly)    
0113.00                                                                        
0114.00 21) K3S_3042   - Just needed recompile for new field added to          
0115.00                   K_PHLDLOG for PO#.                                   
0116.00                                                                        
0117.00 22) K3S_3050   - By changing the new APP record 'K3S_3050  CHANGE_PO#' 
0118.00     K3S_3050FM    to TA_FLAG1 = 1, users can then change PO#s on the   
0119.00                   Hold Out screen.                                     
0120.00                - New 'F21=By PO#' exit which calls K3S_3054            
0121.00                                                                        
0122.00 23) K3S_3051   - By changing the new APP record 'K3S_3050  CHANGE_PO#' 
0123.00     K3S_3051FM    to TA_FLAG1 = 1, users can then change PO#s on the   
0124.00                   Hold Out screen.                                     
0125.00                                                                        
0126.00 24) K3S_3052   - Recompiled for new K_PHLDLOG containing H0_PO#        
0127.00                                                                        
0128.00 25) K3S_3053   - Changed to pass PU_PO# to K3S_3056 for logging.       
0129.00                                                                        
0130.00 26) K3S_3054   - New program to maintain Hold Outs by PO#              
0131.00     K3S_3054FM                                                         
0132.00                                                                        
0133.00 27) K3S_3056   - Includes logging of PO#                               
0134.00                                                                        
0135.00 28) K3S_3057   - Recompiled for new K_PHLDLOG containing H0_PO#        
0136.00     K3S_3057FM    and to display that information                      
0137.00                                                                        
0138.00 29) K3S_3070   - Improved the processing when user changes Views       
0139.00                                                                        
0140.00 30) K3S_3200   - Change text to 'Batch Cost $ Value' in screen.        
0141.00     K3S_3200FM    (no changes to RPG)                                  
0142.00                                                                        
0143.00 31) K3S_3225   - Change text to 'Total cost $ changed for batch:'      
0144.00     K3S_P3225     (no changes to RPG)                                  
0145.00                                                                        
0146.00 32) K3S_3241   - When 3=Copy used to re-populate K_INTCUST, no need    
0147.00                   to make adjustments to field CB_ACTUREG in file      
0148.00                   K_CUSTBCH. Statements removed.                       
0149.00                                                                        
0150.00 33) K3S_3270   - F15=Generate function fixed.                          
0151.00                                                                        
0152.00 34) K3S_3450   - Changed column heading to: New Supplier Source        
0153.00     K3S_3450FM                        from: New Supl Source            
0154.00                                                                        
0155.00 35) K3S_3780   - Ensure From and To dates get completely edited        
0156.00                   prior to Submit of job.                              
0157.00     K3S_3780CL - Remove a section of logic not needed which was using  
0158.00                   Utility CVTSPLFSTMF.                                 
0159.00                                                                        
0160.00 36) K3S_4007   - When user presses F12=, pass proper value back to     
0161.00                   K3S_4000 so it does not lock up.                     
0162.00                                                                        
0163.00 37) K3S_9010   - Fix for when product goes into delete count, drops    
0164.00                   out, then gets added back the following year.        
0165.00                   History is discovered from last year, but we want    
0166.00                   new history record added for this year too.          
0167.00                - When buyer using 'Exclude buying until' and the       
0168.00                   product is over 90 days out, then exclude from       
0169.00                   PE1 - PE5 checks.                                    
0170.00                                                                        
0171.00 38) K3S_9011   - Fix for when product goes into delete count, drops    
0172.00                   out, then gets added back the following year.        
0173.00                   History is discovered from last year, but we want    
0174.00                   new history record added for this year too.          
0175.00                                                                        
0176.00 39) K3S_9505   - Added file K_PRODAPPA to process old records.         
0177.00                - Added file K_INTDEAL to process old records.          
0178.00                                                                        
0179.00 -----------------------------------------------------------------------
0180.00 Physical and logical files added or changed during this release        
0181.00 -----------------------------------------------------------------------
0182.00                                                                        
0183.00 K_PHLDLOG  - Added field H0_PO# to log PO# changes (CPYF *MAP *DROP)   
0184.00 K_PHLDLOGA - Recompiled for H0_PO# change                              
0185.00 K_PRODAPPA - New logical on K_PRODAPP for K3S_9505 use.                
0186.00 K_PRODHLDG - New logical using PU_PO# for Hold Outs by PO# programs.   
0187.00 K_SUPLDLY  - New physical for capturing Supplier Log of order delays   
0188.00 K_SUPLDLYA - New logical on K_SUPLDLY                                  
0189.00                                                                        
0190.00 After this release installed, there should be exactly 366 objects      
0191.00 in library K3S_DTA (data files library) (Rel 4.37 had 362 objects)     
0192.00                                                                        
0193.00 -----------------------------------------------------------------------
0194.00 Special conditions for some customers                                  
0195.00 -----------------------------------------------------------------------
0196.00                                                                        
0197.00 USA Drug, Liberty USA and Navarro all have files K_SUPLDLY and         
0198.00 K_SUPLDLYA capturing data for future release. Ensure a backup of the   
0199.00 physical file to K3S_BAK437 prior to running LODRUN for new release.   
0200.00                                                                        
0201.00 -----------------------------------------------------------------------
0202.00 Programs in library K3S_MOD438                                         
0203.00 -----------------------------------------------------------------------
0204.00                                                                        
0205.00 -- RPGLE                                                               
0206.00 K3S_CVRT22   New Table Code entries                                    
0207.00 K3S_1100     Add one statement to log PO#      EVAL H0_PO# = PU_PO#    
0208.00 K3S_1101     Add one statement to log PO#      EVAL H0_PO# = PU_PO#    
0209.00 K3S_3Q01     Out of stock and none on order   template for K3S_3Qxx's  
0210.00                                                                        
0211.00 -- CLLE                                                                
0212.00 none                                                                   
0213.00                                                                        
0214.00 -- CMD                                                                 
0215.00 none                                                                   
0216.00                                                                        
0217.00 -- DSPF                                                                
0218.00 none                                                                   
0219.00                                                                        
0220.00 -----------------------------------------------------------------------
0221.00 Implementation steps for this release                                  
0222.00 -----------------------------------------------------------------------
0223.00