Global Inventory Form

(1)

1

GLOBAL INVENTORY FORM:

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

User: User Name of the user

(2)

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

(3)

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

(4)

4

On-hand: This shows current available quantity in the inventory

org/subinventory. For details, double click in the On-hand field. Details include,

Quanti ty Expi ry Date . Lot Numb er Pac k Siz e Pac k Kin d Bra nd PO Numb er Pac k Siz e Pac k Kin d Bra nd Subinvent ory Aisl e Ro w Bi n Last movem ent Date Transact ion Descript ion

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,

Quant ity Expi ry Dat e. Lot Numb er Subinven tory Bra nd Pa ck Siz e Pa ck Kin d Ais le Ro w Bi n Transact ion Date PO Number Transact ion Descript ion

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 Subinvento ry PO Receipt XX Departmen t 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,

 Move Order Transfer

 XX_Cerner Move Order Issue

 XX_Cerner Issue

(5)

5

 Other Transaction Types (Miscellaneous Transaction Types )

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 Numbe r PO Dat e Qty Orde r Qty Receive d Qty Cancelle d Qty Onorde r Currenc y Unit Pric e Supplie r Name Lea d Tim e UO M Cod e UOM Descrip tion Comm ent Buy er

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 Numb er Open Date Close Date Publish Date Auction Title UOM Quant ity Vendor Name Vend or Numb er Coun try Cont act Nam e Curre ncy Code

Temp. Receipts: This field shows received quantity of the item against PO. For

details, double click in the Temp. Receipts field. Details include,

Recei pt Num Recei pt Date Qty in Tem UOM PO Unit Price Curren cy PO No PO Enter ed Vendo r Name Qty Order ed Qty Recei ved Qty Delive red to Qty Cancel led Recei ved By Org Na me

(6)

6

p Area

Date Total Total Stock Total

Total

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, Trans action Type Name P O N o P O D at e Rec eipt No Rec eipt Dat e Q t y Trans action Date Lot Nu mbe r Ex pir y Da te Br an d Pa ck Si ze Pa ck Ki nd Sup plier Nam e U O M Curr ency Subinv entory Trans. Source Transa ction Refere nce

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 Numbe r PO Dat e PO Qty Onorde r Qty Price Currenc y UO M Cod e UOM Descrip tion Vendo r Name Comme nts

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,

(7)

7

Ord er Dat e. Order Num ber Ord er Qty Transac tion UOM Lot Num ber Expi ry Dat e Subinven tory To Subinven tory Loca tor Code Bra nd Pa ck Siz e Pa ck Ki nd Locat ion Acco unt Transac tion Type

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

transaction types,

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

date.

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 Subinvento ry To Subinvento ry 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