Current and Previous Year Customer and Channel Positions

This Model Table function is used to provide periodic customer and channel positions for both the current and the previous year.

It defines the following fields:

• Posting Date: You use this field to provide plan and forecast totals on a yearly, quarterly, monthly, or even daily basis to run the profitability and cost management process.

• Position ID: You use this field to specify a unique ID to identify the position.

• Customer ID: You use this field to identify the customer.

• Channel: You use this field to specify the distribution channel, such as wholesale, retail, so on.

• Product for Profitability Analysis: You use this field to define the product or service that uses the activity value as a variable portion to allocate the activities.

• Unit: You use this field to define the quantity, such as pieces.

• Quantity: You use this field to define the quantity of products and services that the customer received via the given channel at the posting date.

• Position Amount [TC]: You use this field to define the price the customer paid for the quantity of products and services.

• Currency Key of Original Transaction Currency: The transaction currency is the currency used in the sample content to calculate profitability. Irrespective of the currency used in an implementation project, it is common practice to translate every amount into one and the same currency so that only one currency (controlling area currency) is used in the complete profitability model.

• Fiscal Year: You use this field to specify the year for accounting purposes.