1

GLOBAL INVENTORY FORM:

This form shows all information of purchasing & Inventory related to the Item and subinventory.

User: User Name of the user

Date/Time: Current Date and Time

2

Organisation: Inventory Org name of the facility

Subinventory: Subinventories are unique physical or logical separations of material inventory. All material within an organization is held in a subinventory therefore it is a store name (Only asset subinventories are available).

Item Code: This is the item for which, you want to check the details. Item description is populated automatically when you enter the item code.

Locator: Locator is physical location of the item in the store. Global inventory form shows locator information of the item, if the item is available on one location. In case of multiple locations, Locator field remains blank.

List.Price: This field show list price of the item which is defined at Organization item level. Usually it is last purchase price of the item.

Date From & To: This is the required period, for which the user wants to check the consumption and other details of the item.

Avg.Price: This field shows current average price of the item.

Min Qty & Max Qty: These fields show Minimum and Maximum quantity of the item and for the particular subinventory entered on the form. Quantities are defined at subinventory level for the item. Min/Max level of the item is used for the planning purpose of the item.

Min-Max Comments: This field shows comments regarding the entered item and for the particular subinventory entered on the form. Comments are provided on DFF at subinventory level for the item.

UOM: UOM (Unit of measure) is used by a variety of functions and transactions to express the quantity of the item. This field shows primary UOM of the item.

Description: This field show UOM description and it is populated automatically.

Last PO Vendor: This field shows the vendor name to whom, the last PO was placed.

3

Manufacturer Name & Catalog Number: This field shows all available manufacturer names and catalog numbers for the item.

Monthly Consumption: This shows total consumption quantity of the item month wise for last twelve months. Consumption is based on following transaction types,

XX_Issue to End User Depts. Internal Order Pick XX_Top Up Move Order Issue XX_Issue_to_Patients XX_Cerner Move Order Issue

4

On-hand: This shows current available quantity in the inventory org/subinventory. For details, double click in the On-hand field. Details include,

Quantity Expiry Date.

Lot Number

Pack Size

Pack Kind

Brand PO Number

Pack Size

Pack Kind

Brand Subinventory Aisle Row Bin Last movement Date

Transaction Description

Reserved: This shows quantity of the item that is reserved/allocated across the organization. For details, double click in the Reserved field. Details include,

Move Order No Transaction Qty Transaction UOM Transaction Type Transaction Date Transaction Action Name

Subinventory Transfer Subinventory

Available: This shows available quantity of the item that you can allocate and transact across the organization.

Expired/Repl.: This field shows expired lot/lots of the item if the expiry date falls between the given dates (Which you enter as query parameter. ). For details, double click in the Expired/Repl. field. Details include,

Quantity Expiry Date.

Lot Number

Subinventory

Brand Pack Size

Pack Kind

Aisle Row Bin

Transaction Date

PO Number Transaction Description

Receiving: This field shows total receipt of the item based on following transaction types,

PO Receipt XX_Department Returns Move Order Transfer XX_Cerner Receipt XX_Return From Patient XX_Received_From_Other_Hosp. Other Transaction Types (Miscellaneous Transaction Types )

For details, double click in the Receiving field. Details include,

Transaction Date

Subinventory PO Receipt XX Department Return

Move Order Transfer

XX Cerner Receipt

XX Patient Returns

XX Received from Other Hosp.

Other Transaction Types

Issuance: This field shows total issuance of the item based on following transaction types,

XX_Issue to End User Depts. Move Order Transfer XX_Issue_to_Patients XX_Cerner Move Order Issue XX_Cerner Issue Internal Order Pick Other Transaction Types (Miscellaneous Transaction Types )

5

For details, double click in the Issuance field. Details include,

Transaction Date

XX issue to End User Depts

Move Order Transfer

XX issue to patient

XX Cerner Issue XX Cerner Move Order issue

Internal Order Pick

Other Transaction Types

Purch. Orders: This field shows all purchase orders’ quantity (Approved POs), which were created for the item. For details, double click in the Purch. Orders field. Details include,

PO Number

PO Date

Qty Order

Qty Received

Qty Cancelled

Qty Onorder

Currency Unit Price

Supplier Name

Lead Time

UOM Code

UOM Description

Comment Buyer

Open Request: This field shows open requisitions quantities (which are not processed to create PO). For details, double click in the Open Request field. Details include,

Line Num Req Number Creation Date Quantity Unit Price Value Supplier Required By Requestor Buyer

Open RFQs: This field shows open RFQs (Request for Quotations) quantities (which are not closed and processed to create PO). For details, double click in the Open RFQs field. Details include,

Line Number

RFQ Number

Open Date

Close Date Publish Date

Auction Title

UOM Quantity Vendor Name

Vendor Number

Country Contact Name

Currency Code

Temp. Receipts: This field shows received quantity of the item against PO. For details, double click in the Temp. Receipts field. Details include,

Receipt Num

Receipt Date

Qty in Temp Area

UOM PO Unit Price

Currency PO No

PO Entered Date

Vendor Name

Qty Ordered Total

Qty Received Total

Qty Delivered to Stock Total

Qty Cancelled Total

Received By

Org Name

Finally Received: This field shows total quantity of the item, which is delivered to stores/departments. For details, double click in the Finally Received field. Details include,

Transaction Type Name

PO No

PO Date

Receipt No

Receipt Date

Qty

Transaction Date

Lot Number

Expiry Date

Brand

Pack Size

Pack Kind

Supplier Name

UOM

Currency

Subinventory

Trans.Source

Transaction Reference

6

PO Returns: This field shows item returned quantity, which is returned to vendor.

On Order: This field shows ordered quantity of the item, which is due and yet to be received from the supplier. For details, double click in the On Order field. Details include,

PO Number

PO Date

PO Qty

Onorder Qty

Price Currency UOM Code

UOM Description

Vendor Name

Comments

Issued F to D: This field shows consumption quantity of the item for the given period and for the organisation/subinventory based on following transaction types,

XX_Issue to End User Depts. Internal Order Pick XX_Top Up Move Order Issue XX_Issue_to_Patients XX_Cerner Move Order Issue

For details, double click in the Issued F to D field. Details include,

Order Date.

Order Number

Order Qty

Transaction UOM

Lot Number

Expiry Date

Subinventory

To Subinventory

Locator Code

Brand

Pack Size

Pack Kind

Location

Account

Transaction Type

Last issue D: This field shows last issuance date of the item based on following transaction types,

XX_Issue to End User Depts. Internal Order Pick XX_Top Up Move Order Issue XX_Issue_to_Patients XX_Cerner Move Order Issue

Current Year: This field shows consumption quantity of the item for the year to date.

7

Previous 1 Yr.: This field shows consumption quantity of the item for previous year like if you are in 2015 then system gives you total consumption of the item for 2014 year.

Previous 2 Yr.: This field shows consumption quantity of the item for second previous year like if you are in 2015 then system gives you total consumption of the item for 2013 year.

Previous 3 Yr.: This field shows consumption quantity of the item for third previous year like if you are in 2015 then system gives you total consumption of the item for 2012 year.

MISC Trans: This field shows transaction quantity of the item for the given period and for the organisation/subinventory based on miscellaneous transaction types. For details, double click in the MISC Trans field. Details include,

Transaction Date Transaction Qty Source Subinventory Transaction Type

MO Unallocated: This field shows unallocated move orders of the item. For details, double click in the MO Unallocated field. Details include,

Order No Order Date Quantity Allocated Qty UOM Code From Subinventory

To Subinventory

Transaction Type Name

Locator

Inter Facility Transfer: This field show inter facility transfer of the item like transfer to SKMC/MAFRAQ. For details, double click in the Inter Facility Transfer field. Details include,

Transaction Date Transaction Quantity Source Subinventory Destination Subinventory Transaction Type Name