|
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
|
|
|
|
| # ? Apr 25, 2024 13:27 |
|
|
Quickbooks?! https://quickbooks.intuit.com/restaurants/
|
|
#
?
Mar 13, 2018 17:05
|
|
|
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
|
|
#
?
Mar 13, 2018 20:35
|
|
|
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
|
|
|
Quickbooks might be a better choice to track inventory, issue invoices, and keep track of payments. you should do a RFP on your food items to make sure youre getting the best pricing on the materials.
|
|
#
?
Mar 14, 2018 20:54
|
|
|
I handled inventory between 3 warehouses and a outdoor area with Excel and it sucked but Ctrl+Fing was the best way I could think of to do it. This was a decade ago but I feel dumb now for not pursuing alternate software. Item exact model number/description, location, cost, quantity, filling up a big Excel sheet. It only took like a week for us to get stuff in, it was more important for us to have inventory for same day turnarounds.
|
|
#
?
Mar 14, 2018 22:22
|
|
|
im really gay
|
|
#
?
Mar 17, 2018 10:39
|
|
|
buglord posted: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. Sounds like your need to get ERP of some form. Good luck with going to another hell hole!
|
|
#
?
Apr 17, 2018 07:32
|
|
|
buglord posted: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. Access will definitely be what you want (out of what you have suggested, an actual ERP solution would be better) and it does a much better job of this stuff than excel. MS has a few templates out there to show how you can do inventory management. The Northwinds template is basically an Access ERP. It probably goes deeper than you need but it can at least give you an idea of what is possible and how you might go about organizing your database. To keep track of food, packaging items, recipes (derives from all the other items), and sales stuff would be pretty easy to implement. I would echo what others said that a 40 day turn time on the product seems insane, but that's your own cross to bear.
|
|
#
?
Apr 20, 2018 01:22
|
|
|
Sounds like an ERP would be a good choice, but it’s generally expensive Have you looked at Shopify? Not sure if it has look-ahead item ordering but basic inventory management is fine
|
|
#
?
May 22, 2018 04:07
|
|
|
Might I suggest SAP for all your small business needs?
|
|
#
?
May 23, 2018 12:49
|
|
|
Whatever you get or make will probably survive with the business for many years, and become increasingly hard to kill, and catch lots and lots of features along the way. If you buy a commercial ERP system there is at least a chance you can get vendor support for it. It's a larger initial investment, but probably better business value in the long run. Just know that custom ERP systems built in Excel, Access, or FileMaker are the bane of every IT person.
|
|
#
?
May 24, 2018 16:09
|
|
|
a semi ran into our warehouse and all the inventory is contaminated. problem solved in the interim.
|
|
#
?
May 24, 2018 18:26
|
|
|
buglord posted:a semi ran into our warehouse and all the inventory is contaminated. problem solved in the interim. I love issues that fix themselves.
|
|
#
?
May 25, 2018 16:48
|
|
|
buglord posted:a semi ran into our warehouse and all the inventory is contaminated. problem solved in the interim. Do you have a contact for this service? It’s unorthodox but hey
|
|
#
?
May 25, 2018 16:55
|
|
|
Comfy Fleece Sweater posted:Do you have a contact for this service? It’s unorthodox but hey Truck Accidents as a Service.
|
|
#
?
May 26, 2018 00:10
|
|
|
|
| # ? Apr 25, 2024 13:27 |
|
|
Schadenboner posted:Might I suggest SAP for all your small business needs?
|
|
#
?
May 28, 2018 11:28
|
|