Statistics Parameters (tdsta0100m000)

Use this session to:

  • Set the parameters of the Statistics module to the specific requirements of a company.
  • Define the levels on which the statistics are updated.

You can change the selected setup later. The session will update the new levels once you have changed the setup. If a complete order/schedule history is available, you can get a full update through the Update Statistics (tdsta2250m000) session. When you make changes, the new levels for historical data are also updated.

The available levels represent the most detailed information that can be printed or displayed.

Related topics

 

Effective Date
The date and time the parameters are valid. The parameters are valid up to the effective date of a more recent parameter setting.
Parent BP Levels to Update
The way in which parent business partner data is updated when statistical data is updated in the Update Statistics (tdsta2250m000) session.
Base Price for Gross Profit Calculation
Define how the gross profit percentage is calculated and displayed in statistics.
Period Table
The period table determines the various periods of a year, including the period number, start date, and end date that are used in statistics.

You can define period tables in the Period Tables (tcccp0160m000) session.

Related topics

Archiving Company
This company number relates to the file where statistical information is stored during archiving. This information is archived through the Archive/Delete Statistics (tdsta2250m100) session.

The check box Archive Company must be selected in the General Company Data (tccom0502m000) session. When company numbers are archived they can only be changed in the General Company Data (tccom0502m000) session.

Detailed Discount Specification
This check box determines whether detailed discounts must be recorded for purchase discounts, sales discounts, rebates, and commissions.

If this check box is selected, the budgets for the discounts that are entered in the Budgets (tdsta2603m000) session can be sorted by discount code in the Sort Budget Data by Discount Type (tdsta2105m000) session. These divided budgets are registered in the statistics.

If this check box is cleared, discounts, commissions, and rebates will not be sorted by discount code.

Discount Code for Order Discount
If the Detailed Discount Specification check box is selected, the discount amounts of orders that do not contain a discount code, are accumulated to the discount code that is specified in this field. The discount amount for order lines that contain a discount code, are accumulated to the discount code of the order line.

If this field is left empty, and the Print detailed discounts check box is selected when printing the statistical results in the Print Statistics (tdsta2400m000) session, the total discount amount that is printed can be lower than the discount amount that is printed if the Print detailed discounts check box is cleared. The reason for this is that the discount amount of order lines without a discount code is not taken into account if this field is empty.

Note

You can only define this field if the Detailed Discount Specification check box is selected.

Discount Code for Promotional Discount
The promotional discounts that result from applied promotions are accumulated to the discount code specified in this field.
Note
  • You can only define this field if the Detailed Discount Specification check box is selected.
  • Premiums are stored in statistics as normal sales order lines.

Related topics

Item for Customized Items
If a customized item is not derived from a standard item, which you can define in the Derived-from Item field of the Item - General (tcibd0101s000) session, you must define a standard item code to store the statistical data. This code can be used in the statistics to cumulate any customized item that is not derived from a standard item.

If the Derived-from Item field is filled for the customized item in the Item - General (tcibd0101s000) session, the customized item data is stored in the statistics under the standard item.

Item for Standard Items
If the Actual Data check box is selected when updating the statistics in the Update Statistics (tdsta2250m000) session, LN does not retrieve the item data from the sales order history or purchase order history sessions, but from the Item - General (tcibd0101s000) session. However, if item data is available in the history, but the item does not exist anymore in the Item - General (tcibd0101s000) session, LN retrieves the actual data for the item that is entered in the current field from the Item - General (tcibd0101s000) session.
Sales Intake Level
Select the level on which you want to update the sales order/schedule intake statistics. Sales intake refers to all sales orders/schedules that are entered in LN.
Note

You can select the level attributes (fields) that must be included in the statistics for this level and level type in the Statistics Level (tdsta0601m000) session.

Sales Intake Update Date
Select the date based on which the sales intake statistics are updated.
Sales Intake Update Date (CMS)
Select the date based on which the sales intake statistics are updated for commissions.
Sales Turnover Level
Select the level on which you want to update the sales turnover statistics. Sales turnover refers to all sales orders/schedules that are processed in the Sales Order Actual Delivery Line History (tdsls4556m000) session.
Note

You can select the level attributes (fields) that must be included in the statistics for this level and level type in the Statistics Level (tdsta0601m000) session.

Sales Turnover Update Date
Select the date based on which the sales turnover statistics are updated.

Allowed values

Delivery/Invoice Date

Default value

The Delivery Date is defaulted from the Actual Delivery Date and the Invoice Date is defaulted from the Invoice Date in the Sales Order Actual Delivery Line History (tdsls4556m000) session.

Sales Turnover Update Date (CMS)
Select the date based on which the sales turnover statistics are updated for commissions.
Sales Cancellation Level
Select the level on which you want to update the sales cancellation statistics. Sales cancellation refers to all sales order/schedule lines that are entered and then deleted or canceled in LN.
Note

You can select the level attributes (fields) that must be included in the statistics for this level and level type in the Statistics Level (tdsta0601m000) session.

Sales Cancellation Update Date
Select the date based on which the sales cancellation statistics are updated.
Sales Cancellation Update Date (CMS)
Select the date based on which the sales cancellation statistics are updated for commissions.
Sales Last Statistics Update Date
The date on which the sales statistics were updated last.
Note

This field is used for information purposes only and is filled when the Update Statistics (tdsta2250m000) session is used.

Sales Actual Level
Select the level on which you want to update the sales actual level statistics. Sales actual refers to the current (actual) sales business partner and sales item data.
Note

You can select the level attributes (fields) that must be included in the statistics for this level and level type in the Statistics Level (tdsta0601m000) session.

Purchase Intake Level
Select the level on which you want to update the purchase order intake statistics. Purchase intake refers to all purchase orders/schedules that are entered in LN.
Note

You can select the level attributes (fields) that must be included in the statistics for this level and level type in the Statistics Level (tdsta0601m000) session.

Purchase Intake Update Date
Select the date based on which the purchase intake statistics are updated.
Purchase Cancellation Level
Select the level on which you want to update the purchase cancellation statistics. Purchase cancellation refers to all purchase order/schedule lines that are entered and then deleted or canceled in LN.
Note

You can select the level attributes (fields) that must be included in the statistics for this level and level type in the Statistics Level (tdsta0601m000) session.

Purchase Cancellation Update Date
Select the date based on which the purchase cancellation statistics are updated.
Purchase Turnover Level
Select the level on which you want to update the purchase turnover statistics. Purchase turnover refers to all purchase orders/schedules that are processed in LN.
Note

You can select the level attributes (fields) that must be included in the statistics for this level and level type in the Statistics Level (tdsta0601m000) session.

Purchase Turnover Update Date
Select the date based on which the purchase turnover statistics are updated.
Purchase Turnover Update Date (Consignment)
Select the date based on which the purchase turnover statistics are updated for consignment.
Purchase Turnover Update Date (Stage Payment)
Select the date based on which the purchase turnover statistics are updated for supplier stage payments.
Purchase Last Statistics Update Date
The date on which the purchase statistics were updated last.
Note

This field is used for information purposes only and is filled when the Update Statistics (tdsta2250m000) session is used.

Purchase Actual Level
Select the level on which you want to update the purchase actual level statistics. Purchase actual refers to the current (actual) purchase business partner and purchase item data.
Note

You can select the level attributes (fields) that must be included in the statistics for this level and level type in the Statistics Level (tdsta0601m000) session.