Relations by Invoice (tdcms2502m000)

Use this session to view:

  • Invoice details.
  • The status of the rebate lines that are released to Invoicing in the Release Commissions/Rebates to Invoicing (tdcms2201m000) session.
  • The status of the commission lines that are released to Accounts Payable in the Release Commissions/Rebates to Invoicing (tdcms2201m000) session.
Note: 
  • When you release a commission line to Accounts Payable, the line status is set to Closed. As a result, LN updates the SO Invoice No. and Invoice fields in the Relations by Invoice (tdcms2502m000) session.
  • When you release a rebate line to Invoicing, the line status is not immediately set to Closed. After you release a rebate line to Invoicing, LN selects the Released to SLI(Rebate) check box in the Relations by Invoice (tdcms2502m000) session. You can now view the rebate invoicing data in the Invoice (cisli3605m000) session. As long as the invoice status is Confirmed, or On Hold in Invoicing, you can still update the rebate amount in the Rebates (tdcms2550m000) session. When you finish the invoicing procedure by composing, printing and posting the invoice, LN creates an open entry in the Accounts Receivable module and sets the rebate status to Closed. As a result, LN updates the SO Invoice No. and Invoice fields in the Relations by Invoice (tdcms2502m000) session.

Field Information

Type

Select the type of report to be printed.

You can select one of the following:

The options you have depend on the values of the Commissions Implemented and Rebates Implemented check boxes in the Commissions/Rebates Parameters session.

Status

The status of the commission/rebate.

Allowed values

Calculated

The initial status of a commission/rebate.

Manual

The status of a modified, manually inserted, or changed line.

Approved

The commission/rebate is approved and can be paid.

Reserved

The commission/rebate is reserved.

Reservation Approved

The reserved commision/rebate is approved.

Ready

The commission/rebate is printed.

Closed

The commission/rebate amount is processed and the commission/rebate is given. You can no longer change the commission/rebate line.

Order

The order number that identifies the sales order.

Line

position number of an order line

Sequence Number

The number of the sales order delivery line.

Actual Delivery Line Sequence Number

The number of the sales order actual delivery line.

Note: This field reads zero if the Calculation Method is set to Sales Order in the Relations (tdcms0110s000) session.
Invoice Line

The number of the sales order invoice line.

Note: This field reads zero if the Calculation Method is set to Sales Order in the Relations (tdcms0110s000) session.
Relation

The number that identifies a relation.

Relation Sequence

sequence number

SO Invoice No.

transaction type

Invoice

The invoice number of the sales order.

Invoice Date

The date and time of the commission or rebate invoice.

Comm./Rebt Invoice

The transaction type used to post the commission/rebate to LN Financials/ LN Central Invoicing.

Comm./Rebt Invoice

The invoice number of the invoiced rebate or commission.

Released to SLI(Rebate)

If this check box is selected, the rebate is released to Invoicing .

Note: 
  • With this check box you can view whether the rebate is already released. If the rebate is released, but the invoice status is Confirmed, or On Hold in Invoicing , you can still update the rebate amount in the Rebates (tdcms2550m000) session.
  • When you release a rebate line to Invoicing , invoicing batches must be generated, and invoices must be composed and printed in Invoicing before an open entry can be generated in Accounts Receivable . Once the invoicing procedure is completed, the rebate status is set to Closed and the Transaction Type and Invoice Number fields are updated.
Period Table

period table

Statistical Year

The year in which the period falls.

Period

period

Reserve

If this check box is selected, the commission or rebate must be reserved in LN. If this check box is cleared, the commission or rebate must be invoiced directly.

Reservation Date

The date on which the commission/rebate was reserved in LN.

Discount

This field is used in the sales statistics to specify certain commissions or rebates. The discount code's type must correspond with the agreement type ( Commission or Rebate). When the commission or rebate is manually adjusted, the discount code must be defined as not for use in an agreement.

Sales Office

sales office

Search Priority

search priorities

This field displays the priority on which the agreement was originally based.

Percentage

The normal percentage that is applicable for the calculation of the commissions/rebates.

Growing Percentage

The percentage that is used to calculate commissions/rebates in addition to the normal commission/rebate amount.

Calculation Date

The date on which the commission/rebate was calculated.

Commission/Rebate Amount

amount

Currency

home currency

Sales Order Amount

The amount on which the commission/rebate calculation is based.

Amount in Sales Order Currency

The commission amount or rebate amount, expressed in the order currency.

Sales Order Currency

The currency that is used on and defaulted from the order.

Amount in Comm./Rebt. Invoice Currency

The commission amount or rebate amount, expressed in the invoice currency.

Comm./Rebt. Invoice Currency

invoice currency

Default value

The invoice currency is defaulted from the relation.