Category Archives: Inventory and warehouse

Catch weight items

Catch weight items are used in industries where the same product can vary in size and/or weight. A common example is food industry where each fruit or meat piece can vary slightly in weight. Lets take a look at some more extreme examples like scrap cars and vehicles that are processed in a scrapyard.

Before we start there is an important distinction between full and partial visibility for catch weight items. It boils down to this:

  • Partial visibility – Receiving multiple units of the item in a batch. In this scenario we do not know the weight of each individual unit
  • Full visibility – Receiving each unit of the item separately and tracking it in inventory. This scenario is what we need for scrap cars

The item model group should be set for Serial number and Serial number control. We will put the vehicle serial number in it.

Item_model_group

The most important settings when opening the item are:

  • checking that the product is CW
  • Choosing the correct tracking dimension
  • Inventory, Sales and Purchase units which is the primary unit

create_item

We need to setup a new unit “Car” which will be used for CW.

CW_unit

Now we need a unit conversion between units. Since we choose “Mass” for the Unit class, it will be an “Intra-class conversion”. The conversion will be 1 Car = 1200/1 kg. This will be the default value if we put a 1 Car unit on any form.intra-class_conversion

Now we are able to choose the CW unit “Car”. We can also put in the minimum and maximum quantity for the CW unit in kg (1 and 50.000 kg respectively).

CW_Unit_setup

All we need to do now is to purchase and receive the items. On the purchase order line we input a CW quantity of 3.

PO

Under product receipt registration form we need to input a line for each vehicle. Additional we add the serial number and actual weight of vehicles.

Product_receipt

After we register and receive the items we can see them in inventory. Inventory overview for standard unit of measure (kg).overview_kg

The overview in CW unit.

cw_overview

This is all there is with catch weight for basic scenarios.

Until next time, keep on DAXing!