How to Setup Selected Product Review Batch of Type Qxx

K3S has the capability for each customer to develop up to 99 customized Selected products review batches with type Q01 through Q99.

This is accomplished by setting up a new SPR Table Code and then developing an RPG program to pick out the products that fit the criteria for each batch.

The first step is to create the new batch type in SPR. Under Admin go to table codes. There you will find table code SPR. Once in SPR on the top click on ‘Add Table Code’.

You will need to enter information into the following fields:

  1. Enter the sequential batch number, using the format of Q01-Q99, in the Table code value field.
  2. Type the description of the batch in the Description 1 field.
  3. Choose the default program type that users will go to when they are looking at products in the batch in the Description 2 field.

             Example:           A = K3S_8000 - All locations for a product  
                                D = K3S_1040 - Orders - Product Detail screen 
                                H = K3S_3030 - Product History screen  
                                P  = K3S_3000 - Product Maintenance 
                                W = K3S_3431 - Weekly Distribution  
  4. Set Flag 1 to 1=ON.

For each new Qxx batch type you will need to generate a corresponding RPG program with the name K3S_3Qxx. You will find the program K3S_3Q01 in library K3S_5MOD for the type Q01 - Out of stock and none on order. This program will serve as a template for you to create other Qxx batch types.