Inventory Management IM06SCN Help - Elliott Business Software

Stock Status Report

Application Overview

The Stock Status Report is used to print out stock status information about a selected item or range of items by location and product category. The report can be printed for All locations or for a range of locations. If All is selected, totals are printed for each item which is stocked at more than one location following a full itemization of the quantities on hand, on order and allocated at the various locations. When an item's quantity on hand is below the reorder level for that item at that location the literal REO (reorder) appears to the right of the item on the report. This report does not take into consideration the quantities on order for the different items. If your company does ordering from individual locations as opposed to central ordering where all orders for a specific item are placed by a single location, this report may be more helpful than the Reordering Advice Report, which assumes centralized ordering when an item's quantity on hand reaches zero, the literal O/S appears to the right of the item on the report. If you are using LIFO or FIFO costing method, this report may also be used to print detailed layer information for each item (out of stock).

Run Instructions

Select Stock Status Report from the pull down I/M Reports window. The following screen will then be displayed:

Stock Status Report Entry Screen

The following options are available:

* Select the desired mode from the Stock Status Report menu bar

* Enter the data requested on the screen

To return to the menu bar, press the ESC or F10 key. To leave this application, press X for EXIT when positioned at the menu bar.

The following entry field only appears if LIFO or FIFO costing method is being used and all locations have been selected to print:

Name

Type and Description

9. Print LIFO/FIFO Valuation

Detail ?

Y or N.

Enter Y if you want to print LIFO or FIFO layer detail for the selected items. Defaults to N.

Stock Status report By Item/Category

Run Date: Oct 30, 2001 - 1:53am Elliott Demonstration Company Page 1

S T O C K S T A T U S R E P O R T

Ranges: All Locations

Items SER-100 Thru SER-100

All Product Categories

Back Order Code: No = May Not Be Back Ordered (Blank Means Item May Be Back Ordered)

Stock Status: Reo = At Or Below Reorder Level O/S = Out Of Stock

Printed By FOB Cost

Item No Qty Qty Qty Qty Reorder Average Value Of Bkord Stk

Uom Price Cat Loc On-Hand Allocated Backordered On-Order Level Cost Inventory Code Sts

SER-100 Pavilion 5000 Laptop

EA 1,095.0000 LA 9.00 2.00 .00 .00 .00 995.0000 8,955.00 Yes

AT .00 .00 .00 .00 .00 .00 O/S

DA .00 .00 .00 .00 .00 .00 O/S

DS .00 .00 .00 .00 .00 .00 O/S

HK .00 .00 .00 .00 .00 .00 O/S

IT .00 .00 .00 .00 .00 .00 O/S

NY .00 .00 .00 .00 .00 .00 O/S

PO .00 .00 .00 .00 .00 .00 O/S

QC .00 .00 .00 .00 .00 .00 O/S

Stock Status Report By G/L Number

Run Date: Oct 30, 2001 - 2:08am Elliott Demonstration Company Page 1

S T O C K S T A T U S R E P O R T B Y G / L A C C O U N T

Ranges: All Accounts Selected

All Items

All Locations

Detail Report

Printed By FOB Cost

Item-No Item-Description Lc Cat Um Qty-Oh Qty-Alc Qty-Bo Qty-Od Avg-Cost Inv-Value

Account Number: 01100-00000-00000

1102-B China Cat - Brandy AT EA .00 .00 .00 .00 12.4456 .00

DA EA .00 .00 .00 .00 12.4456 .00

DS EA .00 .00 .00 .00 12.4456 .00

HK EA .00 .00 .00 .00 12.4456 .00

IT EA .00 .00 .00 .00 12.4456 .00

LA EA 298.00 .00 .00 556.00 12.4456 3,708.79

NY EA .00 .00 .00 .00 12.4456 .00

PO EA .00 .00 .00 .00 12.4456 .00

QC EA .00 .00 .00 .00 12.4456 .00

Item Total: 298.00 .00 .00 556.00 3,708.79

CAS-1917 LEICA Leica M-5 Camera LA EA 24.00 10.00 .00 .00 900.0000 21,600.00

CHAR-GEN Character Generator At 25 Meg LA CVD EA 20.00 5.00 .00 40.00 7.8000 156.00

CHINA CAT 0711 PERS Model ABQ LA EA .00 25.00 25.00 .00 .0000 .00

CLOCK 25 Meg Clock For Mother Board AT A EA .00 .00 .00 .00 12.9637 .00

LA A EA 277.00 100.00 .00 20.00 12.9637 3,590.94

Item Total: 277.00 100.00 .00 20.00 3,590.94

CLOCK-ADJ Adjustment Clock For CPU LA A EA 9.00 .00 .00 .00 18.5000 166.50

CPU-30MEG Z80 Micro Processor 30 Meg LA ACP EA 5.00 5.00 .00 .00 1,700.0000 8,500.00

DATA-BUS Data Bus/Buffer 25 Meg LA ACP EA 19.00 8.00 .00 50.00 15.4500 293.55

DATA-CONTRL Data Control Module LA CVD EA 48.00 .00 .00 40.00 14.7500 708.00

QC CVD EA .00 .00 .00 .00 14.7500 .00

Item Total: 48.00 .00 .00 40.00 708.00

DEFAULT-ITEM Default-Item LA EA 10.00 .00 .00 .00 .0000 .00

PE EA .00 .00 .00 .00 .0000 .00

Item Total: 10.00 .00 .00 .00 .00

DISPLAY Display Blanker For 25 MVideo LA CVD EA 62.00 15.00 .00 10.00 12.4300 770.66

FLOPPY-CNT Floppy Disk Controller LA IOS EA 10.00 .00 .00 .00 80.0000 800.00

KEYBOARD Key Board For System Computer LA IOS EA 10.00 .00 .00 10.00 75.9800 759.80

MEMMGR Memory Manager For CPU Board LA ACP EA 140.00 80.00 .00 40.00 44.0000 6,160.00

PAR-PORT Parallel Port For I/O LA A EA 10.00 .00 .00 30.00 10.0000 100.00

Partial Listing Page 1 – Stock Status Report By GL number