Stock update

[Joeman2020]

Hi,
Can you take a look at my stock database? I am having trouble updating the stock when I run the query "Parts Below Min Stock." I'm not sure what is going on with that. Thanks for your help. Joe, Michigan.

 

[arnelgp]

on "below minimum" query, add Criteria to OnHand column:

< [MinStock]

 

[Joeman2020]

on "below minimum" query, add Criteria to OnHand column:

< [MinStock]

Thanks. That did the trick. One more thing can you look at the purchase order form. When I added the quantity to item 0101 it didn't update the on hand field in the on hand quantities query. Appreciate you help again. Joe.

 

[arnelgp]

PO means the items are "expected" to add to your
inventory, so you don't add it yet.

you need to create another table for the Actual
receipt of those PO.

add this table to your query to increase your OnHand.

 

[Joeman2020]

Hi Arnelgp,
If you have time can you help me set up the Actual table for the PO? I'm not exactly sure what needs to be in that table. Thanks for your help.