Display Inventory Statistics

When you click Inventory, the Executive Information Summary (EIS) program displays these statistics:

Field Name

Displays

Finished goods

Month/period column: Current total value of items whose type is a finished good (product for resale) in on-hand inventory, which is calculated:

Finished goods x Standard unit cost

Actions that update this value:

  • Confirm a shipment with Sales Shipment Confirmation (OC), Secured Confirmation (SOC), or Bill of Lading Maintenance (BLM)

  • Enter an inventory adjustment with Material Issues and Adjustments (IMI)

  • Receive into inventory with Receiver Maintenance (IRC) or Receiving and Inspection (IRI)

Other columns: See below.

Raw materials

Month/period column: Current total value of item types that are not finished goods, including dependent items and phantoms, which is calculated:

Raw materials x Standard unit cost

Actions that update this value:

  • Pick components with Manufacturing Order Maintenance (MIM), Material Usage Maintenance (MUA), Picking Confirmation (MPK), Secured Picking (SMPK), Manufacturing Order Picking Selection (MSS)

  • Backflush picking by operation sequence with Work in Process Movement (WIPM), Labor Entry (LLE), Labor Import (LEI), or at receiving with Receiver Maintenance (IRC)

  • Scrap or reject components with Work in Process Movement (WIPM), Labor Entry (LLE), or Labor Import (LEI)

  • Enter an adjustment, consume a consumable item, scrap material, or pick components for a manufacturing order with Material Issues and Adjustments (IMI)

  • Receive into inventory with Receiver Maintenance (IRC) or Receiving and Inspection (IRI)

  • Select stock as is as the disposition for rejected components in Rejected Material Disposition (MRB)

  • Select salvage components as the disposition for rejected parent items or components in Rejected Material Disposition (MRB)

Other columns: See below.

Floorstock

Month/period column: Current total value of all items in floor stock, which is calculated:

Quantity of floor stock items x Standard unit cost of each

Actions that update this value:

  • Enter a floor stock adjustment or issue on hand inventory to floor stock or floor stock to on hand with Material Issues and Adjustments (IMI)

  • Receive into inventory with Receiver Maintenance (IRC) or Receiving and Inspection (IRI)

Other columns: See below.

Subtotal: Inventory on hand

Month/period column: Current total value of all finished goods and raw materials in on-hand inventory and floor stock, excluding material picked for manufacturing orders (which is included in Work in Process). It is calculated:

(Finished goods + Raw materials + Floor stock) x Standard unit cost

Other columns: See below.

Intransit

Month/period column: Current total value of all items intransit between branches, which is calculated:

Intransit quantity x Receiving branch's standard unit cost

Intransit inventory is defined as belonging to the shipping branch, until it is received by the receiving branch, using the Receiver Maintenance (IRC) and/or Receiving and Inspection (IRI) programs. So while an item is intransit, it "belongs" to the shipping branch's inventory.

Actions that update this value:

  • Confirm shipment with Branch Transfer Confirmation (ITS), Secured Transfer Confirmation (SITS), or Bill of Lading Maintenance (BLM)

  • Receive into stock with Receiver Maintenance (IRC) or Receiving and Inspection (IRI)

Other columns: See below.

Work in process

Month/period column: Current accumulated costs of open manufacturing orders, including materials picked, labor, overhead, and outside service.

Note
Select Work in process and click Detail to display open manufacturing orders. Open manufacturing order costs should match the Accumulated costs column in the WIP Valuation Inquiry.

Actions that update this value:

  • Release requisitions with Requisition Maintenance (IRM), Consolidate Manufacturing Requisitions (MOCR), Order Release Selection (MRR) or enter a manufacturing order with Manufacturing Order Maintenance (MIM)

  • Receive into inventory with Receiver Maintenance (IRC) or Receiving and Inspection (IRI)

  • Release a rework order with Rejected Material Disposition (MRB)

Other columns: See below.

Total inventory

Month/period column: Current total value of inventory. It is calculated:

(Finished goods + Raw materials + Floor stock + Intransit + Work in Process) x Standard unit cost

Other columns: See below.

Column heading:

Year-to-date
This month last year
Last month
Enterprise
Enterprise YTD
Last year total
Last YTD

For each category of statistics:

Total for the year-to-date
Total for the current month/period last year
Total for the last month
Month-to-date total for the enterprise
Year-to-date total for the enterprise
Last year total (end of year) for the enterprise
Last year's year-to-date total

  1. (Optional) Select a inventory category and click Detail to display details:

Inventory Statistics

See

Inventory on hand, Finished goods, Raw materials, Floor stock

Display Inventory Valuation Statistics

Intransit

Display the Status of Items Intransit

Work in process

Display WIP Valuation

Click OK to return to this screen.

  1. Choose the appropriate options:

To

Do This

Print the displayed data

Click Print. See Print an Inquiry.

Display details of inventory statistics

Highlight the category and click Detail or double click the line. See step 1.

Display inventory values by ABC class

Highlight the category and click ABC class. See Display Inventory Values by Class. Click OK to return to this screen.

Display inventory values by product class

Highlight the category and click Prod class. See Display Inventory Values by Class. Click OK to return to this screen.

Display inventory values by account code

Highlight the category and click Acct code. See Display Inventory Values by Class. Click OK to return to this screen.

Return to the Executive Information Summary screen

Click OK. See Display Executive Information Summary Statistics.

Exit and return to the menu

Click Quit.