User Defined Checks
Each customer has the capability to utilize twenty-five user defined groups of products. Products must meet unique criteria to be included in a group, which is decided upon the needs of the customer.
How to Setup User Defined Checks U5 through U25
To setup a U5 – U25 check, do the following steps:
-
Create the SQL tables (K_PRODHLP and K_SUPLHLP) and associated Logical Files (K_PRODHLPA and K_SUPLHLPA) in the 5MOD library if they do not already exist; clone the source from the ZZZ repository
-
Copy the starting source code for programs K3S_HLPBLD.clle, K3S_HLPSUP.rpgle, K3S_HLPCL.clle, K3S_HLPR.rpgle, AE_CALORDR.clle, and ME_CALORDR.rpgle from the ZZZ repository
-
Edit CLLE program K3S_X310CL to add helper table process flag (TYPE(*CHAR) LEN(1)) and set value to ‘1’
-
Edit CLLE program K3S_X310CL to call K3S_HLPBLD after the data area is set to 1
-
Edit RPGLE program K3S_HLPR to identify the products that fit the criteria for each U Check
-
Set Flag 1 = 1 (TA_FLAG1) for the table code record where TA_CODETYP = PHL and TA_CODEVAL = HELPER, this will allow the U Checks to be calculated during the night job order builder and the daytime recalculate process
-
For each U Check in use, set Flag 1 = 1 (TA_FLAG1) for the table code record where TA_CODETYP = PHL and TA_CODEVAL = U5, U6, …, U25. Set Flag 2 (TA_FLAG2) = 1-6 depending on when you want the U Checks to be calculated (1-Night, 2-Post night, 3-Recalculate, 4-Night+Recalculate, 5-Post night+Recalcalculate, 6-All)
-
Enable the U check at the end of the recalculate process by setting Flag 1 = 1 (TA_FLAG1) where TA_CODETYP = YSE and TA_CODEVAL = AE_CALORDR
-
Optional Step: You can change the button label of the U Checks through tablecodes. Set Description 2 (TA_CODEDS2) to the button label and Flag 2 = 1 (TA_FLAG2) where TA_CODETYP = PHL and TA_CODEVAL = U5, U6, …, U25. Suggestion to not make the button label text more than 20 characters
-
Optional Step: Set button color to grey if there are no products for a given U Check by setting Flag 4 = 1 (TA_FLAG4) where TA_CODETYP = PHL and TA_CODEVAL = U5, U6, …, U25
-
Optional Step: Set button color to red, yellow, or green by setting Flag 5 = 1, 2, or 3 (TA_FLAG5) where TA_CODETYP = PHL and TA_CODEVAL = U5, U6, …, U25
Testing
Once the steps above are complete, you can test it by recalculating an order or an entire buy group. The U Checks should appear right away if products within the order match the criteria in RPGLE program K3S_HLPR.
It is highly recommended to test the changes before the next night job runs. If you are not ready for the night job to use your changes, simply undo step 5 above (turn Flag 1 = 0 (TA_FLAG1) where TA_CODETYP = PHL, TA_CODEVAL = HELPER
Where to View Each UCheck
You can view the U Checks on your main page in K3S and on each suggested order screen.
