Procurement requisition processing method and system

A purchasing method and system. The method includes purchasing method comprising generating by said computing system a database table. The database table comprises catalog purchase types for items available for purchase. An entity profile associated with an entity is generated. The entity profile is associated with entity allowable catalog purchase types selected from the available catalog purchase types in the database table. A catalog profile is generated. The catalog profile is associated with the entity profile. A user profile associated with the entity profile is generated. The user profile is associated with the entity allowable catalog purchase types. Specified catalogs are identified and presented to a user. The user profile is comprised of a default purchase type and additional user related details. The specified catalogs are associated with the default purchase type, the user profile, the entity profile, and the catalog profile.

FIELD OF THE INVENTION

The present invention relates to a method and associated system for configuring available purchase types for items available for purchase.

BACKGROUND OF THE INVENTION

Modifying a process for requesting items typically comprises a complicated and inefficient process with little flexibility. A user requesting items may not have the ability to associate the items with external factors. The user may be limited by an inability to modify the process. Accordingly, there exists a need in the art to overcome at least some of the deficiencies and limitations described herein above.

SUMMARY OF THE INVENTION

The present invention provides a purchasing method comprising:

enabling, by a computing system for an administrator, access to said computing system, wherein said computing system comprises a memory system, and wherein said administrator is associated with a first entity;

generating, by said computing system in response to a first command received from said administrator, a database table, wherein said database table comprises catalog purchase types for items available for purchase;

storing said database table in said memory system;

generating, by said computing system in response to a second command received from said administrator, an entity profile associated with said first entity;

associating, by said computing system in response to a third command received from said administrator, said entity profile with entity allowable catalog purchase types selected from said catalog purchase types in said database table;

generating, by said computing system in response to a fourth command received from said administrator, a catalog profile, said catalog profile comprising catalogs that comprise items that are associated with said catalog purchase types for said items available for purchase from said database table;

associating, by said computing system in response to a fifth command received from said administrator, said catalog profile with said entity profile;

generating, by said computing system in response to a first command received from a first user associated with said entity, a user profile for said first user, said user profile comprising a name and address for said first user;

associating, by said computing system, said user profile with said entity allowable catalog purchase types;

receiving from said first user, a selection for a default purchase type from said entity allowable catalog purchase types;

identifying, by said computing system, specified catalogs from said catalogs based on said default purchase type, said user profile, said entity profile, and said catalog profile;

generating, by said computing system, a catalog report comprising said specified catalogs; and

presenting, by said computing system to said first user, said catalog report for initiating a purchasing process.

The present invention provides a computing system comprising a processor coupled to a computer-readable memory unit, said memory unit comprising instructions that when executed by the processor implement a purchasing method, said method comprising:

enabling, by said computing system for an administrator, access to said computing system, wherein said administrator is associated with a first entity;

generating, by said computing system in response to a first command received from said administrator, a database table, wherein said database table comprises catalog purchase types for items available for purchase;

storing said database table in said computer-readable memory unit;

generating, by said computing system in response to a second command received from said administrator, an entity profile associated with said first entity;

associating, by said computing system in response to a third command received from said administrator, said entity profile with entity allowable catalog purchase types selected from said catalog purchase types in said database table;

generating, by said computing system in response to a fourth command received from said administrator, a catalog profile, said catalog profile comprising catalogs that comprise items that are associated with said catalog purchase types for said items available for purchase from said database table;

associating, by said computing system in response to a fifth command received from said administrator, said catalog profile with said entity profile;

generating, by said computing system in response to a first command received from a first user associated with said entity, a user profile for said first user, said user profile comprising a name and address for said first user;

associating, by said computing system, said user profile with said entity allowable catalog purchase types;

receiving from said first user, a selection for a default purchase type from said entity allowable catalog purchase types;

identifying, by said computing system, specified catalogs from said catalogs based on said default purchase type, said user profile, said entity profile, and said catalog profile; and

generating, by said computing system, a catalog report comprising said specified catalogs; and

presenting, by said computing system to said first user, said catalog report for initiating a purchasing process.

The present invention provides a computer program product, comprising a computer readable medium comprising a computer readable program code embodied therein, said computer readable program code adapted to implement a purchasing method within a computing system, said method comprising:

enabling, by said computing system for an administrator, access to said computing system, wherein said administrator is associated with a first entity;

generating, by said computing system in response to a first command received from said administrator, a database table, wherein said database table comprises catalog purchase types for items available for purchase;

storing said database table in said computer readable medium;

generating, by said computing system in response to a second command received from said administrator, an entity profile associated with said first entity;

associating, by said computing system in response to a third command received from said administrator, said entity profile with entity allowable catalog purchase types selected from said catalog purchase types in said database table;

generating, by said computing system in response to a fourth command received from said administrator, a catalog profile, said catalog profile comprising catalogs that comprise items that are associated with said catalog purchase types for said items available for purchase from said database table;

associating, by said computing system in response to a fifth command received from said administrator, said catalog profile with said entity profile;

generating, by said computing system in response to a first command received from a first user associated with said entity, a user profile for said first user, said user profile comprising a name and address for said first user;

associating, by said computing system, said user profile with said entity allowable catalog purchase types;

receiving from said first user, a selection for a default purchase type from said entity allowable catalog purchase types;

identifying, by said computing system, specified catalogs from said catalogs based on said default purchase type, said user profile, said entity profile, and said catalog profile; and

generating, by said computing system, a catalog report comprising said specified catalogs; and

presenting, by said computing system to said first user, said catalog report for initiating a purchasing process.

The present invention provides a process for supporting computer infrastructure, said process comprising providing at least one support service for at least one of creating, integrating, hosting, maintaining, and deploying computer-readable code in a computing system, wherein the code in combination with the computing system is capable of performing a purchasing method, said method comprising:

enabling, by said computing system for an administrator, access to said computing system, wherein said administrator is associated with a first entity;

generating, by said computing system in response to a first command received from said administrator, a database table, wherein said database table comprises catalog purchase types for items available for purchase;

storing said database table in said computing system;

generating, by said computing system in response to a second command received from said administrator, an entity profile associated with said first entity;

associating, by said computing system in response to a third command received from said administrator, said entity profile with entity allowable catalog purchase types selected from said catalog purchase types in said database table;

generating, by said computing system in response to a fourth command received from said administrator, a catalog profile, said catalog profile comprising catalogs that comprise items that are associated with said catalog purchase types for said items available for purchase from said database table;

associating, by said computing system in response to a fifth command received from said administrator, said catalog profile with said entity profile;

generating, by said computing system in response to a first command received from a first user associated with said entity, a user profile for said first user, said user profile comprising a name and address for said first user;

associating, by said computing system, said user profile with said entity allowable catalog purchase types;

receiving from said first user, a selection for a default purchase type from said entity allowable catalog purchase types;

identifying, by said computing system, specified catalogs from said catalogs based on said default purchase type, said user profile, said entity profile, and said catalog profile; and

generating, by said computing system, a catalog report comprising said specified catalogs; and

presenting, by said computing system to said first user, said catalog report for initiating a purchasing process.

The present invention advantageously provides a simple method and associated system capable modifying a process for requesting items.

DETAILED DESCRIPTION OF THE INVENTION

FIG. 1illustrates a purchasing system2for performing a procurement requisition process, in accordance with embodiments of the present invention. System2is used to:

1. To configure available purchase types (i.e., for items or merchandise available for purchase) for a procurement process.

2. Associate the available purchase types with procuring entities (e.g., companies) and hosted catalogs (i.e., comprising items or merchandise available for purchase) associated with the entities.

3. Associate requesters (i.e., users) choosing a purchasing type with catalogs (i.e., comprising the items or merchandise available for purchase).

System2comprises the following functionality for performing a procurement requisition process:

1. All available purchase types for items available for purchase are configurable and do not require additional software application (i.e., for software application18) code changes every time a new purchase type is introduced.

2. Entity (e.g., company), user, and catalog profiles may be associated with newly added purchase types through a simple configuration process.

3. Based on a user's company and selected purchase type, a shopping process provides appropriate catalogs without modifying any software application code.

4. A purchasing type entity is available in the company, user, and catalog profiles so that any part of software application18(e.g. approvals, accounting, buyer assignment, etc) requiring a purchasing type may be modified easily based on a need.

Software application18generates and modifies the following profile types:

1. Entity/company profile—A profile for storing entity details such as entity name, entity address, purchasing options, etc.

2. Catalog profile—A profile for storing catalog details such as catalog name, catalog supplier, allowed entities for purchasing from a selected catalog etc.

3. User profile—A profile for storing user details such as user name, user address, user company, etc.

The above described profiles are used to identify associated (i.e., with an entity, and a user) for performing process. A purchasing process is defined herein as a process to allow users from a given company to purchase items offered by the catalogs.

System2ofFIG. 1comprises input/output (I/O) devices5A and5B connected to a computing system10through a network7. I/O devices5A and5B may comprise any type of I/O device such as, inter alia, a notebook computer, a desktop computer, a personal digital assistant (PDA), etc. I/O devices5A and5B may be used by:

1. An administrator (e.g., a database administrator, a catalog administrator, an entity administrator, etc) for setting up or programming procurement requisition process.

2. A user (i.e., a requester) selecting items or merchandise available for purchase.

Network7may comprise any type of network including, inter alia, a local area network, (LAN), a wide area network (WAN), the Internet, etc. Computing system10may comprise any type of computing system(s) including, inter alia, a personal computer (PC), a server computer, a database computer, etc. Computing system10comprises a memory system14. Memory system14comprises software application18, profiles27(i.e., user, catalog, entity, etc), catalogs15, and database tables28. Software application18controls all functions related to:

System2is used to perform a procurement requisition process using the following steps:

1. A database table called “Purchase types” is generated and stored in memory system14(e.g., a database). The database table is used by software application18. The database table is generated by a database administrator.

2. Predetermined purchase types are inserted into the database table. (i.e., by a database administrator).

3. An entity profile and a company profile are generated by an entity administrator.

4. The entity profile and the catalog profile graphical user interfaces (GUIs) are modified in order to allow administrators to specify allowable purchase types for the entities and catalogs. This step may be performed by an application developer.

5. A user (requester) profile is generated. The user profile comprises an owning entity specified allowed purchase types. This step may be performed by a user.

6. A catalog profile is generated. The catalog profile comprises allowable purchase types. This step may be performed by a catalog administrator.

7. The user profile GUI is modified in order to allow users to set default purchase types based on the user's owning company's or entity allowable purchase types. This step may be performed by an application developer.

8. Shopping process logic is modified in order to provide users with the appropriate catalogs (i.e., for purchasing) based on their owning company's and its pre authorized catalog's allowable purchase types. This step may be performed by a catalog administrator after the application developer modifies the application code logic.

The following description (steps) illustrates an example of implementation for performing a procurement requisition process:

1. A company (entity) administrator generates a company profile for a company code 001 and configures that users of the company code 001 may purchase catalogs meant for internal (INT) users or external (EXT) users.

2. A catalog administrator sets up a catalog profile 001 and configures that this catalog may be purchased only as internal (INT). The catalog administrator configures that this catalog may be purchased only by an entity 001.

3. A user X logins to software application18and his/her company is 001. The user selects a default purchase type as INT in his/her's user profile.

4. When the user logs into software application18, system2checks that this user belongs to 001 and his/her default purchase type is INT.

5. Software application18queries memory system14for catalog purchase types and a catalog table with parameters comprising company code 001 and a purchase type of INT.

6. Since the catalog table and the catalog purchase types table have values for company code 001 and default purchase type INT, that catalog will be made available to the user X for purchasing items from it.

FIG. 2illustrates a flowchart describing an algorithm used by system2ofFIG. 1for performing a procurement requisition process, in accordance with embodiments of the present invention. In step45, an administrator for an entity enables computing system10to generate a database table. The database table comprises catalog purchase types for items available for purchase. In step47, the database table is stored in memory system14(seeFIG. 1). In step49, computing system10generates a graphical user interface (GUI) for enabling an administrator to generate and/or modify an entity profile. In step52, computing system generates an entity profile associated with an entity. In step54, computing system10associates the entity profile with entity allowable catalog purchase types selected from the available catalog purchase types in the database table. In step60, computing system10generates a graphical user interface (GUI) for enabling an administrator to generate and/or modify a catalog profile. In step64, computing system10generates a catalog profile. The catalog profile comprises catalogs that include items that are associated with the catalog purchase types for items available for purchase from the database table. In step68, computing system10associates the catalog profile with the entity profile. In step69, computing system10generates a graphical user interface (GUI) for enabling a user or requester to generate and/or modify a user profile. In step70, computing system10generates a user profile. The user profile may comprise, inter alia, a name and address for a first user. In step71, computing system10associates the user profile with the entity allowable catalog purchase types selected from the available catalog purchase types in the database table. In step72, the user selects a default purchase type from the entity allowable catalog purchase types. In step73, computing system10identifies specified catalogs from the catalogs based on the default purchase type, the user profile, the entity profile, and the catalog profile. In step74, computing system10generates a catalog report comprising the specified catalogs identified in step73. In step74, the catalog report is presented to the user. In step76, the user performs a purchasing process comprising executing purchases for items selected from catalogs from the catalog report and the process terminates in step78.

FIG. 3illustrates a flowchart detailing steps45and47ofFIG. 2for generating a database table(s), in accordance with embodiments of the present invention. In step302, a database administrator logs in to computing system10. In step304, the database administrator determines if a purchase type database table is available.

If in step304, the database administrator determines that a purchase type database table is not available then in step308, computing system10generates a purchase type database table in the database (i.e., memory device14). The purchase type database table comprises two columns (a purchase type column and a purchase type description column) as illustrated in table 1:

In step310, computing system10generates a company (entity) purchase type database table in the database (i.e., memory device14). The company (entity) purchase type database table comprises two columns (a company code column and a purchase code column as illustrated in table 2:

In step312, computing system10generates a catalog purchase type database table in the database (i.e., memory device14). The catalog purchase type database table comprises two columns (a catalog ID column and a purchase type column as illustrated in table 3:

In step314, the database administrator uses the database commands to associate the purchase type database table with the company (entity) purchase type database table and the catalog purchase type database table. The purchase type database table is designated as a parent table and the company (entity) purchase type database table and the catalog purchase type database table are each designated as a child table. Therefore a cascade delete option is enabled so that a deletion of rows in the parent table will automatically delete associated rows in the child tables. In step316, the database administrator uses a database command to insert predetermined purchase types and descriptions into the purchase type database table.

If in step304, the database administrator determines that a purchase type database table is available then in step318it is determined if additional purchase types are necessary. If in step318, it is determined that additional purchase types are necessary then step316is executed as described, supra. If in step318, it is determined that additional purchase types are not necessary then in step320is determined if existing purchase types should be deleted.

If in step318, it is determined that existing purchase types should be deleted then in step324, an existing purchase type row is deleted in the purchase type database table. In step328, computing system10automatically deletes the associated rows in the company (entity) purchase type database table and the catalog purchase type database table.

If in step318, it is determined that existing purchase types should not be deleted then in step322, existing purchase types are presented for viewing.

FIG. 4illustrates a flowchart detailing steps49,52, and54ofFIG. 2for generating/modifying an entity profile, in accordance with embodiments of the present invention. System2comprises an entity profile GUI for setting up entity details. The entity profile GUI may be modified in order to have a drop down selection box for allowing entity administrators to select the allowable purchase types for the entity. The flowchart inFIG. 4describes a workflow for an entity administrator to set up an entity profile and define the allowable purchase types based on the available purchase types defined in the purchase type database table.

In step402, an entity profile GUI is modified (e.g., a code change performed by an application developer) in order to allow entity administrators to generate allowable purchase types for a given entity based on the pre-defined purchase types stored in the purchase type database table (e.g., see table 1). In step404, an entity administrator logs into computing system10. In step410, the entity administrator navigates to an entity profile menu for configuring entity profiles. The entity administrator enables a create new entity profile menu item available under an entity configuration menu. In step408, a create entity profile GUI screen is presented to the entity administrator. The GUI will have all details related to the entity along with a multi select drop down box to allow the entity administrator to choose allowable purchase types for the entity. While the create entity profile screen is being displayed, software application18will dynamically connect to memory system via database commands. In step412, software application18retrieves all predefined purchase types from the purchase type database table and pre populates the allowable purchase types multi select drop down box on the create entity profile screen. In step414, the entity administrator enables a control key (i.e., on a keyboard) and clicks desired purchase types available in the allowable purchase type drop down box. In step416, the entity administrator fills in other details of the entity profile available in the create company profile screen. In step420, the entity profile is saved. In step422, the entity administrator selected purchase types in the allowable purchase type drop down box in the create entity profile screen are stored in the company purchase type table (i.e., see table 2). For example, when the entity administrator creates a new entity profile with an entity code of 001 and an entity name of xyz and allowable purchase types of INT, OUT, EXT, the entity purchase types data will be stored in the entity purchase types table as illustrated in table 2. In step428, the entity profile is presented to the entity administrator.

FIG. 5illustrates a flowchart detailing steps60,64, and68ofFIG. 2for generating/modifying a catalog profile, in accordance with embodiments of the present invention. System2comprises a catalog profile GUI for setting up catalog details. The catalog profile GUI may be modified in order to have a drop down selection box for allowing catalog administrators to select the allowable purchase types for the catalog. The flowchart inFIG. 5describes a workflow for a catalog administrator to set up a catalog profile and define the allowable purchase types based on the available purchase types defined in the purchase type database table.

In step502, a catalog profile GUI is modified (e.g., a code change performed by an application developer) in order to allow catalog administrators to generate allowable purchase types for a given catalog based on the pre-defined purchase types stored in the purchase type database table (e.g., see table 1). In step504, a catalog administrator logs into computing system10. In step510, the catalog administrator navigates to a catalog profile menu for configuring catalog profiles. The catalog administrator enables a create new catalog profile menu item available under a catalog configuration menu. In step508, a create catalog profile GUI screen is presented to the catalog administrator. The GUI will have all details related to the catalog along with a multi select drop down box to allow the catalog administrator to choose allowable purchase types for the catalog. While the create catalog profile screen is being displayed, software application18will dynamically connect to memory system via database commands. In step512, software application18retrieves all predefined purchase types from the purchase type database table and pre populates the allowable purchase types multi select drop down box on the create catalog profile screen. In step514, the catalog administrator enables a control key (i.e., on a keyboard) and clicks desired purchase types available in the allowable purchase type drop down box. In step516, the catalog administrator fills in other details of the catalog profile available in the create company profile screen. In step520, the catalog profile is saved. In step522, the catalog administrator selected purchase types in the allowable purchase type drop down box in the create catalog profile screen are stored in the catalog purchase type table (i.e., see table 3). For example, when the catalog administrator creates a new catalog profile with a catalog code of 001 and a catalog name of xyz and allowable purchase types of INT, OUT, EXT, the catalog purchase type data will be stored in the catalog purchase types table as illustrated in table 3. In step525, the catalog profile is associated with the entity profile. In step528, the catalog profile is presented to the catalog administrator.

FIG. 6illustrates a flowchart detailing steps69,70, and71-74ofFIG. 2for generating/modifying a user profile, in accordance with embodiments of the present invention. In step602, a user logs into computing system10. In step608, it is determined if a user profile exists.

If in step608, it is determined that a user profile does not exists then in step604, a create user profile GUI is displayed for the user. In step610, the user will specify and enter details related to the user such as, inter alia, user name, user address, user entity. In step612, software application18retrieves the entity purchase type database table and pre-populates default purchase types on the create user profile GUI. In step614, the user selects desired default purchase types available from the default purchase types in the create user profile GUI. In step618, the user profile is saved. In step620, the user is presented with a catalog shopping screen. In step624, software application18verifies the user's entity and default purchase type. In step628, software application18identifies associated catalogs available to purchase based on the user's entity and the default purchase type set on the user's profile. In step632, the user performs a purchasing process in order to purchase items.

FIG. 7illustrates a computer apparatus90(e.g., computing system10ofFIG. 1) used for performing a procurement requisition process, in accordance with embodiments of the present invention. The computer system90comprises a processor91, an input device92coupled to the processor91, an output device93coupled to the processor91, and memory devices94and95each coupled to the processor91. The input device92may be, inter alia, a keyboard, a mouse, etc. The output device93may be, inter alia, a printer, a plotter, a computer screen, a magnetic tape, a removable hard disk, a floppy disk, etc. The memory devices94and95may be, inter alia, a hard disk, a floppy disk, a magnetic tape, an optical storage such as a compact disc (CD) or a digital video disc (DVD), a dynamic random access memory (DRAM), a read-only memory (ROM), etc. The memory device95includes a computer code97. The computer code97includes algorithms (e.g., the algorithms ofFIGS. 2-6) for performing a procurement requisition process. The processor91executes the computer code97. The memory device94includes input data96. The input data96includes input required by the computer code97. The output device93displays output from the computer code97. Either or both memory devices94and95(or one or more additional memory devices not shown inFIG. 7) may comprise the algorithms ofFIGS. 2-6and may be used as a computer usable medium (or a computer readable medium or a program storage device) having a computer readable program code embodied therein and/or having other data stored therein, wherein the computer readable program code comprises the computer code97. Generally, a computer program product (or, alternatively, an article of manufacture) of the computer system90may comprise said computer usable medium (or said program storage device).

Still yet, any of the components of the present invention could be created, integrated, hosted, maintained, deployed, managed, serviced, etc. by a service provider who offers to perform a procurement requisition process. Thus the present invention discloses a process for deploying, creating, integrating, hosting, maintaining, and/or integrating computing infrastructure, comprising integrating computer-readable code into the computer system90, wherein the code in combination with the computer system90is capable of performing a method for performing a procurement requisition process. In another embodiment, the invention provides a business method that performs the process steps of the invention on a subscription, advertising, and/or fee basis. That is, a service provider, such as a Solution Integrator, could offer to perform a procurement requisition process. In this case, the service provider can create, maintain, support, etc. a computer infrastructure that performs the process steps of the invention for one or more customers. In return, the service provider can receive payment from the customer(s) under a subscription and/or fee agreement and/or the service provider can receive payment from the sale of advertising content to one or more third parties.