Member: {{user.record[“fullname”]}}
Membership Expires:{{user.record[“apex_expirydate”]|date(“Y-m-d”)}}
Member Number:{{user.record[“apex_membernum”]}}

{% set member_fee = 0 %} {% set renewal_num = “” %} {% set memberproduct = “” %} {% set userid = user.reference.Id %} {% fetchxml collection=”memberFees” cache=”PT30M” %} {% endfetchxml %} {% if memberFees.results.total_record_count > 0 %} {% for memberFee in memberFees.results.entities %} {{memberFee.rbms_memberfeetypename}} {% set member_fee = memberFee.rbms_memberfee %} {% set renewal_num = memberFee.apex_renewalid %} {% set memberproduct = memberFee.rbms_memberfeetype %} {% endfor %}
Renewal Number Description Payment Status Amount
{{memberFee.apex_renewalid}} {{memberFee|formatted_value(“rbms_memberfeetype”)}} {{memberFee|formatted_value(“rbms_paymentstatus”)}} ${{memberFee.rbms_memberfee|number_format(2)}}
{% else %} Missing Membership Fee Schedule – Please Contact Apex Staff {% endif %}