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 can be used 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 and can be grouped 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 – Volume, Company Unit – Weight

Competitor Erosion Category

Competitor Erosion Sorting Order

Consolidation Division

Delivered Not Invoiced

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

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

Include in Competitor Erosion

Invoice Date, Invoice Number

Line Type – SA, Line Type Code – SA

Return

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

Threshold Unit – Volume, Threshold Unit – Weight