TRTVENTAR processing: Manual Entry Reason Loading

RECHTARIF: Intervention before the price list search

Use this entry point to intervene in the price list search (normal or component):

• by modifying the value of the reference date: DATREF,
• by modifying the value of the rate type: LCHGTYP.

You can also use this entry point to perform several search loops in order to obtain the best net price.

 This entry point is called in the TRTVENTAR processing (RECH_TARIF subprogram):

• in price list simulation: to calculate the normal price list,
• in quote management: to calculate the normal or component price list,
• in order management: to calculate the normal or component price list,
• in delivery management: to calculate the normal or component price list,
• in invoice management: to calculate the normal or component price list.

Context and operating mode

Transaction

There is no transaction in progress.

Log file

There is no open log file.

Different call cases

This entry point is called:

· in price list simulation upon activating the "Apply" button. The date entered is stored in the [M:SOH0]ORDDAT, [M:SOH2]DEMDLVDAT, [M:SOH4]DDEMDLVDAT(0) data

· in quote, order, delivery and invoice management, after entering the product quantity.

Available variables and masks

The following variables are loaded and used to identify the call context.

. TYPRECH: 1= for a standard product, 2= for a component

. ITMREF: Product reference

. NLIG: Table line index (nolign-1)

. QTY: Quantity in sales units

. TYPALI: Loading type

                                            = SQH            for quotes

                                            = SOH            for orders and price list simulation

                                            = SDH             for deliveries

                                            = SIH               for invoices

The screen classes loaded are as follows:

The SQH3, SOH4, SDH1, SIH4 screens contain the table of the lines.  

Open tables

In the table shown below, the flag (significant content = yes) indicates that the data in the classes concerned are consistent with the context and must not be modified by the entry point.

Search loops

Reminder:

In the price list search, the best value for the customer is only delivered for an equal priority and for a column (price or charges/discounts).

Some customers may benefit from sales conditions that are more favorable than promotional price lists, but the application of priorities always delivers the promotional price list.

Aim :

Performing several search loops and delivering the best net price.

It is necessary to assign each price list to a search loop. This code (from 0 to 8) will be defined in the setup in a future version.

Example:

It is necessary to start a specific loop for the PROMO price list (assignment of search code 1).  

$ACTION

Case ACTION

  When "RECHTARIF"       : Gosub RECHTARIF

Endcase

Return

$RECHTARIF

Local Integer ZII

ZII=find("PROMO",GPLI)

If ZII: GPLISEA(ZII-1)=1: Endif

Return

RECHTARIF1: Intervene on the values returned by the price list search

Use this entry point to intervene in the values returned by the price list search (standard or component).

This entry point is called in the TRTVENTAR processing (RECH_TARIF subprogram)

- in price list simulation:                  to calculate the standard price list.         (SOH loading type)

- in quote management:                  to calculate the standard or component price list(SQH loading type)

- in order management:      to calculate the standard or component price list(SOH loading type)

- in delivery management:           to calculate the standard or component price list(SDH loading type)

- in invoice management:             to calculate the standard or component price list(SIH loading type)

- in service response management:         to calculate the standard price list                                (CRM loading type)

- in intersite transfer management:          to calculate the standard price list                    (SCS loading type)

Fields available for modification:

-          The gross price (GROPRI), which is one of the parameters of the RECH_TARIF subprogram. You should never directly modify the value defined in the [M]GROPRI (NLIG) class as it can be overwritten depending on the call context.

-          If loading type: SQH, SOH, SDH, SIH

o        the values stored in the [M] class

§         [M]PRIREN (NLIG)                      Price reason

§         [M]DISCRGVALx (NLIG)             Charge/discount (x=1 to 9)

§         [M]DISCRGRENx (NLIG)            Charge/discount reason (x=1 to 9)

§         [M]REPCOE (NLIG)                    Sales representative commission coef. (except for quotes)

-          If loading type: CRM

o        the values stored in the [M:SPSW] class

§         [M:SPSW]PRIREN (NLIG)                     Price reason

§         [M:SPSW]DISCRGVALx (NLIG)           Charge/discount (x=1 to 9)

§         [M:SPSW]DISCRGRENx (NLIG)           Charge/discount reason (x=1 to 9)

§         [M:SPSW]REPCOE (NLIG)                   Sales representative commission coef. (except for quotes)

-          If loading type: SCS

o        the values stored in the [M:SCS1] class

§          [M:SCS1]DISCRGVALx (NLIG)             Charge/discount (x=1 to 9)

Context and operating mode

Transaction

There is no transaction in progress.

Log file

There is no open log file.

Different call cases

This entry point is called:

· in price list simulation upon activating the "Apply" button. The date entered is stored in the [M:SOH0]ORDDAT, [M:SOH2]DEMDLVDAT, [M:SOH4]DDEMDLVDAT(0) data

· in quote, order, delivery and invoice management, after entering the product quantity.

Available variables and masks

The following variables are loaded and used to identify the call context.

. TYPRECH: 1= for a standard product, 2= for a component

tab. ITMREF: Product reference

. NLIG: Table line index (nolign-1)

. QTY: Quantity in sales units

. TYPALI: Loading type

                                            = SQH            for quotes

                                            = SOH            for orders and price list simulation

                                            = SDH             for deliveries

                                            = SIH               for invoices

                                            = CRM             for interventions

                                            = SCS             for inter-site transfers

The screen classes loaded are as follows:

The SQH3, SOH4, SDH1, SIH4 screens contain the table of the lines.  

Open tables

In the table shown below, the flag (significant content = yes) indicates that the data in the classes concerned are consistent with the context and must not be modified by the entry point.

RECHGROUP: Intervene in the values returned by the price list search

Use this entry point to intervene in the thee types of modifications performed by the grouped price lists.

Line modification

The value 1 in the [M]GRPFLG variable (line no.) indicates that a modification occurred on this line.

The fields available for modification are:   

         [M]GROPRI (line no.)                 Gross price

         [M]PRIREN (line no.)                 Price reason

         [M]DISCRGVALx (line no.)        Discount/charge (x=1 à 9)

         [M]DISCRGRENx (line no.)       Discount/charge reasons (x=1 à 9)

         [M]REPCOE (line no.)                Coef. Sales representative commission (except for quotes)

However it is not possible to identify the fields actually modified by the grouped price list. Moreover, the net unit price for the [M]NETPRI line (line no.), is not re-calculated yet.

Modification of the invoicing elements

The grouped price lists can modify the content of the invoicing elements (see the paragraph on the Calculation basis by document in the price list structure). The internal MOTIF and MONTANT tables are used for the update of the table for invoicing elements. MOTIF(x) contains the invoicing element code; MONTANT(x) contains the value returned by the search. At this level, the transfer to the table for elements has already been performed.

Creation of the grouped price list lines

If the search returns free products, the data necessary for the creation of the lines are contained in the following tables:

- FOCITMREF          Product reference

- FOCUOM               Sales unit

- FOCQTY                Quantity

- FOCMOTIF             Free product allocation reason

The free lines are not yet created. By setting the GPE variable to 1, you can cancel this creation.

Context and operating mode

Transaction

There is no transaction in progress.

Log file

There is no open log file.

Different call cases

This entry point is called:

·               in quote, order, delivery and invoice management.

Available variables and masks

. GFONCTION: Loading type

                                            = GESSQH            for quotes

                                            = GESSOH            for orders and price list simulation

                                            = GESSDH             for deliveries

                                            = GESSIH               for invoices

The screen classes loaded are as follows:

The SQH3, SOH4, SDH1, SIH4 screens contain the table of the lines.  

Open tables

In the table shown below, the flag (significant content = yes) indicates that the data in the classes concerned are consistent with the context and must not be modified by the entry point.

RECHGROUP1: Modification of those values coming from the search for a grouped pr

Use this entry point to intervene in the values returned when applying a grouped price list.

After selecting a line on which the grouped price list can be applied (if CODENTPNT=S1)

- It is possible to assign the value 1 to the NONSEL variable in order to reject the selection of the line. In this case, the CUMQTY and CUMAMT variables are not adjusted with the quantity and net price of the line.

Between the line selection loop and the price list application to the selected line (if CODENTPNT=S2)

- This allows you to modify the values for amount total (CUMAMT) and quantity total (CUMQTY), which will be used as a basis for the application of the grouped price list.

- This allows you to intervene during the rounding of the quantity total (CUMQTY) based on the price list unit so that you can prevent it by setting the WARR_CUMQTY variable to 0.

On updating a line (if CODENTPNT=G1 )

- by modifying directly the values stored in the line ([M] class)

         [M]GROPRI (NLG)                Gross price

         [M]PRIREN (NLG)                 Price reason

         [M]DISCRGVALx (NLG)        Charge/discount (x=1 to 9)

         [M]DISCRGRENx (NLG)         Charge/discount reason (x=1 to 9)

         [M]REPCOE (NLG)               Coef. Sales representative commission (except for quotes)

- by using the references for the applied price list

On the update of the free product (if CODENTPNT=G2)

- by directly modifying the values returned before the creation of the free line

         FOCITMREF(IGR-1)        Free product reference

         FOCITMQTY(IGR-1)        Free quantity

         FOCMOTIF(IGR-1)          Free reason

- by using the references for the applied price list

Note:

    Do not modify the IGR value, which is the index for the free item table

    Do not use the NLG value, since it is not significant in the context of free products.

This entry point is called in the TRTVENTAR processing from the generated processes WBTxxxxxx (xxxxxx=price list code)

- in quote management

- in order management

- in delivery management

- in invoice management

Context and operating mode

Transaction

There is no transaction in progress.

Log file

There is no open log file.

Different call cases

This entry point is called:

· in quote, order, delivery and invoice management, after entering the product quantity.

Available variables and masks

The following variables are loaded and used to identify the call context.

tab. CODENTPNT: Type of call to the entry point

                                            = G0                      no update for the line

                                            = G1                      if call when a line is updated

                                            = G2                      if call when a free product is updated

. NLG: Table line index (nolign-1) on update of a line

. GFONCTION: Loading type

                                            = GESSQH            for quotes

                                            = GESSOH            for orders and price list simulation

                                            = GESSDH             for deliveries

                                            = GESSIH               for invoices

The screen classes loaded are as follows:

The SQH3, SOH4, SDH1, SIH4 screens contain the table of the lines.  

Open tables

In the table shown below, the flag (significant content = yes) indicates that the data in the classes concerned are consistent with the context and must not be modified by the entry point.

RECHGROUP0: Intervention before the grouped price list search

Use this entry point to intervene before the grouped price lists are searched.

This entry point is called in TRTVENTAR (RECH_GROUPE subprogram).

Context and operating mode

Transaction

There is no transaction in progress.

Log file

There is no open log file.

Different call cases

This entry point is called in the management of quotes, orders, deliveries, invoices when using "Create" or "Save".

Available variables and masks

The following variables are populated:

. TYPALI: Loading type

                                            = SQH            for quotes

                                            = SOH            for orders and price list simulation

                                            = SDH             for deliveries

                                            = SIH               for invoices

tab. DATREF: Reference date

tab. LCHGTYP: Exchange rate type

tab. LPRITYP: Price type

. LCUR: Currency

 The screen classes loaded are as follows:

The SQH3, SOH4, SDH1, SIH4 screens contain the table of the lines.  

Open tables

In the table shown below, the flag (significant content = yes) indicates that the data in the classes concerned are consistent with the context and must not be modified by the entry point.