13.4 Intercompany Trading Chains, Sales Commissions, and Customer Rebates

13.4 Intercompany Trading Chains, Sales Commissions, and Customer Rebates

Quick Answer: Intercompany trading in Dynamics 365 Supply Chain Management automates supply chains across internal legal entities. When a selling entity receives an external order, the system can automatically generate an Intercompany Purchase Order (IC PO) and a corresponding Intercompany Sales Order (IC SO) in the sourcing entity. In Direct delivery scenarios, shipping from the sourcing entity automatically cascades packing slip postings across all linked orders. For commercial compensation and incentives, D365 SCM provides a three-group Sales commission engine (calculating on revenue or margin) and a comprehensive Customer rebate framework managing periodic cumulation, ledger accruals, and credit note settlement.

---

1. Intercompany Trading Architecture and Relationship Setup

Enterprise organizations frequently operate separate legal entities for distribution (the selling entity) and manufacturing or regional warehousing (the sourcing entity). Intercompany trading automates order creation, document posting, and pricing synchronization across these entities.

+-----------------------------------------------------------------------------------+
|                             SELLING LEGAL ENTITY (USMF)                           |
|  External Customer places Sales Order (SO-001) for Item A-100                     |
|  USMF holds Intercompany Vendor record (VEND-DEMF) linked to DEMF                 |
+-----------------------------------------+-----------------------------------------+
                                          | (Automatic Order Creation)
+-----------------------------------------v-----------------------------------------+
|                             SOURCING LEGAL ENTITY (DEMF)                          |
|  DEMF holds Intercompany Customer record (CUST-USMF) linked to USMF               |
|  System automatically creates Intercompany Sales Order (IC-SO-001)                |
+-----------------------------------------------------------------------------------+

Setting Up Intercompany Trading Partners

1. Vendor Setup: In the selling entity (USMF), navigate to Accounts payable > Vendors > All vendors, open the vendor representing the sourcing entity (VEND-DEMF), and click Action Pane > General > Intercompany.
2. Customer Pairing: In the Intercompany form, specify the sourcing legal entity (DEMF) and the customer account in DEMF that represents USMF (CUST-USMF).
3. Trading Policies Configuration:
   • Purchase Order Policies: Configures whether changes made in USMF automatically update DEMF.
   • Sales Order Policies: Defines order acceptance behavior, pricing rules, and document synchronization.
   • Value Mapping: Maps operational codes between entities, including Units of Measure, Modes of Delivery, Delivery Terms, and Payment Terms.

---

2. Intercompany Order Generation and Direct Delivery Execution

When an external customer places a sales order in the selling legal entity (USMF), two fulfillment paths exist:

Two-Leg Transit Delivery vs. Direct Delivery

Direct Delivery Execution Procedure

1. The sales agent in USMF creates a sales order for the external customer and marks the line as Direct delivery under Line details > Delivery.
2. Clicking Sales order > Action Pane > Generate > Direct delivery prompts D365 SCM to:
   • Create an Intercompany Purchase Order in USMF pegged to VEND-DEMF.
   • Automatically generate an Intercompany Sales Order in DEMF pegged to CUST-USMF.
   • Copy the external customer's physical delivery address into the DEMF intercompany sales order delivery address.

---

3. Cross-Entity Document Synchronization

A hallmark of D365 SCM intercompany automation is Document Synchronization:

1. DEMF (Sourcing) Posts Packing Slip on Intercompany Sales Order
     │
     ▼ (Automated ERP Synchronization Cascades Instantly)
2. USMF (Selling) Automatically Posts Product Receipt on Intercompany Purchase Order
     │
     ▼
3. USMF (Selling) Automatically Posts Packing Slip on External Customer Sales Order

Synchronized Capabilities

• Packing Slip Cascading: When the warehouse worker in DEMF posts the packing slip upon dispatching goods to the external customer, D365 SCM automatically posts the product receipt on the USMF purchase order AND posts the packing slip on the USMF external customer sales order simultaneously.
• Invoice Synchronization: When DEMF posts the intercompany customer invoice, D365 SCM can be configured to automatically generate and post the vendor invoice on the USMF purchase order, updating intercompany AP/AR trade balances.
• Order Modifications: If quantity or delivery dates are amended on the original sales order, changes propagate across the IC PO and IC SO, provided physical picking has not commenced.

---

4. Sales Commission Architecture: Groups, Rules, and Allocation

Dynamics 365 SCM provides a modular three-tier structure to calculate and disburse sales commissions to internal sales representatives or external agents (Sales and marketing > Setup > Commissions).

+---------------------------+   +------------------------+   +-------------------------+
| COMMISSION CUSTOMER GROUP |   | COMMISSION ITEM GROUP  |   | COMMISSION SALES GROUP  |
| E.g., 'Enterprise Key'    |   | E.g., 'High-Margin'    |   | Rep A: 60% | Rep B: 40% |
+-------------+-------------+   +-----------+------------+   +------------+------------+
              |                             |                             |
              +-----------------------------v-----------------------------+
                                            │
                                            ▼
                             COMMISSION CALCULATION RULES
                             Period: Invoice | Basis: Margin (35%)
                             Rate: 5% Commission | Deduct Line Discounts

The Three Foundation Groups

1. Commission Customer Groups: Segments customers based on commission eligibility (e.g., Key Accounts vs. Government Accounts with zero commission).
2. Commission Item Groups: Segments products based on incentive profitability (e.g., Software Licenses vs. Hardware Pass-Through).
3. Commission Sales Groups: Defines the sales team members. A commission sales group can include one or multiple sales representatives, each assigned a Percentage share (e.g., Lead Rep = 70%, Technical Sales Specialist = 30%). The sum of shares must equal 100%.

Commission Calculation Rules

Configured under Sales and marketing > Setup > Commissions > Commission calculation:

• Customer / Item Links: Rules can be established for specific combinations of Table (single customer/item), Group (customer/item commission group), or All.
• Calculation Basis:
  • Gross amount: Commission is calculated strictly on the total invoice sales revenue.
  • Margin / Contribution margin: Commission is calculated on the gross profit ($\text{Invoice Price} - \text{Inventory Cost}$), incentivizing reps to protect pricing margins.
• Discount Deductions: Parameters determine whether Line discounts or Cash discounts are deducted prior to commission calculation.
• Posting: Commission transactions are calculated when the sales invoice is posted, recording accrued commission liability in the General Ledger.

---

5. Customer Rebate Management: Agreements, Accruals, and Settlement

Customer rebates (Sales and marketing > Customer rebates > Rebate agreements) provide retroactive financial incentives to customers based on achieving cumulative purchase volume or value milestones over a designated period.

Rebate Agreements and Cumulation Options

A rebate agreement defines the qualifying criteria and payout structure:

• Rebate Program Types: Standard Rebate, Freight Rebate, or Lump Sum.
• Cumulation Periods: Defines how sales order lines are aggregated to determine volume break eligibility:
  • By invoice: Evaluates each sales invoice independently.
  • By week / month / quarter / year: Aggregates all qualifying invoices across the calendar period, allowing customers to hit higher tier discounts retroactively.
• Rebate Line Break Types: Quantity-based (e.g., 1–500 units = 2%, 501–1,000 units = 4%) or Amount-based ($100k spend = 5%).

Rebate Ledger Accruals and Claims Lifecycle

[Post Sales Order Invoice] ---> Accrue Estimated Rebate (Debit Rebate Expense / Credit Rebate Accrual Liability)
              │
              ▼
[Period End: Rebate Cumulation] ---> Aggregate Cumulative Sales Across Period Thresholds
              │
              ▼
[Rebate Workbench: Approve Claim] ---> Validate and Approve Calculated Rebate Amount
              │
              ▼
[Process Rebate Claim] -------------> Option A: Generate Customer Credit Note in AR
                                     Option B: Pass to Accounts Payable for Vendor Cash Payout

1. Accrual at Invoicing: When an eligible sales invoice is posted, D365 SCM automatically calculates the expected rebate and posts a General Ledger accrual:
   • Debit: Sales Rebates Expense (or Revenue Contra-Account).
   • Credit: Customer Rebate Accrual (Balance Sheet Liability).
2. Cumulation and Approval: At period close, the rebate manager accesses the Rebate workbench (Sales and marketing > Customer rebates > Rebates), reviews cumulative sales totals, and clicks Cumulate rebates. After auditing the calculations, the manager clicks Approve.
3. Settlement Methods:
   • Accounts Receivable Credit Note: The most common method. Processing the claim generates an AR credit note applied against the customer's open balance.
   • Accounts Payable Payment: If the customer is also configured as a vendor, D365 SCM can transfer the claim to Accounts Payable to disburse a physical check or electronic bank payment.

---

6. Implementation Scenarios and Common Exam Traps

[!IMPORTANT] Exam Tip — Direct Delivery Cascading Posting: On the MB-330 exam, questions on intercompany direct delivery frequently test what happens when the sourcing entity posts a packing slip. Remember the cascade: Posting the packing slip on the Intercompany Sales Order in the sourcing entity automatically posts the product receipt on the Intercompany Purchase Order in the selling entity AND posts the packing slip on the external customer Sales Order in one synchronized operation.

[!WARNING] Exam Trap — Commission Group Assignment: When configuring commissions, consultants often forget that assigning a sales representative to a customer record does not calculate commissions by itself. A Commission sales group must be linked, and an explicit Commission calculation rule linking the customer group and item group must be configured. Without the calculation rule, zero commission is computed.

[!TIP] Exam Tip — Rebate Cumulation Timing: If an exam scenario states that a customer qualified for a higher rebate tier across three months of purchases, but individual invoices only received the lowest tier, the solution is to verify that the rebate agreement cumulation period is set to Month or Quarter, and run the Cumulate rebates process in the Rebate workbench.