Using Attributes in Inventory

Customer Introduction:

This company manufactures heat exchangers. It requires plates and pipes as an important raw material.

Problem / Goal:

The unit of measurement of pipe is kg for purchase and meters for inventory. When there was a requirement of say 10m pipe, inventory showed that there was say 500 m in stock. So it seemed more than sufficient. But in reality none of the individual pieces of pipe were large enough. Thus one had to physically go and check the stock.

The Solution:

We then added our Lot Attribute feature. With this feature, the user can add additional information about the lot such as the length.

For plates it will be the Length and Width. This feature is not limited to just dimensions. It could be any other attribute such as Colour or Make.

The Result / Benefits:

Now the users could add individual pipe lengths to the lot and whenever a specific length of pipe was required, it was possible to fetch it.

This feature is also handy for designers who can design based on what is available in stock. It is also useful for planners to allocate the right lots for right jobs.