Entry of catch weight at customer order entry

A catch weight will only be entered on the customer order line if the order quantity is negative (i.e. a customer return) or if the 'CO type' in 'CO Type. Open' (OIS010) is set up for direct delivery (i.e. the status goes directly to '66 – Delivered' or '77 - Invoiced' when exiting customer order entry).

If a catch weight is entered for the customer order line, then the quantity in sales price U/M is calculated as described in the section 'Managing sales price U/M for items with location based catch weight'.

The quantity in the sales price U/M is displayed as the 'Remains to invoice' quantity on the customer order line details in 'Customer Order. Open Line' (OIS101) and panel versions in 'Customer Order. Open Lines' (OIS101) and 'Customer Order. Open Line Toolbox' (OIS301) if the panel version field '&TOINV' is used.

The quantity in the sales price U/M is used to calculate a number of things:

  • Net line amount on the order line
  • Gross amount for the order line if &GRSAM is used in the panel version in (OIS101) and (OIS301)
  • Net line amount and gross line amount in (OIS100MI)
  • Order value gross (BRAM) on the order header
  • Total order value gross (BRLA) on the order header
  • The VAT base and Tax base (the line amount) when calculating VAT or Tax
  • The order header charge when it is based on the order gross and there is a kit with pricing method 3 (the sales price of the kit item is the sum of the values of the detail lines).

The difference between the two values on the order header is that the 'Order value gross' (BRAM) is the 'Remains to invoice value' while the 'Total order value gross' (BRLA) is the 'Ordered value'. They are updated when:

  • Creating the order line
  • Changing the order line
  • Closing the order line
  • Deleting the order line
  • Resetting an order that previously ended abnormally
  • Invoicing

Order Entry Statistics (OSS900)

The catch weight (as cost quantity) is used to calculate the cost in the order entry statistics (OSASTD - UCOS, PCLA, and ACOS).

The quantity in the sales price U/M, which is calculated from the CW quantity, is used to calculate the gross line amount (GRPR), discounts (DIA1-6, OFRA), and the net line amount (SAAM).

External Documents

The quantity in the sales price U/M (and the sales price U/M) is printed on the order confirmation (OIS606 and OIS608), the pro forma invoice (OIS641 and OIS643), and the quotation (QPS601). It is also used to calculate the net line amount.

The catch weight (and the catch weight U/M) is sent in the stream file (0LXECAWE and 0LXECWUN) for the order confirmation (OIS606 and OIS608), the pro forma invoice (OIS641 and OIS643), the invoice (OIS193 and OIS99), and the quotation (QPS601).

Functional Limitations

  • Negative Quantity on the Customer Order Line:
    • If the order quantity is negative, the user is forced to enter a catch weight. It is technically possible to do a partial 'delivery' of this customer order line with a negative quantity. Doing so will cause issues:
      • If the 'delivery' is invoiced, then it leaves a customer order line with a remains to invoice quantity in basic U/M that has no relation to the catch weight on the order line. The remains to invoice quantity in basic U/M will, in this case be used to display the remains to invoice amounts in the places where this can be seen. This amount can of course differ from the actual amount when the remaining quantity is invoiced, since that will be based on the actual catch weight.
      • If the order line is closed, then the line amount and the order total is not reduced since those are calculated based on the catch weight. The user must change the reported catch weight in order for the amounts to be recalculated.
  • Direct Delivery:
    • If the order type is set up for direct delivery (the status goes directly to '66 – Delivered' or '77 - Invoiced'), the user is forced to allocate the order line (in addition to enter a catch weight). If the user allocates less than the ordered quantity, then the ordered quantity is automatically reduced to the allocated quantity (a warning message is given). However, as the line amount is calculated based on the catch weight, neither the line amount or order total is recalculated. The user must change the reported catch weight in order for the amounts to be recalculated.
  • Order Statistics:
    • There is a field for catch weight in the order entry statistics (OSASTD), however this is never updated.
    • Ordered quantity in the sales price U/M (ORQS) and in the statistics (OSASTD and OSBSTD) is based on the standard conversion rate between the basic U/M and the sales price U/M. This also applies when a CW quantity is entered at CO entry.