0001.00 -----------------------------------------------------------------------
0002.00 Notes for Release 6.4 Jan 01, 2022 rel_6.4.doc
0003.00 -----------------------------------------------------------------------
0004.00
0005.00 01) K3S_APIGET - New parameter to pass FTP site to pull updates.
0006.00 K3S_APIIN User/password change. Use new SAVF K3SAPISOBJ in QGPL.
0007.00 K3S_APIUPD
0008.00
0009.00 02) K3S_CVRT22 - Changes to table code records/New table code records:
0010.00
0011.00 API - Setup values and info for APIs & Night Job
0012.00
0013.00 NIT - Night Job schedule display on login
0014.00
0015.00 HIDEARRIVE - Hide PO Arrival date on PO approval screen
0016.00
0017.00 APP - Application codes
0018.00
0019.00 NOTE_DSPLY - Control note sequence in R6
0020.00
0021.00 BTN - R6 display of buttons
0022.00
0023.00 QUICKORDER - Quick Adjust Product Button
0024.00 YWALLPROD - Your Window for All Locations for a product
0025.00 YWAPRORDR - Your Window for Approve Order
0026.00 YWDETAILS - Your Window For Product Details / History
0027.00 YWORDER - Your Window for Supplier Suggested Order
0028.00 YWPOLIST - Your Window PO Header
0029.00 YWPRDORD - Your Window for Products on Order
0030.00 YWPRODSET - Your Window for Product Settings
0031.00
0032.00 RET - Retain records # of days
0033.00
0034.00 K_INTDALY - change default to 365 days
0035.00 K_DLYPROD - change default to 365 days
0036.00 K_INVPROD - change default to 730 days
0037.00 K_INVSUPL - change default to 730 days
0038.00
0039.00 SEM - Security For Viewing Menu Options
0040.00
0041.00 AAX - Authority to Purchase Orders Controller
0042.00 AAY - Authority to Inventory Metrics ReStore
0043.00
0044.00 SWT - Do not allow change supplier with this JOB
0045.00 supplier ID
0046.00
0047.00 YSW - Your Window
0048.00
0049.00 TEMPLATE - Template for Your Window
0050.00
0051.00 03) K3S_FX640A - Adjust RET tablcode for K_INVSUPL and K_INVPROD
0052.00 to allow Supplier Orders to show last year purchase
0053.00 totals with retain set at 730 days.
0054.00
0055.00 04) K3S_INVCMP - metrics cleanup GH827
0056.00 - Force service level to 100% when demand = 0
0057.00 - Increase workfield sizes
0058.00 - Do not need to check if buy group is excluded from
0059.00 metrics as K_INVPROD will not have any data for buygrp
0060.00
0061.00 05) K3S_INVLOCN - metrics cleanup GH827
0062.00 - Force service level to 100% when demand = 0
0063.00 - Increase workfield sizes
0064.00 - Do not need to check if buy group is excluded from
0065.00 metrics as K_INVPROD will not have any data for buygrp
0066.00
0067.00 06) K3S_INVPRD - metrics cleanup GH827
0068.00 - Force service level to 100% when demand = 0
0069.00 - Increase workfield sizes
0070.00 - key list fix to make sure we are grabbing flag
0071.00 to see if this buy group should be bypassed from metrics
0072.00 - Use the same cost for across all calculations
0073.00
0074.00 07) K3S_INVSPL - metrics cleanup GH827
0075.00 - Force service level to 100% when demand = 0
0076.00 - Increase workfield sizes
0077.00
0078.00 08) K3S_LTFIX - Optional use; patch K_PRODLTM when assign to
0079.00 K3S_LTFIX1 K3S supplier is used and SUPL/SUPLSUB are not synced.
0080.00
0081.00 09) K3S_PO_IGN - Optional use; ignore transfer POs from K_INTORDL
0082.00 for multi location customers.
0083.00
0084.00 10) K3S_R6HOT - New parameter to pass FTP site to pull updates.
0085.00 K3S_R6HOTI User/password change. Use new SAVF K3SHOTFIX in QGPL.
0086.00
0087.00 11) K3S_X310CL - Remove the call to AC_CPOAPOR
0088.00 - Add CLRPFM to 4 Dynamic List files
0089.00
0090.00 12) K3S_1500 - Legacy green screen comment out logic to lock order just
0091.00 when user is in F21=Start mode on K3S_1010 and
0092.00 recalculating orders and do not set busy flag.
0093.00 - If a supplier has been organized at least once in the
0094.00 past and now the order cycle is > 6 months old, and
0095.00 all the prodcucts are Manual and/or discontinued, do
0096.00 do not prompt the buyer to re-organize it,
0097.00 until at least 1 product is to be replenished again.
0098.00
0099.00 13) K3S_3026 - Look for suppliers to be included in the process to adjust
0100.00 (04/14/19) products Line Cost. Suppliers that have
0101.00 K3S_3026CL SP_GROUP4 = 'MINSPREDxx' are in this group.
0102.00
0103.00
0104.00 14) K3S_3027 - Retrieve Order Point and Order Up To per Line Cost for
0105.00 (04/16/19) one product.
0106.00
0107.00 15) K3S_3030 - Legacy green screen. Change to allow creation
0108.00 K3S_3031 of seasonal profile with a 0.00 factor.
0109.00 (01/09/18)
0110.00
0111.00 16) K3S_3158 - Add hold outs from an external source daytime e
0112.00 K3S_3158CL and log the add.
0113.00
0114.00 17) K3S_3220 - Improvment; when buyer creates customer usage batch e
0115.00 (03/28/19) and uses the Freeze Forecast Until feature, we need to
0116.00 log to K_PRODLOG to show the Freeze Forecast Until
0117.00 field changed.
0118.00
0119.00 18) K3S_3340 - Theoretical Inventory calculation now understands the
0120.00 (09/07/18) inclusion of both Supplier Add Days and Product Add Days.
0121.00
0122.00
0123.00 19) K3S_3361 - Purchase adjustments report must consider cost divisor
0124.00 K3S_3362 if > 1; previously it was fixed at 1.
0125.00 K3S_3363
0126.00 K3S_3364
0127.00 (01/07/18)
0128.00
0129.00 20) K3S_3439 - Weekly pattern checks to understand new 'F' type in
0130.00 (01/15/21) K_SUPLVOC for fresh suppliers.
0131.00
0132.00 21) K3S_3940 - Logic added to understand customers who send K3S
0133.00 (09/05/18) Period-to-date information, instead of Daily
0134.00 Information. This is known by the field LC_DAILY.
0135.00
0136.00 22) K3S_5080 - Identify and update products that have become
0137.00 K3S_5081 unattached to their deal. Also identify
0138.00 K3S_5082 new products that need
0139.00 K3S_5085 to be attached to a deal.
0140.00 K3S_5080CL
0141.00 K3S_5085CL
0142.00
0143.00 23) K3S_9100 - Do not error when only 1 good records sent from
0144.00 diverter
0145.00
0146.00 24) TS_LTMAPOR- Optional use; used to patch past PO statuses based e
0147.00 on value in tablecode.
0148.00
0149.00 -----------------------------------------------------------------------
0150.00 Physical & logical files added/changed/deleted in release for K3S_5DTA
0151.00 -----------------------------------------------------------------------
0152.00
0153.00 There are 6 new Physical files and 2 new Logical files added in this
0154.00 release. There is 1 physical file changed.
0155.00
0156.00 New files:
0157.00 K_ALLWORK PF Work File - All AW
0158.00 K_INTHLDD PF Interface for Product Hold Out records Daytime IT
0159.00 K_INTHLDDA LF Interface for Product Hold Out LOCN,SUPL,SUB,PROD
0160.00 K_INTSDIS PF Interface for Supplier Discount Brackets IK
0161.00 K_INTSDISA LF Interface for Supplier Disc Brkt - SUPL,SUB,BKT
0162.00 K_PRDWORK PF Work File - Products RW
0163.00 K_PROWORK PF Work File - Products OW
0164.00 K_SPLWORK PF Work File - Suppliers SW
0165.00
0166.00 Files changed:
0167.00 K_INVRLOG
0168.00
0169.00 After this release installed, there should be exactly 519 objects
0170.00 in library K3S_5DTA (data files library) (Rel 6.3 had 511 objects)
0171.00
0172.00 -----------------------------------------------------------------------
0173.00 Programs and Files in library K3S_5OBJ
0174.00 -----------------------------------------------------------------------
0175.00
0176.00 -- RPGLE
0177.00 K3S_1500 Create Supplier Suggested Orders
0178.00 K3S_3026 Look for Suppliers/Products to adjust Line Cost
0179.00 K3S_3027 Retrieve OPNT & OUTL per Line Cost for 1 product
0180.00 K3S_3030 Product history
0181.00 K3S_3031 Product history use with K3S_8000
0182.00 K3S_3220 Customer usage log when freeze forecast used
0183.00 K3S_3340 Ranking reports - get totals K_RANKSPL/K_RANKPRD
0184.00 K3S_3361 Purchase adjustments - Report results Buyer
0185.00 K3S_3362 Purchase adjustments - Report results Locations
0186.00 K3S_3363 Purchase adjustments - Report results Top Supl's
0187.00 K3S_3364 Purchase adjustments - Report results Hub Supl's
0188.00 K3S_3439 Weekly distribution - generate weekly exceptions
0189.00 K3S_3940 Accumulate daily product information to K_DLYSVCE
0190.00
0191.00 -- CLLE
0192.00
0193.00 -----------------------------------------------------------------------
0194.00 Programs and Files in library K3S_5MOD
0195.00 -----------------------------------------------------------------------
0196.00
0197.00 -- RPGLE
0198.00 K3S_CVRT22 New Table Code entries
0199.00 K3S_FX640A Write last period stats by COMP to K_INVCOMP
0200.00 K3S_INVCMP Write last period stats by COMP to K_INVCOMP
0201.00 K3S_INVLCN Write last period stats by LOCN to K_INVLOCN
0202.00 K3S_INVPRD Write last period stats by PROD to K_INVPROD
0203.00 K3S_INVSPL Write last period stats by SUPL to K_INVSUPL
0204.00 K3S_LTFIX Patch SUPL & SUPLSUB on K_PRODLTM
0205.00 K3S_LTFIX1 One time patch past K_PRODLTM records
0206.00 K3S_PO_IGN Auto ignore Transfer POs in K_INTORDL
0207.00 K3S_3158 Load product hold outs - Daytime
0208.00 K3S_5080 Identify supplier switch, reconnect deal
0209.00 K3S_5081 Look for K_PRODUCT records missing deal info
0210.00 K3S_5082 Patch K_PRODUCT records missing PR_DEAL* info
0211.00 K3S_5085 Identify new products that need deal reattached
0212.00 K3S_9100 Do not error when only one good record sent from diverter.
0213.00
0214.00 -- CLLE
0215.00 K3S_3026CL Process Suppliers with SP_GROUP4 = MINSPREDxx
0216.00 K3S_3158CL Load product hold outs - Daytime external load
0217.00 K3S_5080CL Identify supplier switch and came back
0218.00 K3S_5085CL Identify new product reattaching to a deal
0219.00 K3S_X310CL Exit***Before Final program end
0220.00 TS_LTMAPOR R6.4 used to clean up PO stats
0221.00
0222.00 -----------------------------------------------------------------------
0223.00 Changes for library QGPL/QCLSRC
0224.00 -----------------------------------------------------------------------
0225.00
0226.00 K3S_APIGET K3S API: Get API programs from FTP site
0227.00 K3S_APIIN K3S API: Input
0228.00 K3S_APIUPD K3S API: run both K3S_APIGET and K3S_APIXCL
0229.00 K3S_R6HOT K3S R6 Hotfix: Pull K3SHOTFX SAVF & restore
0230.00 K3S_R6HOTI K3S R6 HotFix: Input
0231.00
0232.00 -----------------------------------------------------------------------
0233.00 Special instructions for all customers
0234.00 -----------------------------------------------------------------------
0235.00 -Scheduled job K3S_5RFRSH will need a 2nd parm added to specify
0236.00 ftp site ('K3S.FILES.COM')
0237.00 -Setup tablcode type API, value NIT to contain night job schedule
0238.00 for display upon login.
0239.00 -Object and source for fix programs starting with K3S_FX6* removed
0240.00 from 5MOD and object placed into 5OBJ; should not have been in 5MOD
0241.00 to begin with.
0242.00 -Data will be saved and added back to the PF changed K_INVRLOG.
0243.00 -Note:old patches are being redistributed to catch up all
0244.00 environments and core code to same release; these are noted with
0245.00 a date.
0246.00 -----------------------------------------------------------------------
0247.00 Special instructions for some customers
0248.00 -----------------------------------------------------------------------
0249.00 -Customers with large databases may consider indexing large
0250.00 files (K_INTDALY, K_DLYPROD)
0251.00 -Consider cleanup of PO statuses using TS_LTMAPOR process.
0252.00 -If K_PRODLTM has many records with PL_USEFLAG = 4, consider use
0253.00 K3S_LTFIX and K3S_LTFIX1 to clean up past records and add to
0254.00 K3S_NIGHT process.
0255.00 -If the customer does transfer orders, consider adding call from
0256.00 K3S_X310CL to K3S_PO_IGN to ignore transfer orders.
0257.00 -If the customer uses diverters consider change for K3S_9100
0258.00 when only one valid entry sent.
0259.00 -----------------------------------------------------------------------
