Release 6.1 Technical
01) K3S_CVRT22 - Changes to table code records/New table code records:
API - new group for Setup values and info for the APIs and
Night Job
several records added
APR - New group for PO approval codes
several records added
BBK - New group for Special access granted for BlackBean Users
CPN - new group for Customer Projections - Note Type values
several records added
CPO - new group for Customer Projections - Record Type values
several records added
CPR - new group for Import Spreadsheet Error Types
several records added
DEV - new group for Developer values
several records added
DMD - new group Demand Display and Capture
FIN - new group Product groupings for Financial Log
GPH - new group Graphing Parameters
MAN - New group for Manager Dashboard Values
several records added
ORD - new group for Order Check Parameters
several records added
POR - new group PO Received Types
several records added
SEA - new group for Security For Calling APIs
several records added
SEC - new group for Security For Viewing Pages
several records added
SEM - new group for Security For Viewing Menu Options
several records added
SEM - new group for Security Roles And Levels
several records added
SUM - new group for Locations of type *SUM
02) AR_GENMSG - New TXTSRC member used to email when an error has
occurred in the backend.
03) DEPLOYMENT - Called by new scheduled job K3S_5DPLOY to update
the PHP by pulling an update from ftp.k3s.com
04) K3S_APIGET - Used in the process to pull API updates from
K3S_APIIN ftp.k3s.com and apply to K3S_5OBJ library.
K3S_APIOUT Object/source go to QGPL.
K3S_APIUPD
K3S_APIXCL
05) K3S_FX610A - Fix program to patch protect flag on SEA, SEC, SEM
records in K_TABLCOD.
06) K3S_FX610B - Add entry to file K_K3SRPT for K3S reporting.
07) K3S_FX610C - Adjust flags to hide tableode values.
08) K3S_FX610D - Clean K_TABLCOD records when
character found next to < symbol
09) K3S_GETLT - Most customers required several additional statements of code
to go out and check if K_INTORDB file has IB_SKIP_LT = 1.
K3 and Brantley jointly working to get this impleted for all
customers.
10) K3S_NIGHT - Edit to call new K3S Dashboard, call program to end
locks from Zend server, and submit K3S_NITECL
to the new WEB_BATCH subsystem.
11) K3S_POCHCK - Used by R6 to validate entries on PO approval screen
before the PO is allowed to be aprpoved.
12) K3S_POPARM - Grab default values for PO approval screen from R6.
13) K3S_R6HOT - Used in the process to pull a hot fix update
K3S_R6HOTI from ftp.k3s.com to be manually applied.
K3S_R6HOTO Object/source go to QGPL.
14) K3S_X055CL - Edit to call new API to collect R6 metrics.
15) K3S_X310CL - Edit to call new set of APIs to collect R6 metrics.
16) K3S_XP1011 - New 'Your space' exit point used in R6 only.
This is a clone of green screen your space
K3S_XP1010 but has an additional parm for User ID.
17) K3S_XP1015 - New 'Your space' exit point used in R6 only.
This program will return a 20 character parm for
display within the R6 Purchase Orders screen.
18) K3S_ZNDGET - Used for the R6 install process to download Zend
K3S_ZNDIN from the cloud. Temporary use. These can be deleted
K3S_ZNDOUT after install. Object/source go to QGPL.
19) K3S_1100 - PO approval process must undersand new incoming
parameters and pass new paramenters to K3S_1101CL.
20) K3S_1101CL - PO approval process must undersand new incoming
parameters.
21) K3S_XP8001 - New 'Your space' exit point used in R6 only.
This is a clone of green screen your space
K3S_XP8000 but has an additional parm for User ID.
22) K3S_XP1031 - New 'Your space' exit point used in R6 only.
This is a clone of green screen your space
K3S_XP1030 but has an additional parm for User ID.
23) K3S_1050X1 - New exit point program that will get called after
an order goes to type PB pending batch.
This is for R6 only. It will only be executed if:
TA_FLAG1 = 1 in both of these K_TABLCOD records
1)TA_CODETYP = UEX, TA_CODEVAL = 'AR_APRORDR'
(Also set TA_CODEDS2 = 'K3S_1050X1')
2)TA_CODETYP = APP, TA_CODEVAL = 'K3S_1050 BATCH_PO'
24) K3S_1500 - On 2017-08-05 I had added logic for R5.5 to make sure when an
order was calculated in Day Time by a user, it remained locked.
That set of code had flaws in it and was exposed. This fix
just comments out that logic.
25) K3S_2005 - The change in this program looks to clear SP_USERN1 for
SP_ACTPROD = 0. This happens just before SP_ACTPROD gets
cleared itself, and then rebuilt in night time K3S_1500.
This program went out with K3S_3360 as a pair, as we
worked to improve the 'Orders Past Due' button logic.
- Logic added to see if the supplier has not been ordered
for over a year, or ever ordered at all. We do not want
to prompt in 'Past Due Orders' if no longer used.
- Object date 09/21/18
28) K3S_3030 - New capability created in R5.5 and controlled by APP record
K3S_3031 'K3S_3030 NO_FACTR_0' to not let a product add a seasonal
product if even 1 period had a factor of 0.00 was actually
not letting any of our customers add new profiles! This
needed a quick fix and sent out to all customers.
This was reported by House-Hasson on January 9th, 2018.
30) K3S_3110 - New Batches developed that will let users create batches
Type Status
Product System Status: PSD D Discontinued
PSL L Lumpy
PSN N New
PSR R Regular
PSS S Slow
Product User Status: PUF F Frozen
PUM M Manual
PUP P Probation
- Object date 01/29/19
32) K3S_3360 - Logic improved to treat Fixed Cycle suppliers differently
than non-Fixed Cycle suppliers, when developing the
'Orders Past Due' accmumulater SP_USERN1.
This program went out with K3S_2005 as a pair, as we
worked to improve the 'Orders Past Due' button logic.
- Logic added to make sure the supplier has been ordered
in the past year, and if so, then add a day if the other
conditions are met.
- Logic for MSS and USD split orders now understands when
buyer has done two splits on an order, and the Split 2nd
Type is now either MSS or USD.
- Object date 01/18/19
35) K3S_7020CL - Used by R6 to get the defaults for the PO approval
screen.
36) K3S_9028CL - Modify to setup the 'Add new product daytime'
K3S_9028 from the customer's ERP system.
37) K3S_9022 - Call to K3S Dashboard to send ending timestamp
for the K3S night job.
- Object date 01/07/19 PUW W Watch
38) K3S_9100 - Fix needed for customers who use the diverter system.
Found at Modern Distributors. If only 1 record is good,
and a large set of recors get rejected for a supplier,
then field REJECT_PCT can't hold the result. Remove
the (h) Half Adjust is two places, and recompile.
39) K3S_9500CL - Monthly job to reorganize PF needs call to exit
point program in 5MOD library.
- Object date 03/02/18
40) K3S_9500X1 - New exit point program in 5MOD that monthly
reorganize job will call.
41) K3S_9505CL - Monthly job to delete records needs call to exit
point program in 5MOD library.
- Object date 03/02/18
42) K3S_9505X1 - New exit point program in 5MOD that monthly
delete records job will call.
43) K3S_9931 - New 'Your space' exit point used in R6 only.
This is a clone of green screen your space
K3S_9930 but has an additional parm for User ID.
44) K3S_9941 - New 'Your space' exit point used in R6 only.
This is a clone of green screen your space
K3S_9940 but has an additional parm for User ID.
46) QAPIERRSRC - New source physical file added to library K3S_5MOD
for K3S R6 text for error messagess.
47) QTXTSRC - New source physical file added to library K3S_5MOD
for emailing a message when reports are emailed.
-------------------------------------------------------------------
Objects added/changed/deleted in library K3S_5DTA
-------------------------------------------------------------------
Added in this release:
6 new Physical files
0 new Logical files
1 data area
New physical files:
K_ADJTLOG PF for R6 Buyer Adjustment Log AD
K_BUYRALG PF Night Job totals for select agenda tasks BU
K_FINALOG PF Financial Log Entries FI
K_INTORDF PF Log of User Actions for an Approved Order FU
K_INTORDL PF Log of User Actions for an Approved Order AL
K_INVRLOG PF Inventory Ratio Log Entries IQ
Changed in this release:
-K_PRODAPPX changed to MAXMBRS(*NOMAX)
New data area:
AR_DSERVER Instance for the TCP/IP server
After this release installed, there should be exactly 504 objects
in library K3S_5DTA (data files library) (Rel 5.5 had 497 objects)
-----------------------------------------------------------------------
Other system objects added in this release.
New User, Libraries, Subsystem, Job queue, and scheduled jobs
-----------------------------------------------------------------------
User:
K3SWEB - This is a new IBM iseries user ID that must be setup.
It will be used for the PHP to connect to the K3S
database. We recommend *ALLOBJ authority if possible.
This user must also have authority to QPMLPMGT; use:
GRTOBJAUT OBJ(QSYS/QPMLPMGT) OBJTYPE(*SRVPGM)
USER(K3SWEB) AUT(*USE)
Libraries:
K3S_5HOTFX - This is a new K3S library to hold hot fix objects.
It does not need to be backed up but it must exist
on the server.
K3S_5WEB - This is a new K3S BASE library that must be backed up.
K3S_5OBJBK - this is a new library that is used when the APIs are
updated. It does not have to be backed up but it must
exist on the server.
Subsytem & Job queue
WEB_BATCH - This is a new subsystem and job queue that will be
used for K3S scheduled jobs and K3S reports.
Scheduled jobs
K3S_5DPLOY This is a new scheduled job that will remain on hold.
It will be submitted immediately whenever a K3S update
to the PHP is to be performed.
K3S_5RFRSH This is a new scheduled job that will remain on hold.
It will be submitted immediately whenever a K3S update
to library K3S_5OBJ is to be performed.
K3S_5START- This is a new scheduled job that is optional.
It will run daily to ensure subsystem WEB_BATCH is
released and it will start Zend Server.
A customer can choose to add these commands to
their QSTRUP program so that this job is not needed.
-----------------------------------------------------------------------
Programs and Files in library QGPL/QCLSRC
-----------------------------------------------------------------------
AC_FTPUPD K3S Run FTP update to grab PHP
AC_PHPUPD K3S Dynamic FTP for PHP update
K3S_APIGET K3S API: Get API programs from FTP site
K3S_APIIN K3S API: Input
K3S_APIOUT K3S API: Output
K3S_APIUPD K3S API: run both K3S_APIGET and K3S_APIXCL
K3S_APIXCL K3S API: refresh APIs
K3S_R6HOT K3S R6 Hotfix: Pull R6OBJECTS SAVF & restore
K3S_R6HOTI K3S R6 HotFix: Input
K3S_R6HOTO K3S R6 HotFix: Output
K3S_ZNDGET K3S R6: temp use get ZENDPHP7 SAVF frm cloud
K3S_ZNDIN K3S R6: temp use input
K3S_ZNDOUT K3S R6: temp use output
-----------------------------------------------------------------------
Programs added/changed in library K3S_5OBJ
-----------------------------------------------------------------------
-- CLLE
K3S_9500CL Reorganize physical files - control
K3S_9505CL Delete records based upon # days retention
-- RPGLE
K3S_2005 Clear active products counter at night fix FC date
K3S_3110 Selected products review - build batches
K3S_3360 Purchase adjustments build K_PRODAPP
K3S_9022 Enable R6 to use monitor process for K3S Dashboard
-----------------------------------------------------------------------
Programs and Files in library K3S_5MOD
-----------------------------------------------------------------------
-- QTXTSRC
new add
-- RPGLE
AR_GENMSG Generic Error Message for - Email to Developer
K3S_CVRT22 New Table Code entries
K3S_FX610A Patch TA_PROTECT on SEA SEC SEM K_TABLCOD
K3S_FX610B Add entry to K_K3SRPT for new report
K3S_FX610C Adjust TA_FLAG3=1 for CODETYP=SPR & CODEVAL=OC
K3S_FX610D Patch when character found next to < symbol
K3S_POCHCK Verify custom PO approval fields for R6
K3S_POPARM Grab default values for PO parameters R6
K3S_XP1011 Control YOUR SPACE on K3S_1010 R6 equiv w user
K3S_XP1015 Control YOUR SPACE on K3S_1015 equiv in R6:POs
K3S_XP1031 Control YOUR SPACE on K3S_1030 R6 equiv w user
K3S_XP8001 Control YOUR SPACE on K3S_8000 R6 equiv w user
K3S_1100 Suggested order supplier approval PO headr/det
K3S_9028 Build K_INTPRDD record daytime - R6
K3S_9931 R6 version of K3S_9930 your space with USER
K3S_9941 R6 version of K3S_9940 your space with USER
-- CLLE
DEPLOYMENT K3S Deploy PHP R6 December 10, 2018: 3 parms
K3S_NIGHT Starts night job by submitting K3S_NITECL *YES
K3S_START Start K3S subsystem and R6 engine
K3S_X055CL Exit***Before Clear to active products counter
K3S_X310CL Exit***Before Final program end
K3S_1050X1 Exit after order goes to PB pending batch
K3S_1101CL Approved/Un-apprv orders to customer's PO Syste
K3S_3065X1 Exit from K3S_3065CL - Before products process
K3S_4040X1 Exit from K3S_4040CL - Before tables processng
K3S_4041X1 Exit from K3S_4041CL - Before tables processng
K3S_7020CL Get default PO header screen values R6
K3S_9028CL Add products from customer data - for R6
K3S_9500X1 Exit from K3S_9500CL - Before reorganizing
K3S_9505X1 Exit from K3S_9505CL - Before deleting records
-- CMD
none
-----------------------------------------------------------------------
Special instructions for all customers
-----------------------------------------------------------------------
In this release we installed Zend Server to power the PHP front end.
Presto can be powered down and deleted.
The end of the night job will run inventory metrics if the customer
does not use PTD demand collection.
-----------------------------------------------------------------------
Special instructions for some customers
-----------------------------------------------------------------------
N/A
-----------------------------------------------------------------------
