Add additional field from custom subtotal fields (CMS018)

This procedure defines additional fields from 'custom subtotal' fields. Custom Subtotal fields are created to store new values according to user specification. This custom subtotal field is then connected in 'XML Structure. Open Section' (CMS007) through a custom subtotal section, triggering related option 22='Add Custom Subtotal Section'.

It is also important that 'Grp by element' field in 'XML Structure. Open Section' (CMS007) has a value for the grouping that takes place.

On (CMS018/E), a field is selected as a basis for calculation and uses sum as the calculation function for the new subtotal values. 'Group by' is used to define how the calculated values are arranged in the XML structure. Custom subtotal fields work for both document and reports. Adding new sections can have a large impact on output function performance.

Follow these steps to create a Custom Subtotal - CMS018:

  1. Start (CMS006), select XML structure and use option 11='XML Structure. Open Section' to start (CMS007).
  2. Click Subtotal fields to start 'XML Custom Subtotal Fields. Connect' (CMS018).
  3. Specify the XML section and the virtual field to be read in the section. The value of XML must be larger than 100 and the virtual field must start with ampersand '&' plus 4 alphanumeric values. Use option 1='Create'.
  4. On the E panel, specify the description, name, base XML section, calculation Fnc, No. of decimal, message ID, and group by. Press Enter.
  5. After the virtual field is created, close (CMS018) to return to (CMS007).
  6. In (CMS007), select the section used as base XML section and use option 22='Add custom subtotal section'.
  7. Select the created virtual field from the M3 BE browse window.
  8. Press Enter to create the custom subtotal section.
Related topics