Inventory List with Price Report
Inventory List with Price Report
Inventory List with Price Report
Report #: 2019
Module: Account Generation
Overview
Use the Inventory List with Price Report to view the last price paid for inventory items. User’s branch restrictions apply.
To access this report, select Inventory List with Price (report #2019) from the main menu of SBN.
The Inventory List with Price Report
This window contains two panes: use the upper pane to define the content 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 Inventory List with Price Report.
Note: You can use wildcard characters in selected fields. For more information on using wildcards, see Searches.
|
Field |
Wildcards Accepted |
Description |
|
Primary Vendor |
No |
Enter a check mark in this box to limit the report to those items associated with a primary vendor.
|
|
Branch |
No |
You may select an inventory branch ID to limit the report to items associated with that inventory branch. (This menu originates from program #1530.)
|
|
GL Acc# |
Yes |
You may either select a specific GL account number to limit the report to inventory items associated with that GL account, or use the % wildcard to include all GL account numbers.
|
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 Inventory List with Price Report run for a primary vendor.
Column Descriptions
The following table describes the columns used in the Primary Vendor version of the output of the report.
|
Column |
Description |
|
Branch |
This field remains blank in the Primary Vendor version of the report. |
|
Code |
Identifies the inventory group. |
|
Item Code |
Identifies the selected item. |
|
Unit |
Unit of measure for the selected item. |
|
Description |
Text description of the selected item. |
|
Last Cost |
Last price paid to the primary vendor for the selected item or last purchase price for the selected item for the selected branch. |
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 Inventory List with Price Report
The following table lists modifications and updates to the Inventory List with Price Report document.
|
Mod Number |
Date |
Description |
|
n/a |
07/14/14 |
Images updated. |