Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us $3,400 per month for bandwidth bills alone, and since we don't believe in shoving popup ads to our registered users, we try to make the money back through forum registrations.
  • Locked thread
buglord
Jul 31, 2010

Actually it's ephebophila





Buglord

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.

Adbot
ADBOT LOVES YOU

redeyes
Sep 14, 2002
I LOVE THE WHITE STRIPES!

Quickbooks?!
https://quickbooks.intuit.com/restaurants/

derk
Sep 24, 2004


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

buglord
Jul 31, 2010

Actually it's ephebophila





Buglord

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.

RoboBoogie
Sep 18, 2008


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.

craig588
Nov 19, 2005



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.

Nonviolent J
Jul 20, 2006


Soiled Meat

im really gay

caberham
Mar 18, 2009

FLAVORTOWN OSAKA


Grimey Drawer

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.

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.

Sounds like your need to get ERP of some form. Good luck with going to another hell hole!

Raldikuk
Apr 7, 2006


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.

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.

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.

Comfy Fleece Sweater
Apr 2, 2013

FOUNDER AND PRESIDENT OF THE KUATO FAN CLUB 4/2/13-PRESENT

KUATO IS MY HERO! AMA!


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

Schadenboner
Aug 15, 2011



Might I suggest SAP for all your small business needs?

nielsm
Jun 1, 2009




Fallen Rib

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.

buglord
Jul 31, 2010

Actually it's ephebophila





Buglord

a semi ran into our warehouse and all the inventory is contaminated. problem solved in the interim.

peak debt
Mar 10, 2001
b& :(

Nap Ghost

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.

Comfy Fleece Sweater
Apr 2, 2013

FOUNDER AND PRESIDENT OF THE KUATO FAN CLUB 4/2/13-PRESENT

KUATO IS MY HERO! AMA!


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

Schadenboner
Aug 15, 2011



Comfy Fleece Sweater posted:

Do you have a contact for this service? Itís unorthodox but hey

Truck Accidents as a Service.

Adbot
ADBOT LOVES YOU

mobby_6kl
Aug 9, 2009

"You are the best poster... do not let anyone say otherwise."


Schadenboner posted:

Might I suggest SAP for all your small business needs?


Serious answer, Business One has inventory management and is reasonably affordable. That said, if the company is "willing" to buy Access, this might be still a bit too much.

  • Locked thread