Show/Hide Toolbars

SpendMap User Guide (v14.5)

Navigation: Inventory Control > Reports

On-Hand/On-Order Report

Scroll Prev Top Next More

INVENTORY CONTROL > Reports > On-hand/on-order

 

This report lists the quantity that you have in-stock and on open (un-received) Purchase Orders and Releases, for one or many items, in addition to other high-level inventory-related information for the selected item(s).

You can run the report for one or many inventory locations and there are various other options for the report.

The report is very similar to the Inventory Valuation Report except that dollar values are omitted.

You can view similar information on-screen with View Current Inventory Levels and Inventory Planning.

 

Noteworthy Questions & Options

You will be prompted for a “balances as of” date. You can use this to show on-hand balances as of a date in the past. However, if you run the report for any date other than the current date, the report will not include the on-order balances (the column will show “N/A”).

You can include or exclude non-stock items. While non-stock items will never have an in-stock value, you may choose to include non-stock items as they may be on-order. Items can be set up as either stock or non-stock in the Item Master File.

You can include or exclude items with ZERO stock balances. Excluding these items will shorten the report by omitting items whose on-order AND in-stock balances are zero.