Consolidated Inventory with Branch Details
Consolidated Inventory with Branch Details
Consolidated Inventory with Branch Details
Report #: 2039
Module: Account Generation
Overview
Use the Consolidated Inventory with Branch Details report to view the number of days of inventory on hand for up to nine branches.
User’s branch restrictions apply. To access this report, select Consolidated Inventory with Branch Details (report #2039) from the main menu of SBN.
The following topics are covered within this document:
The Consolidated Inventory with Branch Details Report
The Consolidated Inventory with Branch Details 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 this report.
|
Field |
Description |
|
Inventory Group Range |
|
|
Group - From |
You may select a range of inventory groups to limit the report to inventory groups within that range. Select the beginning inventory group of the range. (This menu originates from program #1764.) O If you leave these fields blank, the report includes all inventory groups. |
|
Group - To |
You may select a range of inventory groups to limit the report to inventory groups within that range. Select the ending inventory group of the range. (This menu originates from program #1764.) O If you leave these fields blank, the report includes all inventory groups. |
|
Vendors Range |
|
|
Vendor - From |
You may select a range of vendor IDs to limit the report to inventory associated with vendors within the range. Select the beginning vendor ID of the range. (This menu originates from program #1758.) O If you leave these fields blank, the report includes all vendor IDs. |
|
Vendor - To |
You may select a range of vendor IDs to limit the report to inventory associated with vendors within the range. Select the ending vendor ID of the range. (This menu originates from program #1758.) O If you leave these fields blank, the report includes all vendor IDs. |
|
Primary |
Enter a check mark in this box to limit the report to items associated with a primary vendor. |
|
Items Range |
|
|
Item - From |
You may select a range of item codes to limit the report to items within the range. Select the beginning item code of the range. (This menu originates from program #1535.) O If you leave these fields blank, the report includes all item codes. |
|
Item - To |
You may select a range of item codes to limit the report to items within the range. Select the ending item code of the range. (This menu originates from program #1535.) O If you leave these fields blank, the report includes all item codes. |
|
Days on Hand |
Enter a check mark in this box to limit the report to items that have a quantity above or below the number of days entered in the following fields. |
|
above |
Type a number of days of on hand inventory to limit the report to items with a quantity greater than the number typed. |
|
or below |
Type a number of days of on hand inventory to limit the report to items with a quantity less than the number typed. |
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 Consolidated Inventory with Branch Details report.
Column Descriptions
The following table describes the columns used in the report output.
|
Column |
Description |
|
Branch |
Displays up to nine branch IDs. |
|
Code |
Identifies the inventory group. |
|
Item Number |
Item number. |
|
OnHand / Value |
Displays quantity on hand and inventory value of each item number, in each branch column; based on (quantity on hand) * (standard cost). |
|
OnOrd / DOH |
Displays quantity on order and the number of days on hand for each item number, in each branch column; based on (quantity on hand) / (average daily usage). |
|
Total Value |
Total value of the selected inventory group, at standard cost. |
|
Grand Total |
Total value for all inventory groups, at standard cost. |
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 Consolidated Inventory with Branch Details
The following table lists modifications and updates to the Consolidated Inventory with Branch Details document.
|
Mod Number |
Date |
Description |
|
n/a |
7/11/14 |
Images updated. |