Quick Tips: Setting Part Reorder Levels

Here is a few quick tips for you out there that wish to set up Part Reorder Levels. 

Reorder levels with Fishbowl

In this post we will go over the differences between Reorder Levels and Reorder Points, and how to create your Reorder Levels 3 Different Ways. As always if you have any questions related to Fishbowl don’t hesitate to call the office on 1300 785 755 in Australia and 0800 785 755 in New Zealand and one of our helpful support team members will be able to give you a hand.

Reorder Levels vs. Reorder Points

Reorder points are certain quantities of inventory that, when reached, trigger the process of purchasing more stock to reach a certain level. So when the total number of parts in stock gets down to the reorder point, you’ll know it’s time to reorder more of the parts.

Let’s make sure we’re all clear about the difference between Reorder Levels and Reorder Points.

Reorder Levels are made up of two things:

  1. Reorder Point: The minimum number of items in stock that marks the point at which they must be reordered to avoid running out.
  2. Order Up to Level: The maximum or preferred number of items that can be contained in stock. The reorder quantity shouldn’t be higher than this number.

You can run a Reorder Report from the Report module to produce a list of all the items in your inventory that have reached their reorder point. It will also show you how many to reorder to return to the proper level.

You can use reorder levels to automatically generate purchase orders for the necessary number of parts to get them back to the desired quantity through the Auto PO wizard. If you’re a manufacturer, you can also use reorder points to automatically generate manufacture orders for the desired quantity using the Auto MO wizard.

3 Ways to Create Reorder Levels

Here are the three methods by which you can create reorder levels:

1. Use a Reorder Levels CSV Import to create multiple reorder levels.

2. Use the Auto ROP wizard to automatically set multiple reorder levels at the same time.

3. Click the Inventory tab in the Part module to create and edit single items’ reorder levels.

Let’s delve into these three methods a bit more closely to give you an idea of how to do them and where to find them in the interface:

1. CSV Import

Click the File button at the top of the interface and then select the Import option. This will pull up a friendly Import wizard to guide you through the process of importing data on reorder levels via Excel spreadsheets. It tells you how to format the data and other essential things to follow

2. Auto ROP Wizard

The Auto ROP wizard is located in the toolbar on top of the interface. Simply click on it and it will bring up a new window to help you specify the right parts you’re looking for and calculate their reorder levels, based on a number of factors. I could spend an entire blog post explaining all of this, but to keep it brief I’ll just have to cut it short here and direct you to the Fishbowl Wiki for detailed instructions on using the Auto ROP wizard.

3. Inventory Tab

There are several tabs located at the top of the Part module, including General, Details, Accounts, and Inventory. Click the Inventory tab and you’ll be able to see detailed information about a particular part, including the number on hand, on order, allocated, committed, backordered, and so forth. You’ll also find a helpful section at the bottom with information about the item’s location, order up to level, and reorder point. You can adjust this information right there.

Look out for this Quick Tips Every Thursday where we delve into commonly asked questions and helpful hints to make sure you are getting the most out of Fishbowl inventory and manufacturing software.

Important changes to the Fishbowl report writing process

Fishbowl inventory management software custom report changes

To make sure you get your custom reports faster, and are more reliable, the Fishbowl team will only be creating reports for the current annual version of Fishbowl. We would also like all report enquiries to be sent to reports@fishbowlinventory.com.au

To increase the speed in which reports are created for our clients, and to minimise report incompatibility, the Fishbowl reports team will now only be able to generate reports for the latest annual release of Fishbowl e.g. Currently, 2016.x.

To simplify the process, and to ensure we get your request to the correct team member, please send any requests to reports@fishbowlinventory.com.au.

If you have any questions regarding these changes, please do not hesitate to contact our team on 1300 785 755 in Australia or 0800 785 755 in New Zealand.

3 Steps to a Better Stock Take

Like Christmas, tax time has a way of sneaking up on you. Unlike the festive season however, that offers the joy of giving gifts and strong eggnog, the end of the Financial Year brings with it the not so joyous burdens of lengthy tax forms and typically a tedious stock take to be undertaken.

This weeks blog I will be taking a look at pratfalls to avoid and steps to take to ensure you have a more successful stock take this year.

1. Right Tools For The Job

Checking stock levels is always going to be a arduous and labourious process but having the right tools can avoid discrepancies and inaccuracy with the final inventory count. It seems like common sense but having pens, clipboards and calculators handily available will make sure that the workers on the warehouse floor will be able to do their job properly. Using different coloured pens for different counts will allow for counts from the separate stock takers to be seen and accounted for. To remove the human error element from the stock take using hand held scanners for items with bar codes can be very useful. Fishbowl Mobile is software the is directly available on a scanner device and this can improve accuracy and speed when counting your stock.

2. Measure Twice, Cut Once

Near enough is not good enough.

All locations and items will have to be accounted for when completing a stock take, this will include any consignment stock and items that have been sold that have not been taken out of the shipping area. This can be a difficult process but from within Fishbowl Warehouse a stock take sheet that includes all locations can be printed and make it easier for the workers in the warehouse doing the stock take. It is also important to take into account that packed items that have quantities written on the side may be incorrect and should be opened and recounted to get the most accurate numbers.

3. Updating Your Inventory Software

Now that all the numbers are correct it is time to update your inventory software to reflect these new numbers. Within Fishbowl updating the inventory counts is as easy uploading the numbers from an Excel CSV worksheet.

Now shutting up shop for a full day or taking a weekend to do a stock take may not be possible for a lot of businesses. A solution to this may be doing a rolling stock take. This allows for bin locations or shelves to be completed at different times and can be uploaded at separate times. The same care, if not more, has to be taken but can cut down on the workforce needed and minimises disruption to everyday business processes.

The best way to complete a stock take for your business is to be prepared, have the most accurate numbers and software that can help reduce the human error element. Following these few steps will ensure that you will have the most accurate inventory numbers and minimal disturbance to your business when tax time rolls around.


Making a Healthier Business – Warehouse Management (Part 4)

Welcome back to this informative series of blog posts where Robert Lockard discusses 10 steps to making your business much healthier. This time he will look about Warehouse Management.

What Is Warehouse Management?

Warehouse management is self-explanatory, actually. It involves setting up, organizing, and maintaining everything inside at least one warehouse. As your company grows, it will tend to add more locations to store your inventory, which adds to the complexity of warehouse management.inventory-warehouse-management

How It Helps Your Business

By mastering warehouse management, you can make sure many of your aspects of your business are running smoothly. For example, your salespeople will have enough products on hand to fill their orders, you won’t have giant overstocks requiring extra storage space or leading to spoilage, and you’ll be able to avoid tying up your precious capital in unnecessary amounts of inventory.

A lot of your business’ health depends on what goes on in the warehouse.

How You Can Manage Your Warehouse

Robert wrote a blog post about this very subject earlier this year, entitled “How Do I Manage a Warehouse?” He covered a lot of the same ground in that post here because it’s still just as true today. Here goes nothing:

  • Set auto reorder points on everything in your warehouse to keep a good balance
  • Use wireless devices to scan bar codes and speed up picking, receiving, and other jobs
  • Put the most popular products close to the receiving dock and group similar products together
  • ‘Use a row, shelf, and bin tracking system to keep tabs on your products’ exact locations

Your business can enjoy a lot of benefits from managing your warehouse(s) effectively. To ensure that you are getting the most out of your facilities and products, use warehouse management software to increase efficiency, keep your shelves stocked, and fulfill customers’ orders in a timely manner.

In this series, we’ve covered the importance of:

Come back next week, and we’ll continue with Inventory Tracking. See you then!

Making Your Inventory Management Software Mobile on iPhone and Other Smart Devices

With the release of iPhone 6 it is probably a good idea to see what else you can do with your phone besides Facebook.

On this blog last week we had listed the many eCommerce platforms that integrate with Fishbowl inventory management software. Now lets look at the mobile devices compatible with Fishbowl.

Inventory Management Software on Mobile Devices

Fishbowl works on a mobile_inventory_management_softwarevariety of mobile devices, If you want to check your inventory levels, order more products, or perform other inventory control tasks while you’re away from a desktop computer, Fishbowl can make it happen.

With LilyPad for Fishbowl, an app provided by Sharpe Concepts, you can use Fishbowl on any mobile device with access to a Web browser.

Fishbowl Is Compatible with the Following Mobile Solutions:

  • Android
  • Apple iOS
  • Blackberry
  • LilyPad
  • Motorola
  • Unitech
  • WindowsPhone

When you’re on the go, you can still stay in control of your inventory with the help of LilyPad for Fishbowl. You can do pretty much everything you could on a laptop or desktop computer on a smartphone or tablet.

Even More Fishbowl Compatibility

I’ve got a lot more to say about Fishbowl’s compatibility with other programs. We’ll continue next week with point of sale solutions. Visit the Fishbowl Compatibility page to see all of the programs Fishbowl works with.


This post comes from Robert Lockard, a member of the USA Fishbowl Team.