PO0300 Purchase Order and Receiving Purchase Order Inquiry

Inquiry

Purchase Order Inquiry 

Application Overview

 This application enables you to quickly review the purchase orders that are on file for a vendor.  If you wish to know which orders are on file for a vendor or what was ordered on a particular purchase order, or what has been received so far against a specific order, you will likely use the Purchase Order Inquiry application to get this data

The Elliot Purchase Order Inquiry allows the user many different ways of accessing and viewing a Purchase Order.  Major features include:

  1. Accessing by P.O. Number without having to enter the Vendor Number.
  2. Lists P.O. Numbers in reverse sequence by listing the highest P.O. number first.  If the P.O. numbering sequence is adhered to, then the list order will be by last P.O. entered. This makes it easier and faster to find and access Purchase Orders.  If viewing Purchase Orders by Vendor, the P.O.’s are also in reverse sequence.
  3. Moving bar highlights the P.O. and shows the details as each P.O. is highlighted.     
  4. Allows you to view the entire P.O. that is highlighted when you press <Enter>.  When you exit this detail screen, the system returns you to the P.O. list.

 

Run Instructions

Select Purchase Order Inquiry from the pull down P/O Inquiry window.  The following screen will then be displayed:

 

 

From this screen you have the following three options:

            F7        Search By Vendor Number

            F8        Search By Vendor Name

            F1        Search By P.O. Number

When inquiring by P.O. Number, the lower menu bar options are:

1.         Return = Next Order,

2.       F1 = List All Orders

3.       F2 = List Orders By Item No.

  

F7/F8 Options

 

From the P.O. No. field you may enter the PO number, press return for next vendor PO , F1 to list all PO’s for vendor, or F2 for item number / vendor number.

 

F1:                   All PO’s for Vendor Inquiry

 

 

F2:                   By Item or Vendor Item No. Inquiry

Beginning with Elliott 7.4, for Purchase Order Inquiry by Item, the system will now display the total PO Qty and Outstanding Balance to give buyers a quick summary view.  In addition, for any un-posted receiving transactions (i.e. goods on ocean), the system will display their quantity in PO Inquiry as “Pending” quantity.

 

When inquiring on a specific purchase order, the purchase order header information will display in the top half of the screen.  Up to three line items will display in the lower half.  If there are more than three line items on the order, a message will display on the bottom line, informing you to press the F1 key to display further line items or to press the ESC key to terminate the inquiry.  If there are no more line items on the order, a message will display, informing you that the end of the order has been reached.

 Once you reach the end of the order and press the RETURN key or you terminate the inquiry, (using the ESC key), the cursor is positioned for entry of another purchase order number.  You may press ESC to return for a selection of another vendor number.

 To return to the menu bar, press the ESC or F10 key. To leave this application, press X for EXIT when positioned at the menu bar.

 

 


Entry Field Descriptions

 

Name

Type and Description

Vendor No

6 alphanumeric characters.

Enter the number of the vendor whose orders you wish to review.  When you enter the number of a vendor on file in the Vendor file, the vendor's name and address will display beside the entry to help you verify that you have the correct vendor number.

Pressing the F7 key will allow you to search for the vendor by number or pressing the F8 key will allow you to search for the vendor by name.

P.O. No

6 numeric digits followed by 2 number digits (999999‑99).

Defaults to the first (or next) order on file for the vendor.

Enter the purchase order number of the vendor's order you wish to review.  If you do not know the precise order number, there are three options available to help you locate it.

If there are only a few orders on file for the vendor, you may find it most convenient to simply press RETURN.  Doing so will cause the program to locate and display the first order's header and line item data.  A question will display on the bottom of the screen, asking if you wish to view another order.  If you answer Y, the next order for the vendor will be displayed.  If you answer N, the cursor will position for the entry of a new purchase order number.

 

P.O. No (continued)

You may continue displaying the next order in this fashion until all of the vendor's orders have been displayed.

Accessing orders one by one to locate the correct one is a slow process, particularly if there are a large number of orders on file.

A faster way is to press the F1 key to get a list of all the orders on file for the vendor.  This list presents the orders in numerical order and provides key information to help you identify the order you need.

If you know the number of one of the items on the order, you may press the F2 key to display a screen upon which you enter the item number (or the vendor's item number).  The program then displays all of the orders upon which this item number appears. 

Line item data is summarized on this list to help you locate the correct order.  As an additional convenience, you may access the item number by the item's description.

Item Number Or

Vendor Item No

15 alphanumeric characters.

Enter the item number.  Its description will display beside the entry and the vendor item number will also display if it is on file.  If you only know the vendor's item number, you may press RETURN to skip the entry of that field.

Pressing the F7 key will allow you to search for an item by number or pressing the F8 key will allow you to search for an item by description.

The entry of the vendor's item number requires that the vendor/item number relationship be defined in the Item Vendor file.  If the program cannot locate such a relationship, the entry will be disallowed.  You may return for entry of the item number by pressing ESC.  If the relationship is defined, the item number and description will display.

Inquiry Display Fields

 

Name

Type and Description

Order Type

Display only.

This is the unlabeled field that displays beside the order number.  It also displays labeled as TYPE on the list of orders that is accessed by pressing the F1 key.  The order type identifies the order as being a NORMAL, BLANKET, RELEASE or DROP SHIP order.

Qty‑Due

Display only.

This field appears only on the list of orders activated by the F2 key.  It represents the difference between the quantity ordered and the quantity received and is expressed in the item's stocking unit of measure if the item is defined in the Item file.

Expected‑Cost

Display only.

This field also appears only on the list of orders that are accessed by the F2 key.  It shows the unit cost at which the merchandise was ordered (in the stocking unit of measure).

Order‑From

Display only.

These fields show the vendor's name and address.

Ship‑To

Display only.

These fields identifies the shipping destination for the order.  The address may be that of the receiving warehouse or, in the case of drop shipments, the customer's shipping address.

Status

Display only.

This is the purchase order's status.  Possible values for this field are NOT REL (Unreleased), RELEASED, PRINTED, CLOSED and CANCEL.

Cancel

Display only.

This field indicates whether cancellation of the order has been initiated.  Once the order has actually been canceled by printing it as a cancellation order, the status above would display Cancel and this field would be blank.  Values for this field are Yes or No.

Ack

Display only.

If an order acknowledgment is requested for the order, Yes dis­plays in this field.  Otherwise, not required.

Confirm

Display only.

If confirmation of the order is requested, Yes displays in this field.  Otherwise, not required.

Ord‑Date

Display only. 

This is the date the order was entered.

Prt‑Date

Display only.

This is the date the order was printed.  If unprinted, this field displays as blank.

Buyer

Display only.

This is the code of the buyer who is associated with the order.

Terms

Display only.

These are the order's terms.

Fob

Display only.

This is the description of the order's FOB point.

Ship‑Via

Display only.

This is the description of the requested shipping method.

C/Ppd

Display only.

This field indicates whether the merchandise on the order is to be shipped freight collect or prepaid by the vendor.  Possible values for this field are COL, PPD and blank.

Item‑No

Display only. 

This is the line items' number as identified on the purchase order.

Line‑No

Display only.

This is the line item's line number on the purchase order.  It displays below the item number.

U/M

Display only.

This is the unit of measure in which quantities for the line item are expressed.  For those items that are defined in the Item file, it is always the item's stocking unit of measure regard­less of the unit of measure in which the merchandise was ordered.  This field displays below the item number and beside the line number.

Item‑Description

Display only. 

This is the description of the item as represented in the pur­chase order.

Ord

Display only.

This is the quantity that was ordered on the line item expressed in the item's stocking unit of measure (when this value is available).

Rec

Display only.

This is the quantity that has been received against the line item so far.  It displays directly below the quantity ordered in the item's stocking unit of measure.

Rej

Display only.

This field shows how many units have been rejected to date in the item's stocking unit of measure.

Inv

Display only.

This field shows how many units have been invoiced through the Accounts Payable package.  As for the other quantities it is ex­pressed in the item's stocking unit of measure.  It displays directly below the reject quantity.

U‑Cost

Display only.

This is the item's unit cost expressed in item's stocking unit of measure.

Prom

Display only.

This is the line item's promise date.  If no promise date has been entered for the line item, the request date displays.

Sts

Display only.

This is the line item's status.  Possible values for this field are NEW, PRT (Printed), CAN (Canceled) or Blank.

 

Purchase Order

  1. Why Receiving Non-Inventory Items in PO Will Cause General Ledger Inventory Account Out of Balance?
  2. Order Has Been Printed But Not Posted
  3. When does the Purchase Line History data get updated?
  4. Can I Edit the Ship Date Field in PO Line Item Screen?
  5. Getting PO Lock File Problem During PO Printing
  6. Feature - Notes Tracking from PO Warehouse Receiving to Inventory Transfer Management to Inventory Transaction
  7. Feature - Prevent MM Item from Purchasing
  8. Feature - Include Or Exclude UDC in Buyer's Desk
  9. Feature - Item Number Verification After Serial Number Scan
  10. PO05S1 Purchase Order and Receiving Receivings Audit Trail Report
  11. PO05S2 Purchase Order and Receiving Drop Shipment Receivings Report
  12. PO0104 Purchase Order and Receiving Release Blanket Orders
  13. PO0105 Purchase Order and Receiving Purge Closed Purchase Orders
  14. PO0200 Purchase Order and Receiving Print Purchase Orders
  15. PO0300 Purchase Order and Receiving Purchase Order Inquiry
  16. PO0400 Purchase Order and Receiving Scheduled Receipts Reports
  17. PO0600 Purchase Order and Receiving Purchase Line History Report
  18. PO0700 Purchase Order and Receiving Cash Requirements Projection Report
  19. PO0800 Purchase Order and Receiving Commodity Code Vendor Report
  20. PO0900M Purchase Order and Receiving Vendor Performance Analysis Report
  21. PO1000 Purchase Order and Receiving P/O Setup
  22. PO1101 Purchase Order and Receiving Buyer Code File Maintenance
  23. PO1201 Purchase Order and Receiving Comment Code File Maintenance
  24. PO1301 Purchase Order and Receiving Reject Reason Code File Maintenance
  25. PO1401 Purchase Order and Receiving Ship-To File Maintenance
  26. PO1501 Purchase Order and Receiving Item Vendor File Maintenance
  27. PO1502 Purchase Order and Receiving Purge Item Vendor File Maintenance
  28. PO1601 Purchase Order and Receiving Vendor Service Address
  29. PO1700 Purchase Order and Receiving Clear Year-to-Date Statistics
  30. PO1800 Purchase Order and Receiving Open Purchase Orders Reports
  31. POCLSMNU Purchase Order and Receiving PO Close Processing
  32. POIMPMNU Purchase Order and Receiving Purchase Order Import
  33. POINVMNU Purchase Order and Receiving Invoice Processing
  34. POORDEXS Purchase Order and Receiving Purchase Order Export
  35. POEQMNT Purchase Order and Receiving Purchase Order Requisition
  36. POEQPST Purchase Order and Receiving Post Requisitions
  37. PORSTSCN Purchase Order and Receiving Reset P/O Rec/Inv Qty
  38. POUPDSTA Purchase Order and Receiving Update Vendor Statistics
  39. POWHRMNT Purchase Order and Receiving Warehouse Recovery Process
  40. POWRIMNT Purchase Order and Receiving Warehouse Receiving Import
  41. Feature -- PO Ship-to File Maintenance Determine Drop Ship Location by State/Zip Code Tables
  42. Feature - Warehouse Receiving Serial Number Validation
  43. Feature - Buyer's Desk Inventory Class Selection Criteria
  44. Feature - PO Ship-To File Received to Transit Location
  45. Purchase Order Line Item Add or Change Event
  46. PO0000 Purchase Order and Receiving Overview 1
  47. PO0000 Purchase Order and Receiving Overview 2
  48. PO0000 Purchase Order and Receiving Overview 3
  49. PO0000 Purchase Order and Receiving Overview 4
  50. PO0000 Purchase Order and Receiving Overview 5
  51. PO0000 Purchase Order and Receiving Overview : Index
  52. PO0100 P/O and Receiving Purchase Order Processing 1
  53. PO0100 P/O and Receiving Purchase Order Processing 2
  54. PO0100 P/O and Receiving Purchase Order Processing 3
  55. PO0100 P/O and Receiving Purchase Order Processing 4
  56. PO0100 P/O and Receiving Purchase Order Processing 5
  57. PO0100 P/O and Receiving Purchase Order Processing: Index
  58. PO2000 P/O and Receiving Receivings Processing 1
  59. PO2000 P/O and Receiving Receivings Processing 2
  60. PO2000 P/O and Receiving Receivings Processing 3
  61. PO2000 P/O and Receiving Receivings Processing 4
  62. PO2000 P/O and Receiving Receivings Processing 5
  63. PO2000 P/O and Receiving Receivings Processing 6
  64. PO2000 P/O and Receiving Receivings Processing 7
  65. PO2000 P/O and Receiving Receivings Processing 8
  66. PO2000 P/O and Receiving Receivings Processing 9
  67. PO2000 P/O and Receiving Receivings Processing: Index
  68. POFRMMNT P/O and Receiving P/O Form Setup 1
  69. POFRMMNT P/O and Receiving P/O Form Setup 2
  70. POFRMMNT P/O and Receiving P/O Form Setup 3
  71. POFRMMNT P/O and Receiving P/O Form Setup 4
  72. POFRMMNT P/O and Receiving P/O Form Setup 5
  73. POFRMMNT P/O and Receiving P/O Form Setup: Index
  74. PORCNMNU P/O and Receiving P/O Reconciliation Process 1
  75. PORCNMNU P/O and Receiving P/O Reconciliation Process 2
  76. PORCNMNU P/O and Receiving P/O Reconciliation Process 3
  77. PORCNMNU P/O and Receiving P/O Reconciliation Process: Index
  78. How to Retrieve Open Purchase Orders Through SQL SELECT Statement
  79. Feature - Receivings Processing Mass Receiving Changes
  80. Feature - Warehouse Receiving Mass Receiving

Feedback and Knowledge Base