Inventory minimum Stock levels

That is not an accounting function. It is a function of your inventory management philosophy.

See above. Accounting software will not predict the future. Make this decision based on Inventory Quantity Movement report. This also requires knowledge of current lead times from suppliers, something the software does not know.

According to what criteria? How would the program know what constitutes an overstocked situation in your mind?

All this can be determined from the Inventory Quantity Movement report.

Use inventory locations. That is what they are for. See Use inventory locations | Manager.

@fahadalarab

At this moment, it sounds like asking for too much & too many. Let us move step by step. As of now, I and many other users now look forward to have a feature to set a re-order quantity level to get an alert once the stock on hand shrinks to reorder quantity level.

I recall, sometime in the middle of last year, I had also strongly requested for this great feature of setting alert for minimum re-order quantity level. In my opinion, this feature can be an option when creating inventory item (like already exiting feature of setting sale price & purchase price). There could be a check box option for minimum reorder quantity level . If the box is checked, the option would permit a user to set a minimum re-order quantity level. Once the stock on hand q’ty comes down to re-order q’ty level, a pop up window (or some kind of report of the list of re-order inventory item) could alert the user. It is up to the developer how best to implement it

There is no denying the importance of this feature as it could be of great advantage for many users too. Unfortunately, we have suffered severely many a times when it was already too late until we found out the stock on hand gone too low level and requiring to re-order. This oversight (or lack of feature) caused interruption in our production line.

@lubos, please consider to implement this great feature as, I feel, it will add great value to Manager.

1 Like

In the meantime, it would not take a lot of effort to export the inventory at the end of each day or shift or week to Excel and have a spreadsheet macro show the inventory items at or near min stock levels

1 Like

In fact, it would probably be easier to manage in a spreadsheet than to modify parameters of inventory items. You could fold all kinds of relevant factors into one algorithm.

1 Like

When to re order, suggested quantities, over stock, dead stock on the basis of sales hot selling and all these intelligent reports are to be based on sales of that product. I understand they are really hard to implement but another thing we can have is API integration with wordpress and other platforms like this since some of these reports are very well generated by wordpress and some plugins that would help to manage the stock aswell on the ecommerce sites automatically. So we can use reports of wordpress and it would tell us about these movements.

I’m already using these locations option for warehouse and shop but to my understanding warehousing is a little diverse module in which we can have some more useful features

My point was that Manager cannot know how things would be based on sales. For example, would you want a linear extrapolation of recent sales? If so, over how many days/weeks/months? How would you allow for changing lead times of suppliers? Would you try to keep all items in stock, or would you be content to special order some that move slowly? Would you consider the necessary investment to maintain very costly inventory in stock? All these things are management decisions, not accounting functions. Can they be automated? Yes, but it might be easier to do that outside your accounting program.

you are right.
so if manager can give us only the minimum stock ability and its reporting it can make management to decide easily.

You are right on everything. But giving an optional check on a minimum quantity can be a first step to have a better control on the inventories.

1 Like

Yes, I strongly agree on this. A minimum quantity level will alert you that you should create PO for that specific item.

Any update sir

2 Likes

Maybe this helps to make stock orders easier but as Custom fields can be exported to Excel the minimum inventory or Reorder Point (ROP) can maybe be solved that way. At least I gave it a shot and seems usable

If five new Custom fields are made for Inventory items, see picture, then ROP can be compared to Qty owned to see if replenishment is due and how much stock needs to be ordered.

For example:
Line 1: ROP is 1 but Qty owned is 0 so reordering is needed.
Line 2: ROP is 10 and Qty owned is 12 so no reordering is needed.

The key ingredient for such a decision is regular (weekly?) manual input into column 2 “Estim. usage NOW for replenishment lead time” (which can be done in Excel) as it can vary widely during the year for Inventory items which number is used. For example for some retail companies they can maybe sell as much in December as the total sales for all the other months in the year. For other companies a static ROP may do but this of course depends on the business and required precision.

If this is constantly updated no alerts would likely be needed as only the review of the table would do. But lets say if update is weekly, the table can still be exported to Excel, lets say every 1-2 days, fairly easily with only updated Qty owned column to compare it to ROP to see if there are any new unforeseen issues.

Column 4 ROP has to include the Excel formula SUM() for the total to update correctly

Topmost Item code can hold the single date (column 5) for the update of the whole table to keep track of updates. There is no need to add the date to all Inventory items.

For information about other columns, Lead time and Safety stock, see https://en.wikipedia.org/wiki/Reorder_point

The Excel table is then imported/updated back into Manager

1 Like

@Tor’s process is a very good example of why the export function and custom fields exist. The program developer could never anticipate all users’ desires for management information and reports. Even if he took you 90% of the way to what you wanted, you might still be frustrated. And the more needs that are catered to, the more bloated and difficult to use the program becomes. The philosophy has been to provide basic information and recognize that outside analysis and display will always be necessary. I’ve worked for Fortune 100 companies with all the resources in the world for customized accounting and management information systems. In every case, there were many things routinely handled with spreadsheets.

1 Like

Is there any update about this topic? Thanks

1 Like

Dear @lubos

how about inventory minimum stock level option
a long time to waiting this feature .?

@meesam, as you know, this suggestion already exists in the ideas list as a result of a topic started by you. Bombarding the developer with the same request in multiple threads does nothing to encourage implementation. Instead, it gives you a reputation as an impatient forum member, possibly causing your request to be ignored or delayed.

it will be very helpfull and it is needed

@lubos

Minimum stock level warning is still pending badly wait for this last 2 years.

@lubos We initiated a request more than two years ago relating a feature of Re-order Q’ty/Level in Inventory Item. Since then, many users asking for this feature have been patiently waiting. Meantime, the software development had been very impressive with addition of so many significant features.

I wonder if this feature is in your work flow chart sometime in near future. An update will be appreciated.

3 Likes

Good Job

I was thinking the same use custom feilds as columns and export data in Excel to calculate like a report

Yes, Promo_Brick you can export to Excel and view report there. You don’t have to import back into Manager unless its beneficial like if there are other employees wanting to see the information inside Manager