R4.28 Technical

Release 4.28 Technical Notes


0001.00 -----------------------------------------------------------------------
0002.00 Notes for Release 4.28  May 30th, 2001                 
0003.00 -----------------------------------------------------------------------
0004.00 01) K3S_ADDSCD - Added Job schedule entry for generating Reminder notes
0005.00                  to users about hold out quantities expiring, on hold. 
0006.00                                                                        
0007.00 02) K3S_CVRT22 - Changes to table code records:                        
0008.00                                                                        
0009.00                     APP Applications Control                           
0010.00                          COMP_SUPL F5=APPROVE - Allow F5 approve       
0011.00                                                  without split. Flag 1 
0012.00                                                  is switch.            
0013.00                          K3S_2000  SP_GROUP1  - Require specific       
0014.00                                                  GROUP1 values. Use    
0015.00                                                  flag 1 as switch.     
0016.00                                                  If on they type of    
0017.00                                                  SG1 will contain valid
0018.00                                                  values.               
0019.00                          K3S_2000  SP_GROUP2  - Require specific       
0020.00                                                  GROUP2 values. Use    
0021.00                                                  flag 1 as switch.     
0022.00                                                  If on they type of    
0023.00                                                  SG2 will contain valid
0024.00                                                  values.               
0025.00                          K_PRODLNK PROCESSING - Added to description 2 
0026.00                                                  text of 'also _3600'  
0027.00                                                                        
0028.00                     CST Customer specific menu options                 
0029.00                          K3S_0060  16   - Added from 16 through 90     
0030.00                              "     xx                                  
0031.00                          K3S_0060  90                                  
0032.00                                                                        
0033.00                     HOQ Hold out quantity to expire                    
0034.00                          CONTROL   DAYS - Notify users # of days in    
0035.00                                            advance. Number 1 field     
0036.00                                            is # of days                
0037.00                          USER      XXXX - XXXX would be the user ID    
0038.00                                            to notify (10 long), can    
0039.00                                            be multiple records         
0040.00                                                                        
0041.00                     PFC Product forecast change types (added 1 type)   
0042.00                          E - Divisional P.C.S. request                 
0043.00                                                                        
0044.00                     RET Retain # of days                               
0045.00                          Added record for K_DEALLOG at 800 days for    
0046.00                          Deals Log Information                         
0047.00                                                                        
0048.00                     SG1 Supplier group 1 required                      
0049.00                          When group 1 required for suppliers, then     
0050.00                           values are listed as key values.             
0051.00                     SG2 Supplier group 2 required                      
0052.00                          When group 2 required for suppliers, then     
0053.00                           values are listed as key values.             
0054.00                                                                        
0055.00                     STP Service level type processing                  
0056.00                           Previous field for exclude was a flag, now   
0057.00                           turned into a field with 3 values.           
0058.00                          0  Normal processing                          
0059.00                          1  Exclude from processing                    
0060.00                          2  Reverse logic processing                   
0061.00                                                                        
0062.00                                                                        
0063.00                     TLE New title records for -                        
0064.00                          K3S_1015FM1C  Approved Orders Summary         
0065.00                          K3S_1015FM2R  Approved Orders PO              
0066.00                          K3S_1016FM1C  Approved Orders Products        
0067.00                          K3S_3036FM1R  Supplier History Selection      
0068.00                                                                        
0069.00 03) K3S_FIXHLD - This program will be used to remove records from the  
0070.00                   K_PRODHLD file that have records with bad data.      
0071.00                   Earlier versions of K3S would allow entry of data    
0072.00                   that was not valid.                                  
0073.00                                                                        
0074.00 04) K3S_FIXTAB - This program will be used to place additional text    
0075.00                   into description 2 for the APP record of             
0076.00                   K_PRODLNK PROCESSING. The text reads 'also 3600'     
0077.00                   which is the overstock processing program, that      
0078.00                   now includes the K_PRODLNK file.                     
0079.00                                                                        
0080.00 05) K3S_FIXYR  - This program will be used to ensure all K_PRODUCT     
0081.00                   records have the correct value in PR_FORCYR. Both    
0082.00                   K3S_3700 and K3S_3701 had PR_FORCYR added as PARMs   
0083.00                   during Release 4.27, and they were passing a         
0084.00                   value back that was sometimes less. Bindley and      
0085.00                   Core Mark, and a few others were patched earlier,    
0086.00                   but this program will make sure ALL customers        
0087.00                   are in sync.                                         
0088.00                                                                        
0089.00 06) K3S_NITECL - Added many new parameters to exit point calls for more
0090.00                  flexability.                                          
0091.00                                                                        
0092.00 07) K3S_PEREND - Added parameter for supplier sub field.               
0093.00                                                                        
0094.00 08) K3S_X010CL - Added many new parameters for more flexability.       
0095.00     K3S_X...CL                                                         
0096.00     K3S_X310CL                                                         
0097.00                                                                        
0098.00 09) K3S_0010FM - K3S Main Menu for new Release 4.28                    
0099.00                                                                        
0100.00 10) K3S_0060   - Customer specific menu - Added menu options 16        
0101.00     K3S_0060FM    through 90 via the F20=Toggle function. Now there    
0102.00                   are 6 of 6 screens.                                  
0103.00                                                                        
0104.00 11) K3S_1010   - Changes are:                                          
0105.00     K3S_1010FM    Using '6=Approve' can this combined order be         
0106.00                    approved without splitting?                         
0107.00                   With F23= exit to new Approved Orders Log.           
0108.00                   When using '4=Cancel' for many orders, the program   
0109.00                    would occaisionally go into a loop.                 
0110.00                   After pressing F5=APPROVE to view orders, had to     
0111.00                    press ENTER twice using the '5=View'.               
0112.00                                                                        
0113.00 12) K3S_1015   - New programs for display of 'Approved Orders Log'     
0114.00     K3S_1015FM    which are accessed from F23= on K3S_1010.            
0115.00     K3S_1016                                                           
0116.00     K3S_1016FM                                                         
0117.00                                                                        
0118.00 13) K3S_1020   - Understands the new capability for approving a        
0119.00                   combined supplier without splitting first.           
0120.00                                                                        
0121.00 14) K3S_1030   - Now diplay '1 of 6', '2 of 6', etc when using the     
0122.00     K3S_1030FM    F20=Toggle function key.                             
0123.00                  Program did not re-position correctly when '3=Hst'    
0124.00                   was the default (at DC Sales), and user had pressed  
0125.00                   F21= through the subfile.                            
0126.00                  When changing the 'View' and entering Product search  
0127.00                   value, the file K_PRODSOQ would be processed         
0128.00                   with an error.                                       
0129.00                                                                        
0130.00 15) K3S_1040   - Avoid the re-cursion problems, and provide a friendly 
0131.00     K3S_1041      error message for both 'Product Maintenance' and     
0132.00                   'Supplier Maintenance'.                              
0133.00                                                                        
0134.00 16) K3S_1050   - If allowing the approval of non-split combined orders,
0135.00                   then place Supplier Purchases data into combined     
0136.00                   supplier's ID.                                       
0137.00                                                                        
0138.00 17) K3S_1056   - New program to check suggested order for multiple     
0139.00                   suppliers. Called out of K3S_1010 and K3S_1020,      
0140.00                   and if combined supplier allowed to be approved      
0141.00                   without splitting, then the supplier ID's must all   
0142.00                   be the same.                                         
0143.00                                                                        
0144.00 18) K3S_1100   - Changes that understand the new capability to approve 
0145.00                   combined supplier without splitting.                 
0146.00                                                                        
0147.00 19) K3S_2000   - Changes that understand the new capability to approve 
0148.00     K3S_2000FM    combined supplier without splitting. Also changes for
0149.00     K3S_2002     required group codes if activated and note line added 
0150.00     K3S_2002FM   as well as CMD key 9 access to the notes system.      
0151.00                                                                        
0152.00 20) K3S_2040   - Note line added as well as CMD key 9 access to notes  
0153.00                  system.                                               
0154.00                                                                        
0155.00 21) K3S_3000   - Note line added as well as CMD key 9 access to notes  
0156.00     K3S_3000FM   system.                                               
0157.00                  Also on screen 5 of 5 added safety stock in days,     
0158.00                  order time factor in days, economic order interval    
0159.00                  in days, actual inventory dollar value, theoretical   
0160.00                  inventory dollar value, and actual/theoretical ratio. 
0161.00                                                                        
0162.00 22) K3S_3001   - Ability to enter lower case in sub supplier field.    
0163.00     K3S_3001FM                                                         
0164.00                                                                        
0165.00 23) K3S_3010   - Changes to understand and log copy history entries    
0166.00                  from online or batch (K3S_NITECL= Night Job)          
0167.00                                                                        
0168.00 24) K3S_3014   - Batch copy history from one supplier to another.      
0169.00                  Shut down a hub transfer division.                    
0170.00                                                                        
0171.00 25) K3S_3016   - Changes to check that product link entry would not    
0172.00                  point back at itself.                                 
0173.00                                                                        
0174.00 26) K3S_3017   - Batch reverse copy history from one supplier to       
0175.00                  another. Shut down a Hub transfer division.           
0176.00                                                                        
0177.00 27) K3S_3030   - Avoid the re-cursion problems, and provide a friendly 
0178.00     K3S_3031      error message for both 'Product Maintenance' and     
0179.00                   'Supplier Maintenance', plus new changes up-stream   
0180.00                   function for hub suppliers.                          
0181.00                                                                        
0182.00 28) K3S_3032   - New changes to forecast up-stream for Hub Suppliers.  
0183.00     K3S_3032FM   provides a window showing Hub supplier and the DC's   
0184.00                  that it feeds & ability to change their forecasts as  
0185.00                  well.                                                 
0186.00                                                                        
0187.00 29) K3S_3033   - New supplier history comparison report. Ability to    
0188.00     K3S_P3033    show a supplier selected years and periods of history 
0189.00                  on a report, used in lower pricing talks.             
0190.00                                                                        
0191.00 30) K3S_3036   - New supplier history comparison report selection      
0192.00     K3S_3036FM   criteria.                                             
0193.00     K3S_3036CL                                                         
0194.00                                                                        
0195.00 31) K3S_3040   - F20=Toggle was rolling down through the subfile       
0196.00     K3S_3040FM   now stays on same page.                               
0197.00                                                                        
0198.00 32) K3S_3050   - New CMD key 9 to generate hold out entries using      
0199.00     K3S_3050FM   a percentage of products forecast. New CMD key 19     
0200.00                  to show product groupings.                            
0201.00                                                                        
0202.00 33) K3S_3051   - Change to show last batch entered, was not doing      
0203.00     K3S_3051FM   so before.                                            
0204.00                                                                        
0205.00 34) K3S_3052   - New hold out quantity batch generation from           
0206.00     K3S_3052CL   CMD key 9 in K3S_3050.                                
0207.00                                                                        
0208.00 35) K3S_3065CL - Added many new parameters for more flexability.       
0209.00     K3S_3065X1                                                         
0210.00     K3S_3065X2                                                         
0211.00     K3S_3065X3                                                         
0212.00                                                                        
0213.00 36) K3S_3070   - F20=Toggle was rolling down through the subfile       
0214.00     K3S_3070FM   now stays on same page. Added logic to delimit by     
0215.00                  supplier and supplier sub fields.                     
0216.00                                                                        
0217.00 37) K3S_3080   - New option 6 to print a batch.                        
0218.00     K3S_3080FM                                                         
0219.00                                                                        
0220.00 38) K3S_3085   - New batch print used with K3S_3080.                   
0221.00     K3S_P3085                                                          
0222.00     K3S_3085CL                                                         
0223.00                                                                        
0224.00 39) K3S_3301   - Options 11 through 18 were printing the selection     
0225.00                  criteria header page twice.                           
0226.00                                                                        
0227.00 40) K3S_3600   - Use product link file in calculations, by use of an   
0228.00                  APP record.                                           
0229.00                                                                        
0230.00 41) K3S_3700   - Year was being passed back as a parameter and could   
0231.00     K3S_3701     update PR_FORCYR incorrectly, Year changed to a work  
0232.00                  field and not a parameter.                            
0233.00                                                                        
0234.00 42) K3S_3710   - Allow lower case entry in supplier sub field.         
0235.00     K3S_3710FM                                                         
0236.00                                                                        
0237.00 43) K3S_3810   - New product ranking by supplier - Store level         
0238.00     K3S_3810CL                                                         
0239.00                                                                        
0240.00 44) K3S_4010   - User authoriation was only checked on first sub file  
0241.00     K3S_4030     record, user not authorized could change records from 
0242.00                  2nd sub file record on.                               
0243.00                                                                        
0244.00 45) K3S_4031   - User authoriation was only checked on first sub file  
0245.00     K3S_4031FM   record, user not authorized could change records from 
0246.00                  2nd sub file record on. New Reverse service level     
0247.00                  logic.                                                
0248.00                                                                        
0249.00 46) K3S_4040CL - Added many new parameters for more flexability.       
0250.00     K3S_4040X1                                                         
0251.00     K3S_4040X2                                                         
0252.00     K3S_4040X3                                                         
0253.00                                                                        
0254.00 47) K3S_4041   - New Revese service level processing.                  
0255.00                                                                        
0256.00 48) K3S_4041CL - Added many new parameters for more flexability.       
0257.00     K3S_4041X1                                                         
0258.00     K3S_4041X2                                                         
0259.00     K3S_4041X3                                                         
0260.00                                                                        
0261.00 49) K3S_5040   - Allow lower case entry in supplier sub field.         
0262.00     K3S_5040FM                                                         
0263.00                                                                        
0264.00 50) K3S_5050   - When APP record set for single location entry         
0265.00     K3S_5050FM   if location field is cleared on add, will now provide 
0266.00                  location selection screen, to enable multiple location
0267.00                  entry & show all products for this supplier (corpoate 
0268.00                  view).                                                
0269.00                                                                        
0270.00 51) K3S_5070   - Start search 10 years back, was 60 days back.         
0271.00                                                                        
0272.00 52) K3S_6030   - New get date for expiring hold out quantities.        
0273.00     K3S_6030CL                                                         
0274.00                                                                        
0275.00 53) K3S_6035   - New generate reminder notes to selected users         
0276.00                  that hold out quantities will expire in a user        
0277.00                  selected # of days.                                   
0278.00                                                                        
0279.00 54) K3S_8000   - Avoid the re-cursion problems, and provide a friendly 
0280.00     K3S_8030      error message for both 'Product Maintenance' and     
0281.00                   'Supplier Maintenance', plus new changes up-stream   
0282.00                   function for hub suppliers.                          
0283.00                                                                        
0284.00 55) K3S_9010   - Changed to use IP_FORCTYP field and not PR_FORCINT    
0285.00                  (forecast interval fields)                            
0286.00                                                                        
0287.00 56) K3S_9300   - Changed to allow lead time variance of 0 to 99.9      
0288.00     K3S_9320     was 5.0 to 80.0.                                      
0289.00                                                                        
0290.00 57) K3S_9505   - Added file K_DEALLOG to automated re-org process.     
0291.00                                                                        
0292.00 58) K3S_9540   - Added SG1/SG2 types to window error message.          
0293.00                  (supplier group 1 & 2 edit).                          
0294.00                                                                        
0295.00 -----------------------------------------------------------------------
0296.00 Physical and logical files added during this release                   
0297.00 -----------------------------------------------------------------------
0298.00                                                                        
0299.00 01) K_INTORDBB - Interface for App Ord Hdr Timestamp (descending)      
0300.00     K_INTORDBC - Interface for App Ord Hdr LOCN,SUPL,SUB,BIRTH,PO#     
0301.00                                                                        
0302.00 -----------------------------------------------------------------------
0303.00 Special processes to run for new release                               
0304.00 -----------------------------------------------------------------------
0305.00                                                                        
0306.00 01) K3S_FIXHLD - This program will be used to remove records from the  
0307.00     (automatic)   K_PRODHLD file that have records with bad data.      
0308.00                   Earlier versions of K3S would allow entry of data    
0309.00                   that was not valid.                                  
0310.00                                                                        
0311.00 02) K3S_FIXTAB - This program will be used to place additional text    
0312.00     (automatic)   into description 2 for the APP record of             
0313.00                   K_PRODLNK PROCESSING. The text reads 'also 3600'     
0314.00                   which is the overstock processing program, that      
0315.00                   now includes the K_PRODLNK file.                     
0316.00                                                                        
0317.00 03) K3S_FIXYR  - This program will be used to ensure all K_PRODUCT     
0318.00     (automatic)   records have the correct value in PR_FORCYR. Both    
0319.00                   K3S_3700 and K3S_3701 had PR_FORCYR added as PARMs   
0320.00                   during Release 4.27, and they were passing a         
0321.00                   value back that was sometimes less. Bindley and      
0322.00                   Core Mark, and a few others were patched earlier,    
0323.00                   but this program will make sure ALL customers        
0324.00                   are in sync.                                         
0325.00                                                                        
0326.00 04) K3S_ADDSCD - Added Job schedule entry for generating Reminder notes
0327.00     (by hand)    to users about hold out quantities expiring, on hold. 
0328.00                                                                        
0329.00 05) K3S_1050   - If allowing the approval of non-split combined orders,
0330.00     (by hand)     then place Supplier Purchases data into combined     
0331.00                   supplier's ID. scan on "No Split"                    
0332.00                                                                        
0333.00 06) K3S_1100   - Changes that understand the new capability to approve 
0334.00     (by hand)     combined supplier without splitting.                 
0335.00                   Scan on "No Split"                                   
0336.00                                                                        
0337.00 07) K3S_X010CL - Added many new parameters for more flexability.       
0338.00     K3S_X...CL                                                         
0339.00     K3S_X310CL                                                         
0340.00     (by hand)                                                          
0341.00                                                                        
0342.00 08) K3S_3065X1 - Added many new parameters for more flexability.       
0343.00     K3S_3065X2                                                         
0344.00     K3S_3065X3                                                         
0345.00     (by hand)                                                          
0346.00                                                                        
0347.00 09) K3S_4040X1 - Added many new parameters for more flexability.       
0348.00     K3S_4040X2                                                         
0349.00     K3S_4040X3                                                         
0350.00     (by hand)                                                          
0351.00                                                                        
0352.00 10) K3S_4041X1 - Added many new parameters for more flexability.       
0353.00     K3S_4041X2                                                         
0354.00     K3S_4041X3                                                         
0355.00     (by hand)                                                          
0356.00                                                                        
0357.00 -----------------------------------------------------------------------
0358.00 Programs in library K3S_MOD428                                         
0359.00 -----------------------------------------------------------------------
0360.00                                                                        
0361.00 -- RPGLE                                                               
0362.00 K3S_CVRT22   will run during install process                           
0363.00 K3S_1050     will need to put in "No Split" changes                    
0364.00 K3S_1100        "                  "                                   
0365.00                                                                        
0366.00 -- CLLE     
0366.01 K3S_PEREND – Added parameter for supplier sub field.                                                          
0367.00 K3S_X010CL - Added many new parameters for more flexability.           
0368.00 K3S_X...CL                                                             
0369.00 K3S_X310CL                                                             
0370.00 K3S_3065X1 - Added many new parameters for more flexability.           
0371.00 K3S_3065X2                                                             
0372.00 K3S_3065X3                                                             
0373.00 K3S_4040X1 - Added many new parameters for more flexability.           
0374.00 K3S_4040X2                                                             
0375.00 K3S_4040X3                                                             
0376.00 K3S_4041X1 - Added many new parameters for more flexability.           
0377.00 K3S_4041X2                                                             
0378.00 K3S_4041X3                                                             
0379.00 -----------------------------------------------------------------------
0380.00 New function in this release                                           
0381.00 -----------------------------------------------------------------------
0382.00 01) Added new job schedule entry for notifying buyers of product       
0383.00     hold out quantities expiring.                                      
0384.00                                                                        
0385.00 02) Ability to approve a combined supplier order with out spliting.    
0386.00                                                                        
0387.00 03) Ability to require specific groups in supplier file, groups are    
0388.00     user defined.                                                      
0389.00                                                                        
0390.00 04) Customer specific menu added options 16 thru 90.                   
0391.00                                                                        
0392.00 05) Ability to notify buyers that product hold out quantities are      
0393.00     going to expire in user defined # of days.                         
0394.00                                                                        
0395.00 06) Ability to use "reverse" service level logic.                      
0396.00                                                                        
0397.00 07) Ability to view approved orders log.                               
0398.00                                                                        
0399.00 08) Note line added to supplier maintenance and product maintenance    
0400.00     screens.                                                           
0401.00                                                                        
0402.00 09) Note line added to Supplier order cycle analysis screen.           
0403.00                                                                        
0404.00 10) Product maintenance added safety stock in days,                    
0405.00     order time factor in days, economic order interval                 
0406.00     in days, actual inventory dollar value, theoretical                
0407.00     inventory dollar value, and actual/theoretical ratio.              
0408.00                                                                        
0409.00 11) Product link entries can not point back at themselves.             
0410.00                                                                        
0411.00 12) If Hub supplier being used and forecast changed to a hubed product 
0412.00     show window possible "Up-stream" changes needed.                   
0413.00                                                                        
0414.00 13) New supplier history comparison report.                            
0415.00                                                                        
0416.00 14) Ability to generate product hold out batches using a percentage    
0417.00     of a products forecast.                                            
0418.00                                                                        
0419.00 15) Ability to print selected product review batch.                    
0420.00                                                                        
0421.00 16) Ability to use product link records in over stock calculations.    
0422.00                                                                        
0423.00 17) Authority now checking correctly in service level maintenance.     
0424.00                                                                        
0425.00 18) Ability to add multiple locations for a deal when single           
0426.00     location entry APP records is used.                                
0427.00                                                                        
0428.00 19) Ability to have lead time variance 0 thru 99.9.                    
0429.00