This chapter contains information about the following reports:
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. |
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.
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 |
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.
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. |
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
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. |
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).
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. |
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.
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. |
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.
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. |
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. |
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.
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. |
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.
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. |
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. |
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. |
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.
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.![]() |
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. |
For information about creating Shelf Labels, see the Xstore Point of Service Manager's Guide.
For information about the Store Layout, see the Xstore Point of Service Shipping, Receiving & Inventory Guide.
For information about the Inventory Count Sheet, see the Xstore Point of Service Shipping, Receiving & Inventory Guide.
For information about the Inventory Count Variance Reports, see the Xstore Point of Service Shipping, Receiving & Inventory Guide.