Release 5.05 Technical Notes
0001.00 -----------------------------------------------------------------------
0002.00 Notes for Release 5.05 Jan 01, 2010 rel_5.05.doc
0003.00 (Name in parenthesis is person who had the idea for the change)
0004.00 -----------------------------------------------------------------------
0005.00
0006.00 01) INV_CHK - Used to determine what invoices have already
0007.00 been captured. Used in program K3S_SALES.
0008.00
0009.00 02) K3S_ADDSCD - Change default from K3S_4040CL to K3S_4041CL since
0010.00 most of our new customers perform setting service
0011.00 level targets by Product Groups.
0012.00
0013.00 03) K3S_ADDSUP - Automatic add of suppliers during K3S night process
0014.00
0015.00 04) K3S_CVRT22 - Changes to table code records/New table code records:
0016.00
0017.00 APP Application codes
0018.00
0019.00 K3S_1500 CAR_COUNT - update to record
0020.00 Update PR_CARCOUN from IP_CARCOUN and
0021.00 IY_CARCOUN? use flag 2
0022.00 new capability via Flag 2
0023.00
0024.00 K3S_3301 LONG_PROD - new record
0025.00 Long Product ID show more product
0026.00 description?
0027.00 allows us to show more of the product
0028.00 description on reports when customer
0029.00 has a long product ID
0030.00
0031.00 K3S_3600 PR_QTYOORD - new record
0032.00 Exclude on order from balance?
0033.00 When quantity balance being calculated
0034.00 for overstock determination, customer
0035.00 can choose to exclude on order quantities
0036.00
0037.00 K3S_3715 EXCLUDE_D - new record
0038.00 Exclude linked "To product"
0039.00 when "D" Daily record exists?
0040.00
0041.00 SEASONAL ENTRY - update to record
0042.00 Ability to enter Profile ID?
0043.00 Changed default to Flag1 = 1 so
0044.00 new customers can name profiles
0045.00
0046.00 PIR Product interface log
0047.00
0048.00 Added 4 new record types to be used for
0049.00 screening data coming in
0050.00 d Negative Unit 6 bracket value
0051.00 e Negative Unit 7 bracket value
0052.00 f Negative Unit 8 bracket value
0053.00 g Negative Unit 9 bracket value
0054.00
0055.00 SDU Supplier discount units
0056.00
0057.00 Took 'protect' flag off of these 3
0058.00 records so customer can manage description
0059.00 Unit 7
0060.00 Unit 8
0061.00 Unit 9
0062.00
0063.00 TLE Title of screens
0064.00
0065.00 K3S_2028FM1C - record changed
0066.00 record changed title from 'Compare' to
0067.00 'Company' Variable Order Cycle Changes Log
0068.00
0069.00 K3S_4131FM1C - new record
0070.00 Supplier/Product Group Service Level Targets
0071.00
0072.00 K3S_4131FM2R - new record
0073.00 Supplier/Product Group Service Level Record
0074.00
0075.00 K3S_4138FM1C - new record
0076.00 Supplier/Product Group Service Level Changes
0077.00 Log
0078.00
0079.00 YSP Your space for subfiles
0080.00
0081.00 K3S_1010 - new record
0082.00 x-- Your Space ---x
0083.00 provides 19 characters for user to populate
0084.00
0085.00 05) K3S_C131 - (Pete Lippe @ Core-Mark 01/09)
0086.00 If product has manual minimum days and it has an SQ,
0087.00 then it should also be an OP check.
0088.00 Used in K3S_1500, K3S_1510, K3S_3025
0089.00
0090.00 06) K3S_C151 - Logic add to clean notes of any characters
0091.00 less than blank.
0092.00
0093.00 07) K3S_C152 - Logic add to clean notes of any characters
0094.00 less than blank.
0095.00
0096.00 08) K3S_C153 - (Scott 01/09/09)
0097.00 New /COPY member to clean notes of any characters
0098.00 less thank blank
0099.00 (which could happen if copy/pasted from email)
0100.00
0101.00 09) K3S_DEALS - Get deal information from customer's ERP system
0102.00 K3S_DL_CLR into K3S deal files during night job. These
0103.00 K3S_DL_GET shell programs are modified to fit customer's
0104.00 K3S_DL_PI environment, and the re-populate daily.
0105.00
0106.00 10) K3S_FX505A - (Brantley)
0107.00 Taking out abbreviations from screen titles to use
0108.00 all of the room we now have.
0109.00
0110.00 11) K3S_FX505B - (Les Schwab)
0111.00 Ability to update Car Count field PR_CARCOUN from
0112.00 interface K_INTPROD and K_INTPRDD. Updated
0113.00 descripton 2 field for APP record
0114.00 'K3S_1500 CAR_COUNT' to read:
0115.00 Update PR_CARCOUN from IP_CARCOUN and
0116.00 IY_CARCOUN? use flag 2
0117.00
0118.00 12) K3S_FX505C - (Core Mark)
0119.00 Un-protect units 7, 8, 9 for SDU Supplier discount
0120.00 units, so that customer can change text.
0121.00
0122.00 13) K3S_FX505D - (Core Mark)
0123.00 Populate PR_DISOTHO with PR_DISOTHR since Unit 6
0124.00 will now get updated nightly via K3S_9010.
0125.00
0126.00 14) K3S_GETLT - Used to capture Lead Time records from customer's
0127.00 PO receipt file.
0128.00
0129.00 15) K3S_SALES - Program used to capture K_INTDALY information from
0130.00 customer's ERP invoice file.
0131.00
0132.00 16) K3S_SELINV - Use OPNQRYF to select invoices to process
0133.00
0134.00 17) K3S_SELPOS - Use OPNQRYF to select POs to process
0135.00
0136.00 18) K3S_SYSCL - (Neill & Pritchard 11/11/2009)
0137.00 Capability to save off the *LDA prior to entering
0138.00 K3S, so customer's ERP system's *LDA can be restored
0139.00 when leaving K3S.
0140.00 - Code that is used during new customer start up
0141.00 to sign off system if not user KING3.
0142.00
0143.00 19) K3S_XP1010 - New program for users to customize 'Your Space'
0144.00 on K3S_1010.
0145.00
0146.00 20) K3S_XRPTCL - For the section on K_SUPLLST, we want to comment
0147.00 out the CPYF from K_SUPLLST to K_SUPLLSTX, and
0148.00 adjust the CVTTOSTMF from QTEMP to *LIBL.
0149.00 (both Steven at Resnick, and Jenny at Bartell,
0150.00 had tried the report option
0151.00 11. Regular Suppliers Lost Opportunities, and
0152.00 both received error. They do have reports going
0153.00 to IFS, and therefore errored.)
0154.00
0155.00 21) K3S_0010FM - K3S Main Menu to show new Release 5.05 Jan-01-2010
0156.00 K3S_0010 - Logic add to clean notes of any characters
0157.00 less than blank.
0158.00
0159.00 22) K3S_0031FM - Ranking Reports Menu options #18 and #28 were under
0160.00 K3S_0031 the wrong columns from the R4 to R5 conversion.
0161.00 They were moved back to the 2nd and 3rd columns,
0162.00 By supplier/product and By product.
0163.00
0164.00 23) K3S_0040FM - Management Controls Menu added option
0165.00 K3S_0040 - 10. Supplier/Product group service level targets
0166.00 (Larry Gerke at Les Schwab Tires)
0167.00
0168.00 24) K3S_1010FM - Logic added to call program K3S_XP1010 to
0169.00 K3S_1010 allow users ability to program 'your space'
0170.00 - (Core Mark)
0171.00 Unit 7,8,9 logic added
0172.00 - Expand supplier mask (supl, sub, name)
0173.00
0174.00 25) K3S_1015FM - Show new fields in K_INTORDB on the screen.
0175.00 K3S_1015 No RPG logic changes.
0176.00 - (Core Mark)
0177.00 Unit 7,8,9 logic added
0178.00
0179.00 26) K3S_1016 - (Core Mark)
0180.00 Unit 7,8,9 logic added
0181.00
0182.00 27) K3S_1020FM - Logic add to clean notes of any characters
0183.00 K3S_1020 less than blank.
0184.00 - ZZ_SUPLMSK increased and logic added to
0185.00 trim blanks (Pete Lippe 11/08)
0186.00 - (Core Mark)
0187.00 Unit 7,8,9 logic added
0188.00 - (Joyce Sublett @ Allison Wholesale 11/17/2009)
0189.00 F24=Function key screen now includes the program IDs
0190.00 for major programs.
0191.00 - (Core Mark - Pete Lippe 11/08)
0192.00 Text reads 'Alt source' when in fact a supplier
0193.00 can be one of 3 types. Change to display:
0194.00 Supl type. 0 Regular
0195.00 1 Alt source
0196.00 2 Combined
0197.00
0198.00 28) K3S_1030FM - ZZ_SUPLMSK increased and logic added to
0199.00 K3S_1030 trim blanks (Pete Lippe 11/08)
0200.00 - (Core Mark)
0201.00 Unit 7,8,9 logic added
0202.00
0203.00 29) K3S_1035FM - (Core Mark)
0204.00 K3S_1035 Unit 7,8,9 logic added
0205.00
0206.00 30) K3S_1040 - Logic add to clean notes of any characters
0207.00 K3S_1040FM less than blank.
0208.00 K3S_1041 - (Core Mark)
0209.00 K3S_1041FM Unit 7,8,9 logic added
0210.00 - Expand supplier mask (supl, sub, name)
0211.00
0212.00 31) K3S_1050FM - (Jonathan @ Modern 10/02/2009)
0213.00 K3S_1050 For daily replenishment orders, K3S_1500 is going to
0214.00 set SO_PREFSEQ = 555. This will allow users to
0215.00 use the LT quoted field to set the arrival dates on
0216.00 PO's without messing up dates for daily rep suppliers.
0217.00 A change was also needed in K3S_1500 to make this work
0218.00 - Expand supplier mask (supl, sub, name)
0219.00 ZZ_LOCNDES 24 to 46
0220.00 ZZ_BUYRNAM 29 to 41
0221.00 ZZ_SUPLNAM 40 to 62
0222.00 ZZ_SUPLCMB 40 to 72
0223.00
0224.00 32) K3S_1200 - (Core Mark)
0225.00 Unit 7,8,9 logic added
0226.00
0227.00 33) K3S_1220 - (Rob Prokesch at Resnick 9/23/2009)
0228.00 Bracket Level function now includes test to look
0229.00 for 'off invoice' deals, and subtract it from
0230.00 Bracket Level cost.
0231.00
0232.00 34) K3S_1500 - Needed recompile because of change to /COPY K3S_C131
0233.00 - (Jonathan @ Modern 10/09)
0234.00 For daily replenishment orders we are going to
0235.00 set SO_PREFSEQ = 555. This will allow users to
0236.00 user the LT quoted field to set the arrival dates on
0237.00 PO's without messing up dates for daily rep suppliers.
0238.00 A change was also needed in K3S_1050 to make this work
0239.00 - (Larry and Lloyd @ Les Schwab 10/09)
0240.00 New capability added to existing car count logic's
0241.00 APP record to allow customer to control PR_CARCOUN
0242.00 through interface files.
0243.00 - (Larry and Lloyd @ Les Schwab 10/09)
0244.00 Switch car count logic from using PR_CONTFLG to the
0245.00 PR_CARCOUN field which is new for R5 database.
0246.00 - (Scott 10/23/2009)
0247.00 RE Reminder checks were not working for Combined
0248.00 Suppliers.
0249.00 - (Resnick Distributors 2/28/2009)
0250.00 Permanent Deal 'off invoice' for both '%' percentage
0251.00 and 'D' difference, generates correct cost.
0252.00 - (Core Mark)
0253.00 Unit 7,8,9 logic added.
0254.00 - (Pete Lippe @ Core-Mark 01/09)
0255.00 If product has manual minimum days and it has an SQ,
0256.00 then it should also be an OP check.
0257.00 (fixed logic is in K3S_C131)
0258.00
0259.00 35) K3S_1510 - (Larry Gerke @ Les Schwab 01/09 found becuase
0260.00 purchase adjusment report was not totaling right
0261.00 because PQ_SOQSRVC field was wrong)
0262.00 Had a scenario where the PR_SOQNITE and PQ_SOQSRVC
0263.00 fields wouldn't get updated to PQ_SOQACT, usually
0264.00 when days were taken off to create order
0265.00 - (Core Mark)
0266.00 Unit 7,8,9 logic added.
0267.00 - (Pete Lippe @ Core-Mark 01/09)
0268.00 If product has manual minimum days and it has an SQ,
0269.00 then it should also be an OP check.
0270.00 (fixed logic is in K3S_C131)
0271.00
0272.00 36) K3S_1910 - (Scott 8/09)
0273.00 For USD Unit Straight Down with Unit 5
0274.00 Purchase Increment, the test is that it be greater
0275.00 than 0 only (previously tested to be greater than 1)
0276.00 - (Core Mark)
0277.00 Added logic for Units 7,8,9
0278.00
0279.00 37) K3S_2000FM - Operation Cleanup
0280.00 K3S_2000 - Logic add to clean notes of any characters
0281.00 less than blank.
0282.00
0283.00 38) K3S_2020FM - Operation Cleanup
0284.00 K3S_2020
0285.00
0286.00 39) K3S_2027FM - Operation Cleanup
0287.00 K3S_2027 No RPG logic changes.
0288.00
0289.00 40) K3S_2028FM - Operation Cleanup
0290.00 K3S_2028 No RPG logic changes.
0291.00
0292.00 41) K3S_2029FM - Operation Cleanup
0293.00 K3S_2029 No RPG logic changes.
0294.00
0295.00 42) K3S_2040FM - Operation Cleanup.
0296.00 K3S_2040 - Logic add to clean notes of any characters
0297.00 less than blank.
0298.00
0299.00 43) K3S_2044FM - Operation Cleanup
0300.00 K3S_2044 No RPG logic changes.
0301.00
0302.00 44) K3S_2060 - Logic add to clean notes of any characters
0303.00 less than blank.
0304.00 - (Jeanine @ LP Shanks March 2009)
0305.00 Fix loop when buyer tries 4=Remove level, then
0306.00 press ENTER to get record displayed, then instead
0307.00 using 'Press ENTER to delete, or F12 to cancel
0308.00 delete' use the F4=. Program loop.
0309.00
0310.00 45) K3S_2067FM - Operation Cleanup
0311.00 K3S_2067 No RPG logic changes.
0312.00
0313.00 46) K3S_2070FM - Operation Cleanup
0314.00 K3S_2070 - Search pattern from 30 to 40 length
0315.00
0316.00 47) K3S_2071FM - Operation Cleanup
0317.00 K3S_2071 - Search pattern from 30 to 40 length
0318.00
0319.00 48) K3S_3000FM - Logic add to clean notes of any characters
0320.00 K3s_3000 less than blank.
0321.00 - Operation cleanup.
0322.00 - (Core Mark)
0323.00 Unit 7,8,9 logic added.
0324.00 - Unit 6 'Other' over-ride and current value
0325.00 displayed.
0326.00 - (Larry @ Les Schwab)
0327.00 'Days out point in units' use of 999 to exclude
0328.00 this product from 'days out of stock' logic
0329.00 'Days out point in units' error message when
0330.00 negative value entered new reads 'Unit not allowed
0331.00 to be negative'.
0332.00
0333.00 49) K3S_3001 - (Core Mark)
0334.00 Unit 7,8,9 logic added.
0335.00
0336.00 50) K3S_3007FM - Operation cleanup
0337.00 K3s_3007 No RPG logic changes.
0338.00
0339.00 51) K3S_3015FM - Operation Cleanup
0340.00 K3S_3015 No RPG logic changes.
0341.00
0342.00 52) K3S_3016FM - Operation cleanup
0343.00 K3S_3016 - (Scott 09/09)
0344.00 We were showing PRODSEQ instead of DESC1
0345.00 when trying to copy a link.
0346.00
0347.00 53) K3S_3019FM - Operation cleanup
0348.00 K3S_3019 - No RPG logic changes.
0349.00
0350.00 54) K3S_3025 - (Larry and Lloyd @ Les Schwab 10/09)
0351.00 Logic added to understand car count logic.
0352.00 - (Pete Lippe @ Core-Mark 01/09)
0353.00 If product has manual minimum days and it has an SQ,
0354.00 then it should also be an OP check.
0355.00 (fixed logic is in K3S_C131)
0356.00
0357.00 55) K3S_3030 - Logic add to clean notes of any characters
0358.00 K3S_3030FM less than blank.
0359.00 K3S_3031 - Expand supplier mask (supl, sub, name)
0360.00 K3S_3031FM
0361.00
0362.00 56) K3S_3032FM - Operation Cleanup.
0363.00 K3S_3032 No RPG logic changes.
0364.00
0365.00 57) K3S_3035 - (Debbie Taylor & Variety Wholesale, 09/09)
0366.00 Two work fields increased in size, to handle
0367.00 the Standard Deviation method when a
0368.00 product has large demand values.
0369.00
0370.00 58) K3S_3040FM - Operation cleanup
0371.00 K3S_3040 - No RPG logic changes.
0372.00
0373.00 59) K3S_3050 - (Steven @ Resnick 06/09)
0374.00 Needed PU_SOURCE = *blanks, otherwise it was
0375.00 populated with 'X' and would get cleared at night
0376.00
0377.00 60) K3S_3051FM - (Steven @ Resnick 06/09)
0378.00 K3S_3051 Needed PU_SOURCE = *blanks, otherwise it was
0379.00 populated with 'X' and would get cleared at night
0380.00 - Operation Cleanup
0381.00
0382.00 61) K3S_3054FM - (Steven @ Resnick 06/09)
0383.00 K3S_3054 Needed PU_SOURCE = *blanks, otherwise it was
0384.00 populated with 'X' and would get cleared at night
0385.00
0386.00 62) K3S_3057FM - Operation cleanup
0387.00 K3S_3057 - No RPG logic changes.
0388.00
0389.00 63) K3S_3058 - (Resnick Distributors)
0390.00 - New program to repopulate hold out records from
0391.00 external source
0392.00
0393.00 64) K3S_3070FM - Operation Cleanup
0394.00 K3S_3070 No RPG logic changes.
0395.00
0396.00 65) K3S_3090FM - Operation Cleanup
0397.00 K3S_3090 No RPG logic changes.
0398.00
0399.00 66) K3S_3200FM - Operation Cleanup
0400.00 K3S_3200 No RPG logic changes.
0401.00
0402.00 67) K3S_3210FM - Operation Cleanup
0403.00 K3S_3210 No RPG logic changes.
0404.00
0405.00 68) K3S_3270FM - Logic add to clean notes of any characters
0406.00 K3S_3270 less than blank.
0407.00 - Operation Cleanup.
0408.00
0409.00 69) K3S_3271 - (Resnick Distributors)
0410.00 New program to populate Bracket Level pricing file
0411.00 from external source.
0412.00
0413.00 70) K3S_3277FM - Operation Cleanup
0414.00 K3S_3277 No RPG logic changes.
0415.00
0416.00 71) K3S_3300FM - Added text to report select criteria screen
0417.00 K3S_3300 to notify user of '*' capability in sub-code field.
0418.00 No RPG logic changes.
0419.00
0420.00 72) K3S_P3301 - (Lisa Raphael @ Bartell 10/09)
0421.00 K3S_3301 Added logic to read new APP record that lets us show
0422.00 more of the product description on reports. This
0423.00 will help customers that have a long product ID.
0424.00
0425.00 73) K3S_3350FM - Added text to report select criteria screen
0426.00 K3S_3350 to notify user of '*' capability in sub-code field.
0427.00 No RPG logic changes.
0428.00
0429.00 74) K3S_3365FM - Added text to report select criteria screen
0430.00 K3S_3365 to notify user of '*' capability in sub-code field.
0431.00 No RPG logic changes.
0432.00
0433.00 75) K3S_3400FM - (got the idea from fix needed for K3S_5300FM)
0434.00 K3S_3400 Cleanup of subfile screens where we need to add
0435.00 hidden fields so that when you 5=View a record
0436.00 we are displaying the correct information for
0437.00 Birth and lastupdate.
0438.00 No RPG logic changes.
0439.00
0440.00 76) K3S_3450FM - Operation Cleanup
0441.00 K3S_3450 No RPG logic changes.
0442.00
0443.00 77) K3S_3452 - (Scott Wynn @ Parts Central 10/29/2009)
0444.00 For suppliers with more than 10,000 products,
0445.00 a test is made before the subfile hits 9,995
0446.00 records, and then displays the message for the user
0447.00 "Use F5=Product for positioning"
0448.00
0449.00 78) K3S_3470FM - (Scott 08/09)
0450.00 K3S_3470 Were not able to 3=copy the automated days
0451.00 due to the larger field sizes.
0452.00 No RPG logic changes.
0453.00
0454.00 79) K3S_3600 - (Scott April 2009)
0455.00 Ability to exclude on order quantities from
0456.00 balance calculation for overstock determination.
0457.00
0458.00 80) K3S_3610FM - Added text to report select criteria screen
0459.00 K3S_3610 to notify user of '*' capability in sub-code field.
0460.00 No RPG logic changes.
0461.00
0462.00 81) K3S_3710FM - Added text to report select criteria screen
0463.00 K3S_3710 to notify user of '*' capability in sub-code field.
0464.00 No RPG logic changes.
0465.00
0466.00 82) K3S_3715 - (Les Schwab 08/09)
0467.00 Logic added so that when they have linked an old produ
0468.00 to a new product they don't want the Obsolete Report
0469.00 to list both of them, since remaining inventory on the
0470.00 would be added to the new product every day.
0471.00
0472.00 83) K3S_3750FM - Added text to report select criteria screen
0473.00 K3S_3750 to notify user of '*' capability in sub-code field.
0474.00 No RPG logic changes.
0475.00
0476.00 84) K3S_3760FM - Added text to report select criteria screen
0477.00 K3S_3760 to notify user of '*' capability in sub-code field.
0478.00 No RPG logic changes.
0479.00
0480.00 85) K3S_3850FM - (got the idea from fix needed for K3S_5300FM)
0481.00 K3S_3850 Cleanup of subfile screens where we need to add
0482.00 hidden fields so that when you 5=View a record
0483.00 we are displaying the correct information for
0484.00 Birth and lastupdate.
0485.00 No RPG logic changes.
0486.00
0487.00 86) K3S_4031 - (Pete Lippe @ Core-Mark 02/09)
0488.00 Fix added to get correct description for
0489.00 P12 product group service level targets.
0490.00 - (Brant) Change default min % for SV checks
0491.00 from 50% to 99% to be like buy group service
0492.00 level targets
0493.00
0494.00 87) K3S_4040 - (King III 10/09 found when helping Les Scwab)
0495.00 Two major improvements for programs that set
0496.00 PR_SERVICE by ranking for either dollars or units:
0497.00 1) Ensure the #1 product in a group of ranked
0498.00 products gets the highest service level setting
0499.00 for Level 1
0500.00 2) For each Level make sure the product that crosses
0501.00 the percentage level setting goes to the higher
0502.00 service level setting
0503.00
0504.00 88) K3S_4041 - (King III 10/09 found when helping Les Scwab)
0505.00 Two major improvements for programs that set
0506.00 PR_SERVICE by ranking for either dollars or units:
0507.00 1) Ensure the #1 product in a group of ranked
0508.00 products gets the highest service level setting
0509.00 for Level 1
0510.00 2) For each Level make sure the product that crosses
0511.00 the percentage level setting goes to the higher
0512.00 service level setting
0513.00
0514.00 89) K3S_4112CL - (King III 10/09 new program for Les Schwab)
0515.00 Call K3S_4113CL
0516.00
0517.00 90) K3S_4113CL - (King III 10/09 new program for Les Schwab)
0518.00 Update products.
0519.00
0520.00 91) K3S_4131FM - (King III 10/09 new program for Les Schwab)
0521.00 K3S_4131 New screen program to allow users to maintain
0522.00 service level targets by location,
0523.00 supplier, product group 1, product group 2
0524.00
0525.00 92) K3S_4133 - (King III 10/09 new program for Les Schwab)
0526.00 Supl/product group service level changes log add
0527.00 program
0528.00
0529.00 93) K3S_4136 - (King III 10/09 new program for Les Schwab)
0530.00 This program is used to control the process of setting
0531.00 new service level targets for products, using the
0532.00 Supplier/product group fields.
0533.00
0534.00 94) K3S_4138FM - (King III 10/09 new program for Les Schwab)
0535.00 K3S_4138 New screen program for supl/product group
0536.00 service level changes log.
0537.00
0538.00 95) K3S_4141 - (King III 10/09 new program for Les Schwab)
0539.00 Supl/product group service level targets, update
0540.00 products
0541.00 Two major improvements for programs that set
0542.00 PR_SERVICE by ranking for either dollars or units:
0543.00 1) Ensure the #1 product in a group of ranked
0544.00 products gets the highest service level setting
0545.00 for Level 1
0546.00 2) For each Level make sure the product that crosses
0547.00 the percentage level setting goes to the higher
0548.00 service level setting
0549.00
0550.00 96) K3S_4141CL - (King III 10/09 new program for Les Schwab)
0551.00 Control batch process that runs weekly
0552.00
0553.00 97) K3S_4141X1 - (King III 10/09 new program for Les Schwab)
0554.00 K3S_4141X2 - these three are exit point programs within
0555.00 K3S_4141X3 - K3S_4141CL and go into K3S_5MOD.
0556.00
0557.00 98) K3S_5050 - Logic add to clean notes of any characters
0558.00 less than blank.
0559.00
0560.00 99) K3S_5051 - Logic add to clean notes of any characters
0561.00 less than blank.
0562.00
0563.00 100) K3S_5300FM - (Pete Lippe @ Core-Mark 09/09)
0564.00 K3S_5300 When 5=Viewing one of the permanent deals, the
0565.00 birth date and last update field was showing the
0566.00 dates from the last record in the subfile.
0567.00 Had to add hidden fields to display the correct
0568.00 dates.
0569.00 No RPG logic changes.
0570.00
0571.00 101) K3S_5401 - (Scott March 2009)
0572.00 - Logic added to test potential Price Increase,
0573.00 and determine if it is actually a Price Decrease.
0574.00 If so, flag as error, and don't add to deal file.
0575.00
0576.00 102) K3S_6010 - Logic add to clean notes of any characters
0577.00 less than blank.
0578.00
0579.00 103) K3S_6020 - Logic add to clean notes of any characters
0580.00 less than blank.
0581.00
0582.00 104) K3S_8000 - Logic add to clean notes of any characters
0583.00 less than blank.
0584.00
0585.00 105) K3S_8010FM - Operation Cleanup
0586.00 K3S_8010 No RPG logic changes.
0587.00
0588.00 106) K3S_8030FM - Logic add to clean notes of any characters
0589.00 K3S_8030 less than blank. Align total fields.
0590.00
0591.00 107) K3S_9010 - (several customers mentioned this)
0592.00 when demand was zero in previous period
0593.00 make PR_PRVSVCE = 100%, not 0%
0594.00 - (King III idea from Jarboe, 09/09)
0595.00 For new products, populate previous deviation %
0596.00 from location file. This will be helpful if
0597.00 previous averages need to be restored because
0598.00 new products would have no previous value.
0599.00 - (Larry and Lloyd @ Les Schwab 10/09)
0600.00 New capability added to existing car count logic's
0601.00 APP record to allow customer to control PR_CARCOUN
0602.00 through interface files.
0603.00 - (Core Mark)
0604.00 Unit 7,8,9 logic added.
0605.00 - Unit 6 'Other' now tested for negative value being
0606.00 passed.
0607.00 - Product Interace Log now has 4 new log types
0608.00 d Negative Unit 6 bracket value
0609.00 e Negative Unit 7 bracket value
0610.00 f Negative Unit 8 bracket value
0611.00 g Negative Unit 9 bracket value
0612.00 - (Larry @ Les Schwab)
0613.00 'Days out point in units' use of 999 to exclude
0614.00 this product from 'days out of stock' logic
0615.00
0616.00 108) K3S_9011 - (King III idea from Jarboe, 09/09)
0617.00 For new products, populate previous deviation %
0618.00 from location file. This will be helpful if
0619.00 previous averages need to be restored because
0620.00 new products would have no previous value.
0621.00 - (Larry and Lloyd @ Les Schwab 10/09)
0622.00 New capability added to existing car count logic's
0623.00 APP record to allow customer to control PR_CARCOUN
0624.00 through interface files.
0625.00 - (Core Mark)
0626.00 Unit 7,8,9 logic added.
0627.00 - Unit 6 'Other' now tested for negative value being
0628.00 passed.
0629.00 - Product Interace Log now has 4 new log types
0630.00 d Negative Unit 6 bracket value
0631.00 e Negative Unit 7 bracket value
0632.00 f Negative Unit 8 bracket value
0633.00 g Negative Unit 9 bracket value
0634.00
0635.00 109) K3S_9013 - (King III idea from Jarboe, 09/09)
0636.00 New program that will only be used on demand-
0637.00 must be manually called. It will restore the
0638.00 'previous' fields in the K_PRODUCT file.
0639.00
0640.00 110) K3S_9070FM - Display Restart value on front screen, so we
0641.00 K3S_9070 immediately see it.
0642.00
0643.00 111) K3S_9120 - (King III found in R5 migration)
0644.00 Make sure PR_ALTSRCE = 1 before deleting
0645.00 product. Can get into trouble if this program
0646.00 is called from K3S_9110CL not compiled into
0647.00 our activation group!
0648.00
0649.00 112) K3S_9257 - (King III)
0650.00 Changed default of how we are calculating
0651.00 Tot Ordered and Tot Shipped
0652.00
0653.00 113) K3S_9540FM - Increased the table code description area by
0654.00 K3S_9540 20 characters. No RPG logic changes.
0655.00
0656.00 114) PO_CHK - Used to determine what PO receipts have already
0657.00 been captured. Used in program K3S_GETLT.
0658.00
0659.00 -----------------------------------------------------------------------
0660.00 Physical and logical files added or changed during this release
0661.00 -----------------------------------------------------------------------
0662.00
0663.00 8 new Physical and Logical files are added during this release
0664.00
0665.00 K_INTPLVL - Interface for Product Bracket Level Costs
0666.00 K_INTPLVLA - Interface for Product Bracket Level Costs - logical file
0667.00 K_INTHOLD - Interface for Product Holds outs
0668.00 K_INTHOLDA - Interface for Product Holds outs - logical file
0669.00 K_SUP1LOG - Supplier/Product Group Service Levels log of changes
0670.00 K_SUP1LOGA - Supplier/Product Group Service Levels - logical file
0671.00 K_SUP1SRV - Supplier/Product Group Service Levels Table
0672.00 K_SUP1SRVA - Supplier/Product Group Service Levels Table - logical
0673.00
0674.00 After this release installed, there should be exactly 425 objects
0675.00 in library K3S_5DTA(data files library) (Rel 5.04 had 417 objects)
0676.00
0677.00 Updated help document included (replaces the current version
0678.00 in library K3S_5OBJ: file K_F1_DOC)
0679.00
0680.00 -----------------------------------------------------------------------
0681.00 Special conditions for some customers
0682.00 -----------------------------------------------------------------------
0683.00
0684.00 none
0685.00
0686.00 -----------------------------------------------------------------------
0687.00 Programs in library K3S_MOD505
0688.00 -----------------------------------------------------------------------
0689.00
0690.00 -- RPGLE
0691.00 K3S_ADDSUP Add new suppliers during K3S night job
0692.00 K3S_CVRT22 New Table Code entries
0693.00 K3S_DL_CLR Re-set deal# to 1, clear product deal information
0694.00 K3S_DL_GET Get deal information into K_INTDEAL
0695.00 K3S_DL_PI Get price increase into K_INTDEAL
0696.00 K3S_GETLT Capture receipts to K_PRODLTM
0697.00 K3S_SALES Capture daily sales/outs to K_INTDALY
0698.00 K3S_XP1010 Control YOUR SPACE in K3S_1010
0699.00 K3S_1050 PO Approval
0700.00 K3S_5401 Create deals from external source
0701.00 K3S_9257 Display daily demand
0702.00
0703.00 -- CLLE
0704.00 K3S_DEALS Re-populate K3S deal information from customer's ERP
0705.00 K3S_SELINV Use OPNQRYF to select invoices to process
0706.00 K3S_SELPOS Use OPNQRYF to select POs to process
0707.00 K3S_SYSCL Start up CL for K3S users
0708.00 K3S_XRPTCL Exit - after Report print
0709.00 K3S_4141X1 Exit - from K3S_4141CL Before tables processing
0710.00 K3S_4141X2 Exit - from K3S_4141CL Before exceptions processing
0711.00 K3S_4141X3 Exit - from K3S_4141CL Before end of program
0712.00
0713.00 -- CMD
0714.00 none
0715.00
0716.00 -- DSPF
0717.00 K3S_1050FM PO Approval
0718.00
0719.00 -- PF
0720.00 INV_CHK Invoice capture file
0721.00 PO_CHK Purchase order capture file
0722.00
0723.00 -----------------------------------------------------------------------
0724.00 Programs in library K3S_5CNV
0725.00 -----------------------------------------------------------------------
0726.00
0727.00 -- RPGLE
0728.00 01) K3S_B001 - Used to populate K_VEND for new install
0729.00 01) K3S_B002 - Used to populate K_TABLCOD with 'P12' records
0730.00 01) K3S_B003 - Used to populate K_GRP1SRV
0731.00
0732.00 -- CLLE
0733.00 none
0734.00
0735.00 -- CMD
0736.00 none
0737.00
0738.00 -- DSPF
0739.00 none
0740.00
0741.00 -----------------------------------------------------------------------
0742.00 Implementation steps for this release
0743.00 -----------------------------------------------------------------------
0744.00
0745.00 Standard LODRUN *OPT
0746.00
0747.00 The 5 changes required for K3S_5MOD after the new release has been
0748.00 installed will be:
0749.00
0750.00 1) K3S_XP1010 Control YOUR SPACE in K3S_1010
0751.00 move over and compile
0752.00
0753.00 2) K3S_1050 PO Approval. Only need this for customers who use
0754.00 Daily Replenishment.
0755.00 add statement of so_prefseq = 555
0756.00
0757.00 *** for Daily Replenishment orders, can use SO_LEADTMO
0758.00 c if dly_arrive = *on and
0759.00 ---> c so_prefseq = 555
0760.00 c lda_sysdat adddur so_leadtmo:*d xx_arvdate
0761.00 c endif
0762.00
0763.00 3) K3S_1050FM PO Approval
0764.00 - Expand supplier mask (supl, sub, name)
0765.00 ZZ_LOCNDES 24 to 46
0766.00 ZZ_BUYRNAM 29 to 41
0767.00 ZZ_SUPLNAM 40 to 62
0768.00 ZZ_SUPLCMB 40 to 72
0769.00 A 3 2'Location..'
0770.00 ---> A ZZ_LOCNDES 46A O 3 13
0771.00 A 4 2'Buy Group.'
0772.00 ---> A ZZ_BUYRNAM 41A O 4 13
0773.00 A 5 2'Supplier..'
0774.00 ---> A ZZ_SUPLNAM 62A O 5 13
0775.00 A 35 6 2'Combined..'
0776.00 ---> A 35 ZZ_SUPLCMB 72A O 6 13
0777.00
0778.00 4) K3S_5401 Create deals from external source
0779.00 This is only needed for customers who pull over deal
0780.00 information from their ERP.
0781.00 Add logic below to the end of the $_errs_chk
0782.00 subroutine.
0783.00
0784.00 c $_errs_chk begsr
0785.00
0786.00 c many error checking statements
0787.00 c "
0788.00
0789.00 **** test for Price Decrease - start - fix for R5.05
0790.00 c if il_apply = 'P' and
0791.00 c il_facttyp = '$'
0792.00 c if il_unit > 0 and
0793.00 c pr_costdiv > 0 and
0794.00 c (il_factval/il_unit <= pr_costreg/pr
0795.00 c eval il_exclude = 1
0796.00 c endif
0797.00 c endif
0798.00 **** test for Price Decrease - end
0799.00
0800.00 c endsr
0801.00
0802.00 5) K3S_XRPTCL Exit - after Report print
0803.00 This is only needed for customers who do you this
0804.00 facility. Change requires two things:
0805.00 1st - comment out the CPYF below
0806.00 2nd - change CVTTOSTMF PARM from QTEMP to *LIBL
0807.00
0808.00 /* CPYF FROMFILE(QTEMP/K_SUPLLST) TOFILE(K_SUPLLSTX) +
0809.00 TOMBR(&USER) MBROPT(*REPLACE) +
0810.00 MONMSG MSGID(CPF2817 CPF2869) */
0811.00
0812.00 Change
0813.00 from --> /* CALL PGM(CVTTOSTMF) PARM('K_SUPLLST QTEMP' +
0814.00 to ----> /* CALL PGM(CVTTOSTMF) PARM('K_SUPLLST *LIBL' +
