Skip to main content
ShanaNiederman
ShanaNiederman
September 7, 2017

What are your best practices for managing inventory?

  • September 7, 2017
  • 3 replies
  • 0 views

What works best for you as far as inventory management strategies? Do you have ideas about what to definitely do or definitely do not do? How did your inventory management change as you scaled? What else can you share about inventory management?

 

Let us know what you know ;-)

      3 replies

      AudreyPratt
      AudreyPratt
      September 7, 2017

      I look forward to learning more regarding this topic! One of my current "work in progress" businesses would require mass amount of inventory. I'd love to hear from others before I take this next step. 

        LeslieBarber
        LeslieBarber
        September 7, 2017

        OMG. That's how I must start. OMG! Managing our inventory has been one of the biggest challenges we have faced with Bellybar. It's both an art and a science, right?! Especially when we were starting out and short on cash - it was so difficult to know how much to produce, how many samples to make, etc. Our products are perishable so we had that added challenge. I suppose my biggest learnings were that even though you save money ordering big volumes, I wouldn't do it again with a perishable product. We were too optimistic :) about our customer sales and then we were stuck with product about to expire. It's so tough! My biz partner is a whiz at this stuff and even then, it was a challenge. Another big learning for me was that inventory was our top cash sink so we had to be super careful with it. Again, back to the idea of not ordering too much to get a discount. In the long run, keeping a super tight eye on inventory is one of the best learnings I have!

          Rustler
          Rustler
          September 8, 2017

          Inventory management is a method of accounting for and controling assets.  Contrary to what accountants are taught, inventory does not mean retail.

           

          In terms of retail inventory, if all you do is buy and sell a widget, then QBO inventory is marginally sufficient, but woefully lacking in reporting and functions.  Desktop inventory is more fully functional but is still lacks some usual inventory functions and reporting.

           

          Perishable items, or any item with a short shelf life, should not be stocked as inventory, especially in any QB version.

            H
            Hansen
            October 13, 2017

            Rustler is exactly correct. I will go one step further and give an example of a QB shortfall I am dealing with right now.

             

            My company manufactures commercial traielrs, so obviusly there are tons of raw materials/inputs that I need to track as inventory. These raw material inventories need to be reduced when a Finished Good is sold. QB does that just fine.

             

            The problem is with the Sales Order step. My sales guys have to sort through more than 100 items in the drop down box to find the trailer they are selling. This causes mistakes and frustrations every day!! There is a work around by making items in-active, but this then stops the inventory tracking of the raw materials.

             

            Why QB does not allow you to track raw materials and only allow sales people to see and select Finished Goods when taking and order is beyond me, it would seem like common sense. I mean you can't sell Paint Labor or Raw Steel. 

             

            Because of this major shortfall for manufacturing I am being forced to look at competitors of QB for a better accouting system. (Yes we have Enterprise Platinum) 

              Rustler
              Rustler
              October 14, 2017

              @Hansen

              Sales orders, invoices, etc all have that product selection issue you are dealing with, and there is no real simple way to cope.

              There are two work arounds I have seen used, neither is optimum

              1.  Create a dummy item named in all caps, SELL THESE ITEMS, make the items for the trailers sub items of that parent and train the salesmen to only select from that group.  In the item list drag and drop that parent/sub to the top of the item type section

              2. Pretty much the same, but use service type items, that puts them at the top of the selection listing.  BUT that means when a sales order or estiamte is created using the service item, someone has to create a new SO or estimate with the details.  The company that does it this way uses the same estimate/SO number and adds a -P to it, for parts. ie
              12434
              12434-P

                R
                roy241
                July 22, 2019

                The downside with QBO is when it comes to raw material inventory management. So that's if you're a manufacturer and you are constantly using up materials which are being allocated to specific sales and manufacturing orders.

                 

                In this case you can group items together as mentioned above so that your raw materials are reduced when a product is sold.

                 

                However it's likely that you could have a product on the shelf for some time, not sold, and so the materials are not being reduced in the inventory, which can cause issues with your production. 

                 

                Ideally you would use an app like Katana, which will track your materials in real-time, allocate them to specific sales orders, and immediately reduce them from inventory once they are committed to a sales or manufacturing order.

                  Terms & ConditionsAccessibility statement