i have a Order Entry and Invoice application with Inventory control i.e when they sell the inventory gets deducted.
Now my customer is asking for FIFO (first in first out)
how do i go about it?
How to tell the computer which one is first?
What if i have 10 from one purchase and 20 from another purchase with different Cost Price and somebody wants 15.
How to keep track of total for each Item?
and so on,
I also have in the application a Purchasing entry from Vendors and the inventory gets increased automatically.
Do you have an idea or a system how to make it work?
please let me know.