IdealWare Online Users Manual

IY2-11 I/Y PROCESSING
30123 Stock Order Sheet

 

PURPOSE

 

The Stock Order Sheet program is used in multiple store environments, where each store has its own computer system, to order stock from the warehouse or another store to be delivered to the ordering store.

 

The following steps are typically performed when using the Stock Order Sheet program:

  1. Create a stock order sheet batch.

  2. If you did not "Load Suggested Quantities" into the batch:
    a. Print the stock order sheet report.

    b. Determine the inventory amounts to order and record the amounts on the stock order sheet report.

    c. Access the stock order sheet batch and enter the order amounts.

    • This could also be done using handheld PDT devices (see 30122 - STOCK COUNT SHEET).

  3. Access the batch and transmit the order to the warehouse.

    At the warehouse:

  4. A transfer sale order is automatically created in the Sale Order Entry system.

  5. Print packing slip, pick the order and modify the transfer sale order if required.

  6. The transfer sale order "Shipped Inventory" information is transmitted to the ordering store.

    At the store:

  7. A transfer purchase order is automatically created for the inventory that is to be received.

  8. Use the Purchase Order Receiving program to receive and verify the items, when the inventory arrives, and modify the purchase order if required.

  9. Use the Inventory Transfer-in Receipts program to process the purchase order.

Stock Order Sheet is accessed from:

  • Inventory Processing Menu

PROCEDURE - BATCH CREATION

 

Select Stock Order Sheet from the Inventory Processing menu. The batch selection screen displays.

 

INVENTORY STOCK ORDER HEADER DISPLAY

┌────────────────────────────────────────────────────────────────────────────────┐
│09/05/07 Tm6           ***** INVENTORY STOCK ORDER SHEET *****            3YHOI1│
│                                                                                â”‚
│                                                                                â”‚
│          COMPANY NUMBER      01  IDEAL BUILDING SUPPLIES LTD.                  â”‚
│                                                                                â”‚
│          STORE CODE                                                            â”‚
│          BATCH NUMBER                                                          â”‚
│          BATCH STATUS                                                          â”‚
│                                                                                â”‚
│          BATCH TYPE                                                            â”‚
│          REPORT SEQUENCE                                                       â”‚
│          REPORT DATE                                                           â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘

 

COMPANY NUMBER

 

Displays company code.

 

Defaults to company code entered at login.

 

 

STORE CODE

 

Enter store code to place warehouse order.

 

This is the ordering store.

 

 

BATCH NUMBER

 

Displays batch number.

 

Defaults to next available sequential number.

 

 

BATCH STATUS

 

Displays batch status.

 

For a new batch the value is NEW.

 

 

BATCH TYPE

 

Displays default batch type: O STOCK ORDER.


Example Batch Header display:

┌────────────────────────────────────────────────────────────────────────────────┐
│09/05/07 Tm6           ***** INVENTORY STOCK ORDER SHEET *****            3YHOI1│
│                                                                                â”‚
│                                                                                â”‚
│          COMPANY NUMBER      01  IDEAL BUILDING SUPPLIES LTD.                  â”‚
│                                                                                â”‚
│          STORE CODE          01  IDEAL BUILDING SUPPLY LTD                     â”‚
│          BATCH NUMBER        0034                                              â”‚
│          BATCH STATUS        NEW BATCH                                         â”‚
│                                                                                â”‚
│          BATCH TYPE          O   STOCK ORDER                                   â”‚
│          REPORT SEQUENCE     _                                                 â”‚
│          REPORT DATE                                                           â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│ENTER '1' FOR LOCATION, '2' FOR PRODUCT, '3' FOR GROUP.                         â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
REPORT SEQUENCE
ENTER '1' FOR LOCATION, '2' FOR PRODUCT, '3' FOR GROUP.

 

You can organize your order sheet by location, product, product group, although location is the typical selection.

 

"1" to list by location.

 

"2" to list by product.

 

"3" to list by product group.

 

REPORT DATE

 

Enter desired date in format MMDDYY.

 

[Enter] for current system date.

 

** PRESS F1 TO START, F3 TO CHANGE ABOVE:

 

[F1] to enter order sheet parameters.

 

[F3] to re-enter date or report sequence.

 

** PRINT STOCK ORDER SHEET? (Y/N):

 

"Y" to print order sheet.

 

Select this option if you require an order sheet for counting purposes. The printer selection menu displays. After printing you are returned to the next prompt.

 


PRINTER SELECTION & CONFIGURATION

┌────────────────────────────────────────────────────────────────────────────────┐
│08/14/07                *****  PRINTER SELECTION  *****                         │
│                                                                                â”‚
│                                                                                â”‚
│** MAKE SURE PRINTER IS READY BEFORE PRESSING CR .....                          â”‚
│                                                                                â”‚
│1. PRINTER NAME ................................. P1  OKIDATA 390               â”‚
│                                                                                â”‚
│2. CHARACTERS PER INCH ? (10,12,17) ............. 10                            â”‚
│   SINGLE OR DOUBLE DENSITY ? (S,D) ............. S   SINGLE DENSITY            â”‚
│                                                                                â”‚
│** PRESS CR TO SET PRINTER, OPTION# TO CHANGE, F4 TO END (BYPASS): _            â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** PRESS CR TO SET PRINTER, OPTION# TO CHANGE, F4 TO END (BYPASS):

 

"1" to change printers.

 

"2" to change the CPI and/or print density.

 

[Enter] to print.

 

[F4] to not print and exit to the menu.

 

[F5] to display a list of printers for selection.

 

"N" to not print the order.

 

Select this option if you do not require an audit trail and/or you set the Load Suggested Order Quantities value to "Y".

 

 

** ENTER STARTING (LOCATION/PRODUCT/GROUP) CODE (CR=FIRST):

 

Depending on the Report Sequence specified, the prompt will ask for either a starting location, product or product group code.

 

Enter code of starting location, product or product group.

 

[Enter] for first location, product or product group on file.

 

** ENTER ENDING (LOCATION/PRODUCT/GROUP) CODE (CR=LAST):

 

Enter code of ending location, product or product group.

 

[Enter] for last location, product or product group on file.

 

** PRINT ALL PRODUCTS? (Y/N):

 

[Enter] to accept default value "Y".

 

"Y" to include all products within range specified.

 

"N" to not include all products.

 

If you elect not to include all of the products on the stock count sheets you have the following options.

 


TRANSFER PRODUCT OPTIONS:
( 1)  NO TRANSFER PRODUCTS
No transfer control, TR type products.
( 2)  ALL TRANSFER PRODUCTS
All transfer control, TR type products.
( 3)  TRANSFER PRODUCTS SOURCED AT 'W1'
Only transfer control, TR type products, warehouse sourced.
( 4)  TRANSFER PRODUCTS NOT SOURCED AT 'W1'
Only transfer control, TR type products sourced from locations other than the warehouse.
** ENTER OPTION:

 

[Enter] to accept default option "1".

 

"1" to selection option 1.

 

If you select option 1 the following prompt displays.

 

 

** PRINT NON-TRANSFER PRODUCTS WITH SOURCE STORE 'W1'? (Y/N):

 

"Y" to include IS type products, warehouse sourced.

 

"N" to not include IS type products.

 

"2", "3" or "4" to select respective option.

 

** PRINT ALL DIRECT SOURCED PRODUCTS:

 

"Y" to include all direct sourced products.

 

"N" to not include all direct sourced products.

 

** PRINT PACKAGES (Y/N):

 

"Y" to include package type products.

 

"N" to not include package type products.

 

** PRINT SPECIAL ORDER PRODUCTS (Y/N):

 

"Y" to include special order products.

 

"N" to not include special order products.

 

** LOAD SUGGESTED ORDER QUANTITIES (Y/N):

 

[Enter] to accept default value "Y".

 

"Y" to include suggested order quantities.

 

The quantiies are based on the parameters set on screen 3 of product maintenance. If you select "Y" the warehouse order sheet will display the order quantities that have been set in product maintenance and you will not be able to change the quantities. This option is typically selected when you do not wish to print the warehouse order sheet(s).

 

 

"N" to not include suggested order quantities.

 

If you select "N" you will have to key in the order quantities manually. The default value is "Y". To change it to "N" press [F3] at the next field to return to this field.

 

 

** PRINT SEASONAL PRODUCTS CURRENT, ALL, ONLY, NO SEASONS; (C/A/O/N):

 

"C" to include current seasonal products.

 

"A" to include all seasonal products.

 

"O" to include only seasonal products.

 

"N" to include no seasonal products.

 

** CR TO CONTINUE:

 

[Enter] to create stock order sheet workfile.

 

If you opted to print the stock order sheet, also print the order sheet.

 

 

You are returned to the Inventory Processing menu. Typically, after printing the worksheet or creating the workfile you would select Warehouse Order Sheet from the menu again, access the batch you just created, and set the order quantities if you did not use the suggested order quantities and then transmit the order to the warehouse.

 

An example Stock Order Sheet printout follows.

 

 

PROCEDURE - ACCESS AN EXISTING BATCH

 

Select Stock Order Sheet from the Inventory Processing Menu. If there are existing batches, the program displays the header of the first batch on file.

 

Example Batch Header display:

┌────────────────────────────────────────────────────────────────────────────────┐
│09/05/07 Tm6          ***** INVENTORY STOCK ORDER SHEET *****            3YHOI1 â”‚
│                                                                                â”‚
│          COMPANY NUMBER      01  IDEAL BUILDING SUPPLIES LTD.                  â”‚
│                                                                                â”‚
│          STORE CODE          01  IDEAL BUILDING SUPPLY LTD                     â”‚
│          BATCH NUMBER        0033                                              â”‚
│          BATCH STATUS        OPEN                                              â”‚
│                                                                                â”‚
│          BATCH TYPE          O  STOCK ORDER                                    â”‚
│          REPORT SEQUENCE     1  LOCATION                                       â”‚
│          REPORT DATE         09/05/07                                          â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│** PRESS F1 TO START, F2 FOR NExT BATCH, CR FOR NEW BATCH: _                    â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** PRESS F1 TO START, F2 FOR NEXT BATCH, CR FOR NEW BATCH:

 

[Enter] to create a new batch.

 

See PROCEDURE - BATCH CREATION.

 

 

[F1] to process displayed batch.

 

See PROCEDURE - DATA ENTRY.

 

 

[F2] to display next batch on file, if any.

 

 

PROCEDURE - DATA ENTRY

 

When you press [F1] at the batch header, the data entry screen displays.

 

Example Stock Order Entry display:

┌────────────────────────────────────────────────────────────────────────────────┐
│STORE: 01                  ***** STOCK ORDER ENTRY *****           PERIOD: 09/07│
│--------------------------------------------------------------------------------│
│BATCH: 0040 WAREHOUSE ORDER QTY ORDERED:            RETAIL AMOUNT:         $.00 â”‚
│--------------------------------------------------------------------------------│
│SEQ#   GROUP        CODE       DESCRIPTION                       PRICE      QTY â”‚
│--------------------------------------------------------------------------------│
│00001  BM-DO-**-**  142110     HARDBOARD B/F 2'0 X 6'8          39.00           â”‚
│00002  BM-DO-**-**  142130     HARDBOARD B/F 3'0 X 6'8          47.80           â”‚
│00003  BM-DO-**-**  142160     2'4 X 6'8 X 1 3/8 HC HB DOOR     28.35           â”‚
│00004  BM-DO-**-**  142170     2'6 X 6'8 X 1 3/8 HC HB DOOR     29.50           â”‚
│00005  BM-DO-**-**  142175     BRASS DOOR KNOB                  19.99           â”‚
│_____                                                                           â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│--------------------------------------------------------------------------------│
│                                                                                â”‚
│--------------------------------------------------------------------------------│
│ENTER THE SEQUENCE# OF THE LINE YOU WISH TO MODIFY OR DELETE.                   â”‚
│F2=DISPLAY, F4=EXIT, F5=PRINT, F6=TRANSMIT ORDER, F7=ABORT, F12=LOCATION MAINT. â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
ENTER THE SEQUENCE# OF THE LINE YOU WISH TO MODIFY OR DELETE.
F2=DISPLAY,F4=EXIT,F5=PRINT,F6=TRANSMIT ORDER,F7=ABORT,F12=LOCATION MAINT.

 

Enter sequence line number of product to set quantity.

 

If you selected "Y" in the LOAD SUGGESTED ORDER QUANTITIES field this value will already be set to the value determined by product maintenance and you can not change it here.

 

 

ENTER QUANTITY TO ORDER. 'CR' FOR: 0

 

Enter quantity of product to order.

 

[Enter] for zero quantity.

 

** OK TO ACCEPT ? (CR TO ACCEPT; F3 TO BACKUP; F4 TO BYPASS):

 

[Enter] to accept quantity entered.

 

[F3] to re-enter quantity.

 

[F4] to cancel quantity entry.

 

Once a quantity has been set for a line if you enter the line number the following prompt displays.

 

 

** PRESS CR TO CONTINUE; 'D' TO DELETE

 

[Enter] to return to lines display.

 

You can then continue processing other lines.

 

 

"D" to reset quantity to zero.

 

You can then set the quantity again to another value.

 

 

[F2] to reset lines display.

 

When you first access the batch only the last page of detail lines is displayed. To reset the display to the beginning or any other line press [F2]. When you access existing lines to change and/or delete quantities the program adds the changed lines to the display, press [F2] to clear the duplicated lines.

 

 

** ENTER STARTING SEQUENCE # (CR FOR FIRST; F4 TO END):

 

Enter line number to begin display.

 

[Enter] to begin display at first line of batch.

 

[F4] to cancel and return to previous display.

 

[F4] to exit to menu.

 

[F5] to print order sheet(s).

 

If you did not print the order sheet(s) during batch creation you can do so here.

 

 

[F6] to transmit order to warehouse.

 

See PROCEDURE - STOCK POSTING BATCH CREATION.

 

 

[F7] to abort batch.

 

All data in the batch is discarded.

 

 

[F12] to access product location maintenance.

  



                                        IDEAL BUILDING SUPPLIES LTD.
09/05/07  16:41:40                                                                                           PAGE: 1
                                       STOCK ORDER SHEET FOR STORE 01
                                       BATCH: 0034  PERIOD: 09/05/07

-----------------------------------------------------------------------------------------------------------------------
      PRODUCT                                  ITEM                  QTY              OH    SUG.  MINIMUM     PACK BASE
LOC   CODE     DESCRIPTION                     CODE          SEQ#  ORDERED   I.Q.    HAND   ORD.   QTY       SIZE  UNIT
-----------------------------------------------------------------------------------------------------------------------

STK-01-***
 ***  157560   SENCO GE21 2" RING NAILS                     00532  _______     0 *    140    0          0       0  BOX

STK-07-***
 ***  157570   SENCO SN325 SPIKER                           00533  _______     0 *     21    0          0       0  EA

STK-01-***
 ***  157580   SENCO AX17 1-1/2" PINS                       00534  _______     0 *    465    0          0       0  BOX
 ***  157590   SENCO AX15 1-1/4" PINS                       00535  _______     0 *    482    0          0       0  BOX
 ***  157600   SENCO AX13 1" PINS 10M                       00536  _______     0 *    496    0          0       0  BOX
 ***  157610   SENCO AY13 1" PINS                           00537  _______     0 *    417    0          0       0  BOX
 ***  157680   SENCO GE24 2 3/8" RING NLS                   00538  _______     0 *      4    0          0       0  BOX
 ***  157690   SENCO N17 1-1/2" STAPLES                     00539  _______     0 *    234    0          0       0  BOX
 ***  157700   SENCO N21 2" STAPLES                         00540  _______     0 *    806    0          0       0  BOX

STK-07-***
 ***  157710   SENCO SKS STAPLER                            00541  _______     0 *      6    0          0       0  EA
 ***  157720   SENCO M-2 STAPLER                            00542  _______     0 *      6    3          0       0  EA

STK-01-***
 ***  157750   SENCO L17 1-1/2" STAPLES                     00543  _______     0 *    613    0          0       0  BOX
 ***  157760   SENCO L15 1-1/4" STAPLES                     00544  _______     0 *    385    0          0       0  BOX
 ***  157770   SENCO N19 1-3/4" STAPLES                     00545  _______     0 *    580    0          0       0  BOX
 ***  157790   SENCO L11 3/4" STAPLES                       00546  _______     0 *    461    0          0       0  BOX

  -  -
      184340   2X3" ALUM ELBOW WHITE                        00547  _______     0 *     13    0          0       0  PCE
      184350   2X3X10' ALUM DOWNPIPE WHITE                  00548  _______     0 *     98    0          0       0  PCE
      184400   4" LEFT ALUM END CAP WHITE                   00549  _______     0 *    144    0          0       0  PCE
      184540   4"x16' ALUM EAVESTROUGH WHITE                00550  _______     0 *     39    0          0       0  PCE
      184640   2"x3" OUTLET WHITE                           00551  _______     0 *     24    3          0       0  PCE
      184780   2x3 WHITE D/P STRAP                          00552  _______     0 *     64    3          0       0  PCE
      184990   1/2 BIRCH PLYWOOD                            00553  _______     0 *     29    0          0       0  SHT
      185000   3/4 BIRCH PLYWOOD                            00554  _______     0 *     17    0          0       0  SHT
      185900   3/4" OAK PLYWOOD                             00555  _______     0 *     18    0          0       0  SHT
      185910   1/4" OAK PLYWOOD                             00556  _______     0 *    124    0          0       0  SHT
      185920   1/8" OAK PLYWOOD                             00557  _______     0 *    135    0          0       0  SHT
      186010   1X2 S4S KD RED OAK                           00558  _______     0 *    275    0          0       0  LINFT
      186020   1X3 S4S KD RED OAK                           00559  _______     0 *    142    0          0       0  LINFT
      186030   1X4 S4S KD RED OAK                           00560  _______     0 *    276    0          0       0  LINFT
      186040   1X5 S4S KD RED OAK                           00561  _______     0 *    296    0          0       0  LINFT
      186050   1X6 S4S KD RED OAK                           00562  _______     0 *     70    0          0       0  LINFT
      186060   1X8 S4S KD RED OAK                           00563  _______     0 *    130    0          0       0  LINFT
      186130   2X2 S4S KD RED OAK                           00564  _______     0 *    223    0          0       0  LINFT
      186140   2X3 S4S KD RED OAK                           00565  _______     0 *      3    0          0       0  LINFT
      186150   2X4 S4S KD RED OAK                           00566  _______     0 *    157    0          0       0  LINFT
      186160   2X6 S4S KD RED OAK                           00567  _______     0 *    102    0          0       0  LINFT
      191640   STYROFOAM INSULATION STOPS                   00568  _______     0 *     55    0          0      20  EACH
      191690   1-1/2" 4X8 TYPE 1 STYROFOAM                  00569  _______     0 *     97    0          0       0  SHT
      191720   2" 4X8 TYPE 1 STYROFOAM                      00570  _______     0 *     14    0          0       0  SHT

          RECORDS PRINTED:   39



FIELDS

LOC            product location code
PRODUCT CODE   product code
DESCRIPTION    product description
ITEM CODE      UPC bar code
SEQ#           sequence number in the order sheet
QTY ORDERED    quantity ordered (blank if Load Suggested set to N)
I.Q.           ideal order quantity
OH HAND        quantity on hand
SUG. ORD.      suggested order quantity
MINIMUM QTY    minimum pack size quantity
PACK SIZE      package size, if applicable
BASE UNIT      base unit of measure for the product