Salesforce Docs Portal

Upsert Partner Inventory Reconciliation Based on Partner Unsold Inventory Data

The Upsert Partner Inventory Reconciliations Based on Unsold Inventory data processing engine (DPE) definition matches partner unsold inventories with partner inventory reconciliations. It creates and updates partner inventory reconciliations, partner inventory item reconciliations, and partner inventory item reconciliation traceabilities based on unsold inventory details in partner unsold inventory and partner unsold inventory ledgers. For valid partner staged data records used in the process, the status is updated to Processed.

Required Editions

Available in: Enterprise, Professional, and Unlimited Editions with the Channel Revenue Management add on
User Permissions Needed
To upsert partner inventory reconciliations Channel Partner Inventory Tracking Admin permission set

Here are the high-level steps in the DPE template.

  1. Get details of partner unsold inventory, partner unsold inventory ledger, partner inventory reconciliation, partner inventory item reconciliation, and partner inventory item reconciliation traceability records.
  2. Filter partner unsold inventories and partner inventory item reconciliations that aren’t closed.
  3. Calculate the quantity of partner unsold inventories with transaction dates that are on or before the related partner inventory reconciliations’ reported-as-of dates. Aggregate the credit and debit ledgers of the unsold inventories to get the quantity as on date.
  4. Define matching criteria to match partner inventory item reconciliations and partner unsold inventories.
  5. For partner inventory item reconciliations that don't match any partner unsold inventories based on their account, product, and unit price details, update the status of the item reconciliations to InProgress.
  6. For partner unsold inventories without associated partner inventory item reconciliations, create partner inventory item reconciliation traceabilities with the quantities as on date as the unsold quantities. Create partner inventory item reconciliations with the Mismatch status by grouping the traceabilities by account, unit price, and product.
  7. For partner unsold inventories with matching partner inventory item reconciliations, perform these operations.
    • For matching inventory item reconciliations without traceabilities, create traceabilities with the quantities as on date as the unsold quantities.
    • For matching inventory item reconciliations with traceabilities, update the unsold quantities of the traceabilities to the quantities as on date.
    • Check if the reported quantity and the total unsold quantity of the matching item reconciliations are the same. If they are, update the status of the inventory item reconciliations to Closed. If they are not, update the status to In Progress.