0001.00 -----------------------------------------------------------------------
0002.00 Notes for Release 4.34 July 1st, 2004
0003.00 -----------------------------------------------------------------------
0004.00
0005.00 01) CVTSTMFRPG - Changed to use COLHDG when building column Headers
0006.00 instead of field name, which is more user friendly.
0007.00
0008.00 02) K3S_CVRT22 - Changes to table code records:
0009.00
0010.00 APP Applications Control
0011.00 K3S_1500 RM_PRV_ORD - Remove previous orders?
0012.00 Store level use only
0013.00 (K3S_1500SP)
0014.00 - Only set Flag1=1 for
0015.00 store level if
0016.00 required.
0017.00
0018.00 K3S_1500 ALTSRC_ALL - Look at all products?
0019.00 Not just PQ_SOQACT > 0
0020.00 - Flag1=1 means look at
0021.00 all products
0022.00 - Default is Flag1=0
0023.00 which means only
0024.00 look at those to be
0025.00 ordered from regular
0026.00 supplier today
0027.00
0028.00 K3S_3439 GEN_EXCPTN - Generate wkly dist
0029.00 exceptions?
0030.00 - Flag 1=1 means
0031.00 generate weekly
0032.00 distribution exception
0033.00 records.
0034.00 - Number 1 WP2 minimum
0035.00 weekly average, with
0036.00 default 30 units
0037.00 - Number 2 contains
0038.00 exception %, with
0039.00 default of 5.00 %
0040.00
0041.00 K3S_SLRP19 LARGE_VALU- Large Inventory Report
0042.00 values
0043.00 - Number 2 holds the
0044.00 Supplier Ratio, with
0045.00 default of 1.40
0046.00 - Number 3 holds the
0047.00 Product Ration with
0048.00 default of 3.00
0049.00
0050.00 NT_SERVER BEING_USED - NT Server being used?
0051.00 Identifies environment
0052.00 where FTP is used to
0053.00 transmit information
0054.00 between IBM POWER SERVER and
0055.00 NT environment.
0056.00
0057.00 EML Email of K3S report selections
0058.00 This section provides the codes used in the
0059.00 report selection process for automatic emailing.
0060.00 Rxx Replenish reports
0061.00 Sxx Store level reports
0062.00
0063.00 SLR Store level report selections
0064.00 R15 Bar code labels print
0065.00 R16 Store weekly missed inventory
0066.00 R17 Bar code labels for PALM
0067.00 R18 Top 20 out of stock
0068.00 R19 Large inventory reported
0069.00
0070.00 SPG Selected program types
0071.00 W Weekly distribution
0072.00
0073.00 SPR Selected products review types
0074.00 W All weekly dist % exceptions
0075.00 WS1 Supplier wkly dist % excptn #1
0076.00 WP1 Product wkly dist % excptn #1
0077.00 WP2 Product wkly dist % excptn #2
0078.00
0079.00 ST2 Products out of stock 2 times
0080.00 ST3 Products out of stock 3 times
0081.00 ST4 Products out of stock 4 times
0082.00 ST5 Products out of stock 5 times
0083.00
0084.00 TLE New title records for -
0085.00 K3S_4050FM1C Supplier Service Level Targets
0086.00 K3S_4050FM1R Supplier Service Level Record
0087.00 K3S_4057FM1C Supplier Svc Level Changes Log
0088.00 K3S_7201FM1C Automatic E-Mail Maintenance
0089.00 K3S_STRBFM1C Out of stock - Bump order
0090.00
0091.00
0092.00 03) K3S_FX434A - This program should be run after the new release
0093.00 is installed if the customer does not have the IBM
0094.00 library QQRYLIB, or if they don't want their buyers
0095.00 to generate Selected Products Review batches of
0096.00 type 'QRY'. The program simply changes ta_flag3=1
0097.00 for ta_codetyp = 'SPR' and ta_codeval = 'QRY'. The
0098.00 change keeps the type of 'QRY' from appearing as an
0099.00 option for the buyer when he presses F6=Add, just
0100.00 like we do for 'PEx' batches.
0101.00
0102.00 04) K3S_FX434B - This program should be run after the new release
0103.00 is installed and will re-populate the field
0104.00 R3_TOTTYPE in file K_PERDPER.
0105.00
0106.00 05) K3S_NITECL - Improved the capture of Begin and End timestamp
0107.00 process for logging purposes, getting final answer
0108.00 back into both K_SCHEDDY & K_SCHEDPE. New program
0109.00 K3S_9022 runs dead last to get final End timestamp.
0110.00 - Changed the controlling program for the process
0111.00 of Period End Performance collection.
0112.00
0113.00 06) K3S_PEREND - Needed PARM of &UBLK declared and passed along
0114.00 in call to K3S_3350CL (two places).
0115.00
0116.00 07) K3S_0010FM - K3S Main Menu to show new Release 4.34 Jul-01-2004
0117.00
0118.00 08) K3S_1010 - Fix the Roll Up key with 'no records' condition
0119.00 - Display all Fixed Cycle Suppliers when mode 'F' is
0120.00 used, regardless of the approval type.
0121.00
0122.00 09) K3S_1015 - Fix the Roll Up key with 'no records' condition
0123.00 - Change logical files to obtain the proper 'Hold out'
0124.00 information when buyer uses 'Hold out' but also
0125.00 used F13=Change supplier in K3S_1050.
0126.00
0127.00 10) K3S_1016 - Fix the Roll Up key with 'no records' condition
0128.00 - Pass the correct PARM of 'id_soqseq#' to K3S_3030, to
0129.00 eliminate problem downstream in K3S_1040 where error
0130.00 of 'Attempt to divide by 0' appeared.
0131.00
0132.00 11) K3S_1030 - Fix the Roll Up key with 'no records' condition
0133.00 - Fix the Roll Up key when 'View' changed condition
0134.00
0135.00 12) K3S_1042 - Change so that cursor doesn't end up at bottom of
0136.00 subfile when returning from K3S_3430.
0137.00 - Fix to use correct PARMs when using 'F7=Weekly
0138.00 history'.
0139.00
0140.00 13) K3S_1070 - Fix the Roll Up key with 'no records' condition
0141.00
0142.00 14) K3S_1080 - Fix the Roll Up key with 'no records' condition
0143.00
0144.00 15) K3S_1100 - Enhancement so that when buyer does an F13=Change
0145.00 Supplier at the same time as using the Hold Out
0146.00 facility in K3S_1050, the Hold Out records will be
0147.00 assigned to the Regular Supplier, and not the
0148.00 temporary supplier.
0149.00
0150.00 16) K3S_1500 - New capability for Store Level environment, controlled
0151.00 with APP record 'K3S_1500 RM_PRV_ORD', that will
0152.00 remove any previous orders for a supplier, in case
0153.00 user is in viewing the order at the same time.
0154.00 - New capability for Alternate Source processing,
0155.00 controlled with APP record 'K3S_1500 ALTSRC_ALL',
0156.00 that will open up the logic to all products, not just
0157.00 those who needed to be ordered from the Regular
0158.00 Source today.
0159.00 - For the Daily Replenishment environment, the product
0160.00 delay is better defined. If today is correct day
0161.00 to order, and an SOQ exists, then Delay=0, but if
0162.00 On hand = 0, then Delay=-1. Otherwise Delay=1
0163.00
0164.00 17) K3S_1800 - Fix the Roll Up key with 'no records' condition
0165.00
0166.00 18) K3S_1810 - Fix the Roll Up key with 'no records' condition
0167.00
0168.00 19) K3S_1812 - Fix the Roll Up key with 'no records' condition
0169.00
0170.00 20) K3S_1814 - Fix the Roll Up key with 'no records' condition
0171.00
0172.00 21) K3S_1900 - Enhanced to allow CMB Combined Supplier order to be
0173.00 split a 2nd time, after the 1st order split of CMB
0174.00
0175.00 22) K3S_2000 - Fix the Roll Up key with 'no records' condition
0176.00 - Fix problem that occured when buyer uses F6=Add to
0177.00 add a new supplier, and after entering the
0178.00 information and pressing ENTER, the window program
0179.00 K3S_9540 would appear for 'Variable order cycles'.
0180.00
0181.00 23) K3S_2007 - Fix the Roll Up key with 'no records' condition
0182.00
0183.00 24) K3S_2020 - Needed to pass PARM of *blanks to program K3S_3431 so
0184.00 that his navigation worked properly.
0185.00
0186.00 25) K3S_2027 - Fix the Roll Up key with 'no records' condition
0187.00
0188.00 26) K3S_2028 - Fix the Roll Up key with 'no records' condition
0189.00
0190.00 27) K3S_2029 - Fix the Roll Up key with 'no records' condition
0191.00
0192.00 28) K3S_2030 - Fix the Roll Up key with 'no records' condition
0193.00
0194.00 29) K3S_2041 - Use a work field to calculate 'orders per year' so
0195.00 that decimals are not used when generating the
0196.00 discount earned by dollars. This is more user
0197.00 friendly.
0198.00 - Fix where discount earned by dollars was not being
0199.00 cleared properly.
0200.00
0201.00 30) K3S_2060 - There are two screens '1 of 2' and '2 of 2'. Switch
0202.00 K3S_2060FM the default to be showing both discount brackets
0203.00 and the discount savings as opposed to showing
0204.00 the Birth date and Last Update date.
0205.00 - Fix where cursor went to end of subfile when F20=
0206.00 used.
0207.00
0208.00 31) K3S_2067 - Fix the Roll Up key with 'no records' condition
0209.00
0210.00 32) K3S_2070 - Fix the Roll Up key with 'no records' condition
0211.00
0212.00 33) K3S_2071 - Fix the Roll Up key with 'no records' condition
0213.00 K3S_2071FM - Fix to problem where buyer tries to do an F6=Add
0214.00 but the cursor jumps to the top of the screen, and
0215.00 buyer can't get to entry fields.
0216.00
0217.00 34) K3S_3001 - Fix the Roll Up key with 'no records' condition
0218.00
0219.00 35) K3S_3007 - Fix the Roll Up key with 'no records' condition
0220.00
0221.00 36) K3S_3016 - Change PARM passed to K3S_9510 from '1' to '0' to keep
0222.00 the 'Blank for all' choice from appearing when the
0223.00 buyer is using F4=Prompt on the Locations fields on
0224.00 the screen (both From and To).
0225.00
0226.00 37) K3S_3019 - Fix the Roll Up key with 'no records' condition
0227.00
0228.00 38) K3S_3034 - Fixed problem where the 'Before' picture of both the
0229.00 Product Forecast and Product Deviation were not
0230.00 correctly captured for the F19=Log. Previously the
0231.00 'Before' picture was showing Product Forecast of 0.
0232.00 - Changed Workstation field in log to capture the word
0233.00 'Batch run', since this program can be run in batch.
0234.00 - Fixed problem where the PR_USRSTAT wasn't being
0235.00 captured properly with 'Before' and 'After' picture.
0236.00 - Changed PF_BIRTH to use actual system timestamp, as
0237.00 opposed to our internal K3S date. That provides a
0238.00 better audit trail for buyers who work weekends.
0239.00
0240.00 39) K3S_3035 - Needed to contain the 'self cleansing' logic from
0241.00 program K3S_9010, so that when buyer does a
0242.00 re-average on a slow mover with many 1's in the
0243.00 history (in program K3S_3030), then a check is
0244.00 made on the T/S being valid.
0245.00
0246.00 40) K3S_3040 - Fix the Roll Up key with 'no records' condition
0247.00
0248.00 41) K3S_3050 - Fix the Roll Up key with 'no records' condition
0249.00
0250.00 42) K3S_3051 - Fix the Roll Up key with 'no records' condition
0251.00
0252.00 43) K3S_3057 - Fix the Roll Up key with 'no records' condition
0253.00
0254.00 44) K3S_3070 - Fix the Roll Up key with 'no records' condition
0255.00
0256.00 45) K3S_3080 - Fix the Roll Up key with 'no records' condition
0257.00 - Added the new batch types of WS1, WP1 and WP2 for the
0258.00 Daily Replenishment environment. Using value of 'W'
0259.00 will bring up all 3 new types. The new 3 types
0260.00 of batches can not be deleted. Like our PE batches,
0261.00 they are protected.
0262.00
0263.00 46) K3S_3090 - Fix the Roll Up key with 'no records' condition
0264.00 K3S_3090FM - New capability to display the type of batch being
0265.00 worked with by the user, which was selected back in
0266.00 program K3S_3080.
0267.00 - Enhanced to handle the 3 new types of WS1, WP1 and
0268.00 WP2 for Daily Replenishment.
0269.00 - New option '9=Wkly dist' which is the 'mode' for the
0270.00 3 new types in Daily Replenishment.
0271.00
0272.00 47) K3S_3200 - Fix the Roll Up key with 'no records' condition
0273.00
0274.00 48) K3S_3210 - Fix the Roll Up key with 'no records' condition
0275.00
0276.00 49) K3S_3300CL - Always Close and Delete the work files in QTEMP
0277.00 for K_RANKSPL and K_RANKPRD. Required for
0278.00 automatated email processes.
0279.00
0280.00 50) K3S_3400 - Fix the Roll Up key with 'no records' condition
0281.00 K3S_3400FM - Several user friendly adjustments were made for
0282.00 better navigation.
0283.00
0284.00 51) K3S_3417 - Fix the Roll Up key with 'no records' condition
0285.00
0286.00 52) K3S_3420 - For the 'source' field 'I' display 'Internal' while
0287.00 K3S_3420FM for 'source' field 'X' display 'External'.
0288.00 - Needed to pass PARM of *blanks to program K3S_3430 so
0289.00 that his navigation worked properly.
0290.00
0291.00 53) K3S_3427 - Fix the Roll Up key with 'no records' condition
0292.00
0293.00 54) K3S_3430 - New enhancement with option 7=Analyze to allow user
0294.00 K3S_3430FM an easier way to select a number of weeks to analyze.
0295.00 - New enhancement to include the 'Supplier set' of
0296.00 information when a buyer is working the product.
0297.00 - Several user friendly adjustments were made to make
0298.00 navigation easier.
0299.00
0300.00 55) K3S_3431 - New enhancement with option 7=Analyze to allow user
0301.00 K3S_3431FM an easier way to select a number of weeks to analyze.
0302.00 - New enhancement with both options '3=Include' and
0303.00 '4=Exclude(E)' that will prompt a WINDOW asking user
0304.00 if he wants to apply change to all products in the
0305.00 supplier for that specific week. Default is 1=Yes.
0306.00 - Several user friendly adjustments were made to make
0307.00 navigation easier.
0308.00
0309.00 56) K3S_3435CL - Added call to K3S_3439 which builds the new batches
0310.00 of WS1, WP1 and WP2 for Daily Replenishment.
0311.00
0312.00 57) K3S_3439 - New program to generate the new batches of WS1, WP1
0313.00 and WP2 for Daily Replenishment. Execution of this
0314.00 new program is controlled by APP record of
0315.00 'K3S_3439 GEN_EXCPTN'.
0316.00
0317.00 58) K3S_3450 - Fix the Roll Up key with 'no records' condition
0318.00 K3S_3450FM - Enhancement made so that buyer can pre-enter new
0319.00 products that don't yet exist in K3S database, and
0320.00 therefore save a day of processing.
0321.00 - Fix problem where ALARM sounds for each successful
0322.00 add of a new record.
0323.00 - Fix where incorrect Birth Date displayed for a
0324.00 record.
0325.00
0326.00 59) K3S_3470 - Fix the Roll Up key with 'no records' condition
0327.00
0328.00 60) K3S_3471 - Fix the Roll Up key with 'no records' condition
0329.00
0330.00 61) K3S_3477 - Fix the Roll Up key with 'no records' condition
0331.00
0332.00 62) K3S_3590 - Needed to capture the PR_USRSTAT field properly for
0333.00 the log file.
0334.00 - Needed to user actual system timestamp for log record,
0335.00 and not our internal K3S date.
0336.00 - Needed to populate PR_SEASSRC with value of 'V',
0337.00 which means 'System generated, user viewed.'
0338.00
0339.00 63) K3S_3850 - Fix the Roll Up key with 'no records' condition
0340.00
0341.00 64) K3S_4007 - Fix the Roll Up key with 'no records' condition
0342.00
0343.00 65) K3S_4010 - Fix the Roll Up key with 'no records' condition
0344.00
0345.00 66) K3S_4030 - Fix the Roll Up key with 'no records' condition
0346.00 K3S_4030FM - Several user friendly adjustments were made to make
0347.00 navigation easier.
0348.00
0349.00 67) K3S_4031 - Fix the Roll Up key with 'no records' condition
0350.00 K3S_4031FM - Several user friendly adjustments were made to make
0351.00 navigation easier.
0352.00
0353.00 68) K3S_4037 - Fix the Roll Up key with 'no records' condition
0354.00
0355.00 69) K3S_4038 - Fix the Roll Up key with 'no records' condition
0356.00
0357.00 70) K3S_5040 - Fix the Roll Up key with 'no records' condition
0358.00 K3S_5040FM - Add 3 more edits to Deal Entry dates:
0359.00 Deal Begin Date > today minus 1 year
0360.00 Deal Begin Date < '2040-01-01'
0361.00 Deal End Date < '2040-01-01'
0362.00
0363.00 71) K3S_5050 - Add 3 more edits to Deal Entry dates:
0364.00 Deal Begin Date > today minus 1 year
0365.00 Deal Begin Date < '2040-01-01'
0366.00 Deal End Date < '2040-01-01'
0367.00
0368.00 72) K3S_5070 - Fix the Roll Up key with 'no records' condition
0369.00
0370.00 73) K3S_5300 - Fix the Roll Up key with 'no records' condition
0371.00
0372.00 74) K3S_5307 - Fix the Roll Up key with 'no records' condition
0373.00
0374.00 75) K3S_7100 - The entire series for Period End Performance reports
0375.00 K3S_7110 was enhanced and made more user friendly, along with
0376.00 K3S_7120 a few fixes.
0377.00 K3S_7130 - K3S_NITECL now calls K3S_7100CL at Period End, as
0378.00 K3S_P7130 opposed to calling K3S_7100 (RPGLE). K3S_7100CL
0379.00 K3S_7100CL now controls the different parts to be executed,
0380.00 which include K3S_7100, K3S_7110CL and K3S_7120.
0381.00
0382.00 76) K3S_8010 - Fix the Roll Up key with 'no records' condition
0383.00
0384.00 77) K3S_8500 - Fix the Roll Up key with 'no records' condition
0385.00
0386.00 78) K3S_8507 - Fix the Roll Up key with 'no records' condition
0387.00
0388.00 79) K3S_8510 - Fix the Roll Up key with 'no records' condition
0389.00
0390.00 80) K3S_8517 - Fix the Roll Up key with 'no records' condition
0391.00
0392.00 81) K3S_8520 - Fix the Roll Up key with 'no records' condition
0393.00
0394.00 82) K3S_8527 - Fix the Roll Up key with 'no records' condition
0395.00
0396.00 83) K3S_9010 - Ensure that no negative values get saved for
0397.00 Previous fields at period end. This could happen
0398.00 if a customer populates our database with negative
0399.00 values from a conversion.
0400.00
0401.00 84) K3S_9021 - Changes made to provide better End timestamp
0402.00 information for both K_SCHEDDY and K_SCHEDPE.
0403.00 New PARMs pass information through K3S_NITECL
0404.00 all the way down to new program K3S_9022.
0405.00
0406.00 85) K3S_9022 - New program that runs dead last in K3S_NITECL, and
0407.00 updates both K_SCHEDDY and K_SCHEDPE with End
0408.00 timestamp information.
0409.00
0410.00 86) K3S_9040 - Fix the Roll Up key with 'no records' condition
0411.00
0412.00 87) K3S_9067 - Fix the Roll Up key with 'no records' condition
0413.00
0414.00 88) K3S_9070 - Fix the Roll Up key with 'no records' condition
0415.00
0416.00 89) K3S_9075 - Fix the Roll Up key with 'no records' condition
0417.00 K3S_9075FM - Fixed problem where the log was not displaying any
0418.00 records past midnight, when the K3S night job
0419.00 started before midnight, and continued past
0420.00 midnight.
0421.00
0422.00 90) K3S_9077 - Fix the Roll Up key with 'no records' condition
0423.00
0424.00 91) K3S_9080 - Fix the Roll Up key with 'no records' condition
0425.00
0426.00 92) K3S_9090 - Fix the Roll Up key with 'no records' condition
0427.00
0428.00 93) K3S_9097 - Fix the Roll Up key with 'no records' condition
0429.00
0430.00 94) K3S_9307 - Fix the Roll Up key with 'no records' condition
0431.00
0432.00 95) K3S_9327 - Fix the Roll Up key with 'no records' condition
0433.00
0434.00 96) K3S_9560 - Fix the Roll Up key with 'no records' condition
0435.00
0436.00 97) K3S_9710 - Fix the Roll Up key with 'no records' condition
0437.00
0438.00 98) K3S_9747 - Fix the Roll Up key with 'no records' condition
0439.00
0440.00 99) K3S_9999 - Populate the PARM of SERIES properly. Previously it
0441.00 was not being populated.
0442.00 - Improved the calculation of seconds, so that our
0443.00 logs to users look normal, and not off by 1 second.
0444.00 Had to do with the rounding of micro-seconds.
0445.00 - K3S_NITECL was changed to call K3S_7100CL instead of
0446.00 K3S_7100, so needed to change our capture of the
0447.00 step completed to K3S_7100CL.
0448.00
0449.00 -----------------------------------------------------------------------
0450.00 Programs in library K3S_MOD434
0451.00 -----------------------------------------------------------------------
0452.00
0453.00 -- RPGLE
0454.00 CVTSTMFRPG Changed to use COLHDG when building column headers
0455.00 instead of field names, which is more user friendly.
0456.00 K3S_CVRT22 New Table Code entries
0457.00 K3S_1100 Adjustments that allow buyer to use F13=Change supplier
0458.00 and also the Hold Out facility during F5=Approval,
0459.00 and the Hold Out records will get assigned to the
0460.00 Regular supplier, and not the temorary supplier.
0461.00
0462.00 -- CLLE
0463.00 K3S_PEREND Need to declare PARM of &UBLK and pass it along to call
0464.00 for K3S_3350CL (two places).
0465.00
0466.00 -- CMD
0467.00 none.
0468.00
0469.00 -- DSPF
0470.00 none.
0471.00
0472.00 -----------------------------------------------------------------------
0473.00 What customers should do after install
0474.00 -----------------------------------------------------------------------
0475.00
0476.00 01) Neither fix program K3S_FX434A nor K3S_FX434B are mandatory to run
0477.00 after the new release is installed.
0478.00
0479.00 -----------------------------------------------------------------------
0480.00 Special conditions for some customers
0481.00 -----------------------------------------------------------------------
0482.00
0483.00 01) K3S_1100 and K3S_PEREND (in K3S_MOD) have already been
0484.00 adjusted for all customers except:
0485.00
0486.00 Cole Brothers We will handle when installing
0487.00 Skidmore Sales We will handle when installing
0488.00 Tecumseh Provide notes for Rebecca Myers
0489.00 White Radio We will handle when installing
0490.00
