Inventory on hand

  • Thread starter Thread starter Lazio Fan
  • Start date Start date
L

Lazio Fan

Hi, i'm trying to create a report that shows current inventory on hand.

For example:
I buy 1000 shirts on Aug 1. I sell 10 shirts on Aug 10th and 10 on Aug
15th, and another 10 on Aug 20th.
How do I create a report that shows me my current inventory for the shirts
for certain date? i.e. Aug 3rd inventory: 1000 Aug 11th inventory 990, Aug
21st 970. The report would should the current inventory of all the different
types of shirts

I have a table for Purchases of shirts and I have a table of sold shirts
which links the purchased shirts table.
 
Use one table with a field defining the type of transaction - Purchase/Sold.

If you do not include the negative sign during data input then in your query
use IIF([TransAct]= "S", [QTY] * -1, [QTY]) and then sum.

You might want a transaction type "T" for trash when items are disposed of
due to soiled mechandise. Also "R" or "C" for reconcile or count when you do
a physical count.
 
Back
Top