Fifo

[Firefighter22]

Hi all..
I have set up a basic inventory/manufacturing database and now am trying to add a bit of functionality. I want to be able to issue parts that were first in (FIFO), so the cost associated with that certain part at the specific time we bought it goes along with the part. I have thought about possibly using a count in a query, but don't know how to get it to lower the "first in" Inventory quantity first.
I have modified Allen Brownes Inventory Method found here http://allenbrowne.com/AppInventory.html This calculates my On Hand Quantity in an Inventory Form.

Here are some of my tables...



tblPurchaseOrder
PurchaseOrderID (PK)
PurchaseOrderDate

tblPurchaseOrderDetail
PurchaseOrderDetailID (PK)
PurchaseOrderID (FK)
InventoryID (FK)
PurchaseOrderQty
PriceEach

tblJob
JobID(PK)
JobDate
JobNote

tblIssueDetail
IssueID(PK)
InventoryID (FK)
IssueQuantity
PriceEach

tblInventory
InventoryID(PK)
InventoryItem
VendorID

Any help or suggestions are appreciated! Thank you

[Firefighter22]

Hi all.
I have the basic table structure for my inventory database and am now working with the functionality of it. I need to be able to use the parts that were first in (FIFO). I need to be able to pull over the part, with the specific price, from the specific time. i.e. a part ordered 2 years ago will probably be cheaper than one ordered today. I have my inventory system working with Allen Brownes InventoryApp. http://allenbrowne.com/AppInventory.html
I have a query right now that tells me the last time each part was ordered and at what price.
I need to be able to have a "count" so to speak, of certain parts that were ordered at "a" price, "b" price...etc. I was thinking this could be done in a query, subtracting the earliest ordered part by date.
I have attached my relationship window.
Any help is appreciated, thank you!