US20020133470A1 - Material ordering and reporting expediter (MORE) - Google Patents
Material ordering and reporting expediter (MORE) Download PDFInfo
- Publication number
- US20020133470A1 US20020133470A1 US09/760,341 US76034101A US2002133470A1 US 20020133470 A1 US20020133470 A1 US 20020133470A1 US 76034101 A US76034101 A US 76034101A US 2002133470 A1 US2002133470 A1 US 2002133470A1
- Authority
- US
- United States
- Prior art keywords
- purchase
- approval
- processor
- purchase document
- document
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Abandoned
Links
- 239000000463 material Substances 0.000 title abstract description 22
- 238000000034 method Methods 0.000 claims abstract description 18
- 238000012552 review Methods 0.000 claims abstract description 14
- 238000004590 computer program Methods 0.000 claims 1
- 230000008569 process Effects 0.000 abstract description 8
- 230000004044 response Effects 0.000 abstract description 5
- 238000012937 correction Methods 0.000 abstract description 2
- 238000012545 processing Methods 0.000 description 25
- 230000008520 organization Effects 0.000 description 9
- 230000008859 change Effects 0.000 description 4
- 238000013479 data entry Methods 0.000 description 4
- 238000012423 maintenance Methods 0.000 description 4
- 230000008439 repair process Effects 0.000 description 4
- 241000237970 Conus <genus> Species 0.000 description 3
- 239000003086 colorant Substances 0.000 description 3
- 238000009826 distribution Methods 0.000 description 3
- 230000000694 effects Effects 0.000 description 3
- 238000007726 management method Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000003825 pressing Methods 0.000 description 2
- 238000011160 research Methods 0.000 description 2
- 208000035871 PIK3CA-related overgrowth syndrome Diseases 0.000 description 1
- 230000009471 action Effects 0.000 description 1
- 238000007792 addition Methods 0.000 description 1
- 239000003708 ampul Substances 0.000 description 1
- 230000003466 anti-cipated effect Effects 0.000 description 1
- 238000013459 approach Methods 0.000 description 1
- 238000013497 data interchange Methods 0.000 description 1
- 230000007123 defense Effects 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 239000000383 hazardous chemical Substances 0.000 description 1
- 230000001771 impaired effect Effects 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 239000003921 oil Substances 0.000 description 1
- 239000003973 paint Substances 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 239000007858 starting material Substances 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- 238000010200 validation analysis Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/08—Payment architectures
- G06Q20/10—Payment architectures specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/08—Payment architectures
- G06Q20/10—Payment architectures specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems
- G06Q20/102—Bill distribution or payments
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/38—Payment protocols; Details thereof
- G06Q20/382—Payment protocols; Details thereof insuring higher security of transaction
- G06Q20/3821—Electronic credentials
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/04—Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
Definitions
- the present invention relates to a computer-based networked purchasing management system. More specifically, the Material Ordering and Reporting Expediter (MORE) is a procurement device that uses the FILEMAKER PRO 5® database to partially automate preparing and obtaining approvals on the numerous types of purchasing documents used by an organization or sub unit of an organization.
- MORE Material Ordering and Reporting Expediter
- An electronic transaction or purchasing system typically permits a user to conduct designated transactions or purchases electronically, which substantially improves efficiency and convenience to the user.
- Examples of electronic transactions or purchases include transactions conducted via computer networks, automated teller machines (ATM's), automated point-of-sale systems, automated library systems, and the like.
- Transactions and purchases conducted via computer networks may encompass a wide range of transactions, including exchanging information and data via a computer network popularly known as the Internet, e.g., to make a purchase from a vendor on the network.
- ATMs typically permit users to conduct financial transactions (such as withdrawals, transfers, deposits, and the like) vis-a-vis a financial institution in an electronic manner.
- Automated point-of-sale systems may be employed by merchants to permit users to purchase products or services using the users' electronic account
- automated library systems may be employed to permit library users to check out and return library materials.
- Other examples of electronic transaction or purchasing systems are readily available in popular literature and are not enumerated herein for brevity sake.
- electronic transaction or purchasing systems typically request the user to provide identification data to authenticate himself as the user authorized to approve the proposed transaction or transactions. If the user fails to provide the requested identification data, the proposed transaction or purchase is not authorized and will not be processed.
- the identification data may be required with each transaction.
- the Material Ordering and Reporting Expediter partially automates preparing various purchasing documents and obtaining approvals thereon. MORE may select subsets of the data and sort those subsets in a variety of ways for generating reports. Because the typical (signature) approval chain goes to the Division level (a specific sub unit of the organization), MORE is implemented on a Division-by-Division basis. MORE is written in FILEMAKER PRO 5® and is renewed (that is, recycles to 0 records) at the start of each fiscal year.
- the program automatically fills in part and vendor information based on a prior order (if any) of the same part number.
- JON Job Order Number
- MJO Master Job Order
- the program determines the approval chain based on rules specific to each Division.
- the program automatically e-mails the next Signatory in the chain.
- a Signatory approves the order
- an electronic signature is affixed to the purchase document.
- the program automatically e-mails the within-Division buyer, called a Processor in the MORE program, that the order is approved for purchase. Only then does the Processor print out a hard copy of the purchase document.
- a preferred embodiment of the present invention is a computer-based system for coordinating a purchase document and approving the purchase by one or more Signatories of an approval chain.
- the program of the current invention provides a means for creating the purchase document by a Requester.
- the program provides a means for notifying a Processor of the purchase document.
- the Processor reviews the purchase document for completeness and accuracy and upon finding the purchase document to be complete and accurate, the processor forwards the purchase document to the approval chain.
- the program provides a means for determining an approval chain for the purchase document.
- the program provides a means for sequentially notifying each of the Signatories in the approval chain and then each of the Signatories approve the purchase by clicking a button that affixes an electronic signature to the purchase document prior to automatically sending the purchase document to the next Signatory in the approval chain.
- the program provides a means for notifying the Processor of approval of the purchase document, after the final Signatory in the approval chain approves the purchase document.
- the program provides a means for printing a purchase document.
- the purchase document form contains information relevant to the purchase and the electronic signature of each of the Signatories in the approval chain.
- Requesters submit a request for a Material purchase by Creating a New Order that describes the item or items needed and then pressing a pale, yellow on-screen button that e-mails a “processor”, i.e. a within-Division buyer, to examine the order for completeness and route it for electronic signatures. (Each requester “in the system” has a default processor, but alternate processors are selectable.)
- the Processor is, in essence, the first approver. Only after the Processor has reviewed an Order and found it acceptable, is it routed to the Signatories for (electronic) signatures.
- the Program determines the approval chain (based on rules specific to each Division) and e-mails the first signatory in response to the processor clicking a large, green, on-screen button that the order is complete.
- Each signature category has an “In Box” button that finds all the order requests awaiting that person's review.
- Each Signatory has a unique password and an approval button with the Signatory's name on it that only that password operates.
- the program automatically e-mails the next Signatory in the chain, such as a supervisor or a financial overseer.
- the Processor receives automatic e-mail that the order is approved for purchase.
- Each signature category has a single reject button that all passwords in that category operate.
- the Signatory may explain why in the “Order Status Dialog Box”. Clicking the Reject button puts the rejecter's name next to the Reject button and automatically generates an e-mail to the Processor, with a cc: to the Requester, that the order is being rejected.
- Requesters may follow the progress of an order through the (within-Division) approval chain by checking the status of open orders. Received and canceled orders are not listed.
- the Order Status screen shows the complete approval chain, in order, date stamps when a Signatory responded, and uses color-coding to indicate who approved the order last.
- MORE can generate a number of canned reports that provide subtotals and totals by Requester, by Processor, by project, by JON, or by division. These reports can be for the entire fiscal year or for a specified time span within the year. The reports can be for a single Requester, Processor, Project, JON or Code, or for all in the category, or for a subset in the category. When a report has more than one individual/item per category, there are subtotals on an individual/item basis with a rollup for all in the selected set/subset.
- One object of a preferred embodiment of the present invention is to provide automatic e-mails that expedite the approval process and “In Box” buttons that prevent orders from being forgotten.
- Another object of a preferred embodiment of the present invention is to provide the Requester with a common interface regardless of the type of purchase that will be pursued. Details of the procurement system not pertinent to the Requester are handled by the Processor. For purchases from the same vendor with the same JON, the program allows easy entry of up to 20 items on a single buy.
- Another object of a preferred embodiment of the present invention is to provide a common interface that works for the Processor as well the Requester. Both have a consistency/uniformity of data entry that may have been lacking before. If all Requesters access the system to place their orders, undecipherable, hand-written requests become a thing of the past.
- Another object of a preferred embodiment of the present invention is to provide a computer-based system where if internet sites were used in the previous purchase of the same item, they are cited for easy referral to the current purchase. Easy referral means the user clicks a button that opens the browser and goes to that site.
- Another object of a preferred embodiment of the present invention is to provide a computer-based system with a link to the FedLog program.
- FedLog tells the user which supply centers in the Federal Supply System carry which items and how many they have in stock. MORE even presents how to create a custom screen in FedLog to display the information the user wants and only that information.
- a custom screen makes it easy to cut and paste between the two programs.
- FIG. 1A is a pictorial representation of the top half portion of the Item 1 screen of a preferred embodiment of the present invention, which includes help features and explanatory text of a preferred embodiment of the present invention.
- FIG. 1B is a pictorial representation of the bottom half portion of the Item 1 screen of a preferred embodiment of the present invention, which includes help features and explanatory text of a preferred embodiment of the present invention.
- FIG. 2 is a pictorial representation of the of the Order Status Screen of a preferred embodiment of the present invention, which includes help features and explanatory text of a preferred embodiment of the present invention.
- FIG. 3A is a pictorial representation of the top half portion of the Signature Buttons screen of a preferred embodiment of the present invention, which includes help features and explanatory text of a preferred embodiment of the present invention.
- FIG. 3B is a pictorial representation of the bottom half portion of the Signature Buttons screen of a preferred embodiment of the present invention, which includes help features and explanatory text of a preferred embodiment of the present invention.
- FIG. 4 is a pictorial representation of the left side portion of the Processor Page screen of a preferred embodiment of the present invention, which includes help features and explanatory text of a preferred embodiment of the present invention.
- FIG. 5 is a flowchart illustrating the processing steps of creating an order using the Material Ordering and Reporting Expediter in accordance with a preferred embodiment of the present invention.
- FIG. 6 illustrates computer systems in a network that are configured in accordance with a preferred embodiment of the present invention.
- FIG. 7 illustrates a simplified block diagram of the Material Ordering and Reporting Expediter, configured in accordance with a preferred embodiment of the present invention.
- the Material Ordering and Reporting Expediter (hereinafter “MORE”) program partially automates the preparation of purchase order documents. MORE may select subsets of the data and sort those subsets in a variety of ways for generating reports. Purchasing is expedited by automatic data fill-in based on a prior order, if any, of the same part number, automatic validation of the Job Order Number, and program determination of the approval chain with automatic e-mailing to the next Signatory when approval is granted. Electronic Signatures are affixed when a Signatory clicks the applicable password-controlled button.
- the utility will be described as it pertains to purchasing documents used at the Naval Air Warfare Center Weapons Division at China Lake, CA and Point Mugu, Calif. These documents are the 6-part short stub, 6-part long stub, a worksheet for a government Bankcard purchase, the Pt. Mugu site Hazardous Materials (hereinafter “HazMat”) Bankcard purchase, and the China Lake site Long Stub.
- the Bankcard worksheet is generally suitable for China Lake Small Procurement Electronic Data Interchange (hereinafter “SPEDI”) purchases.
- the Material Ordering and Reporting Expediter is a FILEMAKER PRO 5.0® database that partially automates preparing purchase order documents, such as:
- the program accommodates entry of the SPEDI catalog number in lieu of a part number.
- SPEDI costs may be included in reports generated by MORE.
- the Bankcard Work Sheet may be used for a hard-copy document of the SPEDI purchase.
- Data may be organized, that is filtered and sorted, by Processor (the person who processes the order, either a Credit Card Holder or someone who handles stubs), Requester, Job Order Number, Project, Organization Code, time span, etc. Combinations of the preceding are also possible.
- Processor the person who processes the order, either a Credit Card Holder or someone who handles stubs
- Requester Job Order Number
- Project Organization Code
- time span etc. Combinations of the preceding are also possible.
- the ability to organize data and to total and subtotal the data on that basis allows for a number of useful reports to be generated.
- various colors are used to assist the user in identifying the various choices available on a screen and information required by the program.
- the active database “OnOrder”, contains all orders submitted in a current fiscal year (FY). This database is used to enter new orders and to review existing orders. As a new fiscal year approaches, a new, empty database is created for the new fiscal year. For example, when used in government organizations, on about October 1, the active “OnOrder” database is renamed “OnOrderFY,” where FY represents the last two digits of its fiscal year. At the same time, the new, empty database is made available under the name “OnOrder.”
- Another database contains information on items previously ordered.
- the records in “Stock” are from the current fiscal year and all prior years that the MORE program existed.
- a Requester enters a part number block 20 in a new order, it is searched in the Stock database, and if a match is found, the information in “Stock” is automatically entered in the new order.
- the Requester clicks an on-screen button 21 that e-mails the Processor that the Requester has an order pending.
- the Processor is the person who checks the order for completeness, starts the e-mail signature chain, prints the order, and submits the paperwork to supply or makes the credit card purchase.
- the Requester's name, a brief description of the order, and the order number are included in the e-mail message.
- the Processor chooses one of two on-screen buttons to respond.
- a button 90 e-mails the Requester that the Processor found no unresolvable problems and the order is being electronically routed for signatures.
- a button 92 e-mails the Requester that a problem with the order exists.
- the Processor is expected to describe the problem in the “Order Status Dialog Box” 94 prior to clicking the “problem” button 92 . If there is a problem, after the Requester fixes it and/or provides clarifying information in the Order Status Dialog Box 94 , the Requester again presses the on-screen button 21 to notify the Processor to process the order. If the Order Status Dialog Box 94 is used to keep a running dialog, the Requester may start each entry with that day's date.
- the program When the Processor e-mails the Requester that the order is acceptable, the program simultaneously e-mails the first signatory, for example a Section Head or Branch Head. That e-mail includes a brief description of the order and the order number, and requests that the Signatory review and respond to the order by approval or rejection. If the signatory chooses to reject the order, the signatory may give the reason why in the Order Status Dialog Box 94 . Clicking a red Reject button 60 , 61 , 62 , 63 , 64 , 65 and 66 initiates e-mail to both the Processor and the Requester.
- the first signatory for example a Section Head or Branch Head. That e-mail includes a brief description of the order and the order number, and requests that the Signatory review and respond to the order by approval or rejection. If the signatory chooses to reject the order, the signatory may give the reason why in the Order Status Dialog Box 94 . Clicking a red Reject button 60 , 61 , 62 , 63
- a check mark is placed next to the signatory's name on the approval button; the signatory's electronic signature is affixed to the form.
- An e-mail to the next signatory such as the Division's Budget Analyst, is automatically generated. Similar e-mails are generated as the order goes from the Budget Analyst block 69 to the Division Head, and from the Division Head to a funds overseer, if any.
- the software is programmed to know the last stop in the approval chain, and when the last signatory approves, the program automatically generates an e-mail to the Processor that approval to purchase has been granted.
- FILEMAKER PRO® To efficiently use the MORE program, a user must first identify himself to FILEMAKER PRO®. Recognized MORE Users have their name added to a list on the opening screen; the user then scrolls this list to select his/her name. However, if the user enters his/her name into FILEMAKER PRO®'s “User Name” exactly as the MORE program has it, no scrolling will be needed. In general, MORE uses the user's name as it appears in Microsoft Outlook's Address Book. The format is: Last Name, First Name Initial. There is only one (1) comma, and there is no period after the Initial. For example, “Smith, John L” might be an entry.
- the user After the user has the precise name (no comma between First Name and Initial), the user opens the user's copy of FILEMAKER PRO® on the user's computer. From the pull-down menu bar near the top of the screen, the user selects the Edit pull-down menu. At the bottom of the list, Preferences is selected, then Application. In the User Name box, the user enters the user's name.
- Double clicking the Desktop starter file icon launches FILEMAKER PRO® and opens the Material Ordering and Reporting Expediter (MORE) “MainMenu.fp5” file.
- This initial screen asks the user to verify identifying information, for example Name block 22 , Code block 23 , Phone Number block 24 , etc. If the user name is not highlighted when the file opens, the user scrolls the list to the user name.
- FIGS. 1A and 1B which illustrate the MORE Item 1 screen
- three other options are available under “Select the Next Step” 25 : “New Order for this Project” 54 , “. . .Next Step” choice, “Duplicate this Order” 55 , also added to the “. . . Next Step” choices, and “Cancel this Order” 56 .
- FIGS. 1A and 1B display the “Item 1” screen. That screen and the other four (4) screens mentioned so far are choices on the “GO TO” navigation button 26 toward the upper right of the Item 1 screen. This pattern is repeated on all five (5) of these screens. As noted earlier, various colors may be incorporated into each screen to assist the user. For example, in a preferred embodiment of the present invention, the “GO TO” navigation button is green.
- the function of each of the main screens of interest may be summarized as follows:
- Item 1 Requesters perform data entry for the 1st item to be purchased, including JON block 27 , justification block 28 , and Vendor block 29 . Processors validate entries on this screen;
- Items 2-20 Requesters enter items 2-20, if any, to be purchased on Credit Card 97 , SPEDI 98 , or Long Stub 99 buys. Processors review the entries on the Items 2-20 screen;
- Signature Buttons Referring to FIGS. 3A and 3B, Signatories review a summary of the order and respond (approve or reject) by clicking a button with their name. These button clicks generate automatic e-mails, and if approval is given, affix electronic signatures.
- Signature buttons include buttons 68 - 78 and Reject buttons include buttons 60 - 66 ;
- Order Status Anyone may view a color-coded representation of where in the approval chain orders are. If approved for purchase, date ordered and date delivered may be shown; and
- Reports Anyone may generate any of a variety of reports by clicking a button and following instructions given in pop-up information boxes.
- an information box pops up. It instructs a user to “Click the orange Requester button and follow its instructions”.
- the program will find all orders the user has submitted this fiscal year that have not been marked as received or canceled, i.e. that are still active.
- Each order number has a background color indicating its status: yellow indicates active, red indicates canceled, gray indicates received.
- the record currently selected will have a vertical, black bar on the left side of the screen, just to the right of the gray Status Area. The user clicks the upper or lower page in the spiral-bound flip book in the upper left to move to the record/order of interest. If the order vehicle is a long stub and the words “Click me for Supply status” appear on the far right of the line, simply single click anywhere on that text and follow the instructions in the information box that pops up to see the status of the order within the Supply Department.
- the Requester needs to correct the problem or provide clarifying information. In either case, the Requester clicks the “GO TO” button 26 and then selects “GO TO Item 1” to access that layout.
- the Requester should use the on-screen Order Status Dialog Box 94 , illustrated in FIG. 1B, to describe the action/response and then click the pale-yellow, on-screen button 21 , illustrated in FIG. 1A, to e-mail the Processor to process the order.
- the Requester should then select the “New Order for this Requester” option in the “Select the Next Step” radio buttons.
- the software creates a new record and places the cursor in the Part Number field block 20 . Then, the Requester may paste in the part number and let the software automatically fill-in many of the fields. If the item is not found in the OnOrder database, the Requester may search the Stock database by pressing the green “Search Stock” button 32 . Then, the Requester follows the same procedure as searching the OnOrder database, but when finished searching, clicks the “Return to OnOrder” button. If the search succeeded and the Requester copied the part number to the clipboard, after “New Order for this Requester” is selected, the part number is pasted. If the search did not succeed, the Requester must perform all the data entry.
- the first entry on the “Item 1” screen, illustrated in FIGS. 1A and 1B, is the Manufacturer's Part Number block 20 .
- This entry triggers a lookup in the Stock database to see if that item has been ordered before. If so, the program will fill in those fields expected to be the same, namely the Nomenclature block 33 , Unit of Issue block 34 , Unit Cost block 35 , National Stock Number block 36 , and Distribution Code block 37 .
- the program will also fill in the Color, Size, Manufacturer, and Vendor information. The fill in should occur very quickly.
- the Requester reviews the “Item 1” screen to fill in and/or change any fields that need it, including those that were filled in by the program.
- the program when the user enters the 12-character Job Order Number (JON) block 27 , the program will look it up in a Master Job Order (MJO) file to validate it. The program checks that the JON is in the MJO file, that the JON is open on this date, that the JON has a positive funds balance, and that the JON is open for purchasing material and for labor. This information is indicated to the right of the JON.
- the “Expires” field 40 will contain either the expiration date of the funds (which confirms that the JON is in the file and will tell the user if it is open or not) or the words JON NOF, where NOF means Not On File. A blank in the balance field indicates a positive balance.
- a red “$-” 41 in the balance field means the JON is “in the red”.
- the Material field (Mat'l) 42 is either Y or N, for Yes or No on being open for material.
- the Labor field follows the same convention. If the JON fails any of these checks, the user will be allowed to continue making entries, but the Processor will not process the submittal until the deficiency is corrected or a satisfactory JON is provided.
- Part Number block 20 Manufacturer's Part Number. This field should be the 1st entry—triggers a lookup in the Stock.fp5 database to automatically fill in several other fields;
- National Stock Number (NSN) block 36 The 13-digit number issued to national/federal stock items. The format is: nnnn-nnn-nnnn. This field is often left blank;
- Distribution Code block 37 This 2 or 3-character code designates the source of supply for NSN items. The correct code is found when using one of the computer databases for federal stock items, e.g. FedLog.
- Nomenclature block 33 A brief description of the item. The first word should be very general/high level and the words that follow more descriptive. This entry is limited to about 44 characters.
- Quantity block 38 The quantity of this item the Requester wishes to order
- Unit of Issue block 34 The Requester selects the correct 2-character abbreviation from the list that appears when tabbing or clicking into the field;
- Unit Cost block 35 The cost per unit of issue. The program will multiple the Unit Cost by the Quantity to determine the extended cost;
- Job Order Number block 27 The organizational JON
- Required Delivery Date block 44 a date (mm/dd/yy) is entered when the Requester needs the item; the item may be especially important for end-of-year purchases. If a date is not entered, the software creates this date when the order is printed. It is the date of printing+30 days;
- Manufacturer block 45 The name of the manufacturer of the part to be ordered.
- Description/Notes block 46 List special features here, e.g. technical, electrical, and physical characteristics. The user should try not to repeat the same words listed in the part number field. This field is large to allow for the listing of all the special features. If the purchase is via a long stub or if the type exceeds the space on the appropriate form, the program will print the entire description on a separate sheet (or sheets)—up to 3 pages;
- Vendor Name block 29 Vendor Addr block 49 , Vendor Phone block 50 , Vendor POC block 51 —The user should list the suggested sources of supply here. Sometimes a vendor has a different part number than the manufacturer. If so, the user may list the vendor's part number next to the name to eliminate confusion. If the total cost is more than $2500, the user may furnish two or more sources. Make entries in the name, address, phone number, and point of contact fields if known. A separate page may help eliminate confusion on a crowded stub. Therefore, the vendors are automatically printed on the separate, extended description sheet;
- Order Status Dialog Box block 94 A place for the Requester and Processor to conduct a dialog concerning the status of the order.
- Internet Addresses block 52 Universal Resource Locators (URLs) give Internet addresses for potential suppliers. Typically, these correspond to entries in the Vendor Name. They are treated as hyperlinks, and clicking the “GO TO” buttons 26 to their left will launch a browser (if necessary) and go to the designated web site.
- URLs Universal Resource Locators
- the “Items 2-20” screen is used for those credit card and Long Stub orders that are for multiple items from the same vendor (and same JON). This screen is accessed by clicking the green, on-screen “GO TO” button 26 and then selecting “GO TO Items 2-20”. As the following Table 1 shows, the seven fields on “Items 2-20” have the same definition as those seven fields on the “Item 1” screen. TABLE 1 “Items 2-20”Fields Field Description Part Number Same definition as the Item 1 Field “MFG Part #”. Nomenclature/Name Same definition as the Item 1 Field “Nomenclature”. (Extended) Description Same definition as the Item 1 Field “(Extended) Description/Notes”.
- the Requester clicks the pale-yellow on-screen button 21 to e-mail the Processor that an order is pending. If the usual Processor is not available, the Requester may use the drop-down list above the e-mail button to select a different processor for an order. If the order is urgent, the Requester clicks the red check box 57 to the right of the required delivery date to have an “URGENT” statement included at the beginning of the e-mail message. If the Requester does not enter a part number or a National Stock Number (NSN), and does not attempt to describe the item, the program will not issue the e-mail, but will request either a part number or further description of the item.
- NSN National Stock Number
- the button 54 will be useful when ordering many parts for a specific project, especially if the parts are federal supply, which requires a separate short stub for each part.
- the “Duplicate this Order” button 55 When creating a new order, there is a third option: the “Duplicate this Order” button 55 . A new record is created with all the Requester entries from this record duplicated. This method will be useful if the changes required are less than making all the non-automatic entries from scratch.
- the “Cancel this Order” button 56 is utilized by the Requester to abort an order.
- the Signature Buttons screen contains several sets of password-controlled buttons 68 through 78 that signatories click to affix their electronic signature to the appropriate form. Only the individual signer will have the password for his or her button 68 through 78 . The password given to “Stand-ins” will operate the button 68 through 78 , but the signature on forms will be preceded by the Stand-in's initials and the word “for”. On the Signature Buttons screen, the Stand-in's full name will appear as the Approver rather than the permanent signatory's name.
- Right above the block of buttons is a condensed version of the order information. That is intended to be sufficient for the signers to decide whether to approve or reject the order.
- the Processor may go to the Signature Buttons screen to enter data into fields indicating who placed the order, when it was placed, and when delivery is expected. Clicking an on-screen button automatically e-mails this information to the Requester. The date ordered is displayed on the Order Status screen.
- the Processor may go to the Signature Buttons screen to enter the quantity received, actual cost, received date, and the recipient. Clicking an on-screen button automatically e-mails this information to the Requester. When this button is clicked the program changes the order status from “active” (yellow background color on the order number e.g. order 59 ) to “received” (gray background color on the order number e.g. order 58 ). The date delivered is displayed on the Order Status screen under “Date Rec'd”.
- the Processor clicks the green “GO TO” button and then selects “GO TO Processor Page” to go to the “Processor Page” layout, as illustrated in FIG. 4.
- This layout has the same “GO TO” button 26 to easily navigate to the “Item 1” screen, to “Items 2-20”, to the “Signature Buttons”, to the “Order Status”, and to the “Reports” screen.
- the Requester's name and order are repeated on the Processor Page for the processor to know what order is being processed. Any problems the Processor sees should be described in the Order Status Dialog Box 94 .
- the Reports screen is used for generating a variety of reports.
- a three-line format is used for each order that is reported.
- a row of buttons along the top left of the screen allows the user to select and sort data by Processor, by Requester, by Job Order Number, by Code, and by project.
- the Processor is responsible for verifying and/or filling in many fields. Many of these fields, which are related to stub purchases are selectable from drop-down lists. For example, the Unit of Issue 34 contained in columns 23-24 of both the Long Stub and the Short Stub is an abbreviation of the types of units under which material is issued. Table 2 presents typical examples of 2-character abbreviations from the list that appears when tabbing or clicking into the field.
- the 2 or 3-character Distribution Code 37 designates the source of supply for NSN items. In the Defense Logistics Agency Customer Assistance Handbook it is called the Routing Identifier Code (RIC). NAWCWPNS chooses from the “NAVY COG” column. Several popular choices are: 9N Def. Sup. Cntr, Columbus (electronics) 9Q GSA, DC 9G Def. Sup. Cntr, Richmond VA 9Z Def. Industrial Sup. Cntr
- Priority is a 2-digit code related to MILSTRIP Force/Activity Designators (F/AD). RDT&E in general, and Code 522 in particular tend to use F/AD IV, encompassing priorities 07/03/14. The lower the Priority Number the quicker the response. Specific projects may be authorized a lower-numbered F/AD.
- [0111] 14 indicates routine requirements, replacement of stock, or scheduled maintenance.
- Designator A is requirements for material without which the activity concerned is unable to perform an assigned mission, or to eliminate an existing work stoppage of the repair of mission-essential equipment
- Designator B is requirement for material, the lack of which is impairing the operational capability of the activity concerned, or is anticipated to cause work stoppage in performing maintenance of mission-essential equipment
- Designator C is routine requirements, replacement of stock, scheduled maintenance.
- Table 4 presents typical Project Codes used in a preferred embodiment of the present invention. Each position of this 3-character code is sub-coded.
- TABLE 4 1st Position 2nd Position 3 rd Position A Aircraft & ground A Allowance-Self Support (COSAL, 0 CASREP/ support equip etc.) Increase Range NMCS F Fleet Ballistic K Repair-Unscheduled 1 Work Stoppage Missile Program (Required for repair of “in-use” (FBM) (SSBNs and equipment.) Ass) (FBM) L Other Fleet Units L Repair-Scheduled 2 Restricts (includes (Required for use in formal repair operation Oceanographic Units/ program.) Detachments) P CNO Special M Overhaul-Unscheduled 3 Shortage (not Projects/Elements (Required for overhaul of“down” fully equipped) equipment.) S Repair and N Overhaul-Scheduled 4 Management Overhaul Shops (other (Required for use in formal Program than AMD) overhaul programs.) T Experimental
- Table 5 presents examples of frequently used codes for Federal Stock. TABLE 5 Advice Codes for Federal Stock Code Explanation 2B Only requested item will suffice. Do not substitute/interchange. Also applies to “Obsolete”/“Inactivated” item previously rejected with Status Code CJ. 2C Do not backorder. Reject any unfilled quantity not available to meet SDD/RDD. Suitable substitute acceptable. 2J Do not substitute or backorder any unfilled quantities. 2L Entry in quantity field exceeds normal demands; however, this is a confirmed valid requirement. 2N Item required in one continuous length as expressed in rp 25-29 and unit of issue in rp 23-24. No other configuration is acceptable and/or multiples of the unit pack are not acceptable. 2P Initial requirement certification.
- Requested item is a mandatory turn-in repairable required for initial outfitting/installation or increased allowance/stockage objective; therefore, no unserviceable unit is available for turn-in. Requires memo explaining why we have no turn-in. J1 Requester authorizes buyer to pay up to 10% higher price without calling for approval.
- an order's status is updated after a credit card order has been placed or a long or short stub has been sent to Supply.
- the Processor may access the necessary fields to update the order's status by opening the MORE Program, navigating to the “Signature Buttons” screen illustrated in FIGS. 3A and 3B, and selecting the appropriate order number. If the purchase is a credit card buy, the user enters the name of the individual who bought the item, the date the order was placed, and the estimated date of delivery. If there was a change in price or a different vendor chosen, the user may enter this new information also. If it is a long or short stub, the user enters the date the stub was sent to Supply and the estimated date of delivery.
- this information is entered on the Signature Buttons screen.
- the user enters the quantity received, the total price, and the date received.
- the requester will be notified of this change in status when the “E-mail Order Rec'd” button is clicked. Clicking the “E-mail Order Rec'd” button changes the background color of the MORE Order Number from yellow (active) to gray (received). If the user clicked the “Cancel This Order” button 56 on the Item 1 screen, the background color will be red to indicate cancellation. If the order has been cancelled for any other reason, the buyer can change the More Order Number to red by selecting the “Red” circle button on the Signature Buttons page.
- Processors have three reports available immediately after logging on to the MORE program. Those reports are 1) Slow Review, which displays a list of orders not yet reviewed; 2) Slow Order, which displays a list of orders reviewed but not yet ordered; and 3) Late Delivery, which displays a list of orders placed but past the delivery due date. If more detailed information is required on a particular order, the user clicks the MORE Order Number and then the desired display screen is accessed by clicking on the green “GO TO” navigation button.
- each display screen needed in processing MORE orders has a drop down entry on the green “GO TO” navigation button. These choices make it easy to move around in the program.
- Item 1 displays the first screen, illustrated in FIGS. 1A and 1B, of the order. This screen is used by the Requester to enter ordering data for the first line item. If more than one line item is ordered from the same vendor, the Requester goes to Items 2-20. Items 2-20 screen (not shown) displays the screen where items 2 through 20 can be entered or reviewed. This includes the part number, description, manufacturer, unit of issue, quantity and u nit cost fields.
- Line item 1 is copied to this second screen and the program adds the shipping charges to the extended costs to calculate the total cost and enter it on the Item 1 screen.
- Signature Buttons screen illustrated in FIGS. 3A and 3B, displays the Signatory buttons 68 through 78 and is used by the signatories to review and then to approve or reject an order. This screen is also used by the processors for updates such as ordering and receiving dates and price changes.
- Order Status screen illustrated in FIG. 2, provides a Buyer/Processor or Requester the most current approval status of each active order. The user selects the Processor name button 110 or Requester name button 112 , types the name for which the user wishes to view orders and then clicks “Continue”.
- the Reports screen (not shown) generates reports based on the Processor/Buyer, Requester, Job Order Number, (Organization) Code, and project fields selected.
- the report can be a combination of fields and for a specific time frame.
- the Processor Page screen, illustrated in FIG. 4 allows the user to select the type of purchase, fill in items such as the Fund Type, e-mail the Requester, and print the appropriate form(s).
- Help Buttons are available on most pages and can be identified by the green question mark (?) inside the green square buttons. These buttons offer additional information the user may need to determine the correct response for the corresponding block. If there is a list, the user clicks on the item needed and it will appear in the block.
- FIG. 5 there is shown a flowchart illustrating the processing steps 120 - 154 which create an order using the Material Ordering and Reporting Expediter in accordance with a preferred embodiment of the present invention.
- Processing steps 120 - 124 require the requester to enter a password, verify his/her name, select “create a new order” on the Main Menu, and then enter a part number. If the part has previously been ordered, MORE inserts the required information from a previous order (processing step 128 ), otherwise the requester must enter this information (processing step 130 , which includes, for example JON block 27 , justification block 28 , and Vendor block 29 .
- the Requester clicks “GO TO” button 26 and then selects “GO TO Items 2-20” prior to inputting the information for items 2-20 (processing steps 134 and 136 ). If special instructions are required for the order, the Requester enters these instructions and/or remarks into the “Order Status Dialog Box” 94 (processing step 140 ). The Requester e-mails the Processor to process the order by clicking on-screen button 21 (processing step 142 ), the processor receives and reviews the order (processing step 144 ), approves the order and sends the order to the first signatory in the approval chain (processing step 154 ).
- the Processor When the order is incomplete or there is an error in the order, the Processor notifies the Requester of the need for additional information to complete the order or to correct the order (processing step 148 ). The Requester makes the necessary additions and/or corrections to the order (processing step 152 ) and returns the order to the Processor for review.
- FIG. 6 illustrates computer files 160 , 162 , 164 , 166 and 168 in a network configured in accordance with a preferred embodiment of the present invention.
- Computer file 160 represents the aggregate of orders for the current fiscal year
- file 162 represents the database file with user information
- file 164 represents the main menu for the material ordering and reporting expedite
- file 166 represents the database with job order number information
- file 168 represents the stock database which contains information on all items ordered in the MORE program.
- FIG. 7 illustrates a simplified block diagram flow chart of the Material Ordering and Reporting Expediter, configured in accordance with a preferred embodiment of the present invention.
- the requester enters the main menu then proceeds to the item one menu of FIGS. 1A and 1B and provides the required information (processing step 126 ).
- the Requester provides the required information using the items 2-20 screen (processing step 172 ).
- the Requester may provide an extended description of the item to be ordered by utilizing block 46 (processing step 174 ).
- the Requester may provide a sole source statement for the item to be ordered by utilizing block 47 (processing step 176 )
- a sole source statement justifies ordering the item from a single source without price competition from multiple vendors. It is generally used when a vendor has an item which is uniquely configured for a particular application.
- the Requester may also provide an urgency statement for the item to be purchased utilizing block 48 (processing step 178 ).
- the Requester may visit a single vendor Web Site or multiple vender Web Sites (processing step 182 ).
- the Requester may view the status of his/her order from the screen illustrated in FIG. 2 (processing step 180 ).
- the Processor page, used by the processor to purchase the item, is illustrated in FIG. 4 (processing step 190 ).
- the signature screen which sets forth the signature chain required for approval to purchase the item is illustrated in FIGS. 3A and 3B (processing step 194 ).
- the Material Order and Reporting Expediter also allows for the generation of reports for items being purchased (processing step 192 ) and includes a screen for viewing purchases within a division (processing step 180 ).
Abstract
The Material Ordering and Reporting Expediter (MORE) provides a method and apparatus which partially automates and assists the various members of an order and approval chain in preparing various purchasing documents. A Requester initiates the process by entering a part number and completing a purchase document and forwards the purchase document to a Processor for acceptance or rejection. The Processor reviews the purchase document and accepts or rejects based upon the completeness and accuracy of the purchase document. If the purchase document is rejected, it is sent back to the Requestor for correction. If the purchase document is accepted, the Processor notifies the Requester and the purchase document is placed in the approval chain for consideration and response. Each member of the approval chain is called a Signatory. Each Signatory approves the purchase document by affixing an electronic signature and rejects the purchase document by clicking a “Reject” button, which initiates notification of rejection to the Processor and the Requester. As each Signatory approves the purchase document, the request is automatically sent to the next member in the approval chain. After the last Signatory approves the purchase order, the Processor receives notification of approval and fills the purchase order.
Description
- [0001] The invention described herein may be manufactured and used by or for the government of the United States of America for governmental purposes without the payment of any royalties thereon or therefor.
- 1. Field of the Invention
- The present invention relates to a computer-based networked purchasing management system. More specifically, the Material Ordering and Reporting Expediter (MORE) is a procurement device that uses the FILEMAKER PRO 5® database to partially automate preparing and obtaining approvals on the numerous types of purchasing documents used by an organization or sub unit of an organization.
- 2. Description of the Related Art
- Electronic transaction and purchasing systems are well known. An electronic transaction or purchasing system typically permits a user to conduct designated transactions or purchases electronically, which substantially improves efficiency and convenience to the user. Examples of electronic transactions or purchases include transactions conducted via computer networks, automated teller machines (ATM's), automated point-of-sale systems, automated library systems, and the like. Transactions and purchases conducted via computer networks may encompass a wide range of transactions, including exchanging information and data via a computer network popularly known as the Internet, e.g., to make a purchase from a vendor on the network. ATMs typically permit users to conduct financial transactions (such as withdrawals, transfers, deposits, and the like) vis-a-vis a financial institution in an electronic manner. Automated point-of-sale systems may be employed by merchants to permit users to purchase products or services using the users' electronic account, and automated library systems may be employed to permit library users to check out and return library materials. Other examples of electronic transaction or purchasing systems are readily available in popular literature and are not enumerated herein for brevity sake.
- To enhance security to the user's account, electronic transaction or purchasing systems typically request the user to provide identification data to authenticate himself as the user authorized to approve the proposed transaction or transactions. If the user fails to provide the requested identification data, the proposed transaction or purchase is not authorized and will not be processed. The identification data may be required with each transaction.
- In the prior art, users are typically required to manually enter the identification data into the electronic transaction system for authentication. Typically, the entry of identification data involves typing in a password on a numeric keypad or on a keyboard. The identification data is then compared with data previously stored within the electronic transaction or purchasing system, and authentication is satisfied when there is a match. As mentioned previously, the transaction or transactions proposed will not be allowed to proceed if there is no match. More recently, electronic signatures have been used to verify the approval of a transaction or purchase and to act as a security device. Typical examples of the use of electronic signatures can be found in U.S. Pat. No. 5,917,913 issued to Wang on Jun. 19, 1999 and U.S. Pat. No. 6,058,483 issued to Vennel on May 2, 2000.
- The Material Ordering and Reporting Expediter (MORE) partially automates preparing various purchasing documents and obtaining approvals thereon. MORE may select subsets of the data and sort those subsets in a variety of ways for generating reports. Because the typical (signature) approval chain goes to the Division level (a specific sub unit of the organization), MORE is implemented on a Division-by-Division basis. MORE is written in FILEMAKER PRO 5® and is renewed (that is, recycles to 0 records) at the start of each fiscal year.
- Automation occurs at various steps in the process. The program automatically fills in part and vendor information based on a prior order (if any) of the same part number. When a Job Order Number (JON) is entered, the program looks it up in a Master Job Order (MJO) file to validate its existence and suitability for this purchase. The program determines the approval chain based on rules specific to each Division. Once the signature cycle is started, the program automatically e-mails the next Signatory in the chain. When a Signatory approves the order, an electronic signature is affixed to the purchase document. When the last Signatory approves the order, the program automatically e-mails the within-Division buyer, called a Processor in the MORE program, that the order is approved for purchase. Only then does the Processor print out a hard copy of the purchase document.
- MORE has 3 classes of users:
- 1) Requesters: people who need something—a tool, a part, a contract—to complete a task.
- 2) Processors (i.e. within-Division buyers)
- 3) Signatories: supervisors and financial personnel with approving authority.
- A preferred embodiment of the present invention is a computer-based system for coordinating a purchase document and approving the purchase by one or more Signatories of an approval chain. First, the program of the current invention provides a means for creating the purchase document by a Requester. Next, the program provides a means for notifying a Processor of the purchase document. The Processor reviews the purchase document for completeness and accuracy and upon finding the purchase document to be complete and accurate, the processor forwards the purchase document to the approval chain. Next, the program provides a means for determining an approval chain for the purchase document. Next, the program provides a means for sequentially notifying each of the Signatories in the approval chain and then each of the Signatories approve the purchase by clicking a button that affixes an electronic signature to the purchase document prior to automatically sending the purchase document to the next Signatory in the approval chain. Next, the program provides a means for notifying the Processor of approval of the purchase document, after the final Signatory in the approval chain approves the purchase document. Next, the program provides a means for printing a purchase document. The purchase document form contains information relevant to the purchase and the electronic signature of each of the Signatories in the approval chain.
- The general flow of the program is described below with the likely user class listed in parenthesis.
- Creating a New Order (Requester):
- Requesters submit a request for a Material purchase by Creating a New Order that describes the item or items needed and then pressing a pale, yellow on-screen button that e-mails a “processor”, i.e. a within-Division buyer, to examine the order for completeness and route it for electronic signatures. (Each requester “in the system” has a default processor, but alternate processors are selectable.)
- Responding to Orders Pending Approval (Processor):
- The Processor is, in essence, the first approver. Only after the Processor has reviewed an Order and found it acceptable, is it routed to the Signatories for (electronic) signatures.
- Responding to Orders Pending Approval (Signatory):
- The Program determines the approval chain (based on rules specific to each Division) and e-mails the first signatory in response to the processor clicking a large, green, on-screen button that the order is complete. Each signature category has an “In Box” button that finds all the order requests awaiting that person's review.
- Each Signatory has a unique password and an approval button with the Signatory's name on it that only that password operates. As each Signatory approves an order (thereby affixing an electronic signature), the program automatically e-mails the next Signatory in the chain, such as a supervisor or a financial overseer. When the last person in the chain approves the order, the Processor receives automatic e-mail that the order is approved for purchase. Each signature category has a single reject button that all passwords in that category operate. When rejecting an order, the Signatory may explain why in the “Order Status Dialog Box”. Clicking the Reject button puts the rejecter's name next to the Reject button and automatically generates an e-mail to the Processor, with a cc: to the Requester, that the order is being rejected.
- Checking the Status of Open Orders (Requester and Processor):
- Requesters (and Processors) may follow the progress of an order through the (within-Division) approval chain by checking the status of open orders. Received and canceled orders are not listed. The Order Status screen shows the complete approval chain, in order, date stamps when a Signatory responded, and uses color-coding to indicate who approved the order last.
- Making the Purchase (Processor):
- When the Processor receives the “approved for purchase” e-mail, the Processor clicks a single button that prints out the form appropriate for this purchase. Electronic signatures of those who approved will be affixed. At this point, the purchase follows established rules for an organization or division.
- Generating a Report (Requester, Processor, Signatory):
- MORE can generate a number of canned reports that provide subtotals and totals by Requester, by Processor, by project, by JON, or by division. These reports can be for the entire fiscal year or for a specified time span within the year. The reports can be for a single Requester, Processor, Project, JON or Code, or for all in the category, or for a subset in the category. When a report has more than one individual/item per category, there are subtotals on an individual/item basis with a rollup for all in the selected set/subset.
- One object of a preferred embodiment of the present invention is to provide automatic e-mails that expedite the approval process and “In Box” buttons that prevent orders from being forgotten.
- Another object of a preferred embodiment of the present invention is to provide the Requester with a common interface regardless of the type of purchase that will be pursued. Details of the procurement system not pertinent to the Requester are handled by the Processor. For purchases from the same vendor with the same JON, the program allows easy entry of up to 20 items on a single buy.
- Another object of a preferred embodiment of the present invention is to provide a common interface that works for the Processor as well the Requester. Both have a consistency/uniformity of data entry that may have been lacking before. If all Requesters access the system to place their orders, undecipherable, hand-written requests become a thing of the past.
- Another object of a preferred embodiment of the present invention is to provide a computer-based system where if internet sites were used in the previous purchase of the same item, they are cited for easy referral to the current purchase. Easy referral means the user clicks a button that opens the browser and goes to that site.
- Another object of a preferred embodiment of the present invention is to provide a computer-based system with a link to the FedLog program. FedLog tells the user which supply centers in the Federal Supply System carry which items and how many they have in stock. MORE even presents how to create a custom screen in FedLog to display the information the user wants and only that information. A custom screen makes it easy to cut and paste between the two programs.
- The objects, features and advantages of the method and apparatus for preferred embodiments of the present invention will be apparent from the following descriptions in which:
- FIG. 1A is a pictorial representation of the top half portion of the
Item 1 screen of a preferred embodiment of the present invention, which includes help features and explanatory text of a preferred embodiment of the present invention. - FIG. 1B is a pictorial representation of the bottom half portion of the
Item 1 screen of a preferred embodiment of the present invention, which includes help features and explanatory text of a preferred embodiment of the present invention. - FIG. 2 is a pictorial representation of the of the Order Status Screen of a preferred embodiment of the present invention, which includes help features and explanatory text of a preferred embodiment of the present invention.
- FIG. 3A is a pictorial representation of the top half portion of the Signature Buttons screen of a preferred embodiment of the present invention, which includes help features and explanatory text of a preferred embodiment of the present invention.
- FIG. 3B is a pictorial representation of the bottom half portion of the Signature Buttons screen of a preferred embodiment of the present invention, which includes help features and explanatory text of a preferred embodiment of the present invention.
- FIG. 4 is a pictorial representation of the left side portion of the Processor Page screen of a preferred embodiment of the present invention, which includes help features and explanatory text of a preferred embodiment of the present invention.
- FIG. 5 is a flowchart illustrating the processing steps of creating an order using the Material Ordering and Reporting Expediter in accordance with a preferred embodiment of the present invention.
- FIG. 6 illustrates computer systems in a network that are configured in accordance with a preferred embodiment of the present invention.
- FIG. 7 illustrates a simplified block diagram of the Material Ordering and Reporting Expediter, configured in accordance with a preferred embodiment of the present invention.
- The Material Ordering and Reporting Expediter (hereinafter “MORE”) program partially automates the preparation of purchase order documents. MORE may select subsets of the data and sort those subsets in a variety of ways for generating reports. Purchasing is expedited by automatic data fill-in based on a prior order, if any, of the same part number, automatic validation of the Job Order Number, and program determination of the approval chain with automatic e-mailing to the next Signatory when approval is granted. Electronic Signatures are affixed when a Signatory clicks the applicable password-controlled button.
- Most organizations have an approval chain specific to the organization or a division thereof. For each order, MORE determines the approval chain based on rules specific to the organization. In addition, MORE can determine the approval chain of a division within an organization. This feature enables the program to automatically e-mail the next Signatory in the approval chain of a division once the signature cycle has been started, and to e-mail the Processor when approval to purchase is granted.
- To better describe the operation of the property management system of the present invention, the utility will be described as it pertains to purchasing documents used at the Naval Air Warfare Center Weapons Division at China Lake, CA and Point Mugu, Calif. These documents are the 6-part short stub, 6-part long stub, a worksheet for a government Bankcard purchase, the Pt. Mugu site Hazardous Materials (hereinafter “HazMat”) Bankcard purchase, and the China Lake site Long Stub. In addition, the Bankcard worksheet is generally suitable for China Lake Small Procurement Electronic Data Interchange (hereinafter “SPEDI”) purchases. The Material Ordering and Reporting Expediter is a FILEMAKER PRO 5.0® database that partially automates preparing purchase order documents, such as:
- 1) the DD Form 1348 (6 PT) Requisition Document (hereinafter “the Short Stub”)
- 2) the DD Form 1348-6 Requisition Document (hereinafter “the Long Stub”)
- 3) the HazMat Bankcard purchase
- 4) a Work Sheet for a government Bankcard purchase,
- 5) the China Lake 4491/1 (9 PT) Requisition Document
- In addition, the program accommodates entry of the SPEDI catalog number in lieu of a part number. Thus, SPEDI costs may be included in reports generated by MORE. Further, the Bankcard Work Sheet may be used for a hard-copy document of the SPEDI purchase. Data may be organized, that is filtered and sorted, by Processor (the person who processes the order, either a Credit Card Holder or someone who handles stubs), Requester, Job Order Number, Project, Organization Code, time span, etc. Combinations of the preceding are also possible. The ability to organize data and to total and subtotal the data on that basis allows for a number of useful reports to be generated. In a preferred embodiment of the present invention, various colors are used to assist the user in identifying the various choices available on a screen and information required by the program.
- The active database, “OnOrder”, contains all orders submitted in a current fiscal year (FY). This database is used to enter new orders and to review existing orders. As a new fiscal year approaches, a new, empty database is created for the new fiscal year. For example, when used in government organizations, on about October 1, the active “OnOrder” database is renamed “OnOrderFY,” where FY represents the last two digits of its fiscal year. At the same time, the new, empty database is made available under the name “OnOrder.”
- Another database, “Stock”, contains information on items previously ordered. The records in “Stock” are from the current fiscal year and all prior years that the MORE program existed. When a Requester enters a
part number block 20 in a new order, it is searched in the Stock database, and if a match is found, the information in “Stock” is automatically entered in the new order. Referring to FIGS. 1A and 1B, when a Requester has completed all entries, the Requester clicks an on-screen button 21 that e-mails the Processor that the Requester has an order pending. The Processor is the person who checks the order for completeness, starts the e-mail signature chain, prints the order, and submits the paperwork to supply or makes the credit card purchase. The Requester's name, a brief description of the order, and the order number are included in the e-mail message. After the Processor has reviewed an order, the Processor chooses one of two on-screen buttons to respond. Abutton 90 e-mails the Requester that the Processor found no unresolvable problems and the order is being electronically routed for signatures. Abutton 92 e-mails the Requester that a problem with the order exists. The Processor is expected to describe the problem in the “Order Status Dialog Box” 94 prior to clicking the “problem”button 92. If there is a problem, after the Requester fixes it and/or provides clarifying information in the OrderStatus Dialog Box 94, the Requester again presses the on-screen button 21 to notify the Processor to process the order. If the OrderStatus Dialog Box 94 is used to keep a running dialog, the Requester may start each entry with that day's date. - When the Processor e-mails the Requester that the order is acceptable, the program simultaneously e-mails the first signatory, for example a Section Head or Branch Head. That e-mail includes a brief description of the order and the order number, and requests that the Signatory review and respond to the order by approval or rejection. If the signatory chooses to reject the order, the signatory may give the reason why in the Order
Status Dialog Box 94. Clicking ared Reject button Budget Analyst block 69 to the Division Head, and from the Division Head to a funds overseer, if any. The software is programmed to know the last stop in the approval chain, and when the last signatory approves, the program automatically generates an e-mail to the Processor that approval to purchase has been granted. - Initial Set Up.
- To efficiently use the MORE program, a user must first identify himself to FILEMAKER PRO®. Recognized MORE Users have their name added to a list on the opening screen; the user then scrolls this list to select his/her name. However, if the user enters his/her name into FILEMAKER PRO®'s “User Name” exactly as the MORE program has it, no scrolling will be needed. In general, MORE uses the user's name as it appears in Microsoft Outlook's Address Book. The format is: Last Name, First Name Initial. There is only one (1) comma, and there is no period after the Initial. For example, “Smith, John L” might be an entry.
- After the user has the precise name (no comma between First Name and Initial), the user opens the user's copy of FILEMAKER PRO® on the user's computer. From the pull-down menu bar near the top of the screen, the user selects the Edit pull-down menu. At the bottom of the list, Preferences is selected, then Application. In the User Name box, the user enters the user's name.
- Starting the Program
- Double clicking the Desktop starter file icon launches FILEMAKER PRO® and opens the Material Ordering and Reporting Expediter (MORE) “MainMenu.fp5” file. This initial screen asks the user to verify identifying information, for
example Name block 22,Code block 23,Phone Number block 24, etc. If the user name is not highlighted when the file opens, the user scrolls the list to the user name. - Next, the user selects from creating a new order, checking order status, responding to an order, generating a report, or quitting the program. Quitting the program closes all MORE databases, but leaves FILEMAKER PRO® open. These choices are available at almost all stages of the MORE program. The user uses a mouse to make the selection. Unless the user elects to quit, the program opens “OnOrder” database and a database containing Job Order Number (JON) information.
- Referring to FIGS. 1A and 1B, which illustrate the
MORE Item 1 screen, once the “OnOrder” database is open, three other options are available under “Select the Next Step” 25: “New Order for this Project” 54, “. . .Next Step” choice, “Duplicate this Order” 55, also added to the “. . . Next Step” choices, and “Cancel this Order” 56. - There are five (5) main screens of interest to the general MORE user. They are
Item 1, Items 2-20, Order Status, Reports and Signature Buttons. - FIGS. 1A and 1B display the “
Item 1” screen. That screen and the other four (4) screens mentioned so far are choices on the “GO TO”navigation button 26 toward the upper right of theItem 1 screen. This pattern is repeated on all five (5) of these screens. As noted earlier, various colors may be incorporated into each screen to assist the user. For example, in a preferred embodiment of the present invention, the “GO TO” navigation button is green. The function of each of the main screens of interest may be summarized as follows: -
Item 1—Requesters perform data entry for the 1st item to be purchased, includingJON block 27,justification block 28, andVendor block 29. Processors validate entries on this screen; - Items 2-20—Requesters enter items 2-20, if any, to be purchased on
Credit Card 97,SPEDI 98, or Long Stub 99 buys. Processors review the entries on the Items 2-20 screen; - Signature Buttons—Referring to FIGS. 3A and 3B, Signatories review a summary of the order and respond (approve or reject) by clicking a button with their name. These button clicks generate automatic e-mails, and if approval is given, affix electronic signatures. Signature buttons include buttons68-78 and Reject buttons include buttons 60-66;
- Order Status—Anyone may view a color-coded representation of where in the approval chain orders are. If approved for purchase, date ordered and date delivered may be shown; and
- Reports—Anyone may generate any of a variety of reports by clicking a button and following instructions given in pop-up information boxes.
- There are two primary reasons to look at a prior order: 1) to check the status of the order, or 2) to obtain pertinent information for a new order. When a user clicks “Check Status of Open Orders” on the Main Menu, the user is directed to the Order Status screen of the “OnOrder” database. A dialog box asks if the user wants to see the “Slow Purchase Report”. This report shows all the user's orders that are more than 7 days old and for which the Processor has not entered an “Ordered On” date.
- After declining or viewing that report, an information box pops up. It instructs a user to “Click the orange Requester button and follow its instructions”. When a user follows those instructions, the program will find all orders the user has submitted this fiscal year that have not been marked as received or canceled, i.e. that are still active. Each order number has a background color indicating its status: yellow indicates active, red indicates canceled, gray indicates received. The record currently selected will have a vertical, black bar on the left side of the screen, just to the right of the gray Status Area. The user clicks the upper or lower page in the spiral-bound flip book in the upper left to move to the record/order of interest. If the order vehicle is a long stub and the words “Click me for Supply status” appear on the far right of the line, simply single click anywhere on that text and follow the instructions in the information box that pops up to see the status of the order within the Supply Department.
- If the purpose of reviewing the order was to check its status because the Processor notified the Requester of a problem, via click-of-a-button automatic e-mail, the Requester needs to correct the problem or provide clarifying information. In either case, the Requester clicks the “GO TO”
button 26 and then selects “GO TOItem 1” to access that layout. The Requester should use the on-screen OrderStatus Dialog Box 94, illustrated in FIG. 1B, to describe the action/response and then click the pale-yellow, on-screen button 21, illustrated in FIG. 1A, to e-mail the Processor to process the order. - Data entry for a new order is greatly reduced if the Requester knows the part number of the item. If a part number is not known, the Requester may search the OnOrder database based nomenclature, manufacturer, description, etc., to find a prior order. In this case, The Requester does not click the orange “Requester” button. Instead, the Requester immediately clicks the green “GO TO”
button 26 and then selects “GO TOItem 1”, as illustrated in FIGS. 1A and 1B. When on that layout, the Requester selects “View” from the pull-down menus, followed by “Find Mode” and then enters the known information in the appropriate fields. After clicking “Find” on the left in the gray Status Area, the Requester may scroll through the records found. If the item is found, its part number may be highlighted and copied to the clipboard. - The Requester should then select the “New Order for this Requester” option in the “Select the Next Step” radio buttons. The software creates a new record and places the cursor in the Part
Number field block 20. Then, the Requester may paste in the part number and let the software automatically fill-in many of the fields. If the item is not found in the OnOrder database, the Requester may search the Stock database by pressing the green “Search Stock”button 32. Then, the Requester follows the same procedure as searching the OnOrder database, but when finished searching, clicks the “Return to OnOrder” button. If the search succeeded and the Requester copied the part number to the clipboard, after “New Order for this Requester” is selected, the part number is pasted. If the search did not succeed, the Requester must perform all the data entry. - In a preferred embodiment of the present invention, when creating a new order, the first entry on the “
Item 1” screen, illustrated in FIGS. 1A and 1B, is the Manufacturer'sPart Number block 20. This entry triggers a lookup in the Stock database to see if that item has been ordered before. If so, the program will fill in those fields expected to be the same, namely theNomenclature block 33, Unit ofIssue block 34,Unit Cost block 35, NationalStock Number block 36, andDistribution Code block 37. The program will also fill in the Color, Size, Manufacturer, and Vendor information. The fill in should occur very quickly. The Requester reviews the “Item 1” screen to fill in and/or change any fields that need it, including those that were filled in by the program. - In a preferred embodiment of the present invention, when the user enters the 12-character Job Order Number (JON)
block 27, the program will look it up in a Master Job Order (MJO) file to validate it. The program checks that the JON is in the MJO file, that the JON is open on this date, that the JON has a positive funds balance, and that the JON is open for purchasing material and for labor. This information is indicated to the right of the JON. The “Expires”field 40 will contain either the expiration date of the funds (which confirms that the JON is in the file and will tell the user if it is open or not) or the words JON NOF, where NOF means Not On File. A blank in the balance field indicates a positive balance. A red “$-” 41 in the balance field means the JON is “in the red”. The Material field (Mat'l) 42 is either Y or N, for Yes or No on being open for material. The Labor field follows the same convention. If the JON fails any of these checks, the user will be allowed to continue making entries, but the Processor will not process the submittal until the deficiency is corrected or a satisfactory JON is provided. - The item(s) is(are) added to the “Stock” database the first time the Requester e-mails the processor this order.
- All fields on the “
Item 1” screen and a brief description of the function are listed as follows, as illustrated in FIGS. 1A and 1B: -
Part Number block 20—Manufacturer's Part Number. This field should be the 1st entry—triggers a lookup in the Stock.fp5 database to automatically fill in several other fields; - National Stock Number (NSN)
block 36—The 13-digit number issued to national/federal stock items. The format is: nnnn-nn-nnn-nnnn. This field is often left blank; -
Distribution Code block 37—This 2 or 3-character code designates the source of supply for NSN items. The correct code is found when using one of the computer databases for federal stock items, e.g. FedLog. -
Nomenclature block 33—A brief description of the item. The first word should be very general/high level and the words that follow more descriptive. This entry is limited to about 44 characters. -
Quantity block 38—The quantity of this item the Requester wishes to order; - Unit of
Issue block 34—The Requester selects the correct 2-character abbreviation from the list that appears when tabbing or clicking into the field; -
Unit Cost block 35—The cost per unit of issue. The program will multiple the Unit Cost by the Quantity to determine the extended cost; - Job
Order Number block 27—The organizational JON; - Funds Expire—The software will automatically fill this in when it looks up the JON in the Master Job Order file. If the JON doesn't exist, JON NOF appears;
- Required
Delivery Date block 44—a date (mm/dd/yy) is entered when the Requester needs the item; the item may be especially important for end-of-year purchases. If a date is not entered, the software creates this date when the order is printed. It is the date of printing+30 days; -
Justification block 25—A brief explanation of why this purchase is necessary; -
Manufacturer block 45—The name of the manufacturer of the part to be ordered. - (Extended) Description/
Notes block 46—List special features here, e.g. technical, electrical, and physical characteristics. The user should try not to repeat the same words listed in the part number field. This field is large to allow for the listing of all the special features. If the purchase is via a long stub or if the type exceeds the space on the appropriate form, the program will print the entire description on a separate sheet (or sheets)—up to 3 pages; -
Vendor Name block 29,Vendor Addr block 49,Vendor Phone block 50,Vendor POC block 51—The user should list the suggested sources of supply here. Sometimes a vendor has a different part number than the manufacturer. If so, the user may list the vendor's part number next to the name to eliminate confusion. If the total cost is more than $2500, the user may furnish two or more sources. Make entries in the name, address, phone number, and point of contact fields if known. A separate page may help eliminate confusion on a crowded stub. Therefore, the vendors are automatically printed on the separate, extended description sheet; - Order Status
Dialog Box block 94—A place for the Requester and Processor to conduct a dialog concerning the status of the order; and - Internet Addresses block52—Universal Resource Locators (URLs) give Internet addresses for potential suppliers. Typically, these correspond to entries in the Vendor Name. They are treated as hyperlinks, and clicking the “GO TO”
buttons 26 to their left will launch a browser (if necessary) and go to the designated web site. - The “Items 2-20” screen is used for those credit card and Long Stub orders that are for multiple items from the same vendor (and same JON). This screen is accessed by clicking the green, on-screen “GO TO”
button 26 and then selecting “GO TO Items 2-20”. As the following Table 1 shows, the seven fields on “Items 2-20” have the same definition as those seven fields on the “Item 1” screen.TABLE 1 “Items 2-20”Fields Field Description Part Number Same definition as the Item 1 Field “MFGPart #”. Nomenclature/Name Same definition as the Item 1 Field“Nomenclature”. (Extended) Description Same definition as the Item 1 Field “(Extended)Description/Notes”. Manufacturer Same definition as the Item 1 Field“Manufacturer”. Unit of Issue Same definition as the Item 1 Field “Unit ofIssue”. Qty Same definition as the Item 1 Field “Quantity”.Unit Cost Same definition as the Item 1 Field “Unit Cost”. - When all entries are completed, including “Items 2-20” as needed, the Requester clicks the pale-yellow on-screen button21 to e-mail the Processor that an order is pending. If the usual Processor is not available, the Requester may use the drop-down list above the e-mail button to select a different processor for an order. If the order is urgent, the Requester clicks the
red check box 57 to the right of the required delivery date to have an “URGENT” statement included at the beginning of the e-mail message. If the Requester does not enter a part number or a National Stock Number (NSN), and does not attempt to describe the item, the program will not issue the e-mail, but will request either a part number or further description of the item. - When a Requester creates a new order from the MainMenu or from the “New Order for this Requester”
button 53 in the “xxx OnOrder” database, MORE automatically fills in the information pertaining to the selected Requester, but nothing else. In the “xxx OnOrder” database there is a second option under “Select the Next Step” 25, which is “New Order for this Project” 54. In a preferred embodiment of the present invention, when the Requester clicks thisbutton 54, in addition to the requester information, the Project Name,Urgency Indicator 48,JON 27, RequiredDelivery Date 44, andJustification 28 are automatically duplicated in the new request. Thebutton 54 will be useful when ordering many parts for a specific project, especially if the parts are federal supply, which requires a separate short stub for each part. When creating a new order, there is a third option: the “Duplicate this Order”button 55. A new record is created with all the Requester entries from this record duplicated. This method will be useful if the changes required are less than making all the non-automatic entries from scratch. Referring to FIGS. 1A and 1B, the “Cancel this Order”button 56 is utilized by the Requester to abort an order. - To exit the program, a user may click the “Exit MORE” radio button in the “Select the Next Step” set of
options 25. All MORE databases will be closed, but the FILEMAKER PROS application will remain open. - Referring to FIGS. 3A and 3B, the Signature Buttons screen contains several sets of password-controlled
buttons 68 through 78 that signatories click to affix their electronic signature to the appropriate form. Only the individual signer will have the password for his or herbutton 68 through 78. The password given to “Stand-ins” will operate thebutton 68 through 78, but the signature on forms will be preceded by the Stand-in's initials and the word “for”. On the Signature Buttons screen, the Stand-in's full name will appear as the Approver rather than the permanent signatory's name. Right above the block of buttons is a condensed version of the order information. That is intended to be sufficient for the signers to decide whether to approve or reject the order. When someone “signs off”, the next higher level signatory is notified automatically and a check mark is placed to the right of the individual's name on his/her approval button. When the final approver in the chain clicks “yes”, the Processor is e-mailed that the order is approved for purchase. Thus, the Processor will know when it is time to print the appropriate hardcopy and proceed with the purchase. - When the Processor places the order, the Processor may go to the Signature Buttons screen to enter data into fields indicating who placed the order, when it was placed, and when delivery is expected. Clicking an on-screen button automatically e-mails this information to the Requester. The date ordered is displayed on the Order Status screen.
- When the order is delivered, the Processor may go to the Signature Buttons screen to enter the quantity received, actual cost, received date, and the recipient. Clicking an on-screen button automatically e-mails this information to the Requester. When this button is clicked the program changes the order status from “active” (yellow background color on the order number e.g. order59) to “received” (gray background color on the order number e.g. order 58). The date delivered is displayed on the Order Status screen under “Date Rec'd”.
- The Processor clicks the green “GO TO” button and then selects “GO TO Processor Page” to go to the “Processor Page” layout, as illustrated in FIG. 4. This layout has the same “GO TO”
button 26 to easily navigate to the “Item 1” screen, to “Items 2-20”, to the “Signature Buttons”, to the “Order Status”, and to the “Reports” screen. The Requester's name and order are repeated on the Processor Page for the processor to know what order is being processed. Any problems the Processor sees should be described in the OrderStatus Dialog Box 94. - There is a line for Shipping and Handling (S & H) charges if it is a credit card order. If it is a stub order, there is an entry for the Contractual/Other Code. After the Processor has decided whether or not there are problems with the order, the Processor presses the appropriate button (Success or Problem) to e-mail the Requester. The Processor then selects the form to print, for
example credit card 97, short stub 104, long stub 99,HazMat 106, or 4491/1 108. This selection assures that when the time is right to print a hardcopy, the right form will be printed. - The Reports screen is used for generating a variety of reports. A three-line format is used for each order that is reported. A row of buttons along the top left of the screen allows the user to select and sort data by Processor, by Requester, by Job Order Number, by Code, and by project.
- The Processor is responsible for verifying and/or filling in many fields. Many of these fields, which are related to stub purchases are selectable from drop-down lists. For example, the Unit of
Issue 34 contained in columns 23-24 of both the Long Stub and the Short Stub is an abbreviation of the types of units under which material is issued. Table 2 presents typical examples of 2-character abbreviations from the list that appears when tabbing or clicking into the field.TABLE 2 Code Description AM Ampoule AT Assortment AY Assembly BA Ball BD Bundle BE Bale BF Board Foot BG Bag BK Book BL Barrel BO Bolt BR Bar BT Bottle BX Box CA Cartridge CB Carboy CD Cubic Yard CE Cone CF Cubic Foot CK Cake CL Coil CN Can CO Container CY Cylinder CZ Cubic Meter DR Drum DZ Dozen EA Each FT Foot FV Five FY Fifty GL Gallon GP Group GR Gross HD Hundred HK Hank IN Inch JR Jar KT Kit LB Pound LG Length LI Liter MC Thousand Cubic Feet ME Meal MR Meter MX Thousand OT Outfit OZ Ounce PD Pad PG Package PM Plate PR Pair PT Pint PZ Packet QT Quart RA Ration RL Reel RM Ream RO Roll SD Skid SE Set SF Square Foot SH Sheet SK Skein SL Spool SO Shot SP Strip SX Stick SY Square Yard TD Twenty-four TE Ten TF Twenty-five TN Ton TO Troy Ounce TS Thirty-six TU Tube VI Vial YD Yard - The 2 or 3-
character Distribution Code 37 designates the source of supply for NSN items. In the Defense Logistics Agency Customer Assistance Handbook it is called the Routing Identifier Code (RIC). NAWCWPNS chooses from the “NAVY COG” column. Several popular choices are:9N Def. Sup. Cntr, Columbus (electronics) 9Q GSA, DC 9G Def. Sup. Cntr, Richmond VA 9Z Def. Industrial Sup. Cntr - The correct code is found when using one of the computer databases for federal stock items, e.g. FedLog.
- Priority is a 2-digit code related to MILSTRIP Force/Activity Designators (F/AD). RDT&E in general, and Code 522 in particular tend to use F/AD IV, encompassing priorities 07/09/14. The lower the Priority Number the quicker the response. Specific projects may be authorized a lower-numbered F/AD.
- 07 indicates a work stoppage has occurred on mission-essential tasks or equipment,
- 09 indicates a work stoppage will occur to a mission-essential task or equipment,
- 14 indicates routine requirements, replacement of stock, or scheduled maintenance.
- If the user has a customer with authority to use a higher priority, attach a memo authorizing use of that priority signed by an official from the code or division. Table3 presents examples of Priority designators used in a preferred embodiment of the present invention.
TABLE 3 Urgency Urgency Urgency F/AD Designator A Designator B Designator C I 01 04 11 II 02 05 12 III 03 06 13 IV 07 09 14 Conus: 12 days Conus: 31 days Conus: 31 days Overseas: 16-17 days Overseas: 69-84 days Overseas: 69-84 days V 08 10 15 - The designators are defined as follows. Designator A is requirements for material without which the activity concerned is unable to perform an assigned mission, or to eliminate an existing work stoppage of the repair of mission-essential equipment; Designator B is requirement for material, the lack of which is impairing the operational capability of the activity concerned, or is anticipated to cause work stoppage in performing maintenance of mission-essential equipment; and Designator C is routine requirements, replacement of stock, scheduled maintenance.
- Table 4 presents typical Project Codes used in a preferred embodiment of the present invention. Each position of this 3-character code is sub-coded.
TABLE 4 1st Position 2nd Position 3rd Position A Aircraft & ground A Allowance-Self Support (COSAL, 0 CASREP/ support equip etc.) Increase Range NMCS F Fleet Ballistic K Repair-Unscheduled 1 Work Stoppage Missile Program (Required for repair of “in-use” (FBM) (SSBNs and equipment.) Ass) (FBM) L Other Fleet Units L Repair-Scheduled 2 Restricts (includes (Required for use in formal repair operation Oceanographic Units/ program.) Detachments) P CNO Special M Overhaul-Unscheduled 3 Shortage (not Projects/Elements (Required for overhaul of“down” fully equipped) equipment.) S Repair and N Overhaul-Scheduled 4 Management Overhaul Shops (other (Required for use in formal Program than AMD) overhaul programs.) T Experimental, Test O Maintenance- Technical 5 Customer and Research (Required under normal preventative Program Programs/ maintenance programs-lube, oils, (forecasted Organizations paints, parts that have worn out but requirement by not failed, etc.) customer) S Production/Manufacture 7 Capability impaired for lack of parts Y Miscellaneous- Y Miscellaneous-Not otherwise 8 Government Not otherwise defined furnished categorized material Z Special Programs Z Disposal Programs 9 Miscellaneous- not otherwise categorized - Table 5 presents examples of frequently used codes for Federal Stock.
TABLE 5 Advice Codes for Federal Stock Code Explanation 2B Only requested item will suffice. Do not substitute/interchange. Also applies to “Obsolete”/“Inactivated” item previously rejected with Status Code CJ. 2C Do not backorder. Reject any unfilled quantity not available to meet SDD/RDD. Suitable substitute acceptable. 2J Do not substitute or backorder any unfilled quantities. 2L Entry in quantity field exceeds normal demands; however, this is a confirmed valid requirement. 2N Item required in one continuous length as expressed in rp 25-29 and unit of issue in rp 23-24. No other configuration is acceptable and/or multiples of the unit pack are not acceptable. 2P Initial requirement certification. Requested item is a mandatory turn-in repairable required for initial outfitting/installation or increased allowance/stockage objective; therefore, no unserviceable unit is available for turn-in. Requires memo explaining why we have no turn-in. J1 Requester authorizes buyer to pay up to 10% higher price without calling for approval. - In a preferred embodiment of the present invention, an order's status is updated after a credit card order has been placed or a long or short stub has been sent to Supply. The Processor may access the necessary fields to update the order's status by opening the MORE Program, navigating to the “Signature Buttons” screen illustrated in FIGS. 3A and 3B, and selecting the appropriate order number. If the purchase is a credit card buy, the user enters the name of the individual who bought the item, the date the order was placed, and the estimated date of delivery. If there was a change in price or a different vendor chosen, the user may enter this new information also. If it is a long or short stub, the user enters the date the stub was sent to Supply and the estimated date of delivery. If any new information comes to the attention of the user, such as the Purchase Order Number or Bankcard Purchase Log Number, that information may be added to the Signature Buttons page as well. After updating the Signature Buttons screen, the user clicks the yellow “E-mail Order Placed” button so that the new information will be forwarded to the requester.
- In a preferred embodiment of the present invention, when an order is received, this information is entered on the Signature Buttons screen. The user enters the quantity received, the total price, and the date received. The requester will be notified of this change in status when the “E-mail Order Rec'd” button is clicked. Clicking the “E-mail Order Rec'd” button changes the background color of the MORE Order Number from yellow (active) to gray (received). If the user clicked the “Cancel This Order”
button 56 on theItem 1 screen, the background color will be red to indicate cancellation. If the order has been cancelled for any other reason, the buyer can change the More Order Number to red by selecting the “Red” circle button on the Signature Buttons page. - Processors have three reports available immediately after logging on to the MORE program. Those reports are 1) Slow Review, which displays a list of orders not yet reviewed; 2) Slow Order, which displays a list of orders reviewed but not yet ordered; and 3) Late Delivery, which displays a list of orders placed but past the delivery due date. If more detailed information is required on a particular order, the user clicks the MORE Order Number and then the desired display screen is accessed by clicking on the green “GO TO” navigation button.
- In a preferred embodiment of the present invention, each display screen needed in processing MORE orders has a drop down entry on the green “GO TO” navigation button. These choices make it easy to move around in the program.
Item 1 displays the first screen, illustrated in FIGS. 1A and 1B, of the order. This screen is used by the Requester to enter ordering data for the first line item. If more than one line item is ordered from the same vendor, the Requester goes to Items 2-20. Items 2-20 screen (not shown) displays the screen whereitems 2 through 20 can be entered or reviewed. This includes the part number, description, manufacturer, unit of issue, quantity and u nit cost fields.Line item 1 is copied to this second screen and the program adds the shipping charges to the extended costs to calculate the total cost and enter it on theItem 1 screen. Signature Buttons screen, illustrated in FIGS. 3A and 3B, displays theSignatory buttons 68 through 78 and is used by the signatories to review and then to approve or reject an order. This screen is also used by the processors for updates such as ordering and receiving dates and price changes. Order Status screen, illustrated in FIG. 2, provides a Buyer/Processor or Requester the most current approval status of each active order. The user selects theProcessor name button 110 orRequester name button 112, types the name for which the user wishes to view orders and then clicks “Continue”. If more details are needed, the user clicks theOrder Number box - Help Buttons are available on most pages and can be identified by the green question mark (?) inside the green square buttons. These buttons offer additional information the user may need to determine the correct response for the corresponding block. If there is a list, the user clicks on the item needed and it will appear in the block.
- Referring to FIG. 5, there is shown a flowchart illustrating the processing steps120-154 which create an order using the Material Ordering and Reporting Expediter in accordance with a preferred embodiment of the present invention. Processing steps 120-124 require the requester to enter a password, verify his/her name, select “create a new order” on the Main Menu, and then enter a part number. If the part has previously been ordered, MORE inserts the required information from a previous order (processing step 128), otherwise the requester must enter this information (
processing step 130, which includes, forexample JON block 27,justification block 28, andVendor block 29. - If more than one item is being ordered from a vendor, the Requester clicks “GO TO”
button 26 and then selects “GO TO Items 2-20” prior to inputting the information for items 2-20 (processing steps 134 and 136). If special instructions are required for the order, the Requester enters these instructions and/or remarks into the “Order Status Dialog Box” 94 (processing step 140). The Requester e-mails the Processor to process the order by clicking on-screen button 21 (processing step 142), the processor receives and reviews the order (processing step 144), approves the order and sends the order to the first signatory in the approval chain (processing step 154). When the order is incomplete or there is an error in the order, the Processor notifies the Requester of the need for additional information to complete the order or to correct the order (processing step 148). The Requester makes the necessary additions and/or corrections to the order (processing step 152) and returns the order to the Processor for review. - FIG. 6 illustrates computer files160, 162, 164, 166 and 168 in a network configured in accordance with a preferred embodiment of the present invention.
Computer file 160 represents the aggregate of orders for the current fiscal year, file 162 represents the database file with user information, file 164 represents the main menu for the material ordering and reporting expedite, file 166 represents the database with job order number information, and file 168 represents the stock database which contains information on all items ordered in the MORE program. - FIG. 7 illustrates a simplified block diagram flow chart of the Material Ordering and Reporting Expediter, configured in accordance with a preferred embodiment of the present invention. To create an order, the requester enters the main menu then proceeds to the item one menu of FIGS. 1A and 1B and provides the required information (processing step126). When there are multiple items to be ordered from the same vendor, the Requester provides the required information using the items 2-20 screen (processing step 172). The Requester may provide an extended description of the item to be ordered by utilizing block 46 (processing step 174).
- The Requester may provide a sole source statement for the item to be ordered by utilizing block47 (processing step 176) A sole source statement justifies ordering the item from a single source without price competition from multiple vendors. It is generally used when a vendor has an item which is uniquely configured for a particular application.
- The Requester may also provide an urgency statement for the item to be purchased utilizing block48 (processing step 178).
- By utilizing
block 52, the Requester may visit a single vendor Web Site or multiple vender Web Sites (processing step 182). The Requester may view the status of his/her order from the screen illustrated in FIG. 2 (processing step 180). There is also an option to view the different forms to purchase an item such as the credit card work sheet, the long stub and/or the short stub (processing step 188). The Processor page, used by the processor to purchase the item, is illustrated in FIG. 4 (processing step 190). Similarly, the signature screen which sets forth the signature chain required for approval to purchase the item is illustrated in FIGS. 3A and 3B (processing step 194). The Material Order and Reporting Expediter also allows for the generation of reports for items being purchased (processing step 192) and includes a screen for viewing purchases within a division (processing step 180). - Although the description above contains many specificities such as colors, indicators and purchasing forms, these should not be construed as limiting the scope of the invention but as merely providing an illustration of the presently preferred embodiment of the invention. Thus the scope of this invention should be determined by the appended claims and their legal equivalents.
Claims (14)
1. A computer-based networked system for coordination of a purchase document and approval of said purchase document by an approval chain having one or more signatories, comprising:
means used by a requester to create said purchase document;
first notifying means for notifying a processor of said purchase document, wherein the processor reviews said purchase document for completeness and accuracy and upon finding said purchase document to be complete and accurate, the processor forwards said purchase document to said approval chain;
means for determining said approval chain for said purchase document;
means for sending said purchase document through said approval chain, wherein each of the signatories approves said purchase order by affixing an electronic signature to said purchase order before said purchase document is forwarded to a next signatory in said approval chain for approval;
second notifying means for notifying the processor of approval of said purchase document by said approval chain, wherein the processor is notified after a final signatory in said approval chain approves said purchase document; and
means for printing an approval form, wherein said approval form contains information relevant to said purchase document and the electronic signature of each of said signatories in said approval chain.
2. The computer-based networked system of claim 1 , further comprising:
means for rejecting said purchase document by any one of said signatories, wherein the processor and the requester are notified of said rejection.
3. The computer-based networked system of claim 1 , further comprising:
means for accessing all purchase orders awaiting approval by each of said signatories.
4. The computer-based networked system of claim 1 , further comprising:
means for illustrating said approval chain, wherein an indicator is provided as each of the signatories approves said purchase document.
5. The computer-based networked system of claim 1 , further comprising:
means for notifying the requester of a need to amend said purchase order.
6. The computer-based networked system of claim 1 , further comprising:
means for completing said purchase document, wherein said computer-based networked system searches a database of existing purchase documents after the requester inputs a new part number which corresponds to an existing part number in said stock database.
7. The computer-based networked system of claim 1 , wherein said first notifying means and said second notifying is by an E-mail.
8. A method of coordinating a purchase document and approving said purchase document by an approval chain having one or more signatories over a network, comprising:
creating said purchase document by a requester;
notifying a processor of said purchase document wherein the processor reviews said purchase document for completeness and accuracy and upon finding said purchase document to be complete and accurate, the processor forwards said purchase document to said approval chain;
determining said approval chain for said purchase document;
sending said purchase document through said approval chain, wherein each of the signatories approves said purchase order by affixing an electronic signature to said purchase document before said purchase document is forwarded to a next signatory in said approval chain for approval;
notifying the processor of approval of said purchase document by said approval chain, wherein the processor is notified after a final signatory in said approval chain approves said purchase document; and
printing an approval form, wherein said approval form contains information relevant to said purchase document and the electronic signature of each of said signatories in said approval chain.
9. The method of claim 8 , further comprising:
rejecting said purchase document by any one of said signatories, wherein the processor and the requester are notified of said rejection.
10. The method of claim 8 , further comprising:
accessing a status for all purchase orders awaiting approval by each of said signatories.
11. The method of claim 8 , further comprising:
illustrating said approval chain, wherein an indicator is provided as each of the signatories approves said purchase document.
12. The method of claim 8 , further comprising:
notifying the requester of a need to amend said purchase order.
13. The method of claim 8 , further comprising:
completing said purchase document, wherein a computer program searches a database of existing purchase documents after the requester inputs a new part number which corresponds to an existing part number in said database.
14. The computer-based system of claim 8 , wherein notifying said processor of said purchase document and notifying the processor of an approval of said purchase document is by an E-mail.
Priority Applications (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US09/760,341 US20020133470A1 (en) | 2001-01-10 | 2001-01-10 | Material ordering and reporting expediter (MORE) |
US11/086,733 US7552059B2 (en) | 2001-01-10 | 2005-03-17 | Material ordering and reporting expediter (MORE) |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US09/760,341 US20020133470A1 (en) | 2001-01-10 | 2001-01-10 | Material ordering and reporting expediter (MORE) |
Related Child Applications (2)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US11/086,733 Continuation US7552059B2 (en) | 2001-01-10 | 2005-03-17 | Material ordering and reporting expediter (MORE) |
US11/086,733 Continuation-In-Part US7552059B2 (en) | 2001-01-10 | 2005-03-17 | Material ordering and reporting expediter (MORE) |
Publications (1)
Publication Number | Publication Date |
---|---|
US20020133470A1 true US20020133470A1 (en) | 2002-09-19 |
Family
ID=25058809
Family Applications (2)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US09/760,341 Abandoned US20020133470A1 (en) | 2001-01-10 | 2001-01-10 | Material ordering and reporting expediter (MORE) |
US11/086,733 Expired - Lifetime US7552059B2 (en) | 2001-01-10 | 2005-03-17 | Material ordering and reporting expediter (MORE) |
Family Applications After (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US11/086,733 Expired - Lifetime US7552059B2 (en) | 2001-01-10 | 2005-03-17 | Material ordering and reporting expediter (MORE) |
Country Status (1)
Country | Link |
---|---|
US (2) | US20020133470A1 (en) |
Cited By (24)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20020120483A1 (en) * | 2001-02-27 | 2002-08-29 | Chi-Chung Chen | Method for dynamically identifying operation entity and system thereof |
US20040030614A1 (en) * | 2002-06-19 | 2004-02-12 | Shields Jay C. | Computer-implemented method and system for managing workload of procurement individuals |
US20040148052A1 (en) * | 2003-01-25 | 2004-07-29 | United Parcel Service | Hazardous materials shipping system, method and computer program product |
US20060259486A1 (en) * | 2005-05-12 | 2006-11-16 | Microsoft Corporation | Method and system for enabling an electronic signature approval process |
US20070100881A1 (en) * | 2005-10-24 | 2007-05-03 | International Business Machines Corporation | Method, system and storage medium for identifying and allocating surplus inventory |
US20080103966A1 (en) * | 2006-10-31 | 2008-05-01 | Chuck Foster | System and/or method for dynamic determination of transaction processing fees |
US20080114691A1 (en) * | 2006-10-31 | 2008-05-15 | Chuck Foster | Processing transactions |
US20080114684A1 (en) * | 2006-10-31 | 2008-05-15 | Chuck Foster | Termination of transactions |
US20090112759A1 (en) * | 2007-10-30 | 2009-04-30 | Chuck Foster | Accumulated transactions |
US7617153B1 (en) | 2002-08-02 | 2009-11-10 | American Express Travel Related Services Company, Inc. | Global procurement bypass shutdown process and method |
US8060437B2 (en) | 2006-10-31 | 2011-11-15 | International Funding Partners Llc | Automatic termination of electronic transactions |
US20130019156A1 (en) * | 2011-07-14 | 2013-01-17 | Docusign, Inc. | Method for Associating Third Party Content with Online Document Signing |
US20140052643A1 (en) * | 2012-08-15 | 2014-02-20 | International Business Machines Corporation | Managing multiple approvals for projects |
US20140095390A1 (en) * | 2012-09-28 | 2014-04-03 | Oracle International Corporation | Mobile transaction approvals |
US9824471B2 (en) | 2012-09-27 | 2017-11-21 | Oracle International Corporation | Automatic generation of hierarchy visualizations |
US9916582B2 (en) | 2011-07-28 | 2018-03-13 | Iii Holdings 1, Llc | Systems and methods for generating and using a digital pass |
US10346898B2 (en) * | 2013-10-24 | 2019-07-09 | American Axle & Manufacturing, Inc. | Electronic purchased part order data management system and method |
CN110619183A (en) * | 2019-09-24 | 2019-12-27 | 中国航空工业集团公司沈阳飞机设计研究所 | Full-life-cycle test flight test data management method |
US20200051029A1 (en) * | 2017-02-27 | 2020-02-13 | Animation 2000 Limited | Digital Document Execution |
JP2020144514A (en) * | 2019-03-05 | 2020-09-10 | ファナック株式会社 | Overseas corresponding application sales management server system |
US10826997B2 (en) | 2015-11-06 | 2020-11-03 | Vynca, Inc. | Device linking method |
US20220067613A1 (en) * | 2018-10-10 | 2022-03-03 | Bayer Aktiengesellschaft | Product supply apparatus |
US11281887B2 (en) * | 2017-11-29 | 2022-03-22 | Vynca, Inc. | Multiple electronic signature method |
US11423164B2 (en) | 2018-05-21 | 2022-08-23 | Vynca, Inc. | Multiple electronic signature method |
Families Citing this family (77)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP3507445B2 (en) * | 2001-01-22 | 2004-03-15 | 田中貴金属工業株式会社 | Compound supply system for chemical vapor deposition and thin film manufacturing system provided with the compound supply system |
US20050256776A1 (en) * | 2002-04-30 | 2005-11-17 | Bayoumi Deia S | Industrial it system for production of distribution power transformers |
US20050108147A1 (en) * | 2003-11-03 | 2005-05-19 | Alan Scroope | Transaction processing |
TW200516447A (en) * | 2003-11-10 | 2005-05-16 | Via Tech Inc | Electronic purchase method and corresponding apparatus |
US8219444B2 (en) * | 2004-03-08 | 2012-07-10 | Sap Aktiengesellschaft | System and method for using sales patterns with markdown profiles |
US7769625B2 (en) * | 2004-03-08 | 2010-08-03 | Sap Aktiengesellschaft | System and method for defining a sales promotion |
US8108270B2 (en) * | 2004-03-08 | 2012-01-31 | Sap Ag | Method and system for product layout display using assortment groups |
US7974851B2 (en) | 2004-03-08 | 2011-07-05 | Sap Aktiengesellschaft | Method and system for price planning |
US7788595B2 (en) * | 2004-03-08 | 2010-08-31 | Sap Ag | Method and system for switching among management system applications |
US7693749B2 (en) * | 2004-03-08 | 2010-04-06 | Sap Ag | System and computer product for managing purchase orders |
US7822692B2 (en) | 2004-03-08 | 2010-10-26 | Sap Ag | Automated control of pricing using markdown profiles |
US20050267873A1 (en) * | 2004-03-08 | 2005-12-01 | Sap Aktiengesellschaft | Method and system for dynamic article listing |
US7752067B2 (en) * | 2004-03-08 | 2010-07-06 | Sap Aktiengesellschaft | System and method for assortment planning |
US8050990B2 (en) * | 2004-03-08 | 2011-11-01 | Sap Ag | Method of and system for generating purchase orders using an auction process |
US8392231B2 (en) * | 2004-03-08 | 2013-03-05 | Sap Aktiengesellschaft | System and method for performing assortment definition |
US8478632B2 (en) * | 2004-03-08 | 2013-07-02 | Sap Ag | System and method for defining a sales promotion |
US7996330B2 (en) * | 2004-03-08 | 2011-08-09 | Sap Aktiengeselleschaft | Automated system for generating proposed markdown strategy and tracking results of proposed markdown |
US8620722B2 (en) * | 2004-03-08 | 2013-12-31 | Sap Aktiengesellschaft | System and method for organizing an enterprise |
US8370184B2 (en) * | 2004-03-08 | 2013-02-05 | Sap Aktiengesellschaft | System and method for assortment planning |
US7383990B2 (en) * | 2004-03-08 | 2008-06-10 | Sap Aktiengesellschaft | Organizational settings for a price planning workbench |
US8051015B2 (en) | 2004-03-08 | 2011-11-01 | Sap Ag | Method and system for automated control of pricing |
US8423428B2 (en) | 2004-03-08 | 2013-04-16 | Sap Ag | Method for allocation of budget to order periods and delivery periods in a purchase order system |
US7343315B2 (en) * | 2004-03-08 | 2008-03-11 | Sap Aktiengesellschaft | System and method of efficient scheduling and processing of purchase orders |
US8050956B2 (en) | 2004-03-08 | 2011-11-01 | Sap Ag | Computer-readable medium, program product, and system for providing a schedule bar with event dates to monitor procurement of a product |
US8165910B2 (en) * | 2004-03-08 | 2012-04-24 | Sap Aktiengesellschaft | Method and system for price planning |
US7647250B2 (en) | 2004-03-08 | 2010-01-12 | Sap Ag | Method and program product for event monitoring |
US8285584B2 (en) | 2004-03-08 | 2012-10-09 | Sap Ag | System and method for performing assortment planning |
US8639548B2 (en) * | 2004-03-08 | 2014-01-28 | Sap Aktiengesellschaft | System and method for assortment planning |
US7805383B2 (en) * | 2004-03-08 | 2010-09-28 | Sap Ag | Price planning system and method including automated price adjustment, manual price adjustment, and promotion management |
US20050197911A1 (en) * | 2004-03-08 | 2005-09-08 | Sap Aktiengesellschaft | Method and system for automated contract determination |
US8046273B2 (en) * | 2004-03-08 | 2011-10-25 | Sap Ag | System and method for purchase order creation, procurement, and controlling |
US7813949B2 (en) | 2004-03-08 | 2010-10-12 | Sap Ag | Method and system for flexible budgeting in a purchase order system |
US7831487B2 (en) | 2004-03-08 | 2010-11-09 | Sap Ag | Method and system for scheduling purchase orders |
US20050197886A1 (en) * | 2004-03-08 | 2005-09-08 | Sap Aktiengesellschaft | System and method for defining a sales promotion |
US8489446B2 (en) * | 2004-03-08 | 2013-07-16 | Sap Ag | System and method for defining a sales promotion |
US7481367B2 (en) | 2004-03-08 | 2009-01-27 | Sap Aktiengesellschaft | Assignment of markdown profiles for automated control of pricing |
US8341011B2 (en) | 2004-03-08 | 2012-12-25 | Sap Aktiengesellschaft | Method and system for reporting price planning results |
US7882088B2 (en) * | 2004-03-08 | 2011-02-01 | Sap Ag | Method and system for transferring data from a data warehouse |
US7742948B2 (en) * | 2004-03-08 | 2010-06-22 | Sap Aktiengesellschaft | Method of and system for allocating an OTB-relevant purchasing contract |
US7739203B2 (en) * | 2004-03-08 | 2010-06-15 | Sap Aktiengesellschaft | Method and system for classifying retail products and services using price band categories |
US8027886B2 (en) * | 2004-03-08 | 2011-09-27 | Sap Aktiengesellschaft | Program product for purchase order processing |
US7983962B2 (en) * | 2004-03-08 | 2011-07-19 | Sap Aktiengesellschaft | Method and system for purchase order data entry |
US8484135B2 (en) * | 2004-03-08 | 2013-07-09 | Sap Aktiengesellschaft | Method of and system for assignment of price groups |
US7660742B2 (en) * | 2004-03-08 | 2010-02-09 | Sap Aktiengesellschaft | Method of and system for processing purchase orders |
US7805335B2 (en) * | 2004-03-08 | 2010-09-28 | Sap Ag | Purchase list having status indicators |
US7853491B2 (en) * | 2004-03-08 | 2010-12-14 | Sap Ag | Purchase orders based on purchasing list, capacity plans, assortment plans, and area spread assortment plans |
US8788372B2 (en) * | 2004-03-08 | 2014-07-22 | Sap Aktiengesellschaft | Method and system for classifying retail products and services using characteristic-based grouping structures |
US7813961B2 (en) * | 2004-03-08 | 2010-10-12 | Sap Ag | System and method for planning, allocation, and purchasing |
US8046275B2 (en) * | 2004-04-16 | 2011-10-25 | Sap Aktiengesellschaft | Synchronizing an allocation table with a procurement system |
US8655697B2 (en) * | 2004-04-16 | 2014-02-18 | Sap Aktiengesellschaft | Allocation table generation from assortment planning |
US7689477B2 (en) * | 2004-04-16 | 2010-03-30 | Sap Aktiengesellschaft | Apparatus and program product for generating an allocation table in a computerized procurement system |
US7908186B2 (en) * | 2004-04-16 | 2011-03-15 | Sap Aktiengesellschaft | Distribution matrix in an allocation table |
US7805334B1 (en) | 2004-06-08 | 2010-09-28 | Sap Ag | Method and system for processing retail data |
US20060059031A1 (en) * | 2004-08-06 | 2006-03-16 | Sap Aktiengesellschaft | Risk management |
US7724890B1 (en) | 2005-09-07 | 2010-05-25 | Sap Ag | Focused retrieval of selected data in a call center environment |
US8484554B2 (en) * | 2006-08-31 | 2013-07-09 | Sap Ag | Producing a chart |
US8255870B2 (en) * | 2006-08-31 | 2012-08-28 | Sap Aktiengesellschaft | Application access for support users |
US7813814B2 (en) * | 2006-09-29 | 2010-10-12 | Sap Ag | Control systems and methods for virtual power plants |
US20080120206A1 (en) * | 2006-10-31 | 2008-05-22 | Sap Aktiengesellschaft | Stock level management |
US7676443B2 (en) * | 2006-11-17 | 2010-03-09 | Sap Ag | System and method for processing data elements in retail sales environment |
US7548900B2 (en) * | 2006-11-30 | 2009-06-16 | Sap Ag | Systems and methods for data management |
US8762293B2 (en) * | 2006-12-28 | 2014-06-24 | Sap Ag | Condition data management |
US8099337B2 (en) | 2007-06-19 | 2012-01-17 | Sap Ag | Replenishment planning management |
US7730052B2 (en) | 2007-07-23 | 2010-06-01 | Sap Aktiengesellschaft | System and method for providing a virtual item context |
US7809707B2 (en) * | 2007-07-23 | 2010-10-05 | Sap Ag | System and method for identifying element usage in a deep element structure |
US7730051B2 (en) | 2007-07-23 | 2010-06-01 | Sap Aktiengesellschaft | System and method for embedded expression assignment |
US8549080B2 (en) * | 2007-12-12 | 2013-10-01 | International Business Machines Corporation | Method to identify and display contributions by author in an e-mail comprising multiple authors |
US8065189B1 (en) | 2008-01-15 | 2011-11-22 | SciQuest Inc. | Method, medium, and system for automatically moving items from a first shopping cart to a second shopping cart |
US8285573B1 (en) | 2008-01-15 | 2012-10-09 | SciQuest Inc. | Prioritizing orders/receipt of items between users |
US8065202B1 (en) | 2008-01-15 | 2011-11-22 | SciQuest Inc. | Form management in an electronic procurement system |
US8359245B1 (en) | 2008-01-15 | 2013-01-22 | SciQuest Inc. | Taxonomy and data structure for an electronic procurement system |
US8930244B2 (en) * | 2008-01-15 | 2015-01-06 | Sciquest, Inc. | Method, medium, and system for processing requisitions |
US8694429B1 (en) | 2008-01-15 | 2014-04-08 | Sciquest, Inc. | Identifying and resolving discrepancies between purchase documents and invoices |
US8112317B1 (en) * | 2008-01-15 | 2012-02-07 | SciQuest Inc. | Providing substitute items when ordered item is unavailable |
US8756117B1 (en) | 2008-05-27 | 2014-06-17 | Sciquest, Inc. | Sku based contract management in an electronic procurement system |
US8069096B1 (en) | 2008-05-27 | 2011-11-29 | SciQuest Inc. | Multi-constituent attribution of a vendor's product catalog |
US9245291B1 (en) * | 2008-05-27 | 2016-01-26 | SciQuest Inc. | Method, medium, and system for purchase requisition importation |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20010051902A1 (en) * | 1999-06-28 | 2001-12-13 | Messner Marc A. | Method for performing secure internet transactions |
US6453306B1 (en) * | 1998-01-26 | 2002-09-17 | Ict Software S.A. | Internet commerce method and apparatus |
US20020188524A1 (en) * | 2001-04-26 | 2002-12-12 | Hidetaka Shimizu | Method for placing/receiving order using electronic mail |
Family Cites Families (15)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5148366A (en) * | 1989-10-16 | 1992-09-15 | Medical Documenting Systems, Inc. | Computer-assisted documentation system for enhancing or replacing the process of dictating and transcribing |
US5272623A (en) * | 1990-11-07 | 1993-12-21 | The United States Of America As Represented By The Secretary Of The Navy | Software programming method for forming Government contracting documents |
US5666493A (en) * | 1993-08-24 | 1997-09-09 | Lykes Bros., Inc. | System for managing customer orders and method of implementation |
US5848271A (en) * | 1994-03-14 | 1998-12-08 | Dun & Bradstreet Software Services, Inc. | Process and apparatus for controlling the work flow in a multi-user computing system |
US6311170B1 (en) * | 1996-12-04 | 2001-10-30 | Mark C. Embrey | Method and apparatus for making payments and delivering payment information |
US6442557B1 (en) * | 1998-02-27 | 2002-08-27 | Prc Inc. | Evaluation of enterprise architecture model including relational database |
US6311192B1 (en) * | 1998-09-29 | 2001-10-30 | Electronic Data Systems Corporation | Method for initiating workflows in an automated organization management system |
US6745196B1 (en) * | 1999-10-08 | 2004-06-01 | Intuit, Inc. | Method and apparatus for mapping a community through user interactions on a computer network |
US7321864B1 (en) * | 1999-11-04 | 2008-01-22 | Jpmorgan Chase Bank, N.A. | System and method for providing funding approval associated with a project based on a document collection |
US7035910B1 (en) * | 2000-06-29 | 2006-04-25 | Microsoft Corporation | System and method for document isolation |
US6920430B1 (en) * | 2000-09-22 | 2005-07-19 | Accenture Llp | Method and system for an electronic procurement system for state governments |
JP2002169709A (en) * | 2000-11-30 | 2002-06-14 | Kurogane Kosakusho Ltd | Managing method of keeping and storing method for document |
US7269656B2 (en) * | 2000-12-28 | 2007-09-11 | Xerox Corporation | Remote order entry system and method |
US20040073507A1 (en) * | 2001-01-03 | 2004-04-15 | Scott William A. | Method and system for providing international procurement, such as via an electronic reverse auction |
US7010506B1 (en) * | 2001-11-29 | 2006-03-07 | Bellsouth Intellectual Property Corp. | Centralized process for addressing request for resource in a large organization |
-
2001
- 2001-01-10 US US09/760,341 patent/US20020133470A1/en not_active Abandoned
-
2005
- 2005-03-17 US US11/086,733 patent/US7552059B2/en not_active Expired - Lifetime
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6453306B1 (en) * | 1998-01-26 | 2002-09-17 | Ict Software S.A. | Internet commerce method and apparatus |
US20010051902A1 (en) * | 1999-06-28 | 2001-12-13 | Messner Marc A. | Method for performing secure internet transactions |
US20020188524A1 (en) * | 2001-04-26 | 2002-12-12 | Hidetaka Shimizu | Method for placing/receiving order using electronic mail |
Cited By (33)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20020120483A1 (en) * | 2001-02-27 | 2002-08-29 | Chi-Chung Chen | Method for dynamically identifying operation entity and system thereof |
US20040030614A1 (en) * | 2002-06-19 | 2004-02-12 | Shields Jay C. | Computer-implemented method and system for managing workload of procurement individuals |
US7617153B1 (en) | 2002-08-02 | 2009-11-10 | American Express Travel Related Services Company, Inc. | Global procurement bypass shutdown process and method |
US20040148052A1 (en) * | 2003-01-25 | 2004-07-29 | United Parcel Service | Hazardous materials shipping system, method and computer program product |
WO2004068302A3 (en) * | 2003-01-25 | 2005-05-19 | United Parcel Service Inc | Hazardous materials shipping system, method and computer program product |
US20060259486A1 (en) * | 2005-05-12 | 2006-11-16 | Microsoft Corporation | Method and system for enabling an electronic signature approval process |
US7849101B2 (en) * | 2005-05-12 | 2010-12-07 | Microsoft Corporation | Method and system for enabling an electronic signature approval process |
US20070100881A1 (en) * | 2005-10-24 | 2007-05-03 | International Business Machines Corporation | Method, system and storage medium for identifying and allocating surplus inventory |
US20080103966A1 (en) * | 2006-10-31 | 2008-05-01 | Chuck Foster | System and/or method for dynamic determination of transaction processing fees |
US20080114684A1 (en) * | 2006-10-31 | 2008-05-15 | Chuck Foster | Termination of transactions |
US20080114691A1 (en) * | 2006-10-31 | 2008-05-15 | Chuck Foster | Processing transactions |
US8060437B2 (en) | 2006-10-31 | 2011-11-15 | International Funding Partners Llc | Automatic termination of electronic transactions |
US20090112759A1 (en) * | 2007-10-30 | 2009-04-30 | Chuck Foster | Accumulated transactions |
CN103959281A (en) * | 2011-07-14 | 2014-07-30 | 多塞股份公司 | Method for associating third party content with online document signing |
AU2012283812B2 (en) * | 2011-07-14 | 2016-12-08 | Docusign, Inc. | Method for associating third party content with online document signing |
US9971754B2 (en) * | 2011-07-14 | 2018-05-15 | Docusign, Inc. | Method for associating third party content with online document signing |
US20130019156A1 (en) * | 2011-07-14 | 2013-01-17 | Docusign, Inc. | Method for Associating Third Party Content with Online Document Signing |
US9268758B2 (en) * | 2011-07-14 | 2016-02-23 | Docusign, Inc. | Method for associating third party content with online document signing |
US20160140101A1 (en) * | 2011-07-14 | 2016-05-19 | Thomas H. Gosner, JR. | Method for associating third party content with online document signing |
EP2732388A4 (en) * | 2011-07-14 | 2016-07-06 | Docusign Inc | Method for associating third party content with online document signing |
US9916582B2 (en) | 2011-07-28 | 2018-03-13 | Iii Holdings 1, Llc | Systems and methods for generating and using a digital pass |
US20140052643A1 (en) * | 2012-08-15 | 2014-02-20 | International Business Machines Corporation | Managing multiple approvals for projects |
US9824471B2 (en) | 2012-09-27 | 2017-11-21 | Oracle International Corporation | Automatic generation of hierarchy visualizations |
US20140095390A1 (en) * | 2012-09-28 | 2014-04-03 | Oracle International Corporation | Mobile transaction approvals |
US10346898B2 (en) * | 2013-10-24 | 2019-07-09 | American Axle & Manufacturing, Inc. | Electronic purchased part order data management system and method |
US10826997B2 (en) | 2015-11-06 | 2020-11-03 | Vynca, Inc. | Device linking method |
US20200051029A1 (en) * | 2017-02-27 | 2020-02-13 | Animation 2000 Limited | Digital Document Execution |
US11281887B2 (en) * | 2017-11-29 | 2022-03-22 | Vynca, Inc. | Multiple electronic signature method |
US11423164B2 (en) | 2018-05-21 | 2022-08-23 | Vynca, Inc. | Multiple electronic signature method |
US20220067613A1 (en) * | 2018-10-10 | 2022-03-03 | Bayer Aktiengesellschaft | Product supply apparatus |
JP2020144514A (en) * | 2019-03-05 | 2020-09-10 | ファナック株式会社 | Overseas corresponding application sales management server system |
US11599922B2 (en) | 2019-03-05 | 2023-03-07 | Fanuc Corporation | Overseas-compatible application sales management server system |
CN110619183A (en) * | 2019-09-24 | 2019-12-27 | 中国航空工业集团公司沈阳飞机设计研究所 | Full-life-cycle test flight test data management method |
Also Published As
Publication number | Publication date |
---|---|
US20050165659A1 (en) | 2005-07-28 |
US7552059B2 (en) | 2009-06-23 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20020133470A1 (en) | Material ordering and reporting expediter (MORE) | |
US7464054B2 (en) | Providing customs information | |
AU713314B2 (en) | Invoice purchase order system | |
US7082408B1 (en) | System and method for ordering items using a electronic catalog via the internet | |
US8880437B1 (en) | System and method for integrating trading operations including the generation, processing and tracking of and trade documents | |
US5627973A (en) | Method and apparatus for facilitating evaluation of business opportunities for supplying goods and/or services to potential customers | |
US7346562B2 (en) | System for placing orders using customer-specific electronic catalog | |
JP2007507800A (en) | System and method for merchant-assisted automatic payment processing and exception management | |
US20050075955A1 (en) | Order fulfillment architecture having an electronic customs invoice system | |
EP1403803A2 (en) | Method and system for the management of end user subscriptions | |
KR20020013038A (en) | business-trip management system and operation method for this system | |
JP4881094B2 (en) | Trading order management device and program | |
AU773004B2 (en) | Computerised ordering system | |
US20030149587A1 (en) | Method and system for processing obsolete goods | |
United States Government Accountability Office | FOREIGN MILITARY SALES: DOD Should Further Strengthen Financial Oversight of Transportation Fees | |
Curry et al. | BA 302: Microsoft Dynamics NAV ERP Exercise/Walkthrough | |
ROCESSING | Preparing a General Permit in NJ DEP Online | |
Regulation | Supply Policy Below the National Level | |
O’Connell | CDUM Program PDIT Final Technical Report | |
O'Connell et al. | Customer Driven Uniform Manufacture (CDUM) Program. Customer Driven Uniform Management Apparel Research | |
JP2001351020A (en) | Method and system for commodity trade | |
BANNER | The University of Louisiana at Monroe-Banner Test Site | |
O’Connell | ARN Program PDIT Final Technical Report–Delivery Orders 3, 12, 13 | |
O'Connell et al. | ARN II Program, Final Technical Report | |
JP2003331149A (en) | Ordering method and order receiving method |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AS | Assignment |
Owner name: SECRETARY OF THE NAVY AS REPRESENTED BY, UNITED ST Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:GRUBER, ROBERT M.;REEL/FRAME:011479/0744 Effective date: 20010110 |
|
STCB | Information on status: application discontinuation |
Free format text: ABANDONED -- FAILURE TO RESPOND TO AN OFFICE ACTION |