Open Purchase Order Report
Open Purchase Order Report
Open Purchase Order Report
Report #: 2012
Module: Account Generation
Overview
Use the Open Purchase Order report to view list of all open purchase orders, by branch, in purchase order number sequence.
To access this report, select Open Purchase Order Report (report #2012) from the main menu of SBN.
The Open Purchase Order Report
This window contains two panes: use the upper pane to define the contents of the report; use the lower pane to define the job output - how, when, and where you want to print the report.
Note: See Report Parameters Pane for information on the fields in the lower pane, which are the same in every report.
Field Descriptions
The following table describes the fields used in the upper pane of the Open Purchase Order Report.
|
Field |
Description |
|
Branch |
You may select a receiving branch ID to limit the report to records associated with that receiving branch. O If you leave this field blank, the report includes all branches. O If option rptprof is on, SBN limits the report output to branches matching the user’s branch profile. |
|
Sched Date Range |
|
|
Date - From |
You may select a range of dates during which the items were scheduled for shipment to limit the report to records within that range. Select the beginning date of the range. |
|
Date - To (No label) |
You may select a range of dates during which the items were scheduled for shipment to limit the report to records within that range. Select the ending date of the range. |
|
Vendor ID |
You may select a specific vendor ID to limit the report to vendor IDs within that range. (This menu originates from program #1758.) |
|
Exp Date Range |
|
|
Exp Date - From (No label) |
You may select a range of dates during which the items are expected to limit the report to records within that range. Select the beginning date of the range. |
|
Exp Date - To (No label) |
You may select a range of dates during which the items are expected to limit the report to records within that range. Select the ending date of the range. |
|
PO Number Range |
|
|
PO # - From (No label) |
You may select a range of purchase order numbers to limit the report to PO numbers within that range. Select the beginning PO number of the range. |
|
PO # - To (No label) |
You may select a range of purchase order numbers to limit the report to PO numbers within that range. Select the ending PO number of the range. |
|
Item Code |
You may type a specific item code to limit the report to records with that item code. |
|
Vend Item Code |
You may type a specific vendor item code to limit the report to records with that vendor item code. The Vend Item Code field holds the entire item code number and description. |
|
Confirm |
You may type a specific confirmation number (from the purchase order) to limit the report to that confirmation number. |
Running and Viewing a Report
For information on running and viewing a report, see Common Functions in SBN.
Report Example
The following graphic shows an example of the output of the Open Purchase Order report.
Column Description
The following table describes the columns used in the output of this report.
|
Column |
Description |
|
Branch |
Receiving branch for the purchase order. |
|
Item Code |
Item code for the item entered in the purchase order. |
|
Vendor Item Code |
Vendor-assigned item code entered in the purchase order. |
|
Description |
Text description of the item. |
|
Qty-Ord |
Quantity of the item ordered. |
|
Qty-Rec |
Quantity of the item received. |
|
Confirm |
Confirmation number entered on the purchase order. |
|
Rem. Cost |
Remaining cost of the items not yet received. |
|
Sch Date |
Date the item(s) are scheduled to ship. |
|
Exp Date |
Date the item(s) are expected to arrive. |
|
PO Number |
Number assigned to the purchase order. |
|
PO Total |
Total amount of the purchase order. |
|
Vendor Total |
Total amount of items ordered from a vendor. |
|
Branch Total |
Total amount of items ordered for a specific branch. |
|
Grand Total |
Total amount of all purchase orders listed on the report. |
Button Functions
The following table displays the buttons, describes the shortcut keys, actions, and functionality.
|
Button |
Name |
Shortcut Key |
Action |
Description |
|
|
Open fields for recurring/template reports |
alt+f1 |
Open fields for recurring/template reports. |
|
|
|
Exit without saving |
esc |
Exit without saving changes to selected record. |
|
|
|
Save Existing Record |
enter |
Save changes to selected record. |
Modifications and Updates to the Open Purchase Orders Document
The following table lists modifications and updates to the Open Purchase Orders document.
|
Mod Number |
Date |
Description |
|
n/a |
07/14/14 |
Images updated. |