I am looking at a solution for inventory.  One important request is that they need to be able to calculate the inventory for previous dates.  E.g. the beginning of the quarter compared to today or this day last year.

My thoughts so far to be able to do this is to have an article file and a stock movements file, all values and quantities of stock will be held in the movements file.  Basically the last related record will be in the movements table will be current value, but we can also find the last related related record based on any date. 

Will this be a fast way to calculate or slow?  I don't want to start and then find things slow down on me too much.

 

After this I will also need to be able to age the stock.  

Edited May 25, 20196 yr by genious

If you are creating a record every time inventory moves, and it shows via a calculation inventory quantity, couldn't you just create a simple find/report?

If it is just the starting stock or qty and EOD, why not just store the values in a summary table for daily records.

To fill you in a little more. We have up to 20,000 articles in a year most of which are unique in other words we make it, sell it and it becomes history. Others can be long standing lines with years of history.  Nothing is high volume total units on the most prolific items is 200 or so.

The movements table means that I will have fewer movements to count if you consider a 10 year history.