How can I substract a stock item from the total stock of that same item from my oldest date ? Secondly, if my stock from my oldest date is not enough, how can I substract from my second oldest date ?
E.G. If my stock article Crunch on 1 dec 2003 = 20, and on 15 dec = 5.
On the 20th I will use 30...
Hi,
I'm developing an wharehouse - inventory access database. I have an inventory table (articles, wharehouse, production date, expiring date, Qty ), an incoming and an outgoing table. The articles leave the wharehouse based on the fifo system.
My products have an production date and an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.