ARM Help

Inventory On Hand

Inventory On Hand Report is the list of what you are holding right now, one line per part, with how many you have, what they cost you and what they sell for. It has no date range because it describes today. Use it to value your stock, to find the parts that have dropped below their minimum before you place an order, and to check what a particular supplier's shelf looks like.

3 how-to answers 5 screenshots Open in ARM Markdown

How do I run the Inventory On Hand report? #

  1. From the Home Screen, click Inventory → Inventory Reports → Inventory On Hand, or click Reports → Inventory Reports → Inventory On Hand.
  2. Type part of a description into Search, part of a category name into Category, or a supplier into Supplier, to narrow the list. Leave them empty to see everything.
  3. Click SEARCH to load the report. SHOW ALL clears every filter and reloads the full list.
  4. Click any column heading to sort by it; click it again to reverse the order. Longer lists are split into pages with page links under the table.
  5. Click PRINT for a PDF copy or DOWNLOAD to export to a spreadsheet. Both buttons appear only when the search returns at least one part.
Inventory On Hand filtered to one supplier
Inventory On Hand filtered to one supplier
Inventory On Hand print output
Inventory On Hand print output

How do I find the parts that need reordering? #

  1. From the Home Screen, click Reports → Inventory Reports → Inventory On Hand.
  2. Click the toggle between Category and Supplier. It reads All Products when off and turns green reading Low Stock when on, and the list reloads on its own.
  3. With Low Stock on, the report keeps only the parts whose Total Stock On Hand has fallen below their Minimum Sugg. Qty. — the parts you should be ordering.
  4. Type a supplier into Supplier and click SEARCH to turn that into a shopping list for one supplier.
  5. Click PRINT or DOWNLOAD to take the list away with you.
Inventory On Hand filters with the All Products toggle off
Inventory On Hand filters with the All Products toggle off
Inventory On Hand parts list with the Total row
Inventory On Hand parts list with the Total row
Inventory On Hand with the Low Stock toggle on
Inventory On Hand with the Low Stock toggle on

How do I work out the extended cost of a part and the value of the stock listed? #

  1. From the Home Screen, click Reports → Inventory Reports → Inventory On Hand, filter as you need and pick one line.
  2. Total Stock On Hand is the quantity you are holding. Example: 12.00.
  3. Average Cost Each is the unit cost ARM holds for the part. Example: $5.02.
  4. Extended Cost is the quantity multiplied by the cost: 12.00 × $5.02 = $60.24. That is what the stock of that one part is worth at cost.
  5. Total Cost Extended, above the table, adds the Extended Cost of every part the filters returned. That is the value of the stock you are looking at.
  6. Sales Price is not part of this sum. It is what you charge for one, so comparing it with Average Cost Each shows the margin on the part rather than the value of the shelf.
About this screen

Each line shows the Category the part belongs to, its Supplier Name, the Part Description and Part Number, the Total Stock On Hand you are holding, the Average Cost Each ARM holds for the part, the Extended Cost of what is on the shelf, the Sales Price you charge, the Minimum Sugg. Qty. below which the part should be reordered, and the Pack Size it is bought in. Three figures sit above the table: Total: is the number of parts listed, Total Cost Each adds up the Average Cost Each column and Total Cost Extended adds up the Extended Cost column. The foot row under the table repeats the same three sums for the parts on the page.

Total Cost Extended is the figure to use when you want the value of your stock, because it is built from quantity and cost together. Total Cost Each adds up a per-unit cost across unrelated parts, so it answers what one of everything would cost rather than what you are holding.

Some parts can show a negative Total Stock On Hand, which happens when more has been issued than ARM was told had been received. Those lines still count towards the totals, so a negative quantity pulls the stock value down. Where you see one, the part is worth counting with Inventory Manual Count before you trust the valuation.

The ADD TO FAVORITES switch beside the report title saves a shortcut to the report under your favourites in the main Reports menu.

People also ask

  • asked 1×

Ask AI