---
schema_version: "1"
id: d7955c69d8c49749b806436409e7c2bb4cbf077af159a468dbd0834e5a42f210
title: Validate Member Points Balances
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/loyalty_validate_member_points_balances.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.loyalty_validate_member_points_balances.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: bbb33bd378c5a685d30fd49cea01b7cf867853515d09663798e51aa4fcc884b8
description: Use the Validate Member Currency Balances for Loyalty Programs Data Processing Engine template. It checks whether the sum of the actual member and escrow balances matches the ledger and aggregated ledger totals. If the sum of the balances doesn’t match the totals, it creates error records in the Data Validation Errors analytics dataset.
products:
  - Loyalty Management
release: "264"
---
# Validate Member Points Balances

Use the Validate Member Currency Balances for Loyalty Programs Data Processing Engine template. It checks whether the sum of the actual member and escrow balances matches the ledger and aggregated ledger totals. If the sum of the balances doesn’t match the totals, it creates error records in the Data Validation Errors analytics dataset.

### 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</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>,&nbsp;<strong>Performance</strong>, <strong>Unlimited</strong>, and&nbsp;<strong>Developer</strong>&nbsp;Editions with Loyalty Management</td></tr></tbody></table>

For each loyalty program containing imported data, perform these steps.

1. Create a Data Processing Engine definition by using the Validate Member Currency Balances for Loyalty Programs template.
2. Enter a value for the Loyalty Program Name input variable.
3. If you’re importing only aggregate ledgers and not individual ledgers, set the value of the Does Validate Loyalty Ledgers input variable to 0 to skip the ledger total validation.
4. Run the Data Processing Engine definition.
5. Review the datasets by using [the Data Assets tab in Data Manager](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_manager.htm&type=5&language=en_US).
6. If there are any errors listed in the dataset, adjust your records such that the balances and the totals match. Then, rerun the definition to confirm data validity.

For each member currency with errors, the dataset contains an error record with these fields.

- MemberCurrencyPointsBalance: The points in the Loyalty Member Currency record, excluding escrow points.
- EffectiveMemberCurrencyBalance: The sum of points in the member currency record, including escrow points.
- TotalLedgerPointsBalance: The sum credited points minus the debited and expired points from all the ledgers.
- TotalAggregatedLedgerPointsBalance: The sum credited points minus the debited and expired points from all the aggregate ledgers.