---
schema_version: "1"
id: 57d845352f637e5db5e6afaf74338b94e31d702234de47e0a41bca170ad40230
title: Expire Non-Qualifying Points Using Traceability Loyalty Ledgers
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/loyalty_expire_nqp_traceability_ledgers.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.loyalty_expire_nqp_traceability_ledgers.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 775c2bc681183256792922c9f6190e0d8515b5f5ce107f9d8998d2e6dc0e44f5
description: The Expire Non-Qualifying Points Using Traceability Loyalty Ledgers job expires non-qualifying points that are traced by using traceability loyalty ledgers.
products:
  - Loyalty Management
release: "264"
---
# Expire Non-Qualifying Points Using Traceability Loyalty Ledgers

The Expire Non-Qualifying Points Using Traceability Loyalty Ledgers job expires non-qualifying points that are traced by using traceability loyalty ledgers.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Lightning Experience in&nbsp;<strong>Enterprise</strong>,&nbsp;<strong>Performance</strong>, <strong>Developer</strong>, and&nbsp;<strong>Unlimited</strong>&nbsp;Editions that have Loyalty Management enabled</td></tr></tbody></table>

The Expire Non-Qualifying Points Using Traceability Loyalty Ledgers Data Processing Engine template includes these key nodes.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
      <colgroup>
        <col style="width:33.33333333333333%">
        <col style="width:33.33333333333333%">
        <col style="width:33.33333333333333%">
      </colgroup>
      <thead class="slds-text-title_caps ">
        <tr class="">
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d22085e69">Node Value</th>
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d22085e72">Description</th>
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d22085e75">Node Type</th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="Node Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e69 ">Loyalty Member Currency</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e72 ">Uses Loyalty Member Currency records as data source for the definition. </td>

          <td data-label="Node Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e75 ">Data Source</td>

        </tr>
        <tr class="">
          <td data-label="Node Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e69 ">Traceability Loyalty Ledgers</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e72 ">Uses Traceability Loyalty Ledger records as data source for the definition. </td>

          <td data-label="Node Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e75 ">Data Source</td>

        </tr>
        <tr class="">
          <td data-label="Node Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e69 "> Loyalty Ledgers</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e72 ">Uses Loyalty Ledger records as data source for the definition.</td>

          <td data-label="Node Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e75 ">Data Source</td>

        </tr>
        <tr class="">
          <td data-label="Node Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e69 ">Find Pending Traceable Ledgers</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e72 ">Formula</td>

          <td data-label="Node Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e75 ">Finds the pending traceable ledgers.</td>

        </tr>
        <tr class="">
          <td data-label="Node Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e69 ">Aggregate Pending Trace Ledgers by Member and Currency</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e72 ">Aggregates the pending traceable ledgers that belong to the specified member and
            currency.</td>

          <td data-label="Node Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e75 ">Group and Aggregate</td>

        </tr>
        <tr class="">
          <td data-label="Node Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e69 ">Join Loyalty Ledgers and Pending Traceable Ledgers by Member and Currency</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e72 ">Joins the loyalty ledgers and the pending traceable ledgers that belong to the
            specified member and currency.</td>

          <td data-label="Node Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e75 ">Join</td>

        </tr>
        <tr class="">
          <td data-label="Node Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e69 ">Add Member Currency Details to Ledgers</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e72 ">Adds the loyalty member currency details to the ledgers.</td>

          <td data-label="Node Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e75 ">Join</td>

        </tr>
        <tr class="">
          <td data-label="Node Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e69 ">Filter with Credit Ledgers without Pending Traceable Ledgers by Member and
            Currency</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e72 ">Filters the ledgers with event type as Credit and without pending traceable
            ledgers that belong to the specified member and currency.</td>

          <td data-label="Node Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e75 ">Filter</td>

        </tr>
        <tr class="">
          <td data-label="Node Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e69 ">Filter Ledgers with Credit Event Type</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e72 ">Filters the ledgers with event type as Credit.</td>

          <td data-label="Node Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e75 ">Filter</td>

        </tr>
        <tr class="">
          <td data-label="Node Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e69 ">Update Process Run Date</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e72 ">Validates if the updated process run date is a future date and corrects it by
            setting any future date to the current date.</td>

          <td data-label="Node Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e75 ">Formula</td>

        </tr>
        <tr class="">
          <td data-label="Node Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e69 ">Find Eligible Expired Credit Ledgers</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e72 ">Finds the eligible Credit ledgers that expired between Last Traceability Run Date
            and Last Expiration Process Run Date.</td>

          <td data-label="Node Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e75 ">Formula</td>

        </tr>
        <tr class="">
          <td data-label="Node Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e69 ">Filter Valid Credit Ledgers Within Eligible Dates</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e72 ">Filters the valid Credit ledgers within eligible dates.</td>

          <td data-label="Node Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e75 ">Filter</td>

        </tr>
        <tr class="">
          <td data-label="Node Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e69 ">Join Expired Credit Ledgers with Total Points Traced</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e72 ">Joins the expired credit ledgers with the total points of the credit ledger that
            are used in Traceability Loyalty Ledger.</td>

          <td data-label="Node Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e75 ">Join</td>

        </tr>
        <tr class="">
          <td data-label="Node Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e69 ">Calculate Remaining Traceable Points to Expire in Credit Ledger</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e72 ">Calculates the remaining points to expire in the credit ledger that can be
            traced.</td>

          <td data-label="Node Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e75 ">Formula</td>

        </tr>
        <tr class="">
          <td data-label="Node Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e69 ">Calculate Total Non-Qualifying Traceable Points to Expire</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e72 ">Gets the sum of non-qualifying traceable points to expire.</td>

          <td data-label="Node Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e75 ">Group and Aggregate</td>

        </tr>
        <tr class="">
          <td data-label="Node Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e69 ">Calculate Total Points Expired and Points to Expire</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e72 ">Calculates the value of total expired points and the points expirable on the
            process run date.</td>

          <td data-label="Node Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e75 ">Formula</td>

        </tr>
        <tr class="">
          <td data-label="Node Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e69 ">Filter Non-zero Points to Expire</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e72 ">Filters the non-zero points to expire.</td>

          <td data-label="Node Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e75 ">Filter</td>

        </tr>
        <tr class="">
          <td data-label="Node Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e69 ">Create Loyalty Ledger</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e72 ">Creates loyalty ledgers for expiring traceable points.</td>

          <td data-label="Node Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e75 ">Writeback Object</td>

        </tr>
        <tr class="">
          <td data-label="Node Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e69 ">Create Transaction Journal</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e72 ">Creates transaction journals for expiring traceable points.</td>

          <td data-label="Node Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e75 ">Writeback Object</td>

        </tr>
        <tr class="">
          <td data-label="Node Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e69 ">Update Loyalty Member Currency</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e72 ">Updates total expired points in the loyalty member currency records.</td>

          <td data-label="Node Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e75 ">Writeback Object</td>

        </tr>
        <tr class="">
          <td data-label="Node Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e69 ">Sum of Credit Ledger Points Used in Traceability Loyalty Ledger</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e72 ">
            <p style="margin-bottom:0;" dir="ltr">The total points of the credit ledger that are used in Traceability
              Loyalty Ledger.</p>
          </td>

          <td data-label="Node Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e75 ">Group and Aggregate</td>

        </tr>
        <tr class="">
          <td data-label="Node Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e69 ">Filter Traceable Ledgers by Program</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e72 ">Filters the traceable ledgers belonging to the specified program name.</td>

          <td data-label="Node Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e75 ">Filter</td>

        </tr>
      </tbody>
    </table>

**Input Variables**

You can define the input parameters for the calculation job so that the input values are passed at the time of job execution.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
      <colgroup>
        <col style="width:100%">
      </colgroup>
      <thead class="slds-text-title_caps ">
        <tr class="">
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d22085e375">Input Variables</th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="Input Variables" class="slds-cell-wrap" style="vertical-align:top;" headers="d22085e375 ">
            <p>Loyalty Program Name</p>
            <p style="margin-bottom:0;">Process Run Date</p>
          </td>

        </tr>
      </tbody>
    </table>

The Process Run Date is used to update the Last Expiration Process Run Date and to determine the unused points that are to be expired.

**Running the Job**

After the job runs, it creates loyalty ledgers and transaction journals for expiring traceable points. The job updates the total expired points in the loyalty member currency records.