Get documents about "Inventory Reports
Document Sample
Inventory Reports
Purpose
Use this job aid as an Inventory Report reference guide. This job aid lists reports
used for Core-CT Inventory. The list includes each report's name, description,
navigation, and any prerequisite steps that must be performed to provide data for
the report.
Additional Reports for the Inventory module can be found on the Catalog of Online
Financial Reports located at http://www.core-ct.state.ct.us/reports/ and
information on running an online report can be found at http://www.core-
ct.state.ct.us/reports/running.asp
This job aid does not cover the CO-59 query. For more information on the CO-59
query, use the following WLA path: Core-CT Asset Management > CO-59 > Data
Entry Procedures > CO-59 Queries for Assets and Inventory.
Report Name Report Description Core-CT Navigation Path Prerequisites for
Running the Report
Material Putaway Plan Lists all items in a staging ID Inventory > Putaway Process a PO Receipt to
by Staging ID (IN that are not in error. Stock > Review Plan (click receive an item into
Putaway Plan - INC3500) FYI – Most agencies have Print button on Review Inventory and run to
been configured to “flag items Plan page) Receiver Push and Load
for auto-putaway” by user Staged Items processes.
preference.
Material Issue Lists details about a material Inventory > Fulfill Stock Enter a Material Stock
Transaction Document stock request. Orders > Stock Requests Request (MSR).
(IN Material Issue > Create/Update Stock
Document - INC6501) Request > (click the Print
button on Stock Request
Summary page next to the
Reserve button. Then go
to the Report Manager,
which will bring you to the
Inventory Material Issue
document).
Shipping Document Provides a copy of the orders Inventory > Fulfill Stock Enter a Material Stock
(INC6503) and order lines shipped in a Orders > Shipping > Request (MSR). Complete
specific Shipping ID. Shipping/Issues > (click Demand Fulfillment
Print button on Order through the Shipping
Summary page next to the and/or Depletion process
Search link. Then go the for the MSR. A Shipping
Report Manager, which ID must be assigned to the
will bring you to the Material Stock Request
Inventory Shipping prior to printing the
document. Shipping Document.
Material Picking Plan Lists picking instructions for Inventory > Fulfill Stock Create Material Stock
Core-CT December 2006
(INS6000) stockroom processing. Orders > Picking > Order Request (MSR) and
Release Request approve. Run the Material
Reservations process.
Picking Shortage Lists non-soft-reserved items Inventory > Fulfill Stock Create and (if applicable)
Report for which insufficient available Orders > Picking > Picking approve an MSR, and run
(INS6060) quantity exists to fulfill Shortage Report materials reservation
requested or promised order process that requests
lines within a given picking more than the available
lead time. quantity of item(s).
Packing Slip Lists the order number, ship Inventory > Fulfill Stock Create an MSR and
(INS6500) to address, and item Orders > Shipping process through all
information for shipping. Reports > Packing Slip Demand Fulfillment steps.
Storage Locations Generates a list of material Inventory > Maintain Define storage locations
(INS2000) storage location attributes. Storage Locations > for the Inventory Business
Storage Locations Report Unit.
Material Putaway Plan Lists all items being put away Inventory > Putaway Process a PO Receipt to
(INS3500) that satisfy the criteria Stock > Putaway Plan receive an item into
specified on the Putaway Report Inventory and run to
Plan page. Receiver Push and Load
Staged Items processes.
Physical Accounting Lists discrepancies between Inventory > Inventory Create a Counting Event.
Reconciliation Report the actual count and the Counts > Reconcile
(INS5050) quantity expected for cycle Inventory Balances >
counts. Reconciliation Report
Counting Sheet Lists the storage locations of Inventory > Inventory Create Counting Event.
(INS9051) items included in a counting Counts > Create Counting
event. You can use this Sheet
report to record the count
results for each location
listed.
Slow Moving Inventory Identifies infrequently used Inventory > Manage Define inventory items for
(INS5200) inventory items. Inventory > Reports > Inventory Business Unit
Slow Moving Inventory and Putaway stock for the
Item.
Negative Balance Identifies all levels at which a Inventory > Manage Items with negative
Report given item has a negative Inventory > Reports > balances present. (Note:
(INS5300) value. Negative quantities Negative Balances negative balances must be
can occur at the business unit corrected as soon as
level, at the storage location possible.)
level, or for an item-lot
combination.
Core-CT December 2006
Stock Status Report Summarizes the availability Inventory > Manage Define inventory items for
(INS5400) and value of stock by item. Inventory > Reports > Inventory Business Unit
Stock Status and Putaway stock for the
Item.
Transaction Register Lists transactions with item Inventory > Manage Create an inventory
Report information and transaction Inventory > Reports > transaction (e.g., an MSR,
(INS7100) dates. Allows selection by Transaction Register Receipt or Transfer Stock
Item and/or Transaction transaction) within the
Group. Inventory Business Unit.
Issues History Report Provides monthly issue Inventory > Manage Create MSR or Express
(INS7150) information about stock items Inventory > Reports > Issue transactions and
for a department, business Issues History process through Depletion.
unit, or all locations.
Inventory Balance Checks inventory quantity Inventory > Manage Receive items into
Audit balances for discrepancies Inventory > Reports > inventory. Create MSRs or
(INS9090) and helps trace the origin of Inventory Balances Express Issues that have
any issues that may exist. gone through the
You should use the audit Depletion process.
reports during system
implementation and during
your testing processes for
system modifications. We
also recommend that you run
the audit reports as part of
your standard system
maintenance procedures.
Manual Replenishment Report to identify Inventory Inventory > Manage Define item minimum
Report items that need to be re- Inventory > Reports > reorder point, and have on
(CTIN6062) ordered. Manual Replenishment hand quantity below
minimum replenishment
value.
Inventory On Hand Provides on-hand quantity Cost Accounting > Define inventory items and
Value Report and on-hand value for items. Inventory and Mfg Putaway stock for the
(Inventory Value Accounting > Reports > Item.
History Report) Inventory Value History
(CMS2010)
Accounting Register Lists accounting transaction Cost Accounting > Enter and process
Report line information by Item. Inventory and Mfg Inventory transactions.
(INS7050) Allows selection by Accounting > Reports > Run the Transaction
Transaction Group and/or Accounting Register Costing and Accounting
Date. Line Creation process.
Core-CT December 2006
Movement by Receipt Summarizes depletions, and Cost Accounting > Receive items into
Line shows on-hand quantity and Inventory and Mfg inventory. Create MSRs or
(CMS2015) value by receipt line. The unit Accounting > Reports > Express Issues that have
costs used to calculate Movement by Receipt gone through the
receipt and depletion costs Depletion process. Run
reflect costs at transaction the Transaction Costing
time. process.
Movement by For each depletion line, this Cost Accounting > Receive items into
Depletion Line report prints the receipt that Inventory and Mfg inventory. Create MSRs or
(CMS2016) the system uses to deplete Accounting > Reports > Express Issues that have
that transaction, by business Movement by Depletion gone through the
unit, book, and by item. The Depletion process. Run
depletion cost is calculated the Transaction Costing
based on the cost at process.
processing time. The report
does not show on-hand
quantity or value.
On Hand Balance Verifies that the quantity Cost Accounting > Item costs must be defined
Validation Report tracked by cost management Inventory and Mfg for the Inventory Business
(CMS9010) processes are the same as Accounting > Reports > Unit. Inventory
the quantities tracked by On Hand Balance transactions must take
inventory processes. You Validation place. Enter Items and
can also reprint existing Putaway stock for the
reports. Items.
Core-CT December 2006
Report Name Report Description Core-CT Navigation Prerequisites for
Path Running the Report
Material Putaway Lists all items in a staging ID Inventory > Putaway Process a PO Receipt to
Plan by Staging ID that are not in error. Stock > Review Plan receive an item into
(IN Putaway Plan - (click Print button on Inventory and run to
INC3500) Review Plan page) Receiver Push and Load
Staged Items processes.
Material Issue Lists details about a material Inventory > Fulfill Enter a Material Stock
Transaction stock request. Stock Orders > Stock Request (MSR).
Document Requests > Material
(IN Material Issue Stock Request >
Document - (click Print button on
INC6501) Stock Request
Summary page)
Shipping Document Provides a copy of the orders Inventory > Fulfill Enter a Material Stock
(INC6503) and order lines shipped in a Stock Orders > Request (MSR).
specific Shipping ID. Shipping > Complete Demand
Shipping/Issues > Fulfillment through the
(click Print button on Shipping and/or
Order Summary Depletion process for the
page) MSR. A Shipping ID must
be assigned to the
Material Stock Request
prior to printing the
Shipping Document.
Material Picking Lists picking instructions for Inventory > Fulfill Create Material Stock
Plan stockroom processing. Stock Orders > Request (MSR) and
(INS6000) Picking > Picking approve. Run the
Plan Report Material Reservations
process.
Picking Shortage Lists non-soft-reserved items Inventory > Fulfill Create and (if applicable)
Report for which insufficient Stock Orders > approve an MSR, and run
(INS6060) available quantity exists to Picking > Picking materials reservation
fulfill requested or promised Shortage Report process that requests
order lines within a given more than the available
picking lead time. quantity of item(s).
Packing Slip Lists the order number, ship Inventory > Fulfill Create an MSR and
(INS6500) to address, and item Stock Orders > process through all
information for shipping. Shipping Reports > Demand Fulfillment
Packing Slip steps.
Storage Locations Generates a list of material Inventory > Maintain Define storage locations
(INS2000) storage location attributes. Storage Locations > for the Inventory
Storage Locations Business Unit.
Core-CT December 2006
Report
Material Putaway Lists all items being put away Inventory > Putaway Process a PO Receipt to
Plan that satisfy the criteria Stock > Putaway receive an item into
(INS3500) specified on the Putaway Plan Report Inventory and run to
Plan page. Receiver Push and Load
Staged Items processes.
Physical Accounting Lists discrepancies between Inventory > Inventory Create a Counting Event.
Reconciliation the actual count and the Counts > Reconcile
Report quantity expected for cycle Inventory Balances >
(INS5050) counts. Reconciliation Report
Counting Sheet Lists the storage locations of Inventory > Prepare Create Counting Event.
(INS9051) items included in a counting Counting Event >
event. You can use this Create Counting
report to record the count Sheet
results for each location
listed.
Slow Moving Identifies infrequently used Inventory > Manage Define inventory items for
Inventory inventory items. Inventory > Reports Inventory Business Unit
(INS5200) > Slow Moving and Putaway stock for
Inventory the Item.
Negative Balance Identifies all levels at which a Inventory > Manage Items with negative
Report given item has a negative Inventory > Reports balances present. (Note:
(INS5300) value. Negative quantities > Negative Balances negative balances must
can occur at the business be corrected as soon as
unit level, at the storage possible.)
location level, or for an item-
lot combination.
Stock Status Report Summarizes the availability Inventory > Manage Define inventory items for
(INS5400) and value of stock by item. Inventory > Reports Inventory Business Unit
> Stock Status and Putaway stock for
the Item.
Transaction Lists transactions with item Inventory > Manage Create an inventory
Register Report information and transaction Inventory > Reports transaction (e.g., an
(INS7100) dates. Allows selection by > Transaction MSR, Receipt or Transfer
Item and/or Transaction Register Stock transaction) within
Group. the Inventory Business
Unit.
Issues History Provides monthly issue Inventory > Manage Create MSR or Express
Report information about stock items Inventory > Reports Issue transactions and
(INS7150) for a department, business > Issues History process through
unit, or all locations. Depletion.
Core-CT December 2006
Inventory Balance Checks inventory quantity Inventory > Manage Receive items into
Audit balances for discrepancies Inventory > Reports inventory. Create MSRs
(INS9090) and helps trace the origin of > Inventory Balances or Express Issues that
any issues that may exist. have gone through the
You should use the audit Depletion process.
reports during system
implementation and during
your testing processes for
system modifications. We
also recommend that you run
the audit reports as part of
your standard system
maintenance procedures.
Manual Report to identify Inventory Inventory > Manage Define item minimum
Replenishment items that need to be re- Inventory > Reports reorder point, and have
Report ordered. > Manual on hand quantity below
(CTIN6062) Replenishment minimum replenishment
value.
Inventory On Hand Provides on-hand quantity Cost Accounting > Define inventory items
Value Report and on-hand value for items. Inventory and Mfg and Putaway stock for
(Inventory Value Accounting > the Item.
History Report) Reports > Inventory
(CMS2010) Value History
Accounting Register Lists accounting transaction Cost Accounting > Enter and process
Report line information by Item. Inventory and Mfg Inventory transactions.
(INS7050) Allows selection by Accounting > Run the Transaction
Transaction Group and/or Reports > Costing and Accounting
Date. Accounting Register Line Creation process.
Movement by Summarizes depletions, and Cost Accounting > Receive items into
Receipt Line shows on-hand quantity and Inventory and Mfg inventory. Create MSRs
(CMS2015) value by receipt line. The unit Accounting > or Express Issues that
costs used to calculate Reports > Movement have gone through the
receipt and depletion costs by Receipt Depletion process. Run
reflect costs at transaction the Transaction Costing
time. process.
Movement by For each depletion line, this Cost Accounting > Receive items into
Depletion Line report prints the receipt that Inventory and Mfg inventory. Create MSRs
(CMS2016) the system uses to deplete Accounting > or Express Issues that
that transaction, by business Reports > Movement have gone through the
unit, book, and by item. The by Depletion Depletion process. Run
depletion cost is calculated the Transaction Costing
based on the cost at process.
processing time. The report
does not show on-hand
quantity or value.
On Hand Balance Verifies that the quantity Cost Accounting > Item costs must be
Core-CT December 2006
Validation Report tracked by cost management Inventory and Mfg defined for the Inventory
(CMS9010) processes are the same as Accounting > Business Unit. Inventory
the quantities tracked by Reports > On Hand transactions must take
inventory processes. You Balance Validation place. Enter Items and
can also reprint existing Putaway stock for the
reports. Items.
Core-CT December 2006
Core-CT December 2006
Related docs
