Invoiced Order Details

The Invoiced Order Details dimension is a degenerate dimension of the Sales Analysis model. This dimension contains additional information on invoiced orders and attributes that you can use to analyze Competitor Erosion.

These attributes serve as flags to exclude customer returns and consolidation division transactions from erosion categorization:

  • Return

    Transactions with invoiced quantity less than zero

  • Consolidation Division

    Transactions from divisions tagged as consolidation divisions in 'Settings - Internal Invoicing' (MFS010)

  • Include in Competitor Erosion

    'Yes' if transaction is neither a customer return nor a consolidation division transaction

Transactions that are included in Competitor Erosion are rated based on competitor erosion risk. You can group the transactions into these categories:

  • No Erosion

    Either weight or volume exceeds threshold, or sales origin is not from either point of sales (ORIG = 8) or customer order (ORIG = 0), or item make/buy code is '1-Manufactured'

  • Unknown

    Either weight or volume is zero or unknown, sales origin is either point of sales (ORIG = 8) or customer order (ORIG = 0), and item make/buy code is '2-Purchased'

  • Some Erosion

    Both weight and volume are within thresholds, sales origin is from point of sales (ORIG = 8), and item make/buy code is '2-Purchased'

  • High Erosion

    Both weight and volume are within thresholds, sales origin is from customer order (ORIG = 0), and item make/buy code is '2-Purchased'

The attributes listed in the table are part of the custom subject area. M3 Analytics contains more attributes in the default subject area. For a complete list, see the mapping document in KB 2015457.

Hierarchy Custom subject area Attributes
Invoiced Order Details M3A Sales

Company Unit – Weight, Company Unit – Volume

Competitor Erosion Category

Competitor Erosion Sorting Order

Consolidation Division

Delivered Not Invoiced

Delivery Method, Delivery Method ID, Delivery Method Name, Delivery Method Description

Delivery Terms, Delivery Terms ID, Delivery Terms Name, Delivery Terms Description

Include in Competitor Erosion

Invoice Date, Invoice Number

Return

Statistics 1, Statistics 1 ID, Statistics 1 Name, Statistics 1 Description

Threshold Unit – Weight, Threshold Unit – Volume