0001.00 ------------------------------------------------------------------------
0002.00 Notes for Release 5.07 Jan 01, 2012 rel_5.07.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 AUTO_EMAILREPORTS
0011.00 Automatically email reports to users?
0012.00
0013.00 F1=HELP ENABLE
0014.00 Enable F1=Help?
0015.00
0016.00 K3S_0010 BYRPERFORM
0017.00 Display period performance statistics?
0018.00
0019.00 K3S_3016 COPY_ALL
0020.00 Generate records for all locations?
0021.00 - Flag 2 has devault value 0=No, 1=Yes
0022.00
0023.00 K3S_3030 NEW_PROB
0024.00 Change New products to Probation status?
0025.00 - Use Number 1 for # of days on probation
0026.00
0027.00 K3S_3090 BY_PASS_D
0028.00 By-pass D discontinued products
0029.00
0030.00 K3S_5050 MMDD_ENTRY
0031.00 Enter Begin/End Deal dates with
0032.00 MMDD only. Logic determines year.
0033.00
0034.00 K3S_5050 REF_DUPS
0035.00 Ability to enter Deal Reference
0036.00 duplicates.
0037.00
0038.00 K3S_5050 OVERLAP_OK
0039.00 Ability to enter overlapping deals
0040.00
0041.00 K3S_8011 SAVE_COST
0042.00 Product cost in PO_FRMEXCS
0043.00
0044.00 K3S_9010 PE_SNPSHOT
0045.00 Period Ending snapshots
0046.00
0047.00 K3S_9010 PE1_FLTR_1
0048.00 Filter PE1 checks when
0049.00 Demand <= Manual Minimum Unit
0050.00
0051.00 CPS Combined Supplier Sequencing
0052.00 New View '5' By your criteria
0053.00
0054.00 PFC Product Forecast Change Types
0055.00 New type 'G' Period End snapshots
0056.00
0057.00 TLE Title of screens
0058.00
0059.00 K3S_0100FM1R - Buyer Period Performance
0060.00 K3S_0110FM1R - Company Period Performance
0061.00 K3S_0120FM1R - Location Period Performance
0062.00 K3S_0130FM1R - Supplier Period Performance
0063.00 K3S_0140FM1R - Product Period Performance
0064.00
0065.00 (Pete @ Core Mark)
0066.00 02) K3S_C131 - When Manual Min Days = 0, Manual Max Days > 0,
0067.00 ensure Manual Max Days appears in Product Detail
0068.00 screen if quantity check allows it.
0069.00 This /COPY member requires 3 program re-compiles:
0070.00 K3S_1500 - Build suggested orders
0071.00 K3S_1510 - Allocation on suggested orders
0072.00 K3S_3025 - Product SOQ simulator
0073.00
0074.00 03) K3S_EMLRPT - New program used to automatically email
0075.00 reports to customer.
0076.00
0077.00 04) K3S_FX507A - Ensure all customers have correct text for
0078.00 SPR and SPS table code types:
0079.00 SPR Selected records review types
0080.00 R4 was Selected products review types
0081.00 SPS Selected records batch status
0082.00 R4 was Selected products batch status
0083.00
0084.00 05) K3S_FX507B - Ensure all customers have correct text for
0085.00 K3S_3080 - Selected Records Review Batches
0086.00 K3S_3090 - Selected Records Review
0087.00 K3S_3100 - Selected Records Review Batches
0088.00
0089.00 06) K3S_HELP - Added APP record "F1=HELP ENABLE" to help
0090.00 control F1= use. With wiki.k3s.com site, the
0091.00 F1= has lost importance.
0092.00
0093.00 (Judi @ JT Davenport)
0094.00 07) K3S_INVALL - Run all inventory analysis programs
0095.00 K3S_INVBYR - Write period statistics by BUYR to K_INVBUYR
0096.00 K3S_INVCMP - Write period statistics by COMP to K_INVCOMP
0097.00 K3S_INVLCN - Write period statistics by LOCN to K_INVLOCN
0098.00 K3S_INVPRD - Write period statistics by PROD to K_INVPROD
0099.00 K3S_INVSPL - Write period statistics by SUPL to K_INVSUPL
0100.00 K3S_INXALL - Choose period for all invent analysis programs
0101.00 K3S_INXBYR - Choose period for stats by BUYR to K_INVBUYR
0102.00 K3S_INXLCN - Choose period for stats by LOCN to K_INVLOCN
0103.00 K3S_INXPRD - Choose period for stats by PROD to K_INVPROD
0104.00 K3S_INXSPL - Choose period for stats by SUPL to K_INVSUPL
0105.00
0106.00 08) K3S_M070 - (Jason @ House-Hasson)
0107.00 - Additional logic needed for Limited Buy deals.
0108.00 - (Larry @ House-Hasson)
0109.00 - Exclude Buying flag should only control extra
0110.00 days, not influence discount amounts.
0111.00
0112.00 09) K3S_SELREC - Use OPNQRYF to select K_DLYSVCE records
0113.00
0114.00 10) K3S_XRPTCL - Added call to K3S_EMLRPT to enable
0115.00 automatic emailing of reports.
0116.00 Also added the creation of CSV and PDF files
0117.00 for purchase adjustments report and period
0118.00 end performance report.
0119.00
0120.00 11) K3S_0010 - Added new APP record to control displaying
0121.00 K3S_0010FM buyer's period performance statistics.
0122.00
0123.00 (Judi @ JT Davenport)
0124.00 12) K3S_0100 - Period performance statistics by buyer
0125.00 K3S_0100FM - Period performance statistics by buyer
0126.00 K3S_0110 - Period performance statistics by company
0127.00 K3S_0110FM - Period performance statistics by company
0128.00 K3S_0120 - Period performance statistics by locations
0129.00 K3S_0120FM - Period performance statistics by locations
0130.00 K3S_0130 - Period performance statistics by suppliers
0131.00 K3S_0130FM - Period performance statistics by suppliers
0132.00 K3S_0140 - Period performance statistics by products
0133.00 K3S_0140FM - Period performance statistics by products
0134.00
0135.00 13) K3S_1010 - (Pete @ Core Mark)
0136.00 - Display 'SO' Split Orders during Due mode.
0137.00 - When user performs either the 7=Un-cancel,
0138.00 or the 9=Unlock, and then would PageDown to
0139.00 see next page, an error occured with 'attempt
0140.00 to write a duplicate record to file K3S_1010FM'
0141.00
0142.00 14) K3S_1015 - Adjust the F8= and F17= positions on the screen
0143.00 K3S_1015FM to be in a fixed location.
0144.00
0145.00 15) K3S_1020 - (confirmed with Larry, Pete and Brian)
0146.00 - When user chooses a specific Select Check
0147.00 from K3S_1020, and then goes out to K3S_1030,
0148.00 returning from K3S_1030 will now clear the
0149.00 Select Check. This will enable buyer to use
0150.00 F21=Start from K3S_1010, and easily move to next
0151.00 supplier without manually clearing Select Check.
0152.00
0153.00 16) K3S_1030 - (Pete @ Core Mark)
0154.00 When working with Combined Suppliers, and you
0155.00 perform an F20=Toggle to change the Option,
0156.00 doing a PageDown would revert back to the
0157.00 original default of Option 6 which is
0158.00 Location/combined supplier ID. The fix
0159.00 enables you to PageUp or PageDown, and
0160.00 remain in the same Option.
0161.00
0162.00 17) K3S_1040 - (House-Hasson Hardware)
0163.00 K3S_1040FM Have F8= key display text in bottom right
0164.00 K3S_1041 corner if being used.
0165.00 K3S_1041FM
0166.00
0167.00 18) K3S_1042 - (Wayne @ Liberty USA)
0168.00 Wrong key value used that did not handle
0169.00 products where supplier sub code used.
0170.00
0171.00 19) K3S_1043 - (discovered working at House-Hasson)
0172.00 When moving to K3S_3030, the wrong BUYR was
0173.00 being passed along.
0174.00
0175.00 20) K3S_1500 - (Wayne @ Liberty USA)
0176.00 New capability to have $0 cost products within a
0177.00 supplier line, that all use Man Min/Max, and then
0178.00 also set supplier to Fixed Cycle, to have the
0179.00 Fixed Cycle date automatically advance, without
0180.00 having to F5=Approve order, was advancing all
0181.00 Fixed Cycle supplier, not just those with
0182.00 $0 cost products. This fix sent out to all customers,
0183.00 not waiting until 2012.
0184.00 - (Jetta @ House-Hasson)
0185.00 - When overstock does exist within the company for
0186.00 a product, make sure that the OV check is not
0187.00 set on when overstock exists at the location
0188.00 being replenished.
0189.00 - (Jason @ House-Hasson)
0190.00 - Additional logic needed for Limited Buy deals.
0191.00 - (Pete @ Core Mark)
0192.00 - Adjustment to /COPY member K3S_C131 Manual Min/Max
0193.00
0194.00 21) K3S_1510 - (Jetta @ House-Hasson)
0195.00 When overstock does exist within the company for
0196.00 a product, make sure that the OV check is not
0197.00 set on when overstock exists at the location
0198.00 being replenished.
0199.00 - (Pete @ Core Mark)
0200.00 - Adjustment to /COPY member K3S_C131 Manual Min/Max
0201.00
0202.00 22) K3S_1910 - (Randy @ Core Mark)
0203.00 When using CMB (Combined Split) the totals for
0204.00 CAW (Unit 7) were incorrect for the new split
0205.00 orders.
0206.00
0207.00 23) K3S_2009 - (Allen @ House-Hasson)
0208.00 Find most recent Order Cycle Analysis change
0209.00 to supplier order cycle. The answer is passed
0210.00 back to calling program.
0211.00
0212.00 24) K3S_3002 - (Ray @ House-Hasson)
0213.00 When F13=Change supplier occurs during K3S_1050
0214.00 PO Approval, the new order written was in a locked
0215.00 state. The change was to write in out not locked.
0216.00
0217.00 25) K3S_3012CL - (Pete & Core Mark)
0218.00 Calls K3S_3012 to enable the copy of history and
0219.00 averages for a supplier's products from one location
0220.00 to another location.
0221.00
0222.00 26) K3S_3016 - (Michael @ Raben Tire)
0223.00 K3S_3016FM Enable a multi-location environment to generate
0224.00 product link records for all locations with single
0225.00 entry.
0226.00 - Set default values for both 'Copy to multiply' and
0227.00 'Copy to type'.
0228.00
0229.00 (Pete @ Core Mark)
0230.00 27) K3S_3025 Adjustment to /COPY member K3S_C131 Manual Min/Max
0231.00
0232.00 28) K3S_3030 - (House Hasson Hardware)
0233.00 K3S_3030FM New capability to automatically turn 'N' New
0234.00 K3S_3031 products to 'P' Probation status when the product
0235.00 K3S_3031FM is given an average. The default ending probation
0236.00 date is 180 days from today's date, and this is pulled
0237.00 from APP record K3S_3030 NEW_PROB.
0238.00 - (House Hasson Hardware)
0239.00 Have F8= key display text in bottom right
0240.00 corner if being used.
0241.00
0242.00 29) K3S_3063CL - (Scott @ Southco)
0243.00 New program to pre-process lead time transactions
0244.00 and summarize like records. Looks for PL_USEFLAG=6
0245.00
0246.00 30) K3S_3070 - (K4)
0247.00 Have F5=Summary totals window appear automatically
0248.00 the first time the user goes to the screen.
0249.00
0250.00 31) K3S_3080 - (Allen @ House-Hasson Hardware)
0251.00 Record lock occured when user selected option
0252.00 9=Unlock, while another user was actually in the
0253.00 batch. Once the Unlock WINDOW appeared, if the user
0254.00 working the batch attempted to process a product
0255.00 then record lock occured.
0256.00
0257.00 32) K3S_3090 - (Larry @ Les Schwab Tires)
0258.00 For the store level environment, they needed
0259.00 for products that become D discontinued during
0260.00 the month to automatically be by-passed for review.
0261.00 - Better error message used when invalid entry attempted,
0262.00 "Reviewed flag X invalid entry."
0263.00
0264.00 33) K3S_3150 - Fix spelling for the word 'Positioned' used during
0265.00 F5=Search process.
0266.00
0267.00 34) K3S_3361CL - New logic to get file K_PRODAPP to file K_PRODAPPX
0268.00 K3S_3361 for auto email processing.
0269.00 K3S_3362CL
0270.00 K3S_3362
0271.00 K3S_3363CL
0272.00 K3S_3363
0273.00 K3S_3364CL
0274.00 K3S_3364
0275.00
0276.00 35) K3S_3365 - comestic fix 'Type of report__________' removed
0277.00 K3S_3365FM underscore, since the field has DSPATR(UL).
0278.00 No RPG adjustments.
0279.00
0280.00 36) K3S_3439 - (AJ Silberman)
0281.00 Very large value in the Outs field for file
0282.00 K_DLYPROD caused halt in calculaton. Added
0283.00 test for conditions.
0284.00
0285.00 37) K3S_3452 - (Scott @ Parts Central)
0286.00 Product showing up twice, and we needed to test
0287.00 for PR_DELTCNT = 0 (their environment has
0288.00 no supplier switching, but all environments would
0289.00 need test.
0290.00
0291.00 38) K3S_3710 - comestic fix 'Type of report__________' removed
0292.00 K3S_3710FM underscore, since the field has DSPATR(UL).
0293.00 No RPG adjustments.
0294.00
0295.00 39) K3S_3715 - (Faye @ Garland C. Norris)
0296.00 K3S_3718 The .csv file was not providing the Product ID,
0297.00 Product Description, and complete Supplier Name.
0298.00 Files K_OBSOLET and K_OBSOLETX changed to include above.
0299.00
0300.00 40) K3S_3900 - (Southco)
0301.00 New capability for the user to define the sequence
0302.00 to be used by combined suppliers on K3S_1030.
0303.00 This is controlled by a new CPS tablcode value that
0304.00 defines View 5 - By your criteria.
0305.00 This program moves to K3S_5MOD from K3S_5OBJ, enabling
0306.00 total flexibility for customer to have modified.
0307.00
0308.00 41) K3S_3940 - Program did not pick up Seasonal Factor properly.
0309.00 Moved logic to call K3S_M051 to right spot in program.
0310.00
0311.00 42) K3S_3941 - Populate K_DLYSVCE from K_DLYPROD - one time use.
0312.00 This program will be used to help a company get started
0313.00 with capturing daily information into K_DLYSVCE.
0314.00
0315.00 43) K3S_3950 - Program that will write out the past 2 years of monthly
0316.00 history, and project for the upcoming 12 months, and
0317.00 create a file that can be exported to send to a supplier.
0318.00
0319.00 44) K3S_4010 - Page down with no records caused program to abend.
0320.00
0321.00 45) K3S_5020 - (Core Mark)
0322.00 K3S_5020FM - After using 4=Delete in K3S_5051 to remove a product,
0323.00 program K3S_5020 would crash.
0324.00 - (House-Hasson Hardware)
0325.00 - Added Deal Reference and re-alligned fields for
0326.00 readability.
0327.00
0328.00 46) K3S_5050 - (House-Hasson Hardware)
0329.00 K3S_5050FM - With proper APP record set, enables customer to enter
0330.00 over-lapping deals.
0331.00 - With proper APP record set, enables customer to enter
0332.00 Begin/End deal dates as MMDD (month day) format.
0333.00 Logic figures the YY automatically. Text will appear
0334.00 on screen that identifies this feature is turned on.
0335.00 - With proper APP record set, enables customer to enter
0336.00 Deal Reference IDs that are duplicates.
0337.00
0338.00 47) K3S_5055 - (House-Hasson Hardware)
0339.00 - With proper APP record set, enables customer to copy
0340.00 a deal and over-lapping another deal's dates.
0341.00
0342.00 48) K3S_5125 - (King @ House-Hasson Hardware)
0343.00 K3S_5126 New deal programs that enable customer to have
0344.00 K3S_5130 K3S pick best price from over-lapping deals.
0345.00 K3S_5140
0346.00 K3S_5150
0347.00 K3S_5160
0348.00 K3S_5170
0349.00
0350.00 49) K3S_5401 - (King @ House-Hasson Hardware)
0351.00 No reason to increment DA_LINESEQ because it is
0352.00 not a line #.
0353.00
0354.00 50) K3S_6010 - (K4) The screen no longer toggles when
0355.00 pressing the ENTER key.
0356.00
0357.00 51) K3S_7101CL - New logic to get Period End Performance file
0358.00 K_PERDPER into QTEMP for auto email capability.
0359.00
0360.00 52) K3S_7130 - New logic to populate Period End Performance
0361.00 work file k_PERDPERX.
0362.00
0363.00 53) K3S_8000 - When user selects 2=Transfer, send LDA buyer to
0364.00 program K3S_8011 since Transfer Transactions are
0365.00 owned by default buyer ID.
0366.00
0367.00 54) K3S_8010 - Use buyer from LDA
0368.00 - Pass PO_STATUS to K3S_8011 so that correct status
0369.00 is displayed.
0370.00
0371.00 55) K3S_8011 - (King @ House-Hasson Hardware)
0372.00 K3S_8011FM New capability to enter product cost for this
0373.00 transfer. Controlled by APP 'K3S_8011 SAVE_COST'
0374.00
0375.00 56) K3S_9010 - (Larry @ Les Schwab Tires)
0376.00 New capability to filter PE1 checks when
0377.00 Demand <= Manual Minimum Unit
0378.00 (Pete @ Core Mark)
0379.00 New capability to capture Period Ending
0380.00 snapshots of the average and deviation
0381.00
0382.00 -----------------------------------------------------------------------
0383.00 Physical and logical files added or changed during this release
0384.00 -----------------------------------------------------------------------
0385.00
0386.00 There were 2 Physical files changed during this release.
0387.00
0388.00 K_OBSOLET - Used with .csv file for Obsolete Report
0389.00 K_OBSOLETX - Used with .csv file for Obsolete Report
0390.00
0391.00 There were 23 Physical and Logical files added during this release.
0392.00
0393.00 K_DEALUSD - Deals used in approved orders
0394.00 K_DEALUSDA - Deals used in approved orders by DEAL,BIRTH
0395.00 K_INVBUYR - Average inventory statistics for buyers
0396.00 K_INVBUYRA - Average inventory by LOCN,FCINT,YR,PRD,BUYR
0397.00 K_INVBUYRB - Average inventory by LOCN,BUYR,FCINT,YR,PRD
0398.00 K_INVBUYRC - Average inventory by LOCN,FCINT,BUYR,YR,PRD
0399.00 K_INVBUYRD - Average inventory by BUYR,LOCN,FCINT,YR,PRD
0400.00 K_INVBUYRE - Average inventory by FCINT,BUYR,LOCN,YR,PRD
0401.00 K_INVCOMP - Average inventory statistics for the company
0402.00 K_INVCOMPA - Average inventory by FCINT,YR,PRD
0403.00 K_INVCOMPB - Average inventory by YR,FCINT,PRD
0404.00 K_INVLOCN - Average inventory statistics for locations
0405.00 K_INVLOCNA - Average inventory by LOCN,FCINT,YR,PRD
0406.00 K_INVLOCNB - Average inventory by LOCN,YR,FCINT,PRD
0407.00 K_INVLOCNC - Average inventory by YR,FCINT,LOCN,PRD
0408.00 K_INVLOCND - Average inventory by FCINT,LOCN,YR,PRD
0409.00 K_INVPROD - Average inventory statistics for products
0410.00 K_INVPRODA - Average inventory by LOCN,FCINT,YR,PRD,BUYR,SUPL
0411.00 K_INVPRODB - Average inventory by FCINT,YR,PRD
0412.00 K_INVSUPL - Average inventory statistics for suppliers
0413.00 K_INVSUPLA - Average inventory by LOCN,FCINT,YR,PRD,BUYR,SUPL
0414.00 K_PERDPERX - Used with .csv file for Period End Perf Report
0415.00 K_PRODAPPX - Used with .csv file for Purchase Adustments Report
0416.00
0417.00 After this release installed, there should be exactly 448 objects
0418.00 in library K3S_5DTA(data files library) (Rel 5.06 had 425 objects)
0419.00
0420.00 -----------------------------------------------------------------------
0421.00 Special conditions for some customers
0422.00 -----------------------------------------------------------------------
0423.00
0424.00 -----------------------------------------------------------------------
0425.00 Programs in library K3S_MOD507
0426.00 -----------------------------------------------------------------------
0427.00
0428.00 -- RPGLE
0429.00 K3S_CVRT22 New Table Code entries
0430.00 K3S_EMLRPT New program to help auto email reports to customers
0431.00 K3S_INVALL Run all inventory analysis programs
0432.00 K3S_INVBYR Write period statistics by BUYR to K_INVBUYR
0433.00 K3S_INVCMP Write period statistics by COMP to K_INVCOMP
0434.00 K3S_INVLCN Write period statistics by LOCN to K_INVLOCN
0435.00 K3S_INVPRD Write period statistics by PROD to K_INVPROD
0436.00 K3S_INVSPL Write period statistics by SUPL to K_INVSUPL
0437.00 K3S_INXALL Choose period for all invent analysis programs
0438.00 K3S_INXBYR Choose period for stats by BUYR to K_INVBUYR
0439.00 K3S_INXLCN Choose period for stats by LOCN to K_INVLOCN
0440.00 K3S_INXPRD Choose period for stats by PROD to K_INVPROD
0441.00 K3S_INXSPL Choose period for stats by SUPL to K_INVSUPL
0442.00 K3S_3900 Add products to K3S combined suppliers (prev in 5OBJ)
0443.00 K3S_3950 Populate K_DEMDEXP for export
0444.00 K3S_5160 Log deals used in approved orders
0445.00 K3S_5170 Update K_DEALDET with deal used count
0446.00 K3S_5401 Deals create from external source
0447.00
0448.00 -- CLLE
0449.00 K3S_SELREC Use OPNQRYF to select K_DLYSVCE recs to process
0450.00 K3S_XRPTCL Exit - after report print
0451.00
0452.00 -- CMD
0453.00 none
0454.00
0455.00 -- DSPF
0456.00
0457.00 -- PF
0458.00
0459.00 -----------------------------------------------------------------------
0460.00 Programs in library K3S_5CNV
0461.00 -----------------------------------------------------------------------
0462.00
0463.00 -- RPGLE
0464.00
0465.00 -- CLLE
0466.00 none
0467.00
0468.00 -- CMD
0469.00 none
0470.00
0471.00 -- DSPF
0472.00 none
0473.00
0474.00 -----------------------------------------------------------------------
0475.00 Implementation steps for this release
0476.00 -----------------------------------------------------------------------
0477.00
