I am setting up a inventory database and i will like the cost of the items to be calculated using FIFO. Can anyone help me with some codes?
Sample tables:
PARTS TABLE:
part code
description
cost
quantity on hand
PART TYPES
part type id
party type
INVENTORY
invent id
location
reorder...