Cowboy_BeBa
Registered User.
- Local time
- Today, 23:46
- Joined
- Nov 30, 2010
- Messages
- 188
hi everyone
a few years back i built a very basic db for my fathers factory, it is meant to do the job of simple erp/stock control software and that is precisely what it does
it keeps track of stock levels of our products/ingredients, it stores nutritional info of each ingredient and works out the totals for our packaging, it stores production info (how many batches of what product is to be blended and in what quantity)
however the one thing it doesnt do is help us adequately plan the use of our resources
for example, we have 50kg of sugar in stock and 100kg of flour, we may need about 500kg of sugar and 1000kg of flour to fulfill our blending commitments,
we do have a "shopping list" which calculates how much stock of each ingredient we need and deducts from how much we have to come up with how much we should order, however this does nothing to help us determine what we're going to do with the resources we have
i need to add a system that is able to look at what weve got in stock, what we need to make and works out what we can make
now im not going to ask for help here, because i know enough about access to know that this will be a big job, probably will require tweaking of alot of pages (forms, tables, queries, etc) in the db, itll be a big job and not something that can get done in a day
basically what im looking for is ideas on how such a system would work, tbh ive never built or seen anything like this, have rough ideas but wondering if people could show me examples theyve built, or direct me to actual paid software with similar functionality that i can look at, just looking for ideas atm so i can figure out what the best way to incorporate this into my DB is
cheers,
beba
a few years back i built a very basic db for my fathers factory, it is meant to do the job of simple erp/stock control software and that is precisely what it does
it keeps track of stock levels of our products/ingredients, it stores nutritional info of each ingredient and works out the totals for our packaging, it stores production info (how many batches of what product is to be blended and in what quantity)
however the one thing it doesnt do is help us adequately plan the use of our resources
for example, we have 50kg of sugar in stock and 100kg of flour, we may need about 500kg of sugar and 1000kg of flour to fulfill our blending commitments,
we do have a "shopping list" which calculates how much stock of each ingredient we need and deducts from how much we have to come up with how much we should order, however this does nothing to help us determine what we're going to do with the resources we have
i need to add a system that is able to look at what weve got in stock, what we need to make and works out what we can make
now im not going to ask for help here, because i know enough about access to know that this will be a big job, probably will require tweaking of alot of pages (forms, tables, queries, etc) in the db, itll be a big job and not something that can get done in a day
basically what im looking for is ideas on how such a system would work, tbh ive never built or seen anything like this, have rough ideas but wondering if people could show me examples theyve built, or direct me to actual paid software with similar functionality that i can look at, just looking for ideas atm so i can figure out what the best way to incorporate this into my DB is
cheers,
beba