Just-in-time requisition and inventory management system
First Claim
1. A Just-In-Time requisition and inventory management system comprising:
- a local computer maintaining a local database including a local inventory record indicating quantities of items on hand at a local warehouse;
a host computer maintaining a host database, said host database including a host inventory record that includes multiple inventory portions, wherein;
one inventory portion of said host inventory record indicates quantities of items on hand at a central location; and
another inventory portion of said host inventory record indicates quantities of items on hand at said local warehouse;
means for bi-directionally communicating between said local computer and said host computer to permit the bi-directional exchange of data between said host database and said local database;
means for sourcing requested quantities of items at desired times, including;
means, provided at said local computer, for generating a requisition order for a requisitioned item;
means for searching said local database for a local inventory record corresponding to said requisitioned item to determine if a requested quantity of said requisitioned item is available at said local warehouse;
means for performing the following steps (A), (B) and (C) from said local computer if said requested quantity of said requisitioned item is available at said local warehouse;
(A) sourcing said requisitioned item from said local warehouse;
(B) updating said local inventory record to indicate the sourcing of said requisitioned item from said local warehouse; and
(C) using said bi-directional communication means to similarly update that portion of said host inventory record, present at said host computer, that indicates quantities of items on hand at said local warehouse;
said searching means further comprising means for searching said host database for a host inventory record corresponding to said requisitioned item if said requested quantity of said requisitioned item is not available at said local warehouse;
means for performing the following steps (D), (E), and (F) from said host computer if said requested quantity of said requisitioned item is not available at said local warehouse but is available at said central location;
(D) using said bi-directional communicating means to transmit data from said host computer to said local computer indicating that said requested quantity of said requisitioned item is available at said central location;
(E) directing the transfer of said requested quantity of said requisitioned item from said central location to said local warehouse; and
(F) updating said host database to indicate the transfer of said requested quantity of said requisitioned item from said central location to said local warehouse by subtracting said requested quantity of said requisitioned items from that portion of said host inventory record, present at said host computer, that indicates quantities of items on hand at said central location; and
(G) using said bi-directional communication means to update said local database, from said host computer, by adding said requested quantity of said requisitioned items to said local inventory record.
5 Assignments
0 Petitions
Accused Products
Abstract
In accordance with the present invention, a requisition and inventory management system is provided which employs both a host computer and a local computer which can be linked to permit two-way data communications in a real time environment. Each computer has an associated database which can be accessed by that computer. By accessing its respective database, each computer can build and transmit to the other computer communications blocks of data relating to a particular requisition of an item in Just-in-Time (JIT) inventory or to the management of the JIT inventory. The other computer can then use the received data to continue processing of the requisition or to update its JIT inventory records. Thus requisition records are created from a real-time interaction between the host and local computers, with each computer using data from its respective database in conjunction with information entered by a Customer Service Representative (CSR) operating the local computer.
The system of the present invention also utilizes means for automatically determining which items in the JIT inventory are likely to require replenishment. The system then proposes a purchase or transfer order for an optimum quantity of the item, which the CSR may accept or modify.
688 Citations
38 Claims
-
1. A Just-In-Time requisition and inventory management system comprising:
-
a local computer maintaining a local database including a local inventory record indicating quantities of items on hand at a local warehouse; a host computer maintaining a host database, said host database including a host inventory record that includes multiple inventory portions, wherein; one inventory portion of said host inventory record indicates quantities of items on hand at a central location; and another inventory portion of said host inventory record indicates quantities of items on hand at said local warehouse; means for bi-directionally communicating between said local computer and said host computer to permit the bi-directional exchange of data between said host database and said local database; means for sourcing requested quantities of items at desired times, including; means, provided at said local computer, for generating a requisition order for a requisitioned item; means for searching said local database for a local inventory record corresponding to said requisitioned item to determine if a requested quantity of said requisitioned item is available at said local warehouse; means for performing the following steps (A), (B) and (C) from said local computer if said requested quantity of said requisitioned item is available at said local warehouse; (A) sourcing said requisitioned item from said local warehouse; (B) updating said local inventory record to indicate the sourcing of said requisitioned item from said local warehouse; and (C) using said bi-directional communication means to similarly update that portion of said host inventory record, present at said host computer, that indicates quantities of items on hand at said local warehouse; said searching means further comprising means for searching said host database for a host inventory record corresponding to said requisitioned item if said requested quantity of said requisitioned item is not available at said local warehouse; means for performing the following steps (D), (E), and (F) from said host computer if said requested quantity of said requisitioned item is not available at said local warehouse but is available at said central location; (D) using said bi-directional communicating means to transmit data from said host computer to said local computer indicating that said requested quantity of said requisitioned item is available at said central location; (E) directing the transfer of said requested quantity of said requisitioned item from said central location to said local warehouse; and (F) updating said host database to indicate the transfer of said requested quantity of said requisitioned item from said central location to said local warehouse by subtracting said requested quantity of said requisitioned items from that portion of said host inventory record, present at said host computer, that indicates quantities of items on hand at said central location; and (G) using said bi-directional communication means to update said local database, from said host computer, by adding said requested quantity of said requisitioned items to said local inventory record. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15)
-
-
16. A method of managing a Just-In-Time inventory, said method comprising the steps of:
-
maintaining a local database with a local computer, the local database including a local inventory record indicating quantities of items on hand at a local warehouse; maintaining a host database with a host computer, the host database including a host inventory record that includes multiple inventory portions, wherein; one inventory portion of said host inventory record indicates quantities of items on hand at a central location; and another inventory portion of said host inventory record indicates quantities of items on hand at said local warehouse; providing means for bi-directionally communicating between said local computer and said host computer, to permit the bi-directional exchange of data between said host database and said local database; sourcing requested quantities of items at desired times, by way of at least the following steps; generating a requisition order for a requisitioned item; searching said local database for a local inventory record corresponding to said requisitioned item to determine if a requested quantity of said requisitioned item is available at said local warehouse; performing the following steps (A), (B) and (C) from said local computer if said requested quantity of said requisitioned item is available at said local warehouse; (A) sourcing said requisitioned item from said local warehouse; (B) updating said local inventory record to indicate the sourcing of said requisitioned item from said local warehouse; and (C) using said bi-directional communication means to similarly update portion of said host inventory record, present at said host computer, that indicates quantities of items on hand at said local warehouse; searching said host database for a host inventory record corresponding to said requisitioned item if said requested quantity of said requisitioned item is not available at said local warehouse; performing the following steps (D), (E) and (F) from said host computer if said requested quantity of said requisitioned item is not available at said local warehouse but is available at said central location; (D) using said bi-directional communicating means to transmit data from said host computer to said local computer indicating that said requested quantity of said requisitioned item is available at said central location; (E) directing the transfer of said requested quantity of said requisitioned item from said central location to said local warehouse; (F) updating said host database to indicate the transfer of said requested quantity of said requisitioned items from said central location to said local warehouse by subtracting said requested quantity of said requisitioned items from that portion of said host inventory record, present at said host computer, that indicates quantities of items on hand at said central location. - View Dependent Claims (17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30)
-
-
31. A Just-In-Time requisition and inventory management system comprising:
-
a plurality of local computers maintaining respective local databases including a local inventory records indicating quantities of items on hand at respective local warehouses; a host computer maintaining a host database, said host database including a host inventory record that includes multiple inventory portions, wherein; one inventory portion of said host inventory record indicates quantities of items on hand at a central location; and other inventory portions of said host inventory record respectively indicate quantities of items on hand at said local warehouses; means for bi-directionally communicating between said host computer and said local computers to permit the bi-directional exchange of data between said host database and said local databases; means, provided at each of said local computers, for sourcing requested quantities of items at desired times, including; means for generating a requisition order for a requisitioned item; means for searching the local database corresponding to said local computer for a local inventory record corresponding to said requisitioned item to determine if a requested quantity of said requisitioned item is available at the corresponding local warehouse; means for performing the following steps (A), (B) and (C) if said requested quantity of said requisitioned item is available at said corresponding local warehouse; (A) sourcing said requisitioned item from said corresponding local warehouse; (B) updating the corresponding local inventory record to indicate the sourcing of said requisitioned item from said local warehouse; and (C) using said bi-directional communication means to similarly update that portion of said host inventory record, present at said host computer, that indicates quantities of items on hand at said corresponding local warehouse; said searching means further comprising means for searching said host database for a host inventory record corresponding to said requisitioned item if said requested quantity of said requisitioned item is not available at said corresponding local warehouse; means for performing the following steps (D), (E) and (F) from said host computer if said requested quantity of said requisitioned item is not available at said corresponding local warehouse but is available at said central location; (D) using said bi-directional communicating means to transmit data from said host computer to said local computer indicating that said requested quantity of said requisitioned item is available at said central location; (E) directing the transfer of said requested quantity of said requisitioned item from said central location to said corresponding local warehouse; and (F) updating said host database to indicate the transfer of said requested quantity of said requisitioned item from said central location to said local warehouse by subtracting said requested quantity of said requisitioned items from that portion of said host inventory record, present at said host computer, that indicates quantities of items on hand at said central location. - View Dependent Claims (32, 33, 34)
-
-
35. A method of managing a Just-In-Time inventory, said method comprising the steps of:
-
maintaining a plurality of local databases with a plurality of respective local computers, the local databases each including local inventory records indicating quantities of items on hand at respective local warehouses; maintaining a host database with a host computer, the host database including a host inventory record that includes multiple inventory portions, wherein; one inventory portion of said host inventory record indicates quantities of items on hand at a central location; and other inventory portions of said host inventory record respectively indicate quantities of items on hand at said local warehouses; providing means for bi-directionally communicating between said local computers, to permit the bi-directional exchange of data between said host database and said local databases; at any one of said local computers, selectively sourcing requested quantities of items at desired times by way of at least the following steps; generating a requisition order for a requisitioned item; searching the local database corresponding to said local computer for a local inventory record corresponding to said requisitioned item to determine if a requested quantity of said requisitioned item is available at the corresponding local warehouse; performing the following steps (A), (B) and (C) if said requested quantity of said requisitioned item is available at said corresponding local warehouse; (A) sourcing said requisitioned item from said corresponding local warehouse; (B) updating the corresponding local inventory record to indicate the sourcing of said requisitioned item from said corresponding local warehouse; and (C) using said bi-directional communication means to similarly update that portion of said host inventory record, present at said host computer, that indicates quantities of items on hand at said corresponding local warehouse; searching said host database for a host inventory record corresponding to said requisitioned item if said requested quantity of said requisitioned item is not available at said corresponding local warehouse; performing the following steps (D), (E) and (F) and from said host computer if said requested quantity of said requisitioned item is not available at said corresponding local warehouse but is available at said central location; (D) using said bi-directional communicating means to transmit data from said host computer to said local computer indicating that said requested quantity of said requisitioned item is available at said central location; (E) directing the transfer of said requested quantity of said requisitioned item from said central location to said corresponding local warehouse; and (F) updating said host database to indicate the transfer of said requested quantity of said requisitioned item from said central location to said local warehouse by subtracting said requested quantity of said requisitioned items from that portion of said host inventory record, present at said host computer, that indicates quantities of items on hand at said central location. - View Dependent Claims (36, 37, 38)
-
Specification