Release 4.26 Technical Notes
0001.00 -----------------------------------------------------------------------
0002.00 Notes for Release 4.26 June 23rd, 2000
0003.00 -----------------------------------------------------------------------
0004.00
0005.00 01) K3S_CVRT22 - Generates new table code record types:
0006.00
0007.00 APP Application Control - added 4 new APP types
0008.00 LEAD_TIME ADJUSTMENT - Add Number2 value
0009.00 to lead time
0010.00 dft is 1.00 day
0011.00 K3S_5030 BLOCK_SUPL - Block supplier
0012.00 templates?
0013.00 K3S_8540 NEW_SLOW - System status of
0014.00 'N' to 'S'?
0015.00 K3S_1810 DEAD_NET - Exit for Dead Net
0016.00 Cost?
0017.00
0018.00 MAX Maximum values - this is a new category
0019.00 K3S_3030 TEST$_DIFF - Max value in Number3
0020.00 field. dft 100,000
0021.00 K3S_3050 PU_HLDQTY - Max value in Number3
0022.00 field. dft 50,000
0023.00
0024.00 SPR Selected Products Review types - added 2 types
0025.00 LDV - Low deviation %
0026.00 Z00 - Profile has factor of 0.00
0027.00
0028.00 INV Investment methods - text has changed
0029.00 was -> 0 - Percent to days conversion
0030.00 now -> 0 - Subtract (Ord Cycle + Lead Tm)
0031.00 was -> 1 - Customer specific routine
0032.00 now -> 1 - Straight percent to days
0033.00
0034.00 02) K3S_C121 - Improved the Convenience Pack calculation to
0035.00 be greater than or equal to the Threshold %,
0036.00 instead of just greater than.
0037.00
0038.00 Programs that needed to be re-compiled:
0039.00 K3S_1500
0040.00 K3S_1510
0041.00 K3S_3025
0042.00
0043.00 03) K3S_FIXINV - Change the K_TABLCOD file for the 2 records of type
0044.00 INV for Investment methods to contain different
0045.00 text.
0046.00
0047.00 04) K3S_FIX01 - Fix the K_NOTEPAD file for 'P' Product notes
0048.00 where Combined Suppliers were not placing these
0049.00 notes at the Regular Supplier level.
0050.00
0051.00 05) K3S_X300CX - Source template for using AUTO_PO function. These
0052.00 statements would be brought into K3S_X300CL.
0053.00
0054.00 06) K3S_0010FM - New release banner for 4.26 March 6th, 2000
0055.00
0056.00 07) K3S_0050 - Activate 2 menu options for Backup and Restore
0057.00 of master files on Operations menu.
0058.00
0059.00 08) K3S_0050X4 - Backup Master files option from Operations menu
0060.00
0061.00 09) K3S_0050X5 - Restore Master files option from Operations menu
0062.00
0063.00 10) K3S_1010 - Don't allow approval of an 'PB' type order using
0064.00 K3S_1010FM option 6=Approve. 'PB' orders are to be picked up
0065.00 with batch program.
0066.00
0067.00 - F22= to create a new order, on a supplier that does
0068.00 not have active products, will still get a suggested
0069.00 order generated, so that you can copy products from
0070.00 other suppliers.
0071.00
0072.00 - F22= to create a new order brings up a WINDOW, and
0073.00 a second F22= will be used to create this new order,
0074.00 and not ENTER as before.
0075.00
0076.00 11) K3S_1020 - Don't allow approval of an 'PB' type order using
0077.00 K3S_1020FM F5=Approve. 'PB' orders are to be picked up
0078.00 with batch program.
0079.00
0080.00 - Passing wrong supplier and supplier sub code to
0081.00 K3S_2000 under certain conditions. Seen at
0082.00 Roses by Letha. Example was Buy-24, Supl-071134
0083.00 Display file needed 'hidden fields'
0084.00
0085.00 - For suppliers with no active products, don't allow
0086.00 F21=Calculate order.
0087.00
0088.00 12) K3S_1040 - Product notes use original supplier source.
0089.00 K3S_1041
0090.00
0091.00 13) K3S_1050 - New 'PB' logic errors. Current customers do NOT need
0092.00 to apply this fix.
0093.00
0094.00 - Changes made to call of K3S_7010CL to get PO Type
0095.00 from supplier file. The PARMs changed in this process
0096.00 so all customers will need their K3S_1050 adjusted.
0097.00 The 3 new PARMs are locn,supl,suplsub which appear
0098.00 in 2 different places.
0099.00
0100.00 14) K3S_1050AU - For auto replenishment, send 'AUTO_PO' as the work
0101.00 station.
0102.00
0103.00 15) K3S_1050LD - For auto replenishment, sets up the LDA for batch
0104.00 process.
0105.00
0106.00 16) K3S_1050PB - /COPY statements needed to be included in source
0107.00 code.
0108.00
0109.00 17) K3S_1053 - For auto replenishment, contains logic to find
0110.00 suppliers to be ordered on the right day.
0111.00
0112.00 18) K3S_1054 - For 'PB' processing, needed to pick up both
0113.00 regular source and combined orders.
0114.00
0115.00 19) K3S_1100 - For auto po processing, needed to pick up the
0116.00 buy group code in batch. Where workstation is
0117.00 labeled with 'AUTO_PO', then get the correct
0118.00 user from the table codes file.
0119.00
0120.00 - For Hub Transfer processing, was not using the
0121.00 correct supplier sub code to capture demand.
0122.00
0123.00 - For Hub Transfer processing, new capability to
0124.00 handle unlimited distribution levels. We are calling
0125.00 it H2H (Hub-to-Hub) processing.
0126.00
0127.00 20) K3S_1101 - Order reset capability will now understand H2H
0128.00 (Hub-2-Hub) logic.
0129.00
0130.00 21) K3S_1210 - When performing the 'Calculate entire order extra
0131.00 days' routine, program can now understand multiple
0132.00 types of INV investment methods.
0133.00
0134.00 22) K3S_1500 - K3S_C121 'Convenience Pack' logic enhanced by
0135.00 looking at >= and not just > for Threshold %.
0136.00
0137.00 - 'When to buy' logic enhanced by using the Order Cycle
0138.00 and not the Order Time Factor.
0139.00
0140.00 - 'Exclude buying until' logic enhanced by looking at
0141.00 customer back orders. Don't wait if backorders exist.
0142.00
0143.00 - Only take portion of Order Cycle when the last
0144.00 order date is within the Order Cycle, and
0145.00 a quantity balance exists.
0146.00
0147.00 - Program now handles both INV Investment methods
0148.00 for calculating extra days.
0149.00
0150.00 - The supplier sub code (usersys) was not being properly
0151.00 populated for 2 files, K_LOGPROD and K_PRODSOQ.
0152.00
0153.00 - Improved the Fixed Cycle section for testing if
0154.00 minimum criteria has been met, and if allocation
0155.00 needed, when it is the right day to buy, even if
0156.00 order delay is not 0 (due).
0157.00
0158.00 23) K3S_1510 - K3S_C121 'Convenience Pack' logic enhanced by
0159.00 looking at >= and not just > for Threshold %.
0160.00
0161.00 - 'Exclude buying until' logic enhanced by looking at
0162.00 customer back orders. Don't wait if backorders exist.
0163.00
0164.00 - For auto PO orders, correct problem where extra days
0165.00 was showing as negative value.
0166.00
0167.00 24) K3S_1800 - The F8= exit was not passing the correct PARMs.
0168.00
0169.00 25) K3S_2000 - When coming into this program from K3S_1020, don't
0170.00 K3S_2000FM allow the normal 'F2=Copy to all suppliers'
0171.00 capability. Letha at Roses found this one.
0172.00
0173.00 - When coming into this program from other programs,
0174.00 where F10= was used, and the customer does use
0175.00 supplier sub codes, then position properly to the
0176.00 correct supplier sub code.
0177.00
0178.00 - Removed API logic for determining Day of Week, and
0179.00 just using normal IBM POWER SERVER technique, in the Fixed
0180.00 Cycle date section of code.
0181.00
0182.00 26) K3S_2002 - When coming into this program from other programs,
0183.00 where F10= was used, and the customer does use
0184.00 supplier sub codes, then position properly to the
0185.00 correct supplier sub code.
0186.00
0187.00 - Removed API logic for determining Day of Week, and
0188.00 just using normal IBM POWER SERVER technique, in the Fixed
0189.00 Cycle date section of code.
0190.00
0191.00 27) K3S_2040 - Number the 3 different looks for the user, with
0192.00 K3S_2040FM '1 of 3', '2 of 3', and '3 of 3' captions at the
0193.00 top.
0194.00
0195.00 - For unit 6, instead of just 'Other.', show the
0196.00 actual text from the supplier record.
0197.00
0198.00 28) K3S_2041 - Order Cycle Calculations now understands using the
0199.00 Location file setting for 'Orders use less than
0200.00 supplier LT'.
0201.00
0202.00 29) K3S_3000 - Fix of Convenience Pack fields being cleared.
0203.00 K3S_3000FM
0204.00 - Display actual Unit 6 text from Supplier file,
0205.00 instead of just 'Other...'
0206.00
0207.00 30) K3S_3001 - Supplier sub field was not being used to build the
0208.00 subfile.
0209.00
0210.00 - For new suppliers with no products, when you
0211.00 perform the copy function, the new copy count
0212.00 was doubled up on that order.
0213.00
0214.00 31) K3S_3010 - Supplier sub code (user system) was not being
0215.00 properly populated.
0216.00
0217.00 32) K3S_3020 - Safety stock simulator now understands using the
0218.00 Location file setting for 'Orders use less than
0219.00 supplier LT'.
0220.00
0221.00 33) K3S_3025 - RANGE statements added for
0222.00 K3S_3025FM Average deviation 1.0 to 99.9
0223.00 Buy multiple 1 to 9999999
0224.00 Minimum quantity 1 to 9999999
0225.00
0226.00 - K3S_C121 'Convenience Pack' logic enhanced by
0227.00 looking at >= and not just > for Threshold %.
0228.00
0229.00 34) K3S_3030 - Fix for weekly products using F21=
0230.00 K3S_3030FM
0231.00 K3S_3031 - Product notes use original supplier source.
0232.00 K3S_3031FM
0233.00 - Warning WINDOW when user keys in an average, where
0234.00 the new net value difference is greater than $100,000.
0235.00
0236.00 - Indicator conflict resolved that controls the display
0237.00 of product delete count value.
0238.00
0239.00 35) K3S_3035 - Fix for Standard Deviation logic when the difference
0240.00 in the squared total is zero.
0241.00
0242.00 36) K3S_3040 - Display any average change increases greater than
0243.00 K3S_3040FM $100,000 in reverse image.
0244.00
0245.00 - Include a label for screen '1 of 3', '2 of 3', and
0246.00 '3 of 3' that coincides with F20=Toggle.
0247.00
0252.00 37) K3S_3042 - Added capability so that product notes will follow
0253.00 supplier during night job updates for supplier
0254.00 switching.
0255.00
0256.00 38) K3S_3050 - Added capability to warn user of a large quantity
0257.00 K3S_3050FM being entered.
0258.00
0259.00 - The supplier sub code (user system) was not being
0260.00 properly populated.
0261.00
0262.00 - During an add of new Hold Out Records, the edits
0263.00 were bypassed, and values of '0001-01-01' were
0264.00 going in as Begin and End dates, if user forgot
0265.00 to key them. Edits now enforced.
0266.00
0267.00 39) K3S_3060 - New capability using APP record
0268.00 'LEAD_TIME ADJUSTMENT' to add days to calculation
0269.00 of product lead time.
0270.00
0271.00 - Needed different logical file to pick up correct
0272.00 product record for environments like auto parts,
0273.00 where the same product can exist under multiple
0274.00 suppliers.
0275.00
0276.00 40) K3S_3062 - Pre-process lead time transactions, to consolidate
0277.00 K3S_3062CL multiple receivings same day, and to remove records
0278.00 with zero or negative quantity received.
0279.00
0280.00 41) K3S_3065 - New capability using APP record
0281.00 'LEAD_TIME ADJUSTMENT' to add days to calculation
0282.00 of product lead time.
0283.00
0284.00 42) K3S_3070 - Supplier sub code (user system) was not being used
0285.00 K3S_3070FM properly.
0286.00
0287.00 43) K3S_3100 - When LTM 'Lead time exceptions' type selected for
0288.00 K3S_3100FM building a batch, then default to 'D' Detail
0289.00
0290.00 - When OVR 'Overstocked products' type selected for
0291.00 building a batch, then default to 'A' All locations
0292.00 for a product.
0293.00
0294.00 - Now handles 2 new types of batches, which are
0295.00 LDV - Low deviation %, and Z00 - Profile with
0296.00 factor of 0.00
0297.00
0298.00 44) K3S_3110 - When LTM 'Lead time exceptions' type selected for
0299.00 building a batch, by-pass 'D' discontinued products
0300.00
0301.00 - Now handles 2 new types of batches, which are
0302.00 LDV - Low deviation %, and Z00 - Profile with
0303.00 factor of 0.00
0304.00
0305.00 45) K3S_3120 - Test for 'next batch #' hitting 99999, and then set
0306.00 back to 0, so incrementor will work properly.
0307.00
0308.00 46) K3S_3140 - Test for 'next seasonal #' hitting 99999, and then set
0309.00 back to 0, so incrementor will work properly.
0310.00
0311.00 47) K3S_3150 - Spelling corrected for 'No records'
0312.00
0313.00 48) K3S_3210 - New capability to generate Customer Usage entries
0314.00 K3S_3210FM using a percentage increase or decease to the
0315.00 product average.
0316.00
0317.00 49) K3S_3220 - Needed to spin through product records to find the
0318.00 regular source product.
0319.00
0320.00 50) K3S_3225 - Accumulate the net dollar adjustment from the
0321.00 K3S_P3225 selected batch, and print on report.
0322.00
0323.00 51) K3S_3250 - Generate customer usage entries via selection
0324.00 K3S_3250CL criteria.
0325.00
0326.00 52) K3S_3340 - Performance enhancement, to only chain out to
0327.00 location file or supplier file, when they change.
0328.00
0329.00 - Ranking calculations now understand using the
0330.00 Location file setting for 'Orders use less than
0331.00 supplier LT'.
0332.00
0333.00 53) K3S_3600 - Overstock calculations now understand using the
0334.00 Location file setting for 'Orders use less than
0335.00 supplier LT'.
0336.00
0337.00 - Edit placed into logic to handle extremely large
0338.00 overstock conditions. Typically bad data passed
0339.00 from user's system for onhand value.
0340.00
0341.00 54) K3S_3600CL - Was missed in Release 4.25 that we needed to
0342.00 pass 2 blank PARMs for the night job when calling
0343.00 K3S_3600 to calculate overstocked products.
0344.00
0345.00 55) K3S_3615 - Edit placed into logic to handle extremely large
0346.00 overstock conditions. Typically bad data passed
0347.00 from user's system for onhand value.
0348.00
0349.00 56) K3S_5030 - New capability to block supplier templates from
0350.00 K3S_5030FM being generated via an APP record.
0351.00
0352.00 - Don't allow 'S' template records without supplier
0353.00
0354.00 - Don't allow 'B' template records without buy group
0355.00
0356.00 57) K3S_5040 - Don't allow deals to be entered for Combined
0357.00 K3S_5040FM Suppliers. Only Regular suppliers allowed here.
0358.00
0359.00 - Use correct location when copying deals to a
0360.00 different location.
0361.00
0362.00 58) K3S_5050 - Remove 'Select all sub supplier components?' text
0363.00 K3S_5050FM and entry field, which is unused.
0364.00
0365.00 - New function for customers like Core Mark, who
0366.00 have central CPU, but use distributed buying, and
0367.00 each buyer wants to enter their own deals. (As
0368.00 opposed to Bindley who central buys). New APP
0369.00 record of 'K3S_5050 ONE_LOCN' controls process.
0370.00
0371.00 - New warning WINDOW for buyers who press F3= or
0372.00 F12= from the 'New Products Select Screen'. They
0373.00 have opportunity to remain, and not lose data
0374.00 entered.
0375.00
0376.00 59) K3S_5051 - Remove 'Select all sub supplier components?' text
0377.00 K3S_5051FM and entry field, which is unused.
0378.00
0379.00 60) K3S_5055 - Copy deal to another supplier fixed.
0380.00
0381.00 61) K3S_5056 - Keep header and detail records in sync.
0382.00
0383.00 62) K3S_5057 - Keep header and detail records in sync.
0384.00
0385.00 63) K3S_5100 - Test for 'next deal #' hitting 99999, and then set
0386.00 back to 0, so incrementor will work properly.
0387.00
0388.00 64) K3S_5200 - Test for 'next deal #' hitting 99999, and then set
0389.00 back to 0, so incrementor will work properly.
0390.00
0391.00 65) K3S_5400 - External source adding of multiple deals on the
0392.00 same product allowed in night job. Coastal Wholesale
0393.00 only customer using this now.
0394.00
0395.00 - Test for 'next deal #' hitting 99999, and then set
0396.00 back to 0, so incrementor will work properly.
0397.00
0398.00 66) K3S_7010 - Program fixed to pull the correct PO Type from
0399.00 Supplier file, to be used as default when order
0400.00 approved.
0401.00
0402.00 67) K3S_7010CL - Moved from K3S_OBJ to K3S_MOD, and source now
0403.00 provided, so that customers can control this
0404.00 default PO Type value if necessary.
0405.00
0406.00 68) K3S_8000 - Correct situations where option field was protected
0407.00 and blinking.
0408.00
0409.00 - Use product ID and not product sequence for getting
0410.00 the correct list of products to display.
0411.00
0412.00 69) K3S_8011 - Supplier sub code (user system) was not properly
0413.00 populated.
0414.00
0415.00 70) K3S_8020 - New capability to generate Overstock Transfer
0416.00 Requests via Customer Usage Batch information.
0417.00
0418.00 71) K3S_8500 - When Transfer Supplier are deleted, remove all
0419.00 references in the K_TRANSPL and K_TRANPRD file.
0420.00
0421.00 72) K3S_8510 - When no records exist in subfile, don't go into
0422.00 loop if user tries to perform F5= function.
0423.00
0424.00 73) K3S_8520 - When no records exist in subfile, don't go into
0425.00 loop if user tries to perform F5= function.
0426.00
0427.00 74) K3S_8540 - When new products are added to a Hub Transfer
0428.00 supplier, automatically change the 'N' new system
0429.00 status code into an 'S' slow system status code.
0430.00 Therefore the product will automatically start
0431.00 ordering product if a back order exists. This
0432.00 feature is controled with an APP record.
0433.00
0434.00 75) K3S_9000 - Clear supplier sub code from user system. This is
0435.00 just a reference for new installs.
0436.00
0437.00 76) K3S_9010 - Change made in Release 4.24 to control the
0438.00 automatic copy of deals for new products to other
0439.00 divisions using an APP record. Missed 2 places where
0440.00 that logic is conditioned.
0441.00
0442.00 - Do not log 'C' transactions any longer. These are
0443.00 very slow products where T/S becomes invalid. Just
0444.00 do the house cleaning.
0445.00
0446.00 - Prime new product records with Inventory Investment
0447.00 method from the company file.
0448.00
0449.00 77) K3S_9011 - Change made in Release 4.24 to control the
0450.00 automatic copy of deals for new products to other
0451.00 divisions using an APP record. Missed 2 places where
0452.00 that logic is conditioned.
0453.00
0454.00 - Populate the supplier sub code (user sys) properly.
0455.00
0456.00 - Populate the original supplier and sub code properly.
0457.00
0458.00 - Update the Supplier file for 'active product count'
0459.00 when products get added during the day time.
0460.00 That will enable an F22=Create an order, when
0461.00 previously no products had existed for that supplier.
0462.00
0463.00 - Prime new product records with Inventory Investment
0464.00 method from the company file.
0465.00
0466.00 78) K3S_9018 - Clear supplier sub code from user system. This is
0467.00 just a reference for new installs.
0468.00
0469.00 79) K3S_9070 - Improve the reference point for displaying the next
0470.00 available Schedule Date.
0471.00
0472.00 80) K3S_9160 - Supplier sub code (user system) was not properly
0473.00 populated.
0474.00
0475.00 81) K3S_9300 - When user presses F4= on the Investment Methods
0476.00 field, the WINDOW was showing an option of
0477.00 'Blank for all' which was invalid.
0478.00
