|
Sup goons. I'm managing inventory for a business, and have been doing so using MS Excel. For a while, the demands were simple enough that the program was a viable option. Now, things have expanded so much that keeping track of all these products and components is time consuming. That, and I can introduce errors pretty easily which causes the whole rickety scaffolding to be wrong. Is MS Access going to be a better alternative for this? During slow periods, I'm goofing around with LibreOffice Base (because I don't know Access or Base yet). Company is willing to get an Access license, but I'd like to be sure it would be better for me and worth the learning curve before I place the order. Here's what im doing: -Keeping track of about 50 food products and making sure there's enough of each to produce different menu items. Some food products are shared between menu items, and some aren't. -Ordering packaging for menu items and keeping track of those too. -Order food products ahead of time, since it takes about 30-40 days to get the product in after I call in an order. This is where it gets trickier, because I have to look ahead 3 months and be sure our supplies are not too low, but also not too high where food products sit in a warehouse too long. I feel like there's a much better way to do all this.
|
# ¿ Mar 13, 2018 16:40 |
|
|
# ¿ Mar 28, 2024 13:53 |
|
derk posted:you're losing your mind over 50 items? why the gently caress does it take 30-40 days to get such products? I was in the restaurant business for 20 years, are you importing directly from a overseas country or what? sounds absurd and unorganized They're ordered from all around the country. These are more or less non-perishable meals, by the way.
|
# ¿ Mar 13, 2018 21:06 |
|
a semi ran into our warehouse and all the inventory is contaminated. problem solved in the interim.
|
# ¿ May 24, 2018 18:26 |