Author Topic: Inventory report  (Read 67 times)

Barb@OakGroveFWBC

  • Newbie
  • *
  • Posts: 1
Inventory report
« on: February 25, 2020, 09:49:42 AM »
Is there a way to produce a separate inventory report that just shows what you actually have in stock, and nothing else.

Annette

  • Global Moderator
  • Sr. Member
  • *****
  • Posts: 166
Re: Inventory report
« Reply #1 on: February 25, 2020, 10:37:37 AM »
You can create an ad-hoc report from the main Inventory grid.  You will probably want to hide most of the columns.  Then, filter the "Qty In Stock" column. Click the filter button and choose 'custom', then select 'does not equal' from the dropdown and enter 0 (zero) in the field next to that.  (See screen shot below). Click OK.  Now you have a list of only items where you have some in stock.

Now, you can either export the data using the grid options (button with the gear) or click on the printer icon to print a copy. Below is a screenshot of the print preview using the 'Fit to Page Width' option in the header.  There are other options to customize the report before you print it.

I recommend showing the 'Actual Count' column so you can take the printed report and compare the Qty in Stock amount to what you actually have in your supply cabinet!

[Note: the screenshots are from the desktop database, but works the same way in the remote client.]
« Last Edit: February 25, 2020, 10:41:54 AM by Annette »