FIFO inventory

M

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.
 
T

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
 
G

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.
 
I

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top