Manage and Track Catch Weights

If cases of your product are sold by the pound, a weight needs to be associated with each case, or an average weight to a group of cases, in order to properly invoice customers. Catch Weight functionality within ColumbusFood is incorporated into all modules that deal with inventory, including:

Purchasing
  • Buy in one unit and pay in another, for example, 10 cases of cheese at $1.15/lb.
  • Record actual weight of each case received, or
  • Record the total weight for a group of cases and utilize the average for each case
Warehouse
  • Inventory of all catch weight items is kept in units and weight, adjustments can be made to either. Both units can be displayed on reports.
ColumbusFood ADC (scanning solution)
  • All necessary transactions provide for the ability to include both weight and units.
Inventory
  • Items will show both the number of cases and the weight involved
Sales
  • Sell in one unit and price in another, for example, 10 watermelons at $.89/lb.
  • Record and show the actual weight for each unit delivered, or
  • Record and show the total weight of a group of items delivered if you used an average weight.

Screen shot of Columbus catch weight management in Microsoft Dynamics

Manage and Track Dual Units of Measure

Many companies want to have a common Unit of Measure (UOM) to use for reporting purposes. For instance, if you sell a product like a beverage which is packaged in many different sizes, knowing how many cases sold is not nearly as useful as knowing how many gallons or pounds were sold. ColumbusFood allows its users to record two UOMs for each inventory transaction that utilize items setup with an alternate UOM. You can also display both UOMs on transaction lines.

Pricing
  • Purchase or Sales prices can be set in a different UOM than you transact the item in. For instance, ground beef is sold by the case, using a nominal weight, and price it by the pound.
Reporting
  • ColumbusFood eliminates the need to manually convert all sold units to a common unit of measure before reporting.

Screen shot of Columbus dual units of measure in Microsoft Dynamics