| # Generate Default Order Numbers (bcmtc1223m000) Use this session to generate default sales, purchase and work order numbers. The settings for generating default order number can be set per order origin. This implies that default sales order numbers can be generated using another method than generated default purchase or work order numbers. 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. Generate Default Sales Order Numbers Indicates if default sales, purchase and/or work order numbers are to be generated. Allowed values Yes and No Default value No Sales Order Series The order series that is used in generating default sales order numbers when using methods ‘Use Prefix’ and ‘Generate New Numbers’. Default value The Automatic Sales Order Number Prefix, as defined in COMIN variable 17 of the MANMAN/HP OMAR database. Overwrite The ‘Overwrite’ checkbox can be used to overwrite the ERP LN 6.1 order numbers generated in a previous run. If you select the ‘Overwrite’ checkbox in combination with the ‘Make Empty’ method it clears all generated Order Numbers. Allowed values Yes and No Default value No Order Number Generation Method The Order Number Generation Method parameter controls the method to be used for generating default order numbers. Allowed values One-To-One First Characters are Zero Use Prefix Generate New Numbers Make Empty If this session is restarted for the purpose of regenerating default order numbers, the various methods only have effect if ‘Overwrite‘ option is selected. Default value One-To-One Related topics For more information and examples on ‘one-to-one’ order number conversion, refer to "To migrate order numbers". 10-to-9 Conversion Handling Indicates how to handle MANMAN/HP order numbers that exceed the 9 positions that are available in ERP LN 6.1 Allowed values Chop first Character Chop last Character Default value Chop first Character Purchase Order Series The order series that is used in generating default purchase order numbers when using methods ‘Use Prefix’ and ‘Generate New Numbers’. Default value The Purchase Order Series as defined in session "Conversion Parameters for Common" is defaulted and cannot be changed Work Order Series The order series that is used in generating default work order numbers when using methods ‘Use Prefix’ and ‘Generate New Numbers’. Default value The Work Order Series as defined in session "Conversion Parameters for Common" is defaulted and cannot be changed. Generate This specific command generates default values for the fields in this session. |