New fields to quotation line to store alias number and replacement

There is a need to store alias number and replacement item on quotation line level, similarly to the functionality on customer order. When creating a customer order line from the quotation, the alias number and the replacement item should be transferred from the quotation line to the customer order line.

Background:

The handling of alias and replacement needs to be similar to the way it is handled for customer order management. Alias number is to be stored in field POPN, replacement item to be stored in field REPI on the quotation line file QULINE. ITNO needs to be replaced with correct item number.

Solution:

When a quotation is created and an alias is entered in 'Quotation. Create' (QUS090) or in 'Quotation. Open Lines'(QUS101), the handling is similar as the one in customer order. An alias is picked and stored in field QUPOPN in table QULINE (Quotation line) and the item number stored in QUITNO in table QULINE. For replacement item, information on the item which is replaced is stored in field QUREPI in table QULINE, and the item replacing it is stored in QUITNO in table QULINE.

When creating a customer order from the quotation, the customer order line is created similarly as to creating a customer order line in 'Customer Order. Open Lines' (OIS101). The alias information from the quotation line triggers an update to OBPOPN in table OOLINE (Customer order line) and OBITNO in table OOLINE is updated with the item number. OBREPI in table OOLINE is updated with the replaced item, and OBITNO in table OOLINE is updated with replacing item. '

To support the required solution, the following enhancements are implemented:

• A new field REPI is added to QULINE (Quotation line) table and to data structure QUS200DS.

• In QUS100MI, POPN and REPI are added to the following transactions:

  • AddQuote

  • LstQuoteLine

  • GetQuoteLine

• The handling of alias and replacement is added to 'Quotation. Create'(QUS090) and to related function QUS091. When a quotation line is created containing alias and/or replacement, the fields POPN and REPI are created on the quotation line table QULINE. When creating an alias or replacement line in 'Quotation. Open Lines' (QUS101), the fields POPN and REPI are created on the quotation line table QULINE.

• In 'Quotation. Open' (QUS100), using related option 14-'Create order' you can create a customer order from the quotation. The fields ALWQ, POPN, ALWT and REPI are generated in the batch order line file OXLINE with values from the quotation line file QULINE. The fields for POPN and REPI in the created customer order line OOLINE are generated from the quotation line.