Release 5.2 Technical Notes
0001.00 -----------------------------------------------------------------------
0002.00 Notes for Release 5.2 Jan 01, 2015 Rel_5.2.doc
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 K3S_5030 VALID_USER
0011.00 New table code record that holds up to
0012.00 3 valid users who can modify the
0013.00 Company Deal Template. Default users are:
0014.00 QSECOFR
0015.00 KING3
0016.00
0017.00 METRICS INVENTORY
0018.00 New tablecode setting that K3S_X310CL
0019.00 reads to know if we should collect
0020.00 inventory metrics at period end.
0021.00
0022.00 METRICS USER
0023.00 New tablecode setting that K3S_X310CL
0024.00 reads to know if we should collect
0025.00 user metrics at period end.
0026.00
0027.00 METRICS MFGOUT
0028.00 New tablecode setting that tells us if
0029.00 metrics calculations should consider
0030.00 the MFGOUT (mfg out of stock) flag.
0031.00
0032.00 DLE - Deal entry template types
0033.00 L New for "Location/Supplier"
0034.00 S Changed text to "Supplier all locations"
0035.00
0036.00 PLK - added new type 'K' for Kit on Product Link types
0037.00 K Kit
0038.00
0039.00 RET - retain records number of days
0040.00 K_PERDPER new records set to 900 days
0041.00 K_PRODAPP changed from 3,650 days to 900 days
0042.00
0043.00 TLE - added title records for some metrics screens
0044.00 K3S_0150 User Metrics
0045.00 K3S_0160 Buy Group Metrics
0046.00 K3S_0170 Buy Group Inventory Metrics
0047.00 K3S_0180 Products from Suppliers Metrics
0048.00 K3S_0190 Supplier Performance Metrics
0049.00 K3S_0210 Diverter Metrics
0050.00 K3S_1047 Approved Orders Display
0051.00
0052.00 02) K3S_ENDQCM - One line needed fixing in K3S_RESTOR for ending jobs
0053.00 K3S_PRSGET K3S_PRESTO in QUSRWRK. No change to the other 4
0054.00 K3S_PRSIN programs needed in the GUI deployment script but I'm
0055.00 K3S_PRSOUT including them for new installs.
0056.00 K3S_RESTOR
0057.00
0058.00 (Doyles Sheehan)
0059.00 03) K3S_CHOUTQ - Run this to route reports to an OUTQ not connected to
0060.00 a printer so that a hard copy does not print.
0061.00
0062.00 (Central Paper)
0063.00 04) K3S_EMLRPT - surround TO email address in quotes.This will fix any
0064.00 issue of email address having a dash in it or other
0065.00 special character. Also include commented out logic
0066.00 of using the user as the 'from' name and email.
0067.00
0068.00 05) K3S_FX520A - Remove any K_PRODLNK records where product is linked
0069.00 to itself. K3S_3016 was fixed in this release, to
0070.00 ensure no future records are added that link to
0071.00 itself. Fix program will clean file.
0072.00
0073.00 06) K3S_FX520B - This fix program changes the RET record for file
0074.00 K_PRODAPP from 3,650 days to just 900 days.
0075.00
0076.00 07) K3S_FX520C - This fix program will change the DLE record for type S
0077.00 to say 'Supplier all locations' instead
0078.00 of 'Supplier'
0079.00
0080.00 08) K3S_TAD - TAD adjustment - twice a decade. This program will be
0081.00 used every 5 years to clear accumulated demand for
0082.00 both weekly and 13 four-weekly products. Past use
0083.00 in years 2009 and 2014. Next use will be first week
0084.00 of 2019.
0085.00
0086.00 (Debbie @ Variety Wholesalers)
0087.00 09) K3S_1010 - When buyer chose F22=Create new order, then
0088.00 K3S_1010FM F23=Entire Buy Group, the process was not
0089.00 re-calculating Combined Suppliers assigned
0090.00 to that buyer. Therefore any PE1 - PE5 checks
0091.00 which had been performed, were not dropping
0092.00 off the Totem Pole that day (night job would
0093.00 have cleared them).
0094.00 - Logic added to include 'S' for Store Level use.
0095.00 - Logic added for RE Reminder testing, to include
0096.00 any suggested orders that have SO_CHKREMI > 0
0097.00 without regard to SOQ type. Before assumption
0098.00 was that buyers would review other types of
0099.00 orders if they were due.
0100.00
0101.00 10) K3S_1015 - Logic added to include 'S' for Store Level use.
0102.00 K3S_1015FM
0103.00
0104.00 11) K3S_1016 - Logic added to include 'S' for Store Level use.
0105.00 K3S_1016FM
0106.00
0107.00 (Kim @ Lyons-Specialty)
0108.00 12) K3S_1020 - Last Order Cycle date needed to exclude the Date6
0109.00 K3S_1020FM format logic, and be formatted for output.
0110.00 - Logic added to include 'S' for Store Level use.
0111.00
0112.00 13) K3S_1030 - Logic added to include 'S' for Store Level use.
0113.00 K3S_1030FM
0114.00
0115.00 14) K3S_1040 - Logic added to include 'S' for Store Level use.
0116.00 K3S_1040FM
0117.00 K3S_1041
0118.00 K3S_1041FM
0119.00
0120.00 (Joe @ Franklin Machine Products)
0121.00 15) K3S_1046 - Fix month-to-date environment, where data is
0122.00 accumulated.
0123.00 Program completely re-written with embeded SQL
0124.00 statements. There are no 'F' specs!
0125.00
0126.00 16) K3S_1100 - Ensure correct supplier and sub code captured,
0127.00 that understands Change Product Source.
0128.00 Adjustment only needed for customers who buy
0129.00 thru K3S Alternate Source module.
0130.00
0131.00 17) K3S_1910 - Split suggested order needed to use new 'PE' instead
0132.00 of earlier 'CG' for PQ_CHKCHG test.
0133.00
0134.00 18) K3S_2000 - Logic added to include 'S' for Store Level use.
0135.00 K3S_2000FM
0136.00
0137.00 19) K3S_2001 - Work field 'newbuyr' had old length of 3, and needed
0138.00 to be length of 5. Used 'like' statement 'pr_buyr'
0139.00 Discovered at Doyles/Sheehan.
0140.00
0141.00 20) K3S_2030 - Logic added to include 'S' for Store Level use.
0142.00 K3S_2030FM
0143.00
0144.00 21) K3S_2031 - Logic added to include 'S' for Store Level use.
0145.00 K3S_2031FM
0146.00
0147.00 22) K3S_2032 - Logic added to include 'S' for Store Level use.
0148.00 K3S_2032FM
0149.00
0150.00 23) K3S_3000 - Logic added to include 'S' for Store Level use.
0151.00 K3S_3000FM
0152.00
0153.00 (Chris @ Duncan Supply)
0154.00 24) K3S_3016 - Logic fixed for edit to ensure a record does not get
0155.00 added that would link to itself. Warning message
0156.00 'Record would link back to itself' now appears.
0157.00 - Logic fixed where records now require values for
0158.00 all key fields (no blanks).
0159.00 - Message now incudes 'K' for Kits, as well as the
0160.00 previous codes of C, D or X.
0161.00
0162.00 (Joe @ Franklin Machine Products)
0163.00 25) K3S_3030 - Logic effecting earlier 'CG' check commented out so
0164.00 K3S_3030FM that new 'PE' check not effected.
0165.00 K3S_3031 - Logic added to include 'S' for Store Level use.
0166.00 K3S_3031FM
0167.00
0168.00 (Dennis @ House-Hasson Hardware)
0169.00 26) K3S_3062 - Logic added to ensure accumulated receipts not larger
0170.00 than 7.0 field.
0171.00
0172.00 27) K3S_3070 - Logic added to include 'S' for Store Level use.
0173.00 K3S_3070FM
0174.00
0175.00 28) K3S_3090 - Fixes issue where user leaves batch products after
0176.00 adjusting the flag to display certain products.
0177.00 When user returns, the default is now always
0178.00 to display what products are left to review.
0179.00
0180.00 (Dan @ K3S)
0181.00 29) K3S_3420 - Start List did not provide a bail out option, and
0182.00 forced buyer through all products.
0183.00 ENTER key will now advance through products
0184.00 until F12=Previous is pressed.
0185.00
0186.00 30) K3S_3911 - This series of new programs run out of K3S_1010
0187.00 K3S_3911CL when buyer had chosen F22=Create new order,
0188.00 K3S_3931 followed by F23=Entire Buy Group. This group of
0189.00 K3S_3931CL programs will remove existing Combined Supplier
0190.00 orders, and then re-create them, for that buyer.
0191.00
0192.00 (Patty @ Core-Mark)
0193.00 31) K3S_3920 - New capability to use APP record of
0194.00 'K3S_3920 SHIFTxxxx' where xxxx is the specific
0195.00 location to be shifted, which will be unique
0196.00 to products in that location only.
0197.00
0198.00 32) K3S_4500 - Recompile for change to file K_DEALENT, where
0199.00 K3S_4501 field DE_LOCN was added.
0200.00
0201.00 (Patty @ Core-Mark)
0202.00 33) K3S_5030 - Many enhancements made to Deal Template program.
0203.00 K3S_5030FM - added new "Location/Supplier" template
0204.00 - Doubled # of lines in subfile
0205.00 - Birth and Last Update added to subfile
0206.00 - Change mode for 1 letter to 4 function keys
0207.00 - Company Template protected, 3 valid users
0208.00 - Manage environment by retrieval
0209.00
0210.00 34) K3S_5035 - Recompile for change to file K_DEALENT, where
0211.00 field DE_LOCN added.
0212.00
0213.00 (Patty @ Core-Mark)
0214.00 35) K3S_5050 - Entering new deals now understand the new
0215.00 "Location/Supplier" Template.
0216.00
0217.00 (Dennis @ House-Hasson
0218.00 36) K3S_5130 - Add logic to by-pass products with cost of $0,
0219.00 when comparing deals.
0220.00
0221.00 (Patty @ Core-Mark)
0222.00 37) K3S_5300 - Diverters at Loc 007 would not work. Bad P2
0223.00 record entered into K_DEALPER. Program adjusted
0224.00 to ensure all key fields not blank for
0225.00 types L1, S1, S2, P1, P2.
0226.00
0227.00 (Patty @ Core-Mark)
0228.00 38) K3S_9040 - New enhancement to automatically write a Buyer
0229.00 Template in the Deal Template file K_DEALENT
0230.00 when a new buyer is added.
0231.00
0232.00 (Merchants Grocery)
0233.00 39) K3S_9100 - We blew up if we rejected >99% but less than 100% of
0234.00 records (example 99.5%). Force rejection % to 99 in
0235.00 this scenario.
0236.00
0237.00 (Phillip @ Central Paper)
0238.00 40) K3S_9259 - Logic added to handle Total line when details fill
0239.00 K3S_9259FM subfile, and Total line would be on next page.
0240.00 - Screen needs 'LC' for lower case on supplier sub code.
0241.00
0242.00 41) K3S_9505 - File K_PERDPER added to program.
0243.00
0244.00 42) K3S_9520 - Logic added to include 'S' for Store Level use.
0245.00 K3S_9520FM
0246.00
0247.00 43) K3S_9530 - Logic added to include 'S' for Store Level use.
0248.00 K3S_9530FM
0249.00
0250.00 -----------------------------------------------------------------------
0251.00 Physical & logical files added/changed/deleted in release for K3S_5DTA
0252.00 -----------------------------------------------------------------------
0253.00
0254.00 No new files were added, and no files were deleted in this release.
0255.00
0256.00 There were 11 Physical files & 15 Logical files changed in this release.
0257.00
0258.00 K_BUYRIMET PF Buyer Inventory Metrics Report new fields
0259.00 K_COMPMET PF Company Metrics Report new fields
0260.00 K_CUSTWRKX PF Customer Usage Transaction work file *nomax
0261.00 K_DEALENT PF Deals Product Entry Template new field
0262.00 K_DEALENTA LF Deals Product Entry Template
0263.00 K_INVBUYR PF Average inventory statistics for buyers new fields
0264.00 K_INVBUYRA LF Average inventory
0265.00 K_INVCOMP PF Average inventory new fields
0266.00 K_INVCOMPA LF Average inventory
0267.00 K_INVCOMPB LF Average inventory
0268.00 K_INVCOMPC LF Average inventory
0269.00 K_INVLOCN PF Average inventory new fields
0270.00 K_INVLOCNA LF Average inventory
0271.00 K_INVLOCNB LF Average inventory
0272.00 K_INVLOCNC LF Average inventory
0273.00 K_INVLOCND LF Average inventory
0274.00 K_INVLOCNE LF Average inventory
0275.00 K_INVSUPL PF Average inventory new fields
0276.00 K_INVSUPLA LF Average inventory
0277.00 K_INVSUPLB LF Average inventory
0278.00 K_INVSUPLC LF Average inventory
0279.00 K_LOCNMET PF Location Metrics Report new fields
0280.00 K_PRODLTMD LF Product Lead Time new field
0281.00 K_PRODLTME LF Product Lead Time new field
0282.00 K_PRODSEDX PF Product Lead Time *nomax
0283.00 K_SUPLMET PF Supplier Metrics Report new fields
0284.00
0285.00 After this release installed, there should be exactly 492 objects
0286.00 in library K3S_5DTA (data files library) (Rel 5.1 had 492 objects)
0287.00
0288.00 -----------------------------------------------------------------------
0289.00 Programs and Files in library K3S_MOD520
0290.00 -----------------------------------------------------------------------
0291.00
0292.00 -- RPGLE
0293.00 K3S_BLDQRP Build the metrics quarterly report work files
0294.00 K3S_BUYMET Write last period stats by buygroup to K_BUYRMET
0295.00 K3S_CVRT22 New Table Code entries
0296.00 K3S_DVTSVG Write last months stats for diverter savings
0297.00 K3S_EMLRPT Email reports
0298.00 K3S_INVALL Run all inventory analysis programs
0299.00 K3S_INVBYR Write period statistics by BUYR to K_INVBUYR
0300.00 K3S_INVCMP Write period statistics by COMP to K_INVCOMP
0301.00 K3S_INVLCN Write period statistics by LOCN to K_INVLOCN
0302.00 K3S_INVPRD Write period statistics by PROD to K_INVPROD
0303.00 K3S_INVSPL Write period statistics by SUPL to K_INVSUPL
0304.00 K3S_INXALL Choose period for all invent analysis programs
0305.00 K3S_INXLCN Choose period for stats by LOCN to K_INVLOCN
0306.00 K3S_INXPRD Choose period for stats by PROD to K_INVPROD
0307.00 K3S_INXSPL Choose period for stats by SUPL to K_INVSUPL
0308.00 K3S_METTYP Tells K3S_METRCL about User and/or Inv Metrics
0309.00 K3S_SPLPER Write last month stats for supl performance
0310.00 K3S_USRMET Write last period stats by USER to K_USERMET
0311.00 K3S_1100 Suggested Order Approval header and detail
0312.00 K3S_9100 Convert alternate source entries
0313.00 K3S_9259 Display daily demand - expanded
0314.00
0315.00 -- CLLE
0316.00 K3S_ENDQCM K3S GUI. End GUI jobs in QCMN
0317.00 K3S_METRCL Answers about User and/or Inv Metrics
0318.00 K3S_PRSGET K3S GUI. Get updates from FTP site
0319.00 K3S_PRSIN K3S GUI. INPUT file
0320.00 K3S_PRSOUT K3S GUI. OUTPUT file
0321.00 K3S_RESTOR K3S GUI. Restore updates.
0322.00 K3S_SPLQRY Sequence K_INVSUPL by chosen field using OPNQRYF
0323.00 K3S_SPPQRY Sequence K_SUPLPER by chosen field using OPNQRYF
0324.00
0325.00 -- CMD
0326.00 none
0327.00
0328.00 -- DSPF
0329.00 K3S_9259FM Daily demand display - expanded
0330.00
0331.00 -----------------------------------------------------------------------
0332.00 Special instructions for some customers
0333.00 -----------------------------------------------------------------------
0334.00
0335.00 Duncan Supply
0336.00 Add back DPG - BUYERS K3S_4031 - Product Group Service Level Targets
0337.00
0338.00 House Hasson Hardware
0339.00 Saving off K_DEALENT and then training for buyers on new process
0340.00
0341.00 -----------------------------------------------------------------------
0342.00 Special instructions for all customers
0343.00 -----------------------------------------------------------------------
0344.00 none for this release
0345.00
0346.00 -----------------------------------------------------------------------
0347.00
0348.00 Metrics
0349.00
0350.00 *** if the customer has data in the following metrics files be sure
0351.00 *** to make a backup copy of the data before upgrading
0352.00 K_INVBUYR
0353.00 K_INVCOMP
0354.00 K_INVLOCN
0355.00 K_INVSUPL
0356.00
0357.00 *** new and changed PF's and LF's for 5DTA ******
0358.00 *** NOTE: some PF's reference fields in other PF's and must be created
0359.00 *** after the initial PF
0360.00 K_BUYRIMET - NOTE this file must be created after K_INVBUYR
0361.00 K_COMPMET - NOTE this file must be created after K_INVCOMP
0362.00 K_INVBUYR
0363.00 K_INVBUYRA
0364.00 K_INVCOMP
0365.00 K_INVCOMPA
0366.00 K_INVCOMPB
0367.00 K_INVCOMPC
0368.00 K_INVLOCN
0369.00 K_INVLOCNA
0370.00 K_INVLOCNB
0371.00 K_INVLOCNC
0372.00 K_INVLOCND
0373.00 K_INVLOCNE
0374.00 K_INVSUPL
0375.00 K_INVSUPLA
0376.00 K_INVSUPLB
0377.00 K_INVSUPLC
0378.00 K_LOCNMET - NOTE this file must be created after K_INVLOCN
0379.00 K_PRODLTMD
0380.00 K_PRODLTME
0381.00 K_SUPLMET - NOTE this file must be created after K_INVSUPL
0382.00
0383.00 **** printer files for 5OBJ ***
0384.00 **** NOTE all metrics printer files need to be compiled with ***
0385.00 **** CPI (characters per inch) = 15 and PAGESIZE width = 198 ***
0386.00 K3S_P0115
0387.00 K3S_P0125
0388.00 K3S_P0135
0389.00 K3S_P0145
0390.00 K3S_P0175
0391.00 K3S_P0185
0392.00 K3S_P0195
0393.00 K3S_P0200
0394.00 K3S_P0215
0395.00
0396.00 *** new or fixed RPG programs in 5MOD ***
0397.00 K3S_BLDQRP
0398.00 K3S_BUYMET
0399.00 K3S_DVTSVG
0400.00 K3S_INVALL
0401.00 K3S_INVBYR
0402.00 K3S_INVCMP
0403.00 K3S_INVLCN
0404.00 K3S_INVPRD
0405.00 K3S_INVSPL
0406.00 K3S_INXALL
0407.00 K3S_INXLCN
0408.00 K3S_INXPRD
0409.00 K3S_INXSPL
0410.00 K3S_METTYP - New RPG program in 5MOD that will tell K3S_METRCL
0411.00 if we should run inventory and/or user metrics
0412.00 for this company.
0413.00 K3S_SPLPER
0414.00 K3S_USRMET
0415.00
0416.00
0417.00 *** new or fixed CL programs in 5MOD ***
0418.00 K3S_METRCL - New CL program in 5MOD that is the main driver of
0419.00 metrics. This will be called out of K3S_X310CL
0420.00 K3S_SPLQRY
0421.00 K3S_SPPQRY
0422.00
0423.00 *** fixes to existing screens/programs in 5OBJ
0424.00 *** Note: screens are marked if they must be compiled with RSTDSP=*YES
0425.00 K3S_0101FM
0426.00 K3S_0101
0427.00 K3S_0110FM RSTDSP
0428.00 K3S_0110
0429.00 K3S_0115
0430.00 K3S_0120FM RSTDSP
0431.00 K3S_0120
0432.00 K3S_0125
0433.00 K3S_0130FM RSTDSP
0434.00 K3S_0130
0435.00 K3S_0135
0436.00 K3S_0140
0437.00 K3S_0160FM
0438.00 K3S_0160
0439.00 K3S_0170FM RSTDSP
0440.00 K3S_0170
0441.00 K3S_0175
0442.00 K3S_0180FM RSTDSP
0443.00 K3S_0180
0444.00 K3S_0185
0445.00 K3S_0190
0446.00 K3S_0195
0447.00 K3S_0210FM RSTDSP
0448.00 K3S_0210
0449.00
