Customer order processing

Customer Order Entry

  • Sales Price U/M

    Set '*PRI' for the 'Sales price U/M' in 'CO Type. Update Field Selection' (OIS014/J) if the sales price U/M should be retrieved from the price source. If this field is blank, the default sales price U/M of the item is used.

    '*PRI' only supports retrieval of the sales price U/M from a price list, agreement, or promotion (price origins 2, 6, and 9). For other sources, the default sales price U/M of the item is used.

    It is not possible to manually change the sales price U/M when '*PRI' is used.

  • Quantity in the Sales Price U/M

    If catch weight is omitted on the CO line, the ordered quantity in the sales price U/M is initially calculated from the order quantity in the item’s basic U/M with the standard conversion rate defined in (MMS015). The delivered quantity in the sales price U/M is later calculated based on the catch weight reported at picking list reporting.

    A catch weight will only be entered on the CO line if the order quantity is negative (i.e. a customer return) or if the CO type is set up for direct delivery (i.e. the status goes directly to '66 – Delivered' or '77 - Invoiced' when exiting CO entry). These scenarios are addressed in section 'Entry of Catch Weight at Customer Order Entry'.

Delivery

The catch weight (and the quantity in the basic U/M) is reported when reporting the pick list. It can also be changed when correcting a previously reported picking list.

The 'Propose weight' field in 'Picking List. Report' (MWS420/P) 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. The catch weight can be changed.

If Propose Weight = 1:

  • The catch weight field is closed on (MWS422/B). Calculated and issued CW = Avg CW per unit on balance ID * issued quantity. This reflects the actual average weight recorded in the table MITLOC in 'Balance Identity. Open Toolbox' (MWS068).
  • The reported catch weight reduces the catch weight on the balance identity (MWS068) and the catch weight for the specific transaction can be seen in 'Stock Transaction. Display History' (MWS070).
  • The catch weight is used to update the net and gross weight on the logistical delivery line (MHDISL). (See section 'Net and Gross Weight Calculation').
  • The catch weight and the quantity in the sales price U/M is updated on the customer order delivery line (ODLINE fields CAWE and DLQS). The quantity in the sales price U/M is calculated from the reported catch weight, with up to 6 decimals independent of the number of decimals defined for the U/M.
  • The quantity in the sales price U/M is used to calculate the line amount, which is also updated on the delivery line (LNAM).
  • The catch weight is displayed on the delivery line in 'CO Delivery. Display Lines' (OIS356) and is also published in the API transaction 'OIS350MI.GetDeliveryLine'. It is also used as the quantity in the cost U/M, since the cost U/M is always the CW U/M for items with location based catch weight, meaning that it is used for the cost calculations. (See section 'Cost Quantity and Cost Calculations').
  • The catch weight updates the cost quantity (CSQT) and catch weight (CAWE) in the table for internal transactions between divisions (CMUFTR). The internal transfer price (INPR) is stated as the price per cost U/M, i.e. the CW U/M, which means that the catch weight is used for calculating the transaction amount.
  • The catch weight is used for calculating the claim amount (OICLCCLM) for supplier rebates.
  • The catch weight is used for calculating line charges that are based on gross weight or net weight.
  • The catch weight is also used for updating the net and gross weight in the CO delivery header (ODHEAD).
  • The catch weight is also used for order header charges calculated based on gross weight or net weight.

Net and Gross Weight Calculations

Note that the catch weight is only used to update the net weight if the item's catch weight U/M is equal to the general weight U/M defined in 'Settings – User-def Item Fields' (CRS703).

The gross weight is then calculated as the catch weight + the difference between the gross and net weight, as defined in 'Item. Open' (MMS001).

For the purpose of this document, it is assumed that the item's catch weight U/M is equal to the general weight U/M defined in (CRS703).

Cost Quantity and Cost Calculations

Note that the catch weight only will be used as the cost quantity if 'Catch weight cost' is activated in 'Item. Connect Facility' (MMS003). If the catch weight is used as the cost quantity, then it will be used for all cost calculations.

For the purpose of this document, it is assumed that 'Catch weight cost' is activated.

Proof of Delivery

Proof of delivery is performed in 'CO Delivery. Approve' (OIS155), (reached from 'CO Delivery. Open' (OIS150) with related option ='33 Proof of Dely').

The delivered quantity in the sales price U/M and/or in the basic U/M can be changed, however the catch weight cannot.

If the sales price U/M is equal to the catch weight U/M, the catch weight on the delivery line is set to the approved quantity in the sales price U/M.

If the sales price U/M is different than the catch weight U/M and the sales price U/M is flagged as a CW price U/M, the catch weight on the delivery line is calculated from the approved quantity in the sales price U/M.

If the sales price U/M is different than the catch weight U/M but the sales price U/M is not flagged as a CW price U/M, the new catch weight is calculated based on the average catch weight per basic U/M for the delivery line.

The net and gross weight on the delivery header is updated to reflect the changed catch weight.

Invoicing

The customer is invoiced for the quantity in the sales price U/M.

The quantity in the transaction tables for 'Invoice accounting' (OINACC.ACQT) and 'Various accounting transactions' (CRACTR.ACQT) are updated with the catch weight (as cost quantity).

Corrective Invoice

Corrective invoicing is performed in 'CO Invoice. Correct or Credit' (OIS380) (reached from 'Invoice. Display' (OIS350) with related option='14 Corr/Credit'). When correcting an invoice line in (OIS380), the quantity in the sales price U/M can be entered with up to 6 decimals, independent of the number of decimals defined for the U/M.

For a corrective invoice, two new deliveries are created, unless it is a full credit of the invoice. A credit delivery reverses the original transaction in full and the original catch weight will be used for the credit. The catch weight on the new debit delivery will be calculated as described below for the different scenarios.

  • If the sales price U/M is equal to the catch weight U/M, the catch weight on the delivery line is set to the quantity in the sales price U/M.
  • If the sales price U/M is different than the catch weight U/M and the sales price U/M is flagged as a CW price U/M, the catch weight on the delivery line is calculated from the quantity in the sales price U/M.
  • If the sales price U/M is different than the catch weight U/M but the sales price U/M is not flagged as a CW price U/M, the catch weight on the delivery line is calculated based on the average catch weight per basic U/M for the delivery line that is being corrected.
  • The net and gross weight on the delivery header is updated with the catch weight.

External Documents

The catch weight (and the catch weight U/M) is sent in the stream file (0LXECAWE and 0LXECWUN) for the invoice (OIS193 and OIS199) and for the pro forma invoice (OIS641 and OIS643) if 'Pro forma basis' is '2-Per delivery'.

Sales Statistics (OSBSTD)

A catch weight field in the sales statistics stores the catch weight (CAWE). The net weight and gross weight (NEWE and GRWE) are also updated with the catch weight.

The catch weight (as cost quantity) is used to calculate the cost in the sales statistics (UCOS, DCOS, PCLA, and ACOS).

Trade Statistics (CSYECT)

The 'Customs value' (ECAM), 'Statistics value' (SSVL), 'Fiscal value' (FSVL), and the 'Foreign currency amount' (CUAM) are based on the catch weight (as cost quantity) when these amounts are calculated as the cost multiplied with the cost quantity.

The net weight in the trade statistics (ECNW) is the catch weight.

Bonus and Commission

The catch weight (as cost quantity) is used to calculate the cost when the generating unit is the 'Cost value' or 'Contribution margin (net - cost value)'.

The catch weight is also used when the generating unit is 'Net weight' or 'Gross weight'.

Customer Returns

It is mandatory to enter both the catch weight and the 'Catch weight for credit' when processing a customer return in 'Customer Return. Open' (OIS390). A different 'Catch weight for credit' means that the catch weight returned to stock is different from the catch weight to be credited.

The reported catch weight increases the catch weight on the balance identity (MWS068) and the catch weight for the specific transaction can be seen in 'Stock Transaction. Display History' (MWS070).

Functional Limitations

Where the sales price U/M is different to the catch weight U/M and the sales price U/M is not flagged as a CW price U/M, it is not possible to enter a catch weight for proof of delivery and corrective invoicing. In this case the catch weight is calculated based on the average catch weight per basic U/M for the delivery line.

Example:

  • Delivered quantity = 10 PCE
  • Reported catch weight = 17.50 KG (standard conversion rate PCE = 2.00 KG)
  • Average catch weight per basic U/M = 1.75 KG
  • Approved or corrected quantity = 9 PCE
  • New catch weight on the delivery line = 15.75 KG (9 * 1.75)

An alternate approach is to calculate the changed catch weight based on the standard conversion rate between the basic U/M and the catch weight U/M. However, in extreme scenarios that could result in negative catch weight on the delivery line. If the corrected quantity in the example above is changed to 1 PCE, the new catch weight on the delivery line would be negative (17.50 – 18.00 = - 0.50 KG).

The fact that the catch weight becomes an approximation instead of an actual catch weight will, in most cases, not affect the customer (as it is not a CW price U/M). The catch weight on the customer delivery line could however affect the following (as described in previous sections):

  • Cost calculations
  • Order line charges based on weight
  • Weights in the CO delivery header (ODHEAD), which affects order header charges calculated based on the weight
  • Stream files for the invoice and for the pro forma invoice
  • Internal transfer transactions between divisions
  • Claim amount for supplier rebates
  • The quantity in the transaction tables for 'Invoice accounting' and 'Various accounting transactions'
  • Sales statistics
  • Trade statistics
  • Bonus and commission
Related topics
  • Catch Weight Management
  • Catch Weight and Cost Unit of Measure Settings
  • Catch Weight in Purchase Order
  • Catch Weight in Distribution Order
  • Perform Physical Inventory For a Catch Weight Item
  • Catch Weight Update
  • Catch Weight Loss Transactions
  • Reclassification of Balance Identity for a Catch Weight Item
  • Change Location on Balance Identity for a Catch Weight Item