Sales Contract Analysis (tdsls3513m000)

Use this session to display all results of sales contracts on an aggregated level.

 

Contract

The sales contract's number.

Item

In LN, the raw materials, subassemblies, finished products, and tools that can be purchased, stored, manufactured, sold, and so on.

An item can also represent a set of items handled as one kit, or exist in multiple product variants.

You can also define nonphysical items, which are not held in inventory but can be used to post costs or to invoice services to customers. The following are examples of nonphysical items:

  • Cost items (for example, electricity)
  • Service items
  • Subcontracting services
  • List items (menus/options)
Effectivity Unit

A reference number, for example a sales order line or a project deliverable line, that is used to model deviations for a unit effective item.

Effective Date

The first day on which a record or a setting is valid. The effective date often includes the effective time.

Expiry Date

The last day on which a record is valid. If you do not specify an expiry time, the validity expires at the end of the expiry date, at 24:00 hours.

Default value

The default date is the effective date plus one year less one day.

Current Date

The present date and time. LN fills this field automatically with the date and time on which you start this session.

Time Elapsed

The time elapsed is expressed as a percentage of the total contract duration, recorded in the Sales Contracts (tdsls3500m000) session.

The time elapsed is calculated as follows:

                  
Time Elapsed = (Current Date - Effective Date ÷ ((Expiry Date - Effective Date) + 1)) * 100% 
				
Agreed Quantity

The contract quantity expressed in the sales unit.

Agreed Quantity

The unit in which an item is sold.

Note

Items can be sold in a different unit than the one in which their inventory is recorded. For example, goods can be stored in kilograms and sold in bails.

Agreed Quantity

The contract quantity expressed in the inventory unit.

Agreed Quantity

The unit of measure in which the inventory of an item is recorded, such as piece, kilogram, box of 12, or meter.

The inventory unit is also used as the base unit in measure conversions, especially for conversions that concern the order unit and the price unit on a purchase order or a sales order. These conversions always use the inventory unit as the base unit. An inventory unit therefore applies to all item types, also to item types that cannot be kept in stock.

Quantity Binding

This field indicates whether the agreed contract quantity is binding.

If this check box is selected, the Evaluate Sales Contracts (tdsls3420m000) session prints all differences between:

  • The called quantity and the maximum contract quantity.
  • The called quantity and the minimum contract quantity.

If this check box is cleared, the Evaluate Sales Contracts (tdsls3420m000) session only prints the differences if the minimum contract quantity or the maximum contract quantity are exceeded.

Minimum Quantity

The minimum contract quantity expressed in the sales unit.

Minimum Quantity

The minimum contract quantity expressed in the inventory unit.

Maximum Quantity

The maximum contract quantity expressed in the sales unit.

Maximum Quantity

The maximum contract quantity expressed in the inventory unit.

Called Quantity

The total of the called quantities for all sales order lines that are linked to the contract line, expressed in the sales unit. The value of this field is raised when you link a sales order line to a contract line.

This quantity is updated during the input of sales order lines, when a sales order is linked to a contract.

Called Quantity

The total of the called quantities for all sales order lines that are linked to the contract line, expressed in the inventory unit.

Called Amount

The total of the called amounts on sales order lines that are linked to a sales contract.

Note

Based on the called amount, the effective date and the expiry date, you can calculate the possible final amount on the expiry date by extrapolating data.

Invoiced Quantity

The total number of invoiced items on sales orders and sales schedules related to a sales contract, expressed in the sales unit

Based on the invoiced quantity, the effective date and the expiry date, you can calculate the possible end quantity on the expiry date by extrapolating data. If you run the Process Delivered Sales Orders (tdsls4223m000) session, the invoiced quantity is raised for each contract related order line.

Note

Order discounts are not accounted for. Only the net goods amounts are totalized.

Invoiced Quantity

The total number of invoiced items on sales orders and sales schedules related to a sales contract, expressed in the inventory unit.

Invoiced Amount

The total of the invoiced amounts on sales order lines that are linked to a sales contract.

Note
  • You can calculate the possible invoiced amount on the expiry date by extrapolating data, based on the invoiced amount, the effective date and the expiry date.
  • The invoiced amount is updated when you run the Process Delivered Sales Orders (tdsls4223m000) session.
Position

The number used to identify the position of the order line on the sales or purchase order.

Total Quantity

The total number of called and invoiced quantities, expressed in the sales unit.

Total Quantity

The total number of called and invoiced quantities, expressed in the inventory unit.

Result

The total number of called items and invoiced items expressed as a percentage of the agreed quantity.

      
Result = (Total Quantity ÷ Agreed Quantity) * 100%
      
or:
       
((Called Quantity + Invoiced Quantity) ÷  Agreed Quantity) * 100%
       
Expected Quantity

This field indicates how much is expected to be sold at the end of the contract duration, expressed in the sales unit.

Expected Quantity = (Total Quantity ÷ Elapsed time in %) * 100%
              
Note

The total quantity is equal to the total of the called and invoiced quantities.

Expected Quantity

This field indicates how much is expected to be sold at the end of the contract duration, expressed in the inventory unit.

Expected Result

The result in relation to the expected quantity. The expected quantity on the expiry date is calculated through extrapolating data.

 
Expected Result = (Total Quantity ÷  Expected Quantity) * 100%
             
or:

(Called Quantity + Invoiced Quantity ÷ (Agreed Quantity * Elapsed Time in % ÷ 100)) * 100%
                
Sales Office

A department that is identified in the company business model to manage the business partner's sales relations. The sales office is used to identify the locations that are responsible for the organization's sales activities.

Sold-to Business Partner

Usually a customer's purchase department, the business partner who orders goods or services from your organization, that owns the configurations you maintain, or for whom you perform a project.

The agreement with the sold-to business partner can include the following:

  • Default price and discount agreements
  • Sales order defaults
  • Delivery terms
  • The related ship-to and invoice-to business partner
Sales Price Group

A group of items to which the same pricing characteristics apply.

If this field is filled, the price or discount on the contract line applies to all items that belong to this price group.

Note

You cannot enter agreements on a contract line that relate to both an item and a price group.

For agreements by price group, the following conditions apply:

  • You cannot define a delivery schedule.
  • You must specify a quantity.
  • The sales unit need not be entered.
  • The sales price unit need not be entered.
  • The Item field must be skipped.
  • You cannot enter multiple contract lines for the same price group in the same contract.
  • For each price group, you can only conclude one normal contract with each customer per period.