simple to use FIFO inventory system

[arran]

I'm completely new to access and am trying to use it to build an inventory system for a new frozen logistics department at my company.

I need to build something very easy to use as the stock manager will have minimal it skills.

As we are only providing logistics, price is irrelevant but as it is food FIFO system is essential.

essentially i am looking to make a database that will show;
supplier, product, code, total held

and sub categories that show
lot no, date recieved, quantity (per lot), lot location.

Ideally, upon recieving goods, end user would only have to put in
product, quantity, location and the date (with lot number being assigned automatically)


For example

main category
tesco ltd-frozen strawberries-fznstr-600kg

sub category 1
001-01/02/2012-250kg-freezer 1 aisle 1
sub category 2
002-05/02/2012-350kg-freezer 1 aisle 2

Upon sending they would put in quantity required and oldest lot(s) and quantity would appear.
Upon sending goods enter

Frozen strawberries- 300 kg

program to show

lot 001-250kg-freezer 1 aisle 1


lot 002-50kg-freezer 1 aisle 2

Upon confirmation that this quantity is to be sent
main category updated to show

tesco ltd-frozen strawberries-fznstr-300kg

Ideally finished lots (0kg remaining) would be moved to a hitsory page to avoid clutering up the main database but still be on record.


I am not so lazy to ask to be spoon fed but I would like to know if a system similar to this can be made in access before I start learning how to use it only to find its not possible and i have been wasting my time.

I have been looking at using ABC Inventory Software by Almyta systems but it seems overly complicated for end user.

Many thanks in advance.

[alansidman]

You might find this site helpful. Scroll down to the section 11 on Inventory Control

http://www.databaseanswers.org/data_models/index.htm

[orange]

You may get some ideas from
https://www.accessforums.net/access/...ory-25249.html

[arran]

Thanks for the suggestions, I'm actually trying to edit the fifo template from that other thread. I'll see how I get on and probably just use 3rd party software if it doesn't work out.