Inventory Management IM06SCN Help - Elliott Business Software



Stock Status Report

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

 

 

 

 

 

 

 

 

 



Elliott Business Software
| Add-ons | Services
3rd Party Solutions | News & Events
Technical Support | Company Profile