Period-End Closing Sales Order - Settlement

Objective

After completing this lesson, you will be able to perform settlement of sales orders

Settlement

The image displays two blue boxes side by side. The left box lists Settlement Rule followed by bullet points for Receivers, Type, and Strategy. The right box lists Settlement Parameters followed by bullet points for Profile, Allocation Structure, PA Structure, and Strategy Sequence.

Settlement is an important transaction in the life cycle of the sales order. Important decisions to be made include identifying the receivers of the settlement, and the techniques to be used for such settlements.

Integration of Settlement

The image illustrates a profitability analysis process, showing the flow from sales order items with planned and actual figures for revenue, cost, and settlement details, to valuations that feed into revenues, cost of goods sold, accruals, and financial accounting components.

The results of results analysis are settled to FI, CO-PA, and PCA.

Transfer Of Values

You can transfer the following values to FI and PCA:

  • Inventory values
  • Provisions for unrealized costs
  • Provisions for imminent loss
  • Provisions for complaints and commissions
  • The cost of sale, if you are using non-valuated sales order stock and the cost-of-sales accounting method in FI

Settle Items

You can settle the following order items to CO-PA:

  • Cost of sale or calculated revenue
  • Reserves for imminent loss and complaints

During settlement to CO-PA, you can valuate the generated line item of the CO-PA with the cost component split of the sales order cost estimate or with the cost component split of a standard cost estimate.

Maintain Settlement Rule

The image displays an interface for configuring settlement rules and parameters for sales orders. It shows fields for the sales order number, settlement receiver methods, settlement rule details including category, receiver type, strategy, and time periods. Additional parameters like settlement profile, structure types, and strategy are also provided.

The system generates the settlement rule for the sales order item automatically, if the following prerequisites are fulfilled:

  • Profitability Analysis (COPA) is active

  • The requirement type in the sales order item defines Manufacturing by sales order

If the scenario Manufacturing by Project is used, the settlement rule in the sales order item must be defined manually.

Note

The actual data settled to Margin Analysis is updated in the central table ACDOCA (simplified COPA). The actual data settled to COPA Costing-based is updated in the tables CE3.... (totals) and CE1.... (line items).

Configuration of Settlement

The image shows a diagram outlining the settlement profile for actual costs/costs of sales in a system. It covers settlement structure with cost element groups, source structure with debit cost elements, PA transfer structure for cost element groups and value fields, default values for settlement/source/transfer structures, valid receivers like profit segments and sales orders, and indicators like percentage/amount settlement and equivalence numbers.

If CO-PA is inactive, you can specify in the settlement profile that the sales order must not be settled. If you settle the order, the system makes a posting to FI in accordance with the posting rules.

Customization of the Allocation Structure

The image displays a results analysis for cost elements related to cost of goods sold. It shows various settlement assignments with associated cost components like material, salary, and internal activities. On the right, it lists the settlement cost elements organized by cost center, profit segment, order, and create options with corresponding numeric values.

You can create the cost element groups that aggregate the primary and secondary cost elements used for debit postings to your orders to use the allocation structure. In Customizing, you link the cost element group to the allocation structure with a settlement assignment. For each settlement assignment, specify by receiver type whether the settlement uses the original posted cost elements, or a designated settlement cost element.

You use settlement cost elements for the following purposes:

  • To identify costs allocated from orders to the receiver and to describe their purpose, such as repairs or maintenance
  • To reduce data volume by consolidating several debit cost elements under one settlement cost element

Settlement to Profitability Segments

The image illustrates the cost elements for results analysis, showing how different accounting items like costs of sales, actual revenue, and reserves for imminent loss are assigned numerical codes (10, 20, 30) which are then mapped to corresponding value fields (Costs, Actual revenue, Res. loss) for reporting or analysis purposes.

If you want to settle costs and revenue of a sales order item to a profitability segment, define a PA transfer structure that assigns costs and revenue to the value fields in CO-PA Costing-based. The PA transfer structure consists of one or more items, called the PA settlement assignments. When defining the PA transfer structure, ensure that every debit cost element in the settlement structure can be assigned only to one settlement cost element.

If you do not carry out results analysis, the posted actual costs and actual revenue of the sales order item are settled to the profitability segment. The PA transfer structure must contain all the cost elements in which you can post costs and revenue on the sales order item.

After you have carried out results analysis, the results analysis data (valuated actual revenue, cost of sales, and reserves for imminent loss) is settled to the profitability segment. In this case, the PA transfer structure must contain all the results analysis cost elements under which data used in CO-PA is posted.

Valuation Using Material Cost Estimate

The image displays a series of steps for setting up valuation using material cost estimate. It outlines actions like defining keys for accessing material cost estimate, assigning costing keys to characteristics, maintaining rule values, assigning value fields, and defining access to actual costing and material ledger.

In CO-PA, you can valuate documents by reading the cost of goods manufactured in the material cost estimates from Product Cost Planning by defining costing keys. You can use the material cost estimate in the sales order item, if a quantity structure (BOM, routing) for the cost estimate has been used. Without a quantity structure, the cost estimate cannot be used for valuation in COPA, because such a cost estimate will be interpreted as a simulation cost estimate (although a material number for the cost estimate has been used). The selection of the cost estimate from the sales order item is useful when the product has been configured due to customer requirements.

You can use valuation for all posting to COPA, when the sender object is assigned to a material number (for example, the settlement of production orders or sales order items). It could not be used within the allocation of cost center costs or the settlement of an internal order to COPA.

The costing key that is used for a particular document depends on when the document is valuated in CO-PA, the record type, the product sold, the material type of that product, or any other characteristic in your operating concern.

When your sales quantities in CO-PA are valuated using periodic allocation prices/actual cost estimates from the Material Ledger, this typically occurs at the period end during revaluation.

You need to set up the following steps in Customizing for valuating the material cost estimates in your system:

  1. When you maintain costing keys, determine which cost estimates the system should read (such as standard cost estimate, or sales order cost estimate) to valuate the data in CO-PA.

  2. Assign these costing keys to any characteristics in your operating concern for valuation using the derivation rule technique.

  3. For each operating concern, use the value field assignment to determine how the cost components in the cost component split are assigned to the value fields in CO-PA. This is carried out for each point of valuation.

Define Keys for Accessing Material Cost Estimate

The image is a flowchart that outlines the process of setting up valuation using material cost estimates in a software system. The right side shows options for determining material cost estimates, controlling data for standard cost estimates, and additional data settings.

Product Cost Planning is used to determine the planned cost of goods manufactured for a product. In CO-PA, you can use these material cost estimates to valuate the data in CO-PA. These include cost estimates with and without quantity structures.

Product Cost Planning is used to calculate actual or planning data in CO-PA. You can do this by defining costing keys. A costing key is a set of access parameters that are used in valuation to determine which data in Product Cost Planning should be read.

The product-dependent or material-dependent material cost estimates in CO-PCP (Product Cost Planning) cannot take into account a variant configuration use in the sales order item. You can define costing keys to select the standard material cost estimate and other costing keys to select the material cost estimate from the sales order. This allows MTS (Make to Stock) and MTO (Make to Order) scenarios to be used in parallel. You can determine the costing keys using your own strategy for flexibly assigning costing keys.

Assignment of Costing Keys to Any Characteristics

The image outlines the process of setting up valuation using material cost estimate. It involves defining keys for accessing material cost estimate, assigning costing keys to characteristics, maintaining rule values, assigning value fields, and defining access to accrual costing/material ledger.

You can use this strategy to determine the costing keys, using the user-defined assignment tables. As a characteristic derivation in CO-PA, you can also work with the table lookups or your own customer enhancements when setting up the strategy.

You can use the following methods to define a strategy:

  • User-Defined Assignment Tables. Using these tables, you assign costing keys separately for each point of valuation, record type and plan version. In addition to these source fields, which are automatically contained in each assignment table, you can specify up to three characteristics in your operating concern as source fields for determining the costing key.

  • Table Lookup— Table lookup allows you to access individual data records in an SAP table. You can transfer the contents of an individual table field to a target field of the type USERTEMP. The USERTEMP fields that have been filled by a table lookup can then be used in a subsequent strategy step as source fields for an assignment rule. In this scenario, you search for the requirement type of the sales order item to determine the process.

  • Customer Enhancements. To set up a strategy to determine costing keys flexibly, you can use the enhancement COPA0002 and the component EXIT_SAPLKEAB_004.

Assignment of Value Fields

The image shows a process flow diagram for setting up valuation using material cost estimate. It outlines steps like defining keys for accessing material cost estimate, assigning costing keys to characteristics, maintaining rule values, and assigning value fields. A table displays cost components like raw materials, production activities with their fix/variable categorization and associated value fields.

You can assign the components of a cost component structure from Product Cost Controlling (CO-PC) to the value fields of your operating concern. Ensure that you maintain separate value field assignments for each point of valuation in CO-PA.

You can separate cost elements into fixed and variable components before transferring them to CO-PA. You can assign as many cost components as required (n:1 relationship) to the same value field for each cost estimate. The values from these cost components are added together in the value field.

If you valuate the multiple material cost estimates simultaneously, the system aggregates the values of different cost components within the same cost estimate and then enters one CO-PA value field.

However, the value fields that already contain data from a previous cost estimate are not overwritten by a cost estimate. You assign value fields in Customizing so that the values of cost estimates are entered in different sets of value fields.

You can assign up to six different value fields from your operating concern to each cost component in the cost component structure. These assignments are indicated by the value fields entered in the columns.

Settle the Sales Order

Summary

  • Settlement transfers results analysis data to Financial Accounting, Profitability Analysis, and Profit Center Accounting.
  • Inventory values, provisions for unrealized costs, and imminent loss are transferred to Financial Accounting and Profit Center Accounting.
  • Cost of sale or calculated revenue and reserves for imminent loss and complaints are settled to Profitability Analysis.
  • Customization of allocation structure involves linking cost element groups to allocation structure with settlement assignment.
  • Profitability Analysis transfer structure assigns costs and revenue to value fields in Profitability Analysis.