Generate Default Order Numbers (bcmtc1223m000)

Generating default orders numbers is controlled by setting 2 parameters:

• Generation Method
• 10-to9 Conversion Handling

The offered methods for generating default order numbers are:

• One-to-one Conversion The MANMAN/HP order numbers are converted without any changes to the ERP LN 6.1 order number.
• First Characters are Zero The MANMAN/HP order numbers are converted to ERP LN 6.1 with multiple zero’s as prefix.
• Use Prefix The MANMAN/HP sales order number prefix, stored in OMAR COMIN 17, is used to convert the order number to ERP LN 6.1. For purchase and work orders, no such prefix is available. Converting these orders based on the ‘use prefix’ method, is done by taking the defined purchase order and work order series in session "Conversion Parameters for Common" as prefix.
• Generate New Numbers New order numbers are generated based on predefined number groups and series, defined in the Conversion Parameters for Common, and converted to ERP LN 6.1. For sales orders, COMIN 17 is used as sales order series.

As the order numbers in MANMAN/HP can contain up to 10 positions, whereas ERP LN 6.1 allows 9 positions, the ’10-to-9 Conversion Handling’ parameter controls the 10 positions to 9 positions conversion.

• Chop first Character
• Chop last Character

Use the ‘Validate’ option present in session Mapping Table for Order Numbers (bcmtc1123m000), after generating default order numbers, for detecting duplicate order numbers per order origin. In this session it is always possible to manually change a defaulted ERP LN 6.1 order number.

Preparation

Before you can use this session all sales, purchase and work order numbers that are to be converted must be present in session Mapping Table for Order Numbers (bcmtc1123m000).

Execution

Generating default order numbers depends on whether Master Data is converted or Production Data (including Master Data). If Production Data is converted it is mandatory to run the session.

Process logic

The order number conversion process is controlled by the selected order origin, the selected method and 10-to-9 conversion handling. In the following flow/pseudo code details the functionality of each of the offered conversion methods. This flow is followed for each source order number in order to get a target order number.

If method = one-to-one conversion

• If order number length is 10.
  • If 10-to-9 Conversion = chop first character -> target order number = source order number – first position.
  • If 10-to-9 Conversion = chop last character -> target order number = source order number – last position
  • If order number length is 9 -> target order number = source order number.
  • If order number length is less than 9 -> target order number = source order number

If method = first characters are zero

• If order number length is 10.
  • If 10-to-9 Conversion = chop first character -> target order number = source order number – first position
  • If 10-to-9 Conversion = chop last character -> target order number = source order number – last position.
  • If order number length is 9 -> target order number = source order number.
  • If order number length is less than 9 -> target order number = source order number prefixed with zero’s up to 9 positions.

If method = use prefix

• If order number length is 10
  • If 10-to-9 Conversion = chop first character -> target order number = source order number – first position.
  • If 10-to-9 Conversion = chop last character -> target order number = source order number – last position.
  • If order number length is 9 -> target order number = source order number.
  • If order number length is less than 9.
    • Determine the sales, purchase and work order series (OMAR COMIN 17, bcmtc100.srpo, bcmtc100.srwo) and the length of these series.
    • If the available length (available length = 9 – source order number length) is greater than the series length, the order series is used as a order number prefix. If the prefix together with the source order number does not add up to 9 positions, zeros are put in between the prefix and source order number. -> target order number = prefix + (zeros +) source order number.

If method = generate new numbers

• Determine the last (previous) issued order number for the current origin (sales, purchase, work order)
  • -> target order number = last issued order number + 1

The following table contains some example source order numbers, with various lengths, and the defaulted target order number, applying the process logic described above.

Source Order no	One-to-One	First Characters are Zero	Use Prefix *	Generate New * Numbers
HP1000	HP1000	000HP1000	MM0HP1000	MM0000001
HP1000001	HP1000001	HP1000001	HP1000001	MM0000001
HP10000010 **	P10000010	P10000010	P10000010	MM0000001
HP10000010 ***	HP1000001	HP1000001	HP1000001	MM0000001

* In these example order number conversion ‘MM’ is used as Series.

** Order number length is 10; order numbers are defaulted using the ‘chop first character’ option.

*** Order number length is 10; order numbers are defaulted using the ‘chop last character’ option.

Restart

When you restart the session to generate new default order numbers, this will only have effect if the checkbox ‘Overwrite’ is selected.