R5.04 Technical

Release 5.04 Technical Notes

0001.00 ----------------------------------------------------------------------- 

0002.00 Notes for Release 5.04  Jan 19, 2009                        

0003.00       (Name in parenthesis is person who had the idea for the change)   

0004.00 ----------------------------------------------------------------------- 

0005.00                                                                         

0006.00 01) K3S_CVRT22 - Changes to table code records/New table code records:  

0007.00                                                                         

0008.00                     APP Application codes                               

0009.00                                                                         

0010.00                     SPECIAL   MESSAGE                     (new)         

0011.00                          New record that allows customer to display     

0012.00                          text on main menu                              

0013.00                                                                         

0014.00                     NJP VALID_PROC                                      

0015.00                       change to TA_CODEDS2 and TA_CODEDS3               

0016.00                                                                         

0017.00                     OSM Order summary modes                             

0018.00                          3                 - User defined for U3 checks 

0019.00                          4                 - User defined for U4 checks 

0020.00                                                                         

0021.00                     SDU Supplier discount unit                          

0022.00                          7                 - Unit 7           (new)     

0023.00                          8                 - Unit 8           (new)     

0024.00                          9                 - Unit 9           (new)     

0025.00                                                                         

0026.00                     YSP 'Your space' for subfiles                       

0027.00                          K3S_1030   - name changed to 'Orders - Product 

0028.00                                                        Summary'         

0029.00                                                                         

0030.00                                                                         

0031.00 02) K3S_FTS1   - (King III)                                             

0032.00                  This program allows us to get objects from             

0033.00                   customer sites.                                       

0034.00                                                                         

0035.00 03) K3S_FTS2   - (Brantley)                                             

0036.00                  Missing this program from K3S_5MOD which is needed     

0037.00                   to FTP to customer.                                   

0038.00                                                                         

0039.00 04) K3S_FX504A - (Brantley)                                             

0040.00                  Change APP record CHECK_U U1_U2 to U1_U4               

0041.00                                                                         

0042.00 05) K3S_FX504B - (Brantley)                                             

0043.00                  Create 3 missing SDU table code records for units      

0044.00                   7, 8, and 9.                                          

0045.00                                                                         

0046.00 06) K3S_FX504C - Set PR_RFBIRTH = PR_BIRTH.                             

0047.00                                                                         

0048.00 07) K3S_FX504D - (King III)                                             

0049.00                  Populate PB_FORCINT for batches created before R5.     

0050.00                                                                         

0051.00 08) K3S_FX504E - (Brantley)                                             

0052.00                  Change TA_CODEDS1 for YSP table code value K3S_1030    

0053.00                                                                         

0054.00 09) K3S_FX504F - (King III)                                             

0055.00                  Create default user preference setting record          

0056.00                  for K3S_BUYERS                                         

0057.00                                                                         

0058.00 10) K3S_HELP   - (K3S)                                                  

0059.00     K3S_HELPFM   Added new option to help window: F1 now goes           

0060.00                  to our K3S wiki and F7 does search                     

0061.00                                                                         

0062.00 11) K3S_MSGADD - (Brantley)                                             

0063.00                  Had to increase the length of the &1 variable that     

0064.00                  is used in messages to accomodate fields such as       

0065.00                  BUYR, LOCN, SUPL, etc.                                 

0066.00                                                                         

0067.00 12) K3S_MSGCL  - (Les Schwab 05/08)                                     

0068.00                  Was not able to accomodate more than 10 messages at    

0069.00                  once when user would copy > 10 products at a time or   

0070.00                  would change pdt source for > 10 products at a time.   

0071.00                                                                         

0072.00 13) K3S_PEREND - (Brantley)                                             

0073.00                  SUPLGPS and PRODGPS variables increased and new        

0074.00                  variable SELVIEW added; PARMs getting passed to        

0075.00                  3100CL changed.                                        

0076.00                                                                         

0077.00 14) K3S_REL_5  - This is our pgm to get softkeys, had to change our     

0078.00                  serial number                                          

0079.00                                                                         

0080.00 15) K3S_WIKICL - (K3S)                                                  

0081.00                  New program to allow F1 help window to go to           

0082.00                  K3S wiki when user presses F1                          

0083.00                                                                         

0084.00 16) K3S_0010   - K3S Main Menu to show new Release 5.04 Jan-19-2009     

0085.00     K3S_0010FM - Changing tablecode to 'SPECIAL    MESSAGE' whi 

0086.00                  display text on main menu in field ZZ_SPECIAL,         

0087.00                  ZZ_SPECIAL increased to 100a   (Skidmore 1/15/09)      

0088.00                                                                         

0089.00 17) K3S_1010   - Took out the unit number from appearing in the         

0090.00                  last column's heading.  (Brantley)                     

0091.00                - Logic added to enable modes 3 and 4 for new            

0092.00                  user defined catgories. (Brantley)                     

0093.00                                                                         

0094.00 18) K3S_1030   - (Debbie Taylor @ Roses asked for this new feature)     

0095.00     K3S_1030FM - Included new PARMs (pr_weighdo and pr_volumedo) for    

0096.00                  the call to K3s_3707.                                  

0097.00                - Changed position of PO# so it lines up with PO# on     

0098.00                  1020 and 1040.  (Brantley)                             

0099.00                                                                         

0100.00 19) K3S_1040FM - Changed position of PO# to line up with PO# on         

0101.00     K3S_1040     1020 & 1030. (Brantley)                                

0102.00     K3S_1041FM - Changed position of ZZ_USER.                           

0103.00     K3S_1041     NO RPG logic changes.  (Brantley)                      

0104.00                                                                         

0105.00 20) K3S_1042   - (Pete Lippe @ CoreMark 03/08)                          

0106.00                  2 keyfields changed                                    

0107.00                                                                         

0108.00 21) K3S_1050    -@msgtext and @msg_text should have been increaesd      

0109.00     K3S_1050FM   from 40 to 100 in R 5.03 (Brantley)                    

0110.00                 -added skip LT as an option to PO screen (King III)     

0111.00                 -logic added to handle the skip LT option(King III)     

0112.00                 -SUPLNAM field changed positions (JP)                   

0113.00                 -logic added so that arrival dates that would be        

0114.00                  on a Sat or Sun will go to Monday (King III)           

0115.00                                                                         

0116.00 22) K3S_1050PB - (Brantley)                                             

0117.00                  @msgtext and @msg_text should have been increaesd      

0118.00                  from 40 to 100 in R 5.03                               

0119.00                                                                         

0120.00 23) K3S_1051   - (Brantley)                                             

0121.00                  @msgtext and @msg_text should have been increaesd      

0122.00                  from 40 to 100 in R 5.03                               

0123.00                                                                         

0124.00 24) K3S_1057   - (found at Core-Mark 11/11/08)                          

0125.00                  d-spec for splittype field changed                     

0126.00                                                                         

0127.00 25) K3S_1090CL - (King III & Brantley)                                  

0128.00                - PO# needed to increase from 8 to 10.                   

0129.00                - Also - move this object and source to K3S_5MOD and     

0130.00                  delete out of K3S_5OBJ since some customers may        

0131.00                  need to customize: Example JTD customized this to      

0132.00                  have Pro Forma print after sending.                    

0133.00                                                                         

0134.00 26) K3S_1100   - (King III)                                             

0135.00                  Added abililty to skip LT forecasting in PO approval   

0136.00                                                                         

0137.00 27) K3S_1500   - (08/08)                                          

0138.00                  Logic added to give a maximum value for safety stock.  

0139.00                - (Chuck at Lyons 12/08)                                 

0140.00                  When delay is < 0 and suggested quantity = 0, set      

0141.00                  delay = 0                                              

0142.00                - (David Dresser Core-Mark 11/13/08)                     

0143.00                  two changes:                                           

0144.00                  1) Not picking up all Add Days records for replenishme 

0145.00                  2) Delay calculation was not using Add Days records    

0146.00                                                                         

0147.00 28) K3S_1510   - (Pete Lippe @ CoreMark 06/08)                          

0148.00                  Logic added to label products as 'BK' checks           

0149.00                  if a product is given an SOQ due to allocations and a  

0150.00                  back order exists for the product.                     

0151.00                                                                         

0152.00 29) K3S_1900FM - (Brantley)                                             

0153.00     K3S_1900     Logic added to handle splitting order using            

0154.00                  new product groups 3, 4, and 5.                        

0155.00                                                                         

0156.00 30) K3S_1910   - Logic added to handle splitting order using            

0157.00                  new product groups 3, 4, and 5. (Brantley)             

0158.00                - Changed how we calculate # of buy multiples            

0159.00                  when splitting truck by purc inc                       

0160.00                  (Scott)                                   

0161.00                                                                         

0162.00 31) K3S_2000   - (Brantley)                                             

0163.00                  Was comparing product group fields to a 5 char         

0164.00                  field, changed comparison field to 10 chars.           

0165.00                                                                         

0166.00 32) K3S_2000X2 - (Brantley & Kerry found at Stewart 07/08)              

0167.00                  Had to comment out call to K3S_SLSX01 which is         

0168.00                  for Store Level environment only.                      

0169.00                                                                         

0170.00 33) K3S_2002FM - (King III & Brantley)                                  

0171.00     K3S_2002     Both objects deleted in release 5.04.                  

0172.00                                                                         

0173.00 34) K3S_2008   - (Navarro)                                              

0174.00                  logic added to handle adding combined supplier through 

0175.00                  K_INTSUPL file                                         

0176.00                                                                         

0177.00 35) K3S_2015   - (Debbie Taylor @ Roses asked for this new feature)     

0178.00                - Changes added to account for weight and volume divisor 

0179.00                  override fields                                        

0180.00                                                                         

0181.00 36) K3S_2480FM - (King III)                                             

0182.00     K3S_2480     New program that is needed to                          

0183.00                  allow users to pass from 24x80                         

0184.00                  environment to 27x132 for user exits.                  

0185.00                                                                         

0186.00 37) K3S_3000FM - (Debbie Taylor @ Roses asked for this new feature)     

0187.00     K3S_3000     Logic added to make pr_weighdo and pr_volumdo          

0188.00                  work. These fields appeared on the screen in           

0189.00                  5.03 but where protected.                              

0190.00                                                                         

0191.00 38) K3S_3007   - (Debbie Taylor @ Roses asked for this new feature)     

0192.00                  Logic added for new weight and volume divisor          

0193.00                  override fields.                                       

0194.00                                                                         

0195.00 39) K3S_3008   - (Debbie Taylor @ Roses asked for this new feature)     

0196.00                  Logic added for new weight and volume divisor          

0197.00                  override fields.                                       

0198.00                                                                         

0199.00 40) K3S_3010FM - (Tim Perkins)                                          

0200.00     K3S_3010   - Changed text for F15 key on the F24=list of fxn keys s 

0201.00                  No RPG logic changes.                                  

0202.00                                                                         

0203.00 41) K3S_3015   - (Lloyd Althiser @ Les Schwab 05/08)                    

0204.00                  New message given when user tries to delete or         

0205.00                  change a processed 'C' type of record.                 

0206.00                  We block them from changing/deleteing since the        

0207.00                  'C' types are a 1 time thing.  The message before      

0208.00                  did not clearly described the error.                   

0209.00                                                                         

0210.00 42) K3S_3016   - (Scott 12/07)                            

0211.00                  Commented out history multipler of 1.000               

0212.00                                                                         

0213.00 43) K3S_3030   - (David Dresser @ Core-Mark 1/9/09)                     

0214.00     K3S_3031     For weekly products, when tried to use F21 in the firs 

0215.00                  it was not calculating average correctly               

0216.00                                                                         

0217.00 44) K3S_3038FM - (New feature)                       

0218.00     K3S_3038     New program - Product history mark period exclusions   

0219.00                                                                         

0220.00 45) K3S_3060FM - (King III)                                             

0221.00     K3S_3060     Cosmetic changes to make LT fields line up.            

0222.00                  No RPG logic changes.                                  

0223.00                                                                         

0224.00 46) K3S_3431FM - (Chad Pickel @ LPShanks 04/08)                         

0225.00     K3S_3431     Added the text 'based on sales prices' to the          

0226.00                   screen.   No RPG logic changes.                       

0227.00                                                                         

0228.00 47) K3S_3432FM - (Chad Pickel @ LPShanks 04/08)                         

0229.00     K3S_3432     Added the text 'based on sales prices' to the          

0230.00                  screen.   No RPG logic changes.                        

0231.00                                                                         

0232.00 48) K3S_3435   - (Bozena @ Core-Mark 01/08)                             

0233.00                  logic added to ensure negative values do not           

0234.00                  get into K_WEEKDIS                                     

0235.00                                                                         

0236.00 49) K3S_3438FM - (Chad Pickel @ LPShanks 04/08)                         

0237.00     K3S_3438     Added the text 'based on sales prices' to the          

0238.00                  screen.   No RPG logic changes.                        

0239.00                                                                         

0240.00 50) K3S_3439   - (King III & Brantley)                                  

0241.00                  Now populating new field PB_FORCINT.                   

0242.00                                                                         

0243.00 51) K3S_3706   - (Debbie Taylor @ Roses asked for this new feature)     

0244.00                  Logic added for new weight and volume divisor          

0245.00                  override fields.                                       

0246.00                                                                         

0247.00 52) K3S_3707   - (Debbie Taylor @ Roses asked for this new feature)     

0248.00                  Logic added for new weight and volume divisor          

0249.00                  override fields.                                       

0250.00                                                                         

0251.00 53) K3S_3760CL - (Brantley)                                             

0252.00                  QRY variables needed to increase from 512 to           

0253.00                  1024 to accomodate larger variables in CL.             

0254.00                                                                         

0255.00 54) K3S_3900   - (Core-Mark 11/20/08)                                   

0256.00                  PRODSEQ was not long enough for combined suppliers     

0257.00                                                                         

0258.00 55) K3S_4041   - (King III found at Navarro 07/08)                      

0259.00                  Change made so that product group service level        

0260.00                  ranking would take both $ AND units into consideration 

0261.00                  when assigning rank; before was only considering units 

0262.00                                                                         

0263.00 56) K3S_5040   - (Brantley)                                             

0264.00                  Changes to dealref field to accomodate the             

0265.00                  bigger deal ID field.                                  

0266.00                                                                         

0267.00 57) K3S_5055   - (Brantley)                                             

0268.00                  Changes to dealref field to accomodate the             

0269.00                  bigger deal ID field.                                  

0270.00                                                                         

0271.00 58) K3S_5056   - (Brantley)                                             

0272.00                  Changes to dealref field to accomodate the             

0273.00                  bigger deal ID field.                                  

0274.00                                                                         

0275.00 59) K3S_5070   - (Brantley)                                             

0276.00                  Changes to dealref field to accomodate the             

0277.00                  bigger deal ID field.                                  

0278.00                                                                         

0279.00 60) K3S_5071   - (Brantley)                                             

0280.00                  added in some %TRIMs to the ZZ_SUPLMSK field           

0281.00                  to get more of the supplier info to show up.           

0282.00                                                                         

0283.00 61) K3S_5300FM - (Brantley)                                             

0284.00     K3S_5300     Text for 'Sub-code' was not showing up. Also           

0285.00                  moved text for 'Unit' and UOM field over.              

0286.00                  No RPG logic changes.                                  

0287.00                                                                         

0288.00 62) K3S_5400   - (Brantley)                                             

0289.00                  Changes to dealref field to accomodate the             

0290.00                  bigger deal ID field.                                  

0291.00                                                                         

0292.00 63) K3S_7100   - (Larry @ Les Schwab 12/19/08)                          

0293.00                  Needed to populate FORCINT field in K_PERDPER in       

0294.00                  order for inventory performance report to be valid     

0295.00                                                                         

0296.00 64) K3S_9010   - Logic added for new weight and volume divisor          

0297.00                  override fields (New logic by request Debbie Taylor)   

0298.00                - Logic added to save off previous period's days out     

0299.00                  (Lloyd Althiser @ Les Schwab 07/08)                    

0300.00                                                                         

0301.00 65) K3S_9011   - Logic added for new weight and volume divisor          

0302.00                  override fields.(New logic by request of D Taylor)     

0303.00                - Changed how suplorg/suplors are populated for when     

0304.00                  products are F15=copied to a suplier from K3S_1030.    

0305.00                  caused problems if copied in products from sub         

0306.00                  supplier and then recalculated the order. (JTD 03/08)  

0307.00                                                                         

0308.00 66) K3S_9257   - (Brantley)                                             

0309.00                  @msgtext and @msg_text should have been increaesd      

0310.00                  from 40 to 100 in R 5.03                               

0311.00                                                                         

0312.00 67) K3S_9300FM - (Brantley & King III)                                  

0313.00     K3S_9300     Several fields changed positions because               

0314.00                  not everything was showing up before due               

0315.00                  to increased field sized.                              

0316.00                  No RPG logic changes.                                  

0317.00                                                                         

0318.00 68) K3S_9320FM - (Brantley & King III)                                  

0319.00     K3S_9320    -Several fields changed positions because               

0320.00                  not everything was showing up before due               

0321.00                  to increased field sized.                              

0322.00                 -The 'Yes' and 'No' text next to flags has been fixed   

0323.00                  to show proper text when using F21=Start or F6=Add.    

0324.00                                                                         

0325.00 ----------------------------------------------------------------------- 

0326.00 Physical and logical files added or changed during this release         

0327.00 ----------------------------------------------------------------------- 

0328.00                                                                         

0329.00 10 new Physical and Logical files are added during this release         

0330.00                                                                         

0331.00 K_DEMDEXP  - Demand export                                              

0332.00 K_INTPROM  - Interface for Promotions feed                    

0333.00 K_INTPROMA - Interface for Promotions feed - logical file               

0334.00 K_INTPROMB - Interface for Promotions feed - logical file               

0335.00 K_PRODHISD - Product History - logical file     (Bartell)               

0336.00 K_PRODH52D - Product History - logical file                             

0337.00 K_PRODHXX  - Product History Period Exclusions                 

0338.00 K_PRODHXXA - Product History Period Exclusions - logical file           

0339.00 K_PRODHXXB - Product History Period Exclusions - logical file           

0340.00 K_PRODHXXC - Product History Period Exclusions - logical file           

0341.00                                                                         

0342.00                                                                         

0343.00 7 Physical files from R4 were missing (note: all of these are used in r 

0344.00                                                                         

0345.00 K_OBSOLETX                                                              

0346.00 K_ORCCYCLX                                                              

0347.00 K_PRODOVPX                                                              

0348.00 K_PRODTRNX                                                              

0349.00 K_RANKPRDX                                                              

0350.00 K_RANKSPLX                                                              

0351.00 K_SUPLLSTX                                                              

0352.00                                                                         

0353.00 1 Physical file and 3 logical files get deleted                         

0354.00                                                                         

0355.00 K_PRODHEX                                                               

0356.00 K_PRODHEXA                                                              

0357.00 K_PRODHEXB                                                              

0358.00 K_PRODHEXC                                                              

0359.00                                                                         

0360.00 After this release installed, there should be exactly 417 objects       

0361.00 in library K3S_5DTA(data files library) (Rel 4.41 had 376 objects)      

0362.00                                         (Rel 5.03 had 404 objects)      

0363.00                                                                         

0364.00 Updated help document included (replaces the current version in K3S_5OB 

0365.00                                                                         

0366.00 K_F1_DOC                                                                

0367.00                                                                         

0368.00 1 Save file object from R4 was missing (goes to library K3S_5MOD):      

0369.00                                                                         

0370.00 K3S_SAVF                                                                

0371.00                                                                         

0372.00 1 Other file object from R4 was missing (goes to library K3S_5MOD):     

0373.00                                                                         

0374.00 K3S_OBJPF                                                               

0375.00                                                                         

0376.00 ----------------------------------------------------------------------- 

0377.00 Special conditions for some customers                                   

0378.00 ----------------------------------------------------------------------- 

0379.00                                                                         

0380.00 none                                                                    

0381.00                                                                         

0382.00 ----------------------------------------------------------------------- 

0383.00 Programs in library K3S_MOD504                                          

0384.00 ----------------------------------------------------------------------- 

0385.00                                                                         

0386.00 -- RPGLE                                                                

0387.00 K3S_CVRT22   New Table Code entries                                     

0388.00 K3S_FTS1     Convert k3s_savf to k3s_obtpf to send objects              

0389.00 K3S_FTS2     Convert k3s_opjpf to k3s_savf for receive of objects       

0390.00 K3S_1050     Suggested order supplier approval                          

0391.00 K3S_1050PB   Suggested order batch approval PB type                     

0392.00 K3S_1051     Suggested order supplier un-approve                        

0393.00 K3S_1100     Suggested order supplier approval PO header/detail         

0394.00 K3S_3706     Product change and call to K3S_3707 template               

0395.00 K3S_9257     Display daily demand                                       

0396.00                                                                         

0397.00 -- CLLE                                                                 

0398.00 K3S_PEREND   Create period end reports                                  

0399.00 K3S_1090CL   Alternate source order - Pro forma report                  

0400.00 K3S_2000X2   Exit from K3S_2000 for supplier delete stores              

0401.00                                                                         

0402.00 -- CMD                                                                  

0403.00 none                                                                    

0404.00                                                                         

0405.00 -- DSPF                                                                 

0406.00 K3S_1050FM   Suggested order supplier approval                          

0407.00                                                                         

0408.00 ----------------------------------------------------------------------- 

0409.00 Programs in library K3S_5CNV                                            

0410.00 ----------------------------------------------------------------------- 

0411.00                                                                         

0412.00 -- RPGLE                                                                

0413.00 none                                                                    

0414.00                                                                         

0415.00 -- CLLE                                                                 

0416.00 none                                                                    

0417.00                                                                         

0418.00 -- CMD                                                                  

0419.00 none                                                                    

0420.00                                                                         

0421.00 -- DSPF                                                                 

0422.00 none                                                                    

0423.00                                                                         

0424.00 ----------------------------------------------------------------------- 

0425.00 Implementation steps for this release                                   

0426.00 ----------------------------------------------------------------------- 

0427.00                                                                         

0428.00 Standard LODRUN *OPT