Minimum Reorder

[Bob Quintal]

=?Utf-8?B?Sm9obiBQYXVsIEFuZ2FsYSBQaWdhbw==?=

Good day,

I have this Inventory Monitoring running and i came up with an
idea of Minimum Reorder. I would like to run a report where all
items that is under the specified Miniumum Qty will be displayed
in a report. How can i do that?

I have a table for the main inventory, item id, item description,
etc. I have there a field for Qty and Reorder Qty. Now how can i
make a report that will display only the certain items that Qty on
Hand are below the Minimum Qty?

Please help...

Thanks in advance...

John Paul Angala Pigao

Step 1: create a query using the design tool.
Use your inventory table.
In the Criteria row for [Qty On Hand], put
< [Minimum Qty]
Save and run the query.
Build a report based on this query.

 

[John Paul Angala Pigao]

Good day,

I have this Inventory Monitoring running and i came up with an idea of
Minimum Reorder. I would like to run a report where all items that is under
the specified Miniumum Qty will be displayed in a report. How can i do that?

I have a table for the main inventory, item id, item description, etc. I
have there a field for Qty and Reorder Qty. Now how can i make a report that
will display only the certain items that Qty on Hand are below the Minimum
Qty?

Please help...

Thanks in advance...

John Paul Angala Pigao