| # 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 Statistics 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. Allowed values Parent BP Levels to Update Base Price for Gross Profit Calculation Define how the gross profit percentage is calculated and displayed in statistics. Allowed values Gross Profit Calculation 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 Setting up periods 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. Related topics To use an archive company 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 Promotion retrieval 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. Allowed values Order/Transaction Date Sales Intake Update Date (CMS) Select the date based on which the sales intake statistics are updated for commissions. Allowed values Calculation/Transaction Date 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. Allowed values Invoice/Transaction Date 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. Allowed values Order/Transaction Date Sales Cancellation Update Date (CMS) Select the date based on which the sales cancellation statistics are updated for commissions. Allowed values Calculation/Transaction Date 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. Allowed values Order/Transaction Date 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. Allowed values Order/Transaction Date 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. Allowed values Receipt/Transaction Date Purchase Turnover Update Date (Consignment) Select the date based on which the purchase turnover statistics are updated for consignment. Allowed values Usage Date/Transaction Date Purchase Turnover Update Date (Stage Payment) Select the date based on which the purchase turnover statistics are updated for supplier stage payments. Allowed values Released Date/Transaction Date 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. |