Catch Weight and Cost Unit of Measure Settings

This document describes the settings required to support the catch weight functionality and cost unit of measure (U/M).

If necessary, reference the document for an introduction to the functionality available to support the concept of catch weight.

Why use location based catch weight

  • Catch weight follows the quantities on location as opposed to averages per lot.
  • Costing is performed at a unit of measure other than basic unit of measure.
  • Inventory evaluation is based upon catch weight rather than basic unit of measure.

Outcome

Parameters for catch weight and costing unit are set.

Restrictions

Parameter 'FoB-Food' must be specified at company level in 'Company. Open' (MNS095).

Follow these steps

  1. Set 'Industry parameter' field in 'M3 Company. Open' (MNS095) to 'FoB-Food'.

  2. Activate the 'Override balance status' field in 'Settings - Warehouse Planning Control' (CRS701).

  3. Set tolerance parameters in 'Item Group. Open' (CRS025), 'Settings - Physical Inventory Line' (MMS309) and 'Settings - Physical Inventory' (CRS717).

  4. Activate catch weight fields in 'Item Type. Open' (CRS040) and 'Item Type. Select Fields' (MWS041).

  5. Set alternate cost unit in 'Item. Connect Alternate U/M' (MMS015).

  6. Activate cost unit in 'Item. Open' (MMS001), 'Item. Connect Facility' (MMS003) and 'Product Costing. Display' (PCS300).

  7. Specify stock zone settings in 'Stock Zone. Open' (MMS040).

  8. Specify the settings for 'catch weight' and 'catch weight cost' in:

    • 'Item Type. Open' (CRS040)
    • 'Item. Connect Alternate U/M' (MMS015)
    • 'Item. Connect Facility' (MMS003)
    • 'Picking List. Report' (MWS420/P)
  9. Define panel versions to include catch weight information in:

    • 'Balance Identity. Open Toolbox' (MWS068)
    • 'Stock Transaction. Display History' (MWS070)
    • 'Item. Open Toolbox' (MMS200)

Setting descriptions

Program ID Field heading Description
(MNS095/E) Industry Select 'FoB-Food' for the required company.
(CRS701/E) Override balance status Select the check box to enable override of the lot status with status per balance identity. Can only be used when the setting 'FoB-Food' is specified in (MNS095/E). Can be used for ordinary lots and catch-weight controlled lots.
(MMS040/E) Two-step put-away

Indicates whether two-step put-away is activated:

'0=No'

'1=Yes'

'2=Staged'. IE. located at a receiving area, waiting to be directed to the correct put-away location during put-away confirmation.

This activation occurs in the stock zone, and in the goods receiving method or order type. For purchase orders, the activation is in goods receiving method. For manufacturing orders and DO/RO orders, it occurs in the respective order types.

Must be active in both the stock zone and the goods receiving method/order type for two-step put-away to commence.

(CRS717/E) Propose quantity Select the check box if quantity is to be proposed when reporting physical inventory. Must be activated in order to report physical inventory line with empty location and no on hand balance.
(CRS717/E) Enter Catch Weight

Indicates if catch weight/physical inventory weight should be calculated based on the existing MITLOC record or entered manually. Alternatives:

0 = Catch weight calculated based upon existing MITLOC record.

1 = Catch weight must be entered when quantity is changed.

(CRS025/E)

(MMS309/E)

Tolerance percent The field indicates the maximum variance tolerated of the expected weight per item group when a stock transaction is reported for a catch weight item. The variance is expressed as a percentage to two decimal places. This can also be set in (MMS309/E) per warehouse/Item.

(CRS025/E)

(MMS309/E)

Tolerance weight The field indicates the maximum variance tolerated of the expected average weight per item group when a stock transaction is reported for a catch weight item. The variance is expressed in a unit of weight This can also be set in (MMS309/E) per warehouse/Item.
(MWS041/G) Location Based CW

Select fields for (MMS001/G)

Activate 'Loc-based CW'

(MWS041/1H) Cost U/M

Select fields for (MMS001/H)

Activate output fields for cost units of measure

(MWS041/1H) Alternate U/M

Select fields for (MMS001/H)

Activate output fields for new units of measure

(MWS041/1H) Catch Weight U/M

Select fields for (MMS001/H)

Activate output fields for new units of measure

(MWS041/2H) Catch Weight - Approved ohb

Select fields for (MMS002/H)

Indicates the on-hand balance in Catch weight U/M

(MWS041/2H) Catch Weight - Rejected ohb

Select fields for (MMS002/H)

Indicates the rejected on-hand balance in Catch weight U/M

(MWS041/2H) Catch Weight - Inspection ohb

Select fields for (MMS002/H)

Indicates the on-hand balance under inspection in Catch weight U/M

(MWS041/3E) Catch Weight - Approved ohb Rejected ohb Inspection ohb

Select fields for (MMS003/E)

Activate output fields for Catch Weight On-hand balance accumulators

(MWS041/3E) Catch Weight Cost

Select fields for (MMS003/E)

Indicates if the value for a specific transaction should be calculated based on the actual weight multiplied by the cost per weight. All stock transactions and internal accounting transactions will be created based on the actual weight and a cost expressed per weight unit. Internal accounting and general ledger transactions will continue to hold a quantity but this will be the actual weight-based quantity and not the quantity in the basic unit of measure.

Alternatives:

0 = No catch weight cost

1 = Catch weight cost

2 = Catch weight cost by facility

If alternative 1 is selected, the standard weight of the product is the same across the company and the standard cost is calculated based on the weight conversion factor in (MMS015/E). If alternative 2 is selected, the standard weight of the product varies from facility to facility and the standard cost is calculated based on the weight conversion factor in (MMS003/E).

Prerequisites for the catch weight cost are:

Value in the (MNS905/E) 'Industry' field must be 'Fob-Food'.

Value in the (MMS001/G) 'Active or catch weight item' field must be 2, 3, or 4

Value in the 'Standard U/M – Catch weight' field must be equal to that in the 'Standard U/M – Cost' field in (MMS015/E)

Setting for alternate cost unit

  • Alternate cost unit can be used separately without catch weight.
  • If catch weight is not activated, a fixed conversion between basic unit of measure and cost unit of measure will take place.
Program ID Field heading Description
(MMS015/B) Alternate U/M type The most common setting is to have both type 1 and type 2 set, where for example purchase and sales prices are set in same unit of measure as the CW unit of measure.
(MMS015/B) Alternate U/M Indicates an alternate unit of measure (U/M) for the basic U/M of an item. An unlimited number of alternate U/Ms may be defined for each item.
(MMS015/E) Std PO U/M Indicates whether or not the alternative U/M is the standard purchase U/M. Select the check box if the alternative U/M is the standard purchase U/M. Standard purchase U/M is used when purchase U/M is not entered at purchase order entry. If standard purchase U/M is not defined, the basic U/M of the item will be used as purchase U/M.
(MMS015/E) Std Pe U/M Indicates whether or not the alternative U/M should be used as the standard product engineering U/M. Select the check box if the alternative U/M should be used as the standard product engineering U/M. Standard product engineering U/M is used when product engineering U/M is omitted when materials are entered in the structures. If standard product engineering U/M is not defined, the basic U/M of the item will be used.
(MMS015/E) Std CW U/M Select the check box if a catch weight U/M should be used as a standard U/M for the catch weight. If catch weight U/M is not defined, the basic U/M of the item will be used as the catch weight U/M. Catch weight U/M can only be entered for an item when 'Location based CW' is selected in (MMS001/G).
(MMS015/E) Std CO U/M Select the check box if the alternative U/M will be used as the standard sales U/M. Standard sales U/M is used when sales U/M is omitted during order line entry. If there is no standard sales U/M, the basic U/M of the item will be used as sales U/M during order line entry.
(MMS015/E) Std St U/M Select the check box if the alternative U/M should be used as standard statistics U/M. Standard statistics U/M is used both in the order entry and sales statistics. If no standard statistics U/M has been entered, the basic U/M of each item will be used in the statistics.
(MMS015/E) Std MO U/M Select the check box if the alternative U/M should be used as the standard manufacturing U/M. Standard manufacturing U/M is used when manufacturing U/M is not entered in connection with the entry of receipts from manufacturing in the manufacturing order processing module. If standard manufacturing U/M is not defined, the basic U/M of the item will be used.
(MMS015/E) Std Cost U/M Select 'Alternate U/M' (defined on (MMS015/B)) as Std Cost U/M. Cost unit of measure is displayed in (MMS001/H). Cost unit is displayed in various programs, for example in (MMS003/E) and (PCS300/B).
(MMS003/E) Inv Acc Method Select Inventory accounting method.
(MMS003/E) CW Cost

The field indicates if the value for a specific transaction should be calculated based on the actual weight multiplied by the cost per weight. All stock transactions and internal accounting transactions will be created based on the actual weight and a cost expressed per weight unit. Internal accounting and General Ledger transactions will continue to hold a quantity but this will be the actual weight-based quantity and not the quantity in the basic unit of measure.

Alternatives:

0 = No catch weight cost

1 = Catch weight cost. The standard weight of the product is the same across the company and the standard cost is calculated based on the weight conversion factor in (MMS015/E).

2 = Catch weight cost by facility. The standard weight of the product varies from facility to facility and the standard cost is calculated based on the weight conversion factor in (MMS003/E).

Prerequisites for the catch weight cost are:

Value in the (MNS095/E) Industry field must be 'FoB-Food'.

Value in the (MMS001/G) active or catch weight item field must be 2, 3, or 4.

Value in the Standard U/M – Catch weight field must be equal to that in the Standard U/M – Cost field in (MMS015/E).

(MMS001/E) Lot control Method For Catch Weight methods, lot in lot-master with alternative 3 should be selected.
(MMS001/G) Active/ Catch weight Item Select from CW item 2 - 4.
(MMS001/G) Location Based CW Select the check box. This stores catch weight on the location level. If not selected, catch weight is stored on the lot level. In order to store catch weight on the location level, the alternative 'FoB-Food' must be selected in the Industry field in (MNS095).
(MMS001/H) Cost U/M The U/M in which the cost of the item is calculated and saved. In addition to the cost the inventory accounting price, acquisition cost, average cost, and internal transfer price are defined in the cost U/M. Every item has a cost U/M specified. For companies not in the Food and Beverage industry, the basic U/M is always used as the cost U/M and it cannot be changed. For companies in the Food and Beverage industry, an alternate U/M in (MMS015) can be defined to be the standard U/M for cost.
(MMS001/H) Catch Weight U/M

The field indicates the catch weight U/M.

The U/M in which the catch weight of the item is saved. For Food & Beverage customers who use location based catch weight, an alternative U/M for catch weight can be created.

Define panel version for catch weight on (MWS068) and (MWS070)

Program ID Field heading Description
(MWS068/B) CW Balance ID/Lot CW Old catch weight fields calculated from lot master MILOMA (&LCAWE and &BCAWE). Remove &LCAWE and &BCAWE when new location based catch weight is used. Instead add Catch Weight from balance ID table MITLOC (MLCAWE)
(MWS070/B)

Catch Weight OHB on trans date

Catch Weight OHB on reg. date

Select these fields for stock:

Catch Weight OHB on trans date – MTCWTT

Catch Weight OHB on reg. date - MTCWTQ

(MWS070/B)

Costing unit of measure

Costing quantity for transaction

Select these fields for costing:

Costing unit of measure – MMCPUN

Costing quantity for transaction- MTCSQT

(MMS200/B) Different Catch Weight fields

The following fields are available to support catch weight:

  • MMCAWP - Location based Catch weight
  • MMCWUN – Catch weight U/M
  • MMCPUN – Costing U/M
  • MBQUCW – Catch weight under insp per warehouse
  • MBRJCW – Rejected catch weight per warehouse
  • MBSTCW – Catch weight on hand per warehouse
  • M9QUCW – Catch weight under inspection per facility
  • M9RJCW – Rejected catch weight per facility
  • M9STCW – Catch weight on hand per facility

Display catch weight fields on (MWS422/B), (MWS440/A), and (MWS445/B)

This table describes the available catch weight fields in programs 'Picking List. Report Lines' (MWS422/B), 'Goods Receipt DO/RO. Report' (MWS440/A), and 'Goods Receipt DO/RO. Report Details' (MWS445/B).

Program ID Field heading Description
(MWS420/P) Propose weight

Indicates how catch weight is displayed in 'Picking List. Report Lines' (MWS422).

If Propose Weight = 0:

The catch weight field is open in (MWS422/B) and proposed CW=allocated weight. This reflects the weight at the time for allocation and can be changed.

If Propose Weight = 1:

The catch weight field is closed in (MWS422/B). Calculated and issued CW = Avg CW per unit on balance ID * issued quantity. This reflects the actual weight recorded in MITLOC (MWS068).

(MWS445/P) Propose weight

Deactivated check box: If not populated, the catch weight field is opened for editing in (MWS445/B), but not proposed.

Activated check box: If populated, the catch weight field is opened for editing in (MWS445/B), and the weight is displayed reflecting the actual weight recorded in MITLOC (MWS068).

(MWS440/P) Propose weight

Indicates whether the catch weight from pick list reporting (MWS422) should be proposed as the default during DO receipt.

If the catch weight should be proposed as default (alternatives 1 and 2 below), the fields on the (MWS440/A) panel must be entered based on the receipt of a single line.

0 = No. Not proposed as default.

1 = Yes. Propose catch weight as default, but do not show the A panel again unless there is an error.

2 = Yes. Propose catch weight as default, and redisplay the A panel so that the retrieved catch weight is displayed.

This reflects the actual weight recorded in MITLOC (MWS068).