10 Inventory Reports
Inventory Movement Report
The Inventory Movement Report lists items that were involved in a transaction and a code indicating the type of inventory movement. The report also shows the inventory location that each item came from, and where it was moved to (destination location). You can control the information on the report by specifying a range of item IDs, a date range when the movement occurred, and the type of inventory movement you want to list.
Table 10-1 Inventory Movement Report Parameters
Parameter | Description |
---|---|
Date |
The activity date. |
Item |
The item identifier. |
Serial Number |
The item's serial number. |
Quantity |
The line item quantity. |
Action Code |
The code for the item movement activity. For example, ITEM_RETURN is a code for a returned item and an ITEM_SALE code indicates the item was sold. |
Source data |
Location: The inventory location from which the item was moved. Bucket: The inventory bucket from which the item was moved. |
Destination data |
Location: The inventory location the item was moved into. Bucket: The inventory bucket the item was moved into. |
Criteria Selections for Inventory Movement Report
Select an option or make entries in any of the following fields to control report output:
-
Date Range: Enter a single fixed date, a date range (begin and end dates), or select a relative date option (Yesterday, Last Week, and so on) from the drop-down list.
-
Start Item ID: Enter the first item ID you want to include on the report.
-
End Item ID: Enter the last item ID you want to include on the report.
-
Movement Type: Select a movement type from the list of movement codes.
Figure 10-1 Sample: Inventory Movement Report
![Inventory Movement Report Inventory Movement Report](img/inventory_movement.png)
Inventory Stock Cost Report
This report looks at current on-hand inventory with the consideration of the item cost. These values together represent current cost of goods (on-hand). Use this report to understand your inventory.
Table 10-2 Inventory Stock Cost Report Parameters
Parameter | Description |
---|---|
Item |
The item identifier. |
Description |
The item description. |
On-Hand |
On-hand inventory quantity. |
Unit Cost |
Item unit cost. |
Total Cost |
On-hand quantity x Item Unit Cost |
Criteria Selections for Inventory Stock Cost Report
Select an option or make entries in any of the following fields to control report output:
-
Item ID: Enter an item ID to view the stock cost for that item.
-
Department: Enter a department ID to view the stock cost for items in a department.
-
Show Criteria: Determines whether the report will show the criteria used to create it.
Figure 10-2 Sample: Inventory Stock Cost Report
![Inventory Stock Cost Report Inventory Stock Cost Report](img/invent_stock_cost_rep.png)
Shipping/Receiving Exception Reports
The Shipping/Receiving Exception Reports include two separate reports, one for Shipping Exceptions and one for Receiving Exceptions. Both reports show the differences between the amounts expected to be shipped or received and the actual amounts for each Inventory Document number.
Table 10-3 Shipping/Receiving Exception Reports Parameters
Parameter | Description |
---|---|
Summary |
|
Document |
The document identifier. |
Date |
The activity date. |
Carton Count |
The number of cartons. Note: Not available on the Shipping Exception Report. |
Line Count |
The number of lines. |
Expected |
The number of items expected in the shipment based on the Inventory Document. Note: All store-created shipping documents have an expected item count of zero. Only documents downloaded from the home office have a value for the expected item count |
Shipped |
The actual number of items shipped. |
Difference |
The count discrepancy between the expected and the item count actually shipped. |
Totals |
Totals for Carton Count, Line Count, Expected, Shipped, and Difference. |
Detail |
|
Carton |
The carton number. Note: Not available on the Shipping Exception Report. |
Date |
The activity date. |
Item |
The item identifier |
Serial Number |
The item serial number. |
Description |
The item description. |
Expected |
The number of items expected in the shipment based on the Inventory Document. Note: All store-created shipping and receiving documents have an expected item count of zero. Only documents downloaded from the home office have a value for the expected item count. |
Shipped or Received |
The actual number of items shipped or received. |
Difference |
The count discrepancy between expected and the item count actually shipped or received. |
Totals |
Totals for Expected, Shipped, and Difference. |
Criteria Selections for Shipping/Receiving Exception Reports
Select an option or make entries in any of the following fields to determine report output:
Note:
The criteria selection forms for both shipping and receiving offer the same criteria options, except for the document type list. The types of documents available for shipping and receiving are listed separately below.
-
Report Date: Enter a single fixed date or select a relative date option (Today or Yesterday) from the drop-down list.
-
Report Type: Summary, Detail, Summary and Detail.
-
Document: Enter a specific shipping or receiving document number.
-
Carton: Enter a specific carton number.
Note:
The Carton number is not supported in the Shipping Exception Report.
-
(Shipping) Doc. Type: Select the kind of shipping inventory document you want to include in the report. The following list shows examples of shipping inventory document types. Your list may be different based on your business requirements.
-
All
-
Return to Vendor
-
Call Back
-
Work Order
-
Sale
-
Repair
-
Store Transfer
-
Defective Return
-
Order
-
-
(Receiving) Doc. Type: Select the kind of receiving inventory document you want to include in the report. The following list shows examples of receiving inventory document types. Your list may be different based on your business requirements.
-
All
-
ASN
-
Transfer
-
Work Order
-
Special Order
-
Order
-
Figure 10-3 Sample: Receiving Exception Report
![Receiving Exception Report Receiving Exception Report](img/receiv_exept_rep.png)
Figure 10-4 Sample: Shipping Exception Report
![Shipping Exception Report Shipping Exception Report](img/shipping_exception4.png)
Shipping Manifest Report
The Shipping Manifest Report provides shipping manifest information including the shipment recipient, the carrier and shipping method, the date shipped, and the item information for the shipment.
Table 10-4 Shipping Manifest Report Parameters
Parameter | Description |
---|---|
Ship to address information |
Name, Address, City, State, Country, Zip and Phone |
Ship Date |
The date the shipment was shipped. |
Carrier |
The shipper presenting the bill of lading for transferring the item. |
Ship Via |
The shipper method. |
Tracking |
The number assigned by the carrier. This number is used to track the progress of this shipment with the carrier. |
Item |
The item identifier. |
Description |
The item description. |
Quantity |
The item quantity. |
Criteria Selections for Shipping Manifest Report
Select an option or make entries in any of the following fields to control report output:
-
Date Range: Enter a single fixed date, a date range (begin and end dates), or select a relative date option (Yesterday, Last Week, and so on) from the drop-down list (Ship Date).
Figure 10-5 Sample: Shipping Manifest Report
![Shipping Manifest Report Shipping Manifest Report](img/ship_manifest_rep.png)
Receiving Report
This report includes receiving details so that you can validate proper receiving procedures and maintain inventory levels. Each Document is on its own page.
Navigate: Reports > Inventory Reports > Receiving Report.
Table 10-5 Receiving Report Parameters
Parameter | Description |
---|---|
Document |
The document identifier. |
Carton |
The carton identifier. |
Department |
The department for the subset of items. |
Item |
The item identifier and description. |
Dimension 1 |
The item color. |
Dimension 2 |
The item size. |
Qty. Expected |
The number of items expected in the shipment based on the Inventory Document. |
Qty. Received |
The received quantity of the item. |
Qty. Verified |
The verified quantity of the item. |
Carton Total |
Sum of the quantity expected, quantity received, and quantity verified for the carton. |
Total |
Sum of the quantity expected, quantity received, and quantity verified for the document. |
Selections for Receiving Report
Select an option or make entries in any of the following fields to control report output:
-
Date Range: Enter a single fixed date, a date range (begin and end dates), or select a relative date option (Yesterday, Last Week, and so on) from the drop-down list.
-
Specific Date: Choose a drop-down option.
-
Document: Enter the document identifier.
-
Carton: Enter the carton identifier.
-
Employee: Enter the ID of the person who received the carton.
Figure 10-6 Sample: Receiving Report
![Receiving Report Receiving Report](img/receiv_rep.png)
Restock Report
The Restock Report reflects all items that have been sold at the register and must be replaced on the shelves in order to maintain a consistent quantity.
Information on the report is grouped by department and shows the item ID, item description, and quantities for the items within each department. A total number of items sold within the department is calculated, and a report total shows a count of all items from all departments listed.
Table 10-6 Restock Report Parameters
Parameter | Description |
---|---|
Department data |
ID: The department identifier. Description: The department description. |
Item data |
ID: The item identifier. Description: The item description. |
Quantity Sold |
The number of items sold. |
Criteria Selections for Restock Report
Select an option or make entries in any of the following fields to determine report output:
-
Date Range: Enter a single fixed date, a date range (begin and end dates), or select a relative date option (Yesterday, Last Week, and so on) from the drop-down list.
-
Start Time: Enter the first time that you want to include in the report. The system will automatically enter “:" between the hours and minutes. The first one or two digits you enter indicate the hours and the digits after the colon are minutes. You must then enter “a" for morning hours (a.m.) or “p" for afternoon hours (p.m.)
-
End Time: Enter the last time that you want to include in the report using the same format indicated for the Start Time entry.
-
Department: Enter a department identifier.
Figure 10-7 Sample: Restock Report
![Restock Report Restock Report](img/restock_report.png)
Item List Report
The Item List Report shows inventory items, their current location ID, the inventory bucket within the location, and the quantity of items at that location.
Table 10-7 Item List Report Parameters
Parameter | Description |
---|---|
Item |
The item identifier. |
Description |
The item description. |
Location |
The inventory location for the item. |
Bucket |
The inventory bucket for the item. |
Quantity |
The number of items in this location and bucket. |
Criteria Selections for Item List Report
Select an option or make entries in any of the following fields to control report output:
-
Location: Select one of the defined inventory locations from the drop-down list.
-
Bucket: Select one of the defined inventory buckets from the drop-down list.
Figure 10-8 Sample: Item List Report
![Item List Report Item List Report](img/item_list_rep.png)
Inventory Movement Pending Report
The Inventory Movement Pending Report shows items from transactions in which an inventory location has not yet been specified when Location Based Inventory is being used.
Note:
The Inventory Movement Pending Reconciliation option allows an item to be assigned to a location so it is no longer in a pending status.
The report shows the transaction number, transaction date, item ID and quantity, and the inventory action code that is currently assigned.
Navigate: Inventory > Location Based Inventory > Inventory Movement Pending Report.
Table 10-8 Inventory Movement Pending Report Parameters
Parameter | Description |
---|---|
Date |
The activity date. |
Transaction |
The transaction number. |
Item |
The item identifier. |
Description |
The item's description. |
Serial Number |
The item's serial number. |
Action Code |
The code for the activity performed on the item. For example: ON_HAND-SOLD ON_HAND-SHIPPED ON_HAND-LAYAWAY LAYAWAY-SOLD SPECIAL_ORDER-SOLD |
Quantity |
The item count for the action. |
Criteria Selections for Inventory Movement Pending Report
Select an option or make entries in any of the following fields to control report output:
-
Date Range: Enter a single fixed date, a date range (begin and end dates), or select a relative date option (Yesterday, Last Week, and so on) from the drop-down list.
Figure 10-9 Sample: Inventory Movement Pending Report
![Inventory Movement Pending Report Inventory Movement Pending Report](img/invent_mov_pend_rep.png)
Inventory Movement History Report
The Inventory Movement History Report is useful when using Location Based Inventory. Line items in the report include the current stock ledger count. Additional line items in the report show information about items in specific transactions. This report shows where the item came from (the item's source location and inventory bucket) and where it went to (the item's destination location and destination inventory bucket). The quantity of items that were moved is also shown.
Table 10-9 Inventory Movement History Report Parameters
Parameter | Description |
---|---|
For each Item |
|
Date/Stock |
Stock = The items recorded in the current stock ledger. Date = The activity date of the transaction. |
Trans |
The transaction identifier. |
Source |
The inventory location from which the item was moved. |
Bucket |
The inventory bucket from which the item was moved. |
Destination |
The inventory location the item was moved into. |
Bucket |
The inventory bucket from which the item was moved. |
Destination |
The inventory location the item was moved into. |
Bucket |
The inventory bucket the item was moved into. |
Action Code |
The code for the activity performed on the item. |
Qty |
The item count for the action. |
Criteria Selections for Inventory Movement History Report
Select an option or make entries in any of the following fields to control report output:
-
Item ID: Enter an item ID to include on the report.
-
Date Range: Enter a single fixed date, a date range (begin and end dates), or select a relative date option (Yesterday, Last Week, and so on) from the drop-down list.
Figure 10-10 Sample: Inventory Movement History Report
![Inventory Movement History Report Inventory Movement History Report](img/invent_mov_hist_rep.png)
Inventory Adjustment Report
The Inventory Adjustment Report prints automatically when you manually adjust item inventory outside a sale transaction. Inventory adjustments are performed using the Inventory Adjustment option on the Back Office Inventory menu. Adjustments are often used to track damaged items discovered on the selling floor or items donated to a charitable organization, and are associated with a reason code for the adjustment. An employee signature line is also printed at the bottom of the report.
Table 10-10 Inventory Adjustment Report Parameters
Parameters | Description |
---|---|
For each Document # and Reason Code |
|
Date |
The activity date of the adjustment. |
Item and Description |
The item identifier and description. |
Quantity |
The item quantity. |
Bucket |
The inventory bucket the item was moved into. |
Location |
The inventory location the item was moved into. |
Open Product Request Summary Report
The Replenishment Open Product Requests Report displays replenishment orders that are Open, Submitted, or Confirmed. The report can be viewed on the screen and printed.
Navigate: Reports > Inventory Reports > Replenishment Open Product Request Report.
Table 10-11 Open Product Request Summary Report Parameters
Parameter | Description |
---|---|
Document Number |
Replenishment request document ID number. |
Date Submitted |
The date the request was submitted. (The Date Submitted field will be blank if the order has not yet been submitted). |
Source Entity Name |
The fulfillment source for the document. |
Replenishment Product Request Report
The Replenishment Product Request Report allows you to query by Order Status, Date Range or Specific Date, Requestor ID, Item ID, and Sourcing Entity. The report can be viewed on the screen and printed.
Navigate: Reports > Inventory Reports > Replenishment Product Request Report.
Table 10-12 Replenishment Product Request Report Parameters
Parameter | Description |
---|---|
Report Header |
|
Document Number |
Document identifier |
Request Date |
Replenishment order request date. |
Requestor |
Requesting system or user. |
Sourcing |
Source entity that will be fulfilling the replenishment request for this document/item. |
Ship To |
Ship-to details for the destination store address e.g. street, city, state and zip. |
Shipper |
Shipper identifier. |
Comments |
Comments entered by the user when creating the document. |
Report Detail |
|
Item |
Item identifier. |
Description |
Item description. |
Quantity |
Requested quantity for this item |
Confirmed data |
Date. Date quantity for this item was confirmed. Quantity: Confirmed quantity for this item. Number: The PO number, DC shipment number, or any other number generated by the home office to fulfill the store's request. |
Received |
Date: Date item was received for this request. Quantity: Quantity of this item received for this request. |
Status |
Status of this item. |
Total Weight |
Total shipping weight of all items for the request. |
Criteria Selections for Replenishment Product Request Report
Select an option or make entries in any of the following fields to control report output:
-
Order Status: Select the status from the drop-down list; All, Open, Submitted, Confirmed, Partially Received, Closed, or Cancelled.
-
Request Date Range: Enter a single fixed date, a date range (begin and end dates), or select a relative date option (Yesterday, Last Week, and so on) from the drop-down list.
-
Requestor ID: Enter the user ID or system ID that placed the replenishment order.
-
Item ID: Enter an item ID to include on the report.
-
Sourcing Entity: Enter the identifier for the location that sourced the replenishment order.
-
Show Criteria: Select Yes to show the criteria in the report, or No to not show them.
Figure 10-13 Sample: Product Request Detail Status
![Product Request Detail Status Report Product Request Detail Status Report](img/prod_req_det_stat.png)
Replenishment Order Worksheet
The Replenishment Order Worksheet is a summary by item ID and shows one line for each item Id on the current order.
Note:
In base, the Replenishment Order Worksheet is accessed through the Inventory Replenishment print options.
![Inventory Replenishment Print Options Inventory Replenishment Print Options](img/invent_rep_print_opt.png)
Table 10-13 Replenishment Order Worksheet Parameters
Parameter | Description |
---|---|
Source |
The default source id for the item. |
Item |
ID: The item identifier. Description: The item description. |
Order |
The total number of items that have been ordered but not confirmed by the home office yet. |
Pack Size |
The item pack size. |
On Hand |
The on-hand quantity of the item. |
Suggested |
The suggested quantity of the item. |
Confirmed |
The confirmed quantity of the item. |
Shipped |
The shipped quantity of the item. |
Received |
The received quantity of the item. |
Shelf Labels
For information about creating Shelf Labels, see the Xstore Point of Service Manager's Guide.
Store Layout
For information about the Store Layout, see the Xstore Point of Service Shipping, Receiving & Inventory Guide.