Release 5.4 Technical Notes
0001.00 -----------------------------------------------------------------------
0002.00 Notes for Release 5.4 Jan 01, 2017 rel_5.4.doc
0003.00 (Name in parenthesis is company who had the idea for the change)
0004.00 -----------------------------------------------------------------------
0005.00
0006.00 (Mutual Distributing)
0007.00 01) AR_DIVPROR - Web - Divide products into different Split Codes
0008.00 New "Best Fit" technology for a multi truck environment
0009.00
0010.00 02) K3S_CVRT22 - Changes to table code records/New table code records:
0011.00
0012.00 Fixed an issue where old DESC is 50 characters, and in
0013.00 Release 5, our TA_CODEDS1 is now 100 characters. The
0014.00 APP record 'K3S_1500 DELAY_VOC' had a value 52
0015.00 positions long, ending in 'e?'. Fix program
0016.00 K3S_FX540A will clean up any customers who may have
0017.00 been effected. added statement 2016-03-16 to clear
0018.00 any remaining data in last 50 characters of
0019.00 TA_CODEDS1 before new record developed.
0020.00
0021.00 APP Application codes
0022.00
0023.00 AUTO_EMAILREPORTS
0024.00 -Automatically email reports to users?
0025.00 Chanaged description 3 to read:
0026.00 Flag2 type: 0=MMAIL 1=EZEML400
0027.00 2=ESEND 3=SNDSMTPEMM
0028.00
0029.00 K3S_1015 SUPL_NAM
0030.00 -Include IB_CUST_PO at end of supplier name?
0031.00 New table code record that will enable a
0032.00 customer to display their own PO# along
0033.00 with the K3S assigned PO#, by using
0034.00 the last area of the supplier name.
0035.00
0036.00 K3S_1020 APR_FILTER
0037.00 -Approve filters used for volume or weight?
0038.00 New table code record that will enable a
0039.00 customer to stop any suggested order from
0040.00 being placed that is larger than either
0041.00 a maximum volume and/or weight.
0042.00
0043.00 K3S_1220 EXC_DEALS
0044.00 -Exclude all deals from Retrieve process?
0045.00 New table code record that will enable a
0046.00 customer to specficially use a Bracket Level
0047.00 cost, and by-pass any time-phased and
0048.00 permanent deals
0049.00
0050.00 K3S_3000 ALLOW_BOTH
0051.00 -Allow both manual min/max days and units?
0052.00 New table code record that will enable a
0053.00 customer to enter both manual min/max values
0054.00 for Days and also Units. This new feature
0055.00 is helpful for a Store Level environment.
0056.00
0057.00 K3S_3600 ALL_D_OVER
0058.00 -All inventory for Discontinued as Overstock?
0059.00 New table code record that will enable a
0060.00 customer to treat all inventory as overstock
0061.00 for Discontinued products, regardless of the
0062.00 average.
0063.00
0064.00 K3S_9010 PR_QTYPEND
0065.00 -Update PR_QTYPEND from IP_TRNOORD?
0066.00 New table code record that will enable a
0067.00 customer to pass any pending transfers thru
0068.00 the existing interface file K_INTPROD
0069.00
0070.00 SPR Selected records review types
0071.00
0072.00 three new records:
0073.00 DOA - Demand occurences-All products
0074.00 DOD - Demand occurences-Discontinued
0075.00 OVG - Gather OV checks to 1 location
0076.00
0077.00 (Raben Tires)
0078.00 03) K3S_DMOC - New program to develop Demand Occurances XX of last YY periods
0079.00
0080.00 (Mutual Distributing)
0081.00 04) K3S_EMLRPT - Email reports - using K_K3SRPT file
0082.00 New logic to enable using customer's email facility
0083.00
0084.00 05) K3S_FX540A - Clean up any customer's K_TABLCOD file where TA_CODEDS1
0085.00 may have 'e?' sitting in positions 51-52.
0086.00
0087.00 06) K3S_FX540B - Change APP record for AUTO_EMAILREPORTS to have
0088.00 Description 3 text to read:
0089.00 Flag2 type: 0=MMAIL 1=EZEML400
0090.00 2=ESEND 3=SNDSMTPEMM
0091.00
0092.00 07) K3S_LPAR - Picture of LPAR, K_LOCATNS and library name
0093.00 (both CL program and CMD comand)
0094.00
0095.00 (Raben Tires)
0096.00 08) K3S_OVG1 - New program to Gather OV checks to 1 location
0097.00
0098.00 09) K3S_RMVJOB - No longer runs K3S_9702. Ran into a problem at
0099.00 MDC where this job was cancelling customer's
0100.00 job that initiated it. More research will be
0101.00 required in the future to re-instate this
0102.00 capability.
0103.00
0104.00 10) K3S_XRPTCL - New version with soft code logic
0105.00
0106.00 11) K3S_0010 - Display new Release info R5.4 January 1st, 2017
0107.00 K3S_0010FM
0108.00
0109.00 12) K3S_0050 - Added option 9. Display LPAR information
0110.00 K3S_0050FM
0111.00
0112.00 (Mutual Distributing)
0113.00 13) K3S_1010 - New capability to use 3=Copy on any of the
0114.00 K3S_1010FM suggested orders, to create a new identical
0115.00 suggested order of type 'SO' Split Order
0116.00 which can then be adjusted and approved.
0117.00 (Cooper-Booth)
0118.00 - Passing empty parms to K3S_1015. These parms are
0119.00 needed when K3S_1020 calls K3S_1015.
0120.00
0121.00 (Mutual Distributing)
0122.00 14) K3S_1015 - New capability to display the customer's
0123.00 K3S_1015FM assigned PO# in the last area of the
0124.00 supplier's name.
0125.00 - The Hold Out Reason field expanded from 15 to 40
0126.00 characters.
0127.00 (Cooper-Booth)
0128.00 - Incoming parms added so that exit point K3S_1020X1
0129.00 can be programmed to drill down to a specific
0130.00 supplier when calling K3S_1015.
0131.00
0132.00 (Mutual Distributing)
0133.00 15) K3S_1020 - New capability to filter any suggested orders
0134.00 from being approved when they are too large,
0135.00 by weight or volume.
0136.00
0137.00 16) K3S_1021CL - Enhancements added for new soft code email process
0138.00
0139.00 (Mutual Distributing)
0140.00 17) K3S_1022 - New program called from K3S_1010 to copy a
0141.00 suggested order.
0142.00
0143.00 (Mutual Distributing)
0144.00 18) K3S_1035 - New capability that enables a user to let
0145.00 K3S_1035FM the K3S logic find the "Best Fit" when
0146.00 needing to split a mulitple container
0147.00 order by weight or volume.
0148.00
0149.00 (Mutual Distributing)
0150.00 19) K3S_1040 - The Transfer Pending field did not display
0151.00 K3S_1040FM a negative value. Only the screen was
0152.00 K3S_1041 adjusted with the proper edit code. No
0153.00 K3S_1041FM changes were made to the RPG programs.
0154.00
0155.00 (Mutual Distributing)
0156.00 20) K3S_1050 - The Hold Out Reason field was exanded from
0157.00 K3S_1050FM 15 to 40 characters on the PO approval screen.
0158.00 There were no logic changes in the RPG program.
0159.00
0160.00 (Mutual Distributing)
0161.00 21) K3S_1051 - The Hold Out Reason field was exanded from
0162.00 K3S_1051FM 15 to 40 characters on the PO un-approve screen.
0163.00 There were no logic changes in the RPG program.
0164.00 Today this program is not being used in production,
0165.00 but it made sense to keep it up to date with the
0166.00 Hold Out Reason expansion.
0167.00
0168.00 22) K3S_1090CL - Enhancements added for new soft code email process
0169.00
0170.00 (Core-Mark)
0171.00 23) K3S_1100 - Adjustment made to NOT include Permanent Deal info
0172.00 when user had retrieved Bracket Level Costs
0173.00 (Mutual Distributing)
0174.00 - The Hold Out Reason field was exanded from
0175.00 15 to 40 characters on the PO approval screen.
0176.00
0177.00 (Mutual Distributing)
0178.00 24) K3S_1101 - The Hold Out Reason field was exanded from
0179.00 15 to 40 characters for the un-approve process.
0180.00 Today this program is not being used in production,
0181.00 but it made sense to keep it up to date with the
0182.00 Hold Out Reason expansion.
0183.00
0184.00 (Core-Mark)
0185.00 25) K3S_1220 - A new capability to exclude both Time Phased and
0186.00 Permanent deals when Bracket Levels are being used.
0187.00
0188.00 (Core-Mark)
0189.00 26) K3S_1500 - Improvement to the Days Counter for orders that have
0190.00 sat Due and not ordered.
0191.00
0192.00 (Cooper-Booth)
0193.00 27) K3S_1510 - Fix the OP check indentity for products that use
0194.00 the Manual Min/Max in days or units.
0195.00
0196.00 28) K3S_1910 - For MSS split, and when there is only 1 product, enable
0197.00 multiple truck orders to be suggested.
0198.00
0199.00 29) K3S_2018 - Clear SP_USERN1 for 2 conditions: 1) Supplier has no
0200.00 active products, 2) Supplier has not been ordered
0201.00 in the past six months.
0202.00
0203.00 (Mutual Distributing)
0204.00 30) K3S_3000 - Display the current average on screen '4 of 5' to make
0205.00 K3S_3000FM it easier for buyers to manage the Buy Multiple.
0206.00 - The Transfer Pending field did not display
0207.00 a negative value. The screen was adjusted with the
0208.00 proper edit code.
0209.00 (Variety Wholesalers)
0210.00 - For the ReStore environment, provide a new capability
0211.00 that allows both a Manual Min/Max in Days, and also
0212.00 a Manual Min/Max in Units.
0213.00
0214.00 (Mutual Distributing)
0215.00 31) K3S_3030 - The Transfer Pending field did not display
0216.00 K3S_3030FM a negative value. Only the screen was
0217.00 K3S_3031 adjusted with the proper edit code. No
0218.00 K3S_3031FM changes were made to the RPG programs.
0219.00 This adjustment was in the Back out
0220.00 summary WINDOW.
0221.00
0222.00 (Mutual Distributing)
0223.00 32) K3S_3042 - This program was re-compiled for the
0224.00 Product Hold Out Reason field increase
0225.00 from 15 to 40 characters. There were no
0226.00 logic changes required.
0227.00
0228.00 (Mutual Distributing)
0229.00 33) K3S_3050 - The Product Hold Out Reason field was
0230.00 K3S_3050FM increased from 15 to 40 characters.
0231.00 - A new capability to enter a quantity
0232.00 and have it spread across all products
0233.00 selected based upon product averages.
0234.00
0235.00 (Mutual Distributing)
0236.00 34) K3S_3051 - The Product Hold Out Reason field was
0237.00 K3S_3051FM increased from 15 to 40 characters.
0238.00
0239.00 (Mutual Distributing)
0240.00 35) K3S_3052 - The Product Hold Out Reason field was
0241.00 increased from 15 to 40 characters.
0242.00 K3S_3052CL - A new capability to enter a quantity
0243.00 and have it spread across all products
0244.00 selected based upon product averages.
0245.00
0246.00 (Mutual Distributing)
0247.00 36) K3S_3053 - The Product Hold Out Reason field was
0248.00 increased from 15 to 40 characters.
0249.00
0250.00 (Mutual Distributing)
0251.00 37) K3S_3054 - The Product Hold Out Reason field was
0252.00 K3S_3054FM increased from 15 to 40 characters.
0253.00
0254.00 (Mutual Distributing)
0255.00 38) K3S_3056 - The Product Hold Out Reason field was
0256.00 increased from 15 to 40 characters.
0257.00
0258.00 (Mutual Distributing)
0259.00 39) K3S_3057 - The Product Hold Out Reason field was
0260.00 K3S_3057FM increased from 15 to 40 characters.
0261.00
0262.00 (Mutual Distributing)
0263.00 40) K3S_3058 - The Product Hold Out Reason field was
0264.00 increased from 15 to 40 characters.
0265.00
0266.00 (Mutual Distributing)
0267.00 41) K3S_3059 - This is a new program that is used in the
0268.00 K3S_3059CL process to allocate a total quantity
0269.00 across products based upon their averages.
0270.00
0271.00 42) K3S_3085CL - Enhancements added for new soft code email process
0272.00
0273.00 (Raben Tires)
0274.00 43) K3S_3100 - Three new batch types were added in this release.
0275.00 K3S_3110 OVG - Gather OV checks to 1 location
0276.00 DOA - Demand occurences - All products
0277.00 DOD - Demand occurences - Discontinued
0278.00
0279.00 44) K3S_3220CL - Enhancements added for new soft code email process
0280.00
0281.00 45) K3S_3351 - Fix issue with target service level reporting
0282.00
0283.00 (Raben Tires)
0284.00 46) K3S_3600 - New capability for customers to specify that all
0285.00 inventory should be categorized as overstock
0286.00 when the product is coded 'D' Discontinued.
0287.00
0288.00 (Cooper-Booth)
0289.00 47) K3S_3715 - Added buyer to report, and .CSV and .PDF files
0290.00 K3S_P3715
0291.00 K3S_3718
0292.00 K3S_P3718
0293.00 K3S_3711CL - Needed to adjust PARM from 'OBSOLETE' to 'OBSOLET2'
0294.00
0295.00 (Mutual Distributing)
0296.00 48) K3S_4501 - The Product Hold Out Reason field was
0297.00 increased from 15 to 40 characters.
0298.00
0299.00 (Mutual Distributing)
0300.00 49) K3S_6035 - The Product Hold Out Reason field was
0301.00 increased from 15 to 40 characters.
0302.00
0303.00 50) K3S_7101CL - Comment out call to K3S_7120. Unnecessary code.
0304.00
0305.00 (Core-Mark)
0306.00 51) K3S_7130 - The totals page is now specific to the
0307.00 K3S_P7130 selection criteria.
0308.00
0309.00 (Mutual Distributing)
0310.00 52) K3S_9010 - The capability that enables a customer
0311.00 to send Transfer quantities from their
0312.00 ERP system.
0313.00
0314.00 (Mutual Distributing)
0315.00 53) K3S_9505 - The Product Hold Out Reason field was
0316.00 increased from 15 to 40 characters.
0317.00
0318.00 54) K3S_9991 - Improvements made to the authorization
0319.00 process.
0320.00
0321.00 -----------------------------------------------------------------------
0322.00 Physical & logical files added/changed/deleted in release for K3S_5DTA
0323.00 -----------------------------------------------------------------------
0324.00
0325.00 There was 1 Physical file & 2 Logical files added in this release.
0326.00
0327.00 K_K3SRPT PF Generic file 2 determine Email Software being used
0328.00 K_K3SRPTA LF Generic file - by Report ID
0329.00 K_K3SRPTB LF Generic file - by Report ID, Menu Option
0330.00
0331.00 There were 4 Physical files & 8 Logical files changed in this release.
0332.00 *2 files needed to save off data and restore it
0333.00 K_INTHOLD PF Interface for Product Hold Outs
0334.00 K_INTHOLDA LF Interface for Product Hold Outs - LOCN,SUPL,SUB,PROD
0335.00 K_OBSOLET PF Obsolete products Independent locations (added PR_BUYR)
0336.00 K_OBSOLETX PF Obsolete products Independent locations (added PR_BUYR)
0337.00 K_PHLDLOG PF*Product hold out - Log of Change
0338.00 K_PHLDLOGA LF Product hold out change log by LOCN,SUPL,PROD,TIME
0339.00 K_PRODHLD PF*Product Hold Out Quantities
0340.00 K_PRODHLDA LF Product Hold Out Qty LOCN,SUPL,PROD,BEGIN
0341.00 K_PRODHLDB LF Product Hold Out Qty LOCN,SUPL,PROD,TIMESTP
0342.00 K_PRODHLDC LF Product Hold Out Qty LOCN,SUPL,PO#
0343.00 K_PRODHLDD LF Product Hold Out Qty LOCN,SUPL,PROD,END
0344.00 K_PRODHLDE LF Product Hold Out Qty LOCN,HLDREAD,BEGIN,END,PROD
0345.00 K_PRODHLDF LF Product Hold Out Qty LOCN,PO#,PROD
0346.00 K_PRODHLDG LF Product Hold Out Qty LOCN,PO#,HLDREAS,BEG,END,PROD
0347.00
0348.00 Most of the files above were effected from the expansion of
0349.00 the field Hold Out Reason from 15 to 40 characters.
0350.00
0351.00 After this release installed, there should be exactly 495 objects
0352.00 in library K3S_5DTA (data files library) (Rel 5.3 had 492 objects)
0353.00
0354.00 -----------------------------------------------------------------------
0355.00 Programs and Files in library K3S_MOD540
0356.00 -----------------------------------------------------------------------
0357.00
0358.00 -- RPGLE
0359.00 K3S_CVRT22 New Table Code entries
0360.00 K3S_DMOC Demand occurences XX of last YY periods
0361.00 K3S_EMLRPT Email reports - using K_K3SRPT file (soft code email)
0362.00 K3S_OVG1 Gather OV checks to 1 location
0363.00 K3S_1050 Suggested order supplier approval
0364.00 K3S_1051 Suggested order supplier un-approve
0365.00 K3S_1100 Suggested order supplier approval PO Headr/det
0366.00 K3S_1101 Suggested order supplier un-apprv PO Headr/det
0367.00 K3S_2018 Clear SP_USERN1 for 2 conditions
0368.00
0369.00 -- CLLE
0370.00 K3S_XRPTCL Exit - After Report print (soft code email)
0371.00 K3S_1021CL Supplier suggested order list (soft code email)
0372.00 K3S_1090CL Alternate source - Proforma (soft code email)
0373.00 K3S_3085CL Selected products review print (soft code email)
0374.00 K3S_3220CL Customer usage Trans - rpt & upd (soft code email)
0375.00
0376.00 -- CMD
0377.00 none
0378.00
0379.00 -- DSPF
0380.00 K3S_1050FM Suggested Order Supplier Approval
0381.00 K3S_1051FM Suggested Order Supplier un-approve
0382.00
0383.00 -----------------------------------------------------------------------
0384.00 Special instructions for all customers
0385.00 -----------------------------------------------------------------------
0386.00
0387.00
0388.00 -----------------------------------------------------------------------
0389.00 Special instructions for some customers
0390.00 -----------------------------------------------------------------------
0391.00
0392.00 Duncan Supply
0393.00 Add back DPG - BUYERS K3S_4031 - Product Group Service Level Targets
0394.00
0395.00 Cooper-Booth
0396.00 CBW's exit program K3S_102CB currently exits to K3S_1015.
0397.00 Exit program will need updating with increased parm list
0398.00 for K3S_1015.
0399.00
0400.00 -----------------------------------------------------------------------
0401.00 Special instructions for customers that buy from diverters
0402.00 -----------------------------------------------------------------------
0403.00
0404.00 SP_CASHDSC might contain 2.0% on some Suppliers. Determine if this is
0405.00 residue from back before R5.1 was installed. K3S_2008 used to prime
0406.00 that field with 2.0% which is being added to the minimum threshold
0407.00 to test the margin. Found at Allison Wholesale.
0408.00
0409.00
0410.00 -----------------------------------------------------------------------
