[VIDEO] Catalog Formulas and Replenishing Stock of Parts 

Oleg Shilovitsky
Oleg Shilovitsky
5 February, 2021 | 2 min for reading
[VIDEO] Catalog Formulas and Replenishing Stock of Parts 

Purchasing components for your project can be a hard and tedious task. To export data from a CAD system, to create part lists for purchasing, organize them by quantities, and managing the lists of components – all these tasks are hard and unpleasant. So, it is not surprising that you will be looking at how to automate and simplify the task. 

OpenBOM production and purchasing planning can help you do exactly that. As you probably know already, you can organize items in the catalogs, export data from CAD, and manage BOMs and purchasing. 

One of the often asked questions is how to get a timely alert that you need to order some parts that have a Quantity on Hand below some predefined quantity (replenishment level). 

To do so you can use a simple formula in the catalog to that will help you to calculate it. The easiest way to do so it to create another property in the catalog that will indicate the min stock level. Then you can make a calculation between Quantity on Hand and this min stock level and if the result is negative, it means you need to order. Sort will help you to do it more efficiently. 

Please check the video for more details.

Conclusion 

OpenBOM catalog formulas give you an easy way to make useful calculations to define criteria for ordering. It is not limited to that, but also can help you to do many other useful calculations – eg. Stock cost, etc. 

Check it by yourself – register to use OpenBOM for free and start a 14-day trial for Company Subscription NOW. 

Best, Oleg

Want to learn more about PLM? Check out my Beyond PLM blog and PLM Book website. Read OpenBOM customer reviews on G2 Crowd to learn what customers are saying about OpenBOM. 

Related Posts

Also on OpenBOM

4 6
29 August, 2025

Digital BOM is a foundation of all OpenBOM to ERP integrations. From the very early days of PLM, the connection...

28 August, 2025

In 2025, the push for better design-to-manufacturing integration is stronger than ever. But for many companies, this still gets reduced...

27 August, 2025

For decades, PDM meant file vaults, check-in/check-out, and revision control. But today’s products span mechanical, electronic, and software domains, with...

26 August, 2025

This article is part of OpenBOM BOM Excel MCP building in public. For the next few weeks, we are going...

22 August, 2025

In yesterday’s article – Understanding OpenBOM’s Multi-Tenant Data Model and System Configuration, I shared some insights about OpenBOM’s multi-tenant data...

21 August, 2025

In today’s manufacturing and engineering world, the term multi-tenant triggers both questions and confusion. Product Lifecycle Management (PLM) has historically...

20 August, 2025

Since the very beginning of OpenBOM, our mission has been to help engineers, manufacturers, and teams organize product information and...

19 August, 2025

There is a need for a rich and structured context.  Artificial intelligence has quickly become the buzzword in every boardroom,...

15 August, 2025

A recent post by Martijn Dullaart on LinkedIn about Product Changes caught my attention. Here is the link to the...

To the top