FIFO inventory

[Michael Fenton]

I am working on a database that will work on a FIFO
inventory model. I cannot get the database to remove the
product from the inventory in this fashion. How would I
go about getting the database to take (for example) all
of the older product first and then, in the same order,
take the more recent product, all while reflecting the
price change. Please inform me of any good links on FIFO
DB creation.

 

[Tim Ferguson]

How would I
go about getting the database to take (for example) all
of the older product first and then,

SELECT TOP 10 PERCENT
...
ORDER BY ProductDate ASC;

or the newest ones will be

SELECT TOP 15
...
ORDER BY ProductDate DESC;

I am not aware of such a thing as a 'FIFO Database' -- isn't this just a
database with a UI built to offer things in some particular order?

Hope that helps


Tim F

 

[Guest]

That does help a bit. FIFO (first in first out) would
take the oldest product at it's price and use it to fill
an order until the older product is depleted, it would
then select the next oldest and remove as many units at
the updated price as needed to fill the order.

 

[Immanuel Sibero]

Hi

As Tim indicated, no such thing as a FIFO database. But a database can
certainly be programmed to implement FIFO inventory movement.

You would start with a query which:
- is sorted by ReceivedDate ASCENDING
- indicates that the product is "in stock"

How do you acquire products? One product at a time with one price
(obviously)? Or a batch at a time with one price?


Immanuel Sibero