Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents
47 Member Management
47.1 Product Stack
47.2 Member Module – Highlights
47.3 Setup Entities
47.3.1 MEMBER COMMUNITY
47.3.2 MEMBERSHIP SETUP
47.3.3 Membership Sales Setup
47.3.4 MEMBERSHIP ADMISSION SETUP
47.3.5 MEMBERSHIP ALTERATION SETUP
47.3.6 MEMBER REMINDER SETUP
47.3.7 MEMBER LIMITATION SETUP
47.4 Master Data and Relation Entities
47.4.1 Membership
47.4.2 Membership Role
47.4.3 Member
47.4.4 Member Card
47.4.5 Membership Notification
47.5 Entry Entities
47.5.1 Membership Entry
47.5.2 Member Info Capture
47.5.3 Membership Points Entry
47.5.4 Member Notification entry
47.6 High Level Entity Relationship Model
47.7 Details
47.7.1 Member Community
47.7.2 Membership Setup
47.7.3 Membership Sales Setup
47.7.4 Membership Admission Setup
47.7.5 MM Membership Alteration Setup
47.7.6 MEMBER NOTIFICATION SETUP
47.7.7 MEMBERSHIP LIMITATION SETUP
47.7.8 Membership
47.7.9 MEMBERSHIP ROLE
47.7.10 MEMBER
47.7.11 MEMBER CARD
47.7.12 Membership Entry
47.7.13 MEMBERSHIP NOTIFICATION
47.7.14 MEMBER NOTIFICATION ENTRY
47.8 Managing Memberships
47.8.1 POS commands
47.8.2 Web Services
47.8.3 RENEW
47.8.4 Price calculations
47.8.5 Stacking
47.8.6 Grace Period
47.8.7 Extend
47.8.8 Price calculations
47.8.9 Stacking
47.8.10 Grace Period
47.8.11 Upgrade
47.8.12 Price calculations
47.8.13 Stacking
47.8.14 Grace Period
47.8.15 CANCEL
47.8.16 Price calculations
47.8.17 Stacking
47.8.18 Grace Period
47.8.19 REGRET
47.8.20 Price calculations
47.8.21 Stacking
47.8.22 Grace Period
47.9 Member Notification
Setup example:
47.9.1 Activating
47.9.2 Member Opt-out
47.9.3 Email templates
47.9.4 Automation
47.10 Setup
47.10.1 ROLE CENTER
Setting up the role center Profile ID.
47.10.2 Assigning a Profile ID to User ID
47.11 POS Setup
47.11.1 Touch Screen Setup
47.12 Internal Member Registration Process
Overview
47.12.1 Before Audit is posted
47.12.2 During Audit Role posting
47.13 Web Services
47.13.1 Setup in Navision:
47.13.2 Setting up memberships
47.13.3 Querying Memberships and members
47.13.4 Mananging the membership product and duration
47.13.5 Tickets and registering member Integration
47.14 Loyalty Reward Program
47.14.1 Member Community
47.14.2 Loyalty setup
Example of Date Formula in Navision
47.14.3 Item Points Setup
47.15 Members' Link to Loyalty Reward Programs
47.15.1 Membership Setup
47.15.2 Membership Sales Setup
47.15.3 Create Membership
47.16 Application of the Loyalty Reward Programs
47.16.1 Sale on POS to a Member
47.17 Loyalty Reports:
47.17.1 Loyalty Points Summary
47.17.2 Report: Loyalty Points Value
47.17.3 Report: Loyalty Points Detail
47.18 Earning and Redeeming points
47.19 Auto Renew Process


Anchor
_Toc494715719
_Toc494715719
Anchor
_Toc505335438
_Toc505335438
Member Management


Anchor
_Toc505335439
_Toc505335439
Product Stack










Anchor
_Toc494715720
_Toc494715720
Anchor
_Toc505335440
_Toc505335440
Member Module – Highlights




The Membership Module adopts the following approach:

...

Web Service integration for Magento integration

...


Anchor
_Toc494715721
_Toc494715721
Anchor
_Toc505335441
_Toc505335441
Setup Entities


Anchor
_Toc505335442
_Toc505335442
MEMBER COMMUNITY


The membership community is the top level in the setup of member and membership. A community is the club or association that is marketing the memberships. A Navision company can host any number of communities. The setup defines common rules that apply to membership within the community


Anchor
_Toc505335443
_Toc505335443
MEMBERSHIP SETUP


The membership setup defines the rules that govern a specific membership in this community. The membership defines the benefits (pricing and discounts) the member will be able to capitalize on.


Anchor
_Toc505335444
_Toc505335444
Membership Sales Setup


Memberships can be sold using different items in the POS or on the WEB. One aspect of membership is to sell a potential benefit to the customer that is valid for a specific amount of time.


Anchor
_Toc505335445
_Toc505335445
MEMBERSHIP ADMISSION SETUP


In combination with the Ticket Module, members can gain access to extra tickets and have guests accompanying them for the visit. With his setup, memberships are linked to different types of tickets that can be selected when using the self-scan solution.


Anchor
_Toc505335446
_Toc505335446
MEMBERSHIP ALTERATION SETUP


This table is used to define how an already created membership may be altered, both in terms of validity in time and the type of membership that is currently active.


Anchor
_Toc505335447
_Toc505335447
MEMBER REMINDER SETUP


Member can have reminders sent to them because of different events. Setup of notifications are done in this table. Reminders can be chained, if this notification is not canceled, it will create a new future notification to be executed.


Anchor
_Toc505335448
_Toc505335448
MEMBER LIMITATION SETUP


This table is used to limit access for memberships in order to prevent misuse of cards.

...


Anchor
_Toc494715722
_Toc494715722
Anchor
_Toc505335449
_Toc505335449
Master Data and Relation Entities


Anchor
_Toc505335450
_Toc505335450
Membership


Membership connects one or more member roles.


Anchor
_Toc505335451
_Toc505335451
Membership Role


Member role is the link between a member and its membership(s). A member can be part of multiple memberships and act in different roles.
Currently 2 roles are defined:

...

  • Administrator – has the right to manage and benefit from membership
  • User – has the right to benefit from membership


Anchor
_Toc505335452
_Toc505335452
Member


The member entity store the information about a member. A member is a person.


Anchor
_Toc505335453
_Toc505335453
Member Card


Members can identify their right to a membership using the member card. A member may have multiple cards for the same membership.


Anchor
_Toc505335454
_Toc505335454
Membership Notification


The system generates pre-emptive events to be processed in the future. The notification due date it is derived from the setup.


Anchor
_Toc494715723
_Toc494715723
Anchor
_Toc505335455
_Toc505335455
Entry Entities


Anchor
_Toc505335456
_Toc505335456
Membership Entry


This table stores the time frame(s) for which the membership is valid. The initial price, discounts and initial duration is also captured.


Anchor
_Toc505335457
_Toc505335457
Member Info Capture


This is a temporary entity used to capture the information used for the current transaction.


Anchor
_Toc505335458
_Toc505335458
Membership Points Entry


Reserved for future use.


Anchor
_Toc505335459
_Toc505335459
Member Notification entry


This is the data available to the notification being generated. This entry will be created when the notification is processed.


Anchor
_Toc494715724
_Toc494715724
Anchor
_Toc505335460
_Toc505335460
High Level Entity Relationship Model



Anchor
_Toc494715725
_Toc494715725
Anchor
_Toc505335461
_Toc505335461
Details


Anchor
_Toc505335462
_Toc505335462
Member Community


Menu: Departments > Retail Add Ons > Members > Member Community

...

FIELD NAME

DESCRIPTION

Code

A code used to link this community with other tables

Description

A use description of the community

External No. Search Order

An option to define what search term should be used when there is ambiguity.

  • CARDNO
  • MEMBERNO
  • MEMBERSHIPNO
  • ALL

External Membership No. Series

Number series to generate the external membership identity

External Member No. Series

Number series to generate the external member identity

Member Unique Identity

The member value that must be used to uniquely identify a member;

  • NONE
  • EMAIL
  • PHONENO*
  • SSN (Social Security Number)

Create Member UI Violation

When a member is created and the unique identity is violated the system can react with in the following ways;

  • ERROR – An hard error is thrown
  • CONFIRM – A confirm question is issued to challenge the entered value. The user will has the chance to ERROR or REUSE.
  • REUSE – will block the old member and create a new member

Member Logon Credentials

Defined what term to use for logon credentials when a 3rd party member management soft is used;

  • NA
  • MEMBER_UNIQUE_ID
  • MEMBER_NUMBER
  • CUSTOM

Membership to Cust. Rel.

This is field is used when memberships are linked with customers. This is required in the following scenarios;

  • When members have access to specific discount and price structures.
  • When members have access to their account on the web and can/must link their purchases with the membership account number.

Create Renewal Notification

Create a notification when membership requires renewal




Anchor
_Toc505335463
_Toc505335463
Membership Setup


Note, this is a setup table to define how a membership should behave when it is created.
Menu: Departments > Retail Add Ons > Members > Membership Setup

...

FIELD NAME

DESCRIPTION

Code

A code used to link this community with other tables

Description

A use description of the membership

Membership Type

Controls how members and memberships are related.

  • COMMUNITY – This is simple type of membership where all members are put into one big group. This is practical when the "membership" is informal and like in email register f.ex. Members may still have a member card and there may be benefits for the individual members.
  • GROUP – Similar to the COMMUNITY mode. In this mode the membership time-frame plays a predominant role. Number of members in a group can me limited. The members can have individual roles.
  • INDIVIDUAL – One membership – one member.

Loyalty Card

For future use.

Customer Template Code

This code identifies a template for how the customer associated with the membership will be created. This field is required when the "Membership to Cust. Rel." field on community is checked.

Member Information

How the member entity should be treated.

  • NAMED – The member must exist
  • ANONYMOUS - Membership can be anonymous – there is no member, just the card (Membership Type COMMUNITY)

Blocked

The setup is blocked from usage

Blocked At

Time of block

Perpetual

The membership validity can be perpetual (everlasting)

Member Role Assignment

How members are assigned their role in the membership

  • MEMBERS_ONLY
  • FIRST_IS_ADMIN
  • ALL_ADMINS

Membership Member Cardinality

Maximum members in a GROUP membership

Community Code

A link to the community this membership belongs to

Create Renewal Notification

Create a notification when membership requires renewal

Create Welcome Notification

Create a notification when member is created

Receipt Print Object Type

The type of object used for generating printing for the receipt

Receipt Print Object ID

The object ID used for generating the printout. The system supplied codeunit for printing is

Account Print Object Type

The type of object used for generating printing for the account information

Account Print Object ID


Allow Membership Delete

This options allow memberships to be deleted.

Confirm Member On Card Scan

When a POS function requires the member card to be scanned, the member card will pop up for visual confirm.


The following fields defined how the member card number should be handled. The member card number is public and should not be a sequential number only.


Card Number Scheme

Who responsible of creating the member card number

  • NA
  • GENERATED
  • EXTERNAL

Card Number Prefix

Specific prefixes can be defined (or generated by the number series)

Card Number Length

The length is used to pad a number that is too short

Card Number Validation

If there should be a check digit appended to end of the generated number

Card Number No. Series

The number series used generated the base of member card number

Card Number Valid Until

For how long a member card should be valid

Card Number Pattern

A patter can be entered to control how the card number should be generated. A pattern consists of keywords that will create a number that is a bit more difficult to guess. Available keywords are listed below and must be included between [ and ].

  • MA - Member Account Number
  • MS – Membership Number
  • S – The number generated by the number series
  • N – A random number
  • A – A random character
  • X – A random alphanumeric character.


    N, A, X can be suffixed by a * and number to repeat it, that number of times.
    The default pattern is [X*4][MA][X*4][MS][S]

    Which would generated a member card number similar to:
    RQ41MM-00147VBH7MS-0013100087

Card Print Object Type

The type of object used for generating printing for the member card

Card Print Object ID





Anchor
_Toc505335464
_Toc505335464
Membership Sales Setup


This table is used to defined the first-time sales of memberships. The menu is in the shortcut from Membership Setup, under Home Ribbon.

...

FIELD NAME

DESCRIPTION

Type

An option to define what type of "item" we are selling.

  • ITEM
  • ACCOUNT – This option is reserved for future use. Currently a membership sales must be an item

No.

The Item or Account used for membership sales

Membership Code

Links the Membership Setup table. The item sold will create a membership of this type.

Blocked


Blocked At


Valid From Base

An option to define how the membership time frame start date should be calculated.

  • SALESDATE
  • DATEFORMULA

Sales Cut-Off Date Calculation

Reserved for future use.

Valid From Date Calculation

Date formula for activation date

Valid Until Calculation

An option to define the duration of the membership. Options are;

  • DATEFORMULA
  • END_OF_TIME

Duration Formula

Date formula for duration




Anchor
_Toc505335465
_Toc505335465
Membership Admission Setup


This table is used in combination with the ticket module. When a member uses the self-scan solution a combination of extra tickets can be associated with the membership code. The menu is in the shortcut from Membership Setup, under Home Ribbon.

A total cardinality can be registered on the record with Ticket No. Type "NA". The total cardinality limits the maximum combination of tickets for this member. Example – the membership itself targets senior citizens and following guest admissions have been setup.

...

  • The self-scan will always create new tickets for the member and admission. If the ticket items created include multiple admission codes (valid for more than admission location or event), it's advisable from a statistical view to print the tickets for the member and have member and guest reuse those for future arrival and departure validation.

    FIELD NAME

    DESCRIPTION

    Membership Code

    Links the membership setup table

    Admission Code

    Links the ticket admission definition table

    Ticket No. Type

    Defines which type and source of item number is used to define the sales number of ticket. Options are;


  • NA
  • ITEM
  • ITEM_CROSS_REF
  • ALTERNATIVE_NUMBER
    |

    Ticket No.

    The (Item) number to use when creating tickets. Must be setup in the ticket module.

    Cardinality Type

    The options are:


  • UNLIMITED
  • LIMITED
    |

    Max Cardinality

    Maximum number of tickets of this type per interaction. (Requires Cardinality Type LIMITED)

    Description

    A useful description for the member to understand when to select this alternative


    Anchor
    _Toc505335466
    _Toc505335466
    MM Membership Alteration Setup


This table defines the setup and business rules for altering a membership. Se the section "Managing Memberships" for an in depths analysis of business impact. The menu is in the shortcut from Membership Setup, under Navigate Ribbon.

...

FIELD NAME

DESCRIPTION

Alteration Type

The type of alteration describe, options are:

  • CANCEL
  • RENEW
  • UPGRADE
  • EXTEND

From Membership Code

Links to Membership Setup. The type of membership we intend to change.

Sales Item No.

The sales item used in the POS and accounting to capture the event.

Description

The description used in POS

To Membership Code

The target membership code

Alteration Activate From

Options to define the start date calculation of this change, options are:

  • As soon as possible (TODAY)
  • Date Formula

Alteration Date Formula

Date formula calculate the start date, e.g. CM+1 to calculate the first of next month.

Activate Grace Period

Activate the grace period filters. Allows for filtering out unwanted change paths in relation to the current state of the membership validity. (E.g. it should not be possible to RENEW membership until 1 month prior to it expires)

Grace Period Relates To

Which date the grace period should operate on. Options are:

  • Start Date
  • End Date

Grace Period Before

A date formula (such as "14D") to define the time frame BEFORE the grace date which this alteration is valid.

Grace Period After

A date formula (such as "14D") to define the time frame AFTER the grace date which this alteration is valid.

Membership Duration

The duration of the new membership time frame

Price Calculation

How the price should be calculated. Options are:

  • UNIT_PRICE – Item Unit Price is suggested
  • PRICE_DIFFERENCE – The value difference of the overlapping time period is calculated and the fraction of the extended value is added together
  • TIME_DIFFERENCE – only the fraction of the extend value is considered.


    Not all calculations apply to every alteration type

Stacking Allowed

Defines if multiple RENEWs are possible.




Anchor
_Toc505335467
_Toc505335467
MEMBER NOTIFICATION SETUP


This table hold set up that created member notifications. The menu is in the shortcut from Member Community, under Navigate Ribbon.

...

FIELD NAME

DESCRIPTION

Code

Primary Key

Description

A useful description

Type

Option to determine type of notification

  • WELCOME
  • RENEWAL

Days Before

Used with type renewals, this will create a notification X days before the membership needs to be renewed

Days Past

Used with WELCOME and NONVISIT. Number of days since member was created or members' previous visit.

Template Filter Value

This value is passed on the email processing and the intention is to simply notification template selection.

Community Code

This notification belongs to stated Community Code. May be blank to be independent of membership code.

Membership Code

This notification belongs to stated Membership Code. May be blank to be independent of membership code.

Next Notification Code

Unless the notification is canceled when processed, it will create a new notification with this code.

Cancel Overdue Notif. (Days)

Is a safeguard to not send notifications that are overdue, stated by number of days. A zero indicates no safeguard.

Target Member Role

Who among the membership members is the target of the notification;

  • FIRST ADMIN
  • ALL ADMINS
  • ALL MEMBERS


    The welcome notification e.g. might be intended for admin members only.


Anchor
_Toc505335468
_Toc505335468
MEMBERSHIP LIMITATION SETUP


This table is used to define membership access rules. The menu is in the shortcut from Membership Setup, under Navigate ribbon.

You define rules for the membership access and when a condition is met, the system will react and prompt with a message.

...

FIELD NAME

DESCRIPTION

Membership Code

This rule is for the stated membership code

Admission Code

This rule is for the stated admission code. Works with webservie not POS (yet)

Constraint Type

Options are

  • Relative Time - now minus the seconds (last hour)
  • Fixed Time - between certain times of day (lunch time)(rush hour)
  • Dateformula - similar to relative time but uses date formula

Constraint Source

Options are

  • Membership
  • Member
  • Membercard

    Defines whether rule is applied to the memberships, members or
    member cards. Memberships can have many members and every
    member could have multiple cards. When the relationship is 1:1:1
    this does really matter

Constraint Seconds

No. of seconds when constraint type is Relative Time

Constraint From Time

Constraint start time when constraint type is Fixed Time

Constraint Until Time

Constraint end time when constraint type is Fixed Time

Constraint Dateformula

Date formula when constraint type is Dateformula

Event Limit

The access limit per event

POS Response Action

Options are

  • Error
  • Confirm
  • Message
  • Allow

POS Response Message

Response message to display depending on the POS response action
selected

WS Response Action

Options are

  • Error
  • Allow

WS Deny Message

Message when WS response action is Error

Response Code

Unique code for each response

Blocked

Block rule when not in use


Anchor
_Toc505335469
_Toc505335469
Membership


The membership entity holds the actual membership.
Menu: Departments > Retail Add Ons > Members > Memberships

...

FIELD NAME

DESCRIPTION

Entry No.

Primary Key

External Membership No.

The external membership identification

Description

Membership description

Company Name

A corporate membership belongs to a named company

Blocked

Enables blocking a membership without interrupting the membership time frame

Blocked At

When it was blocked

Blocked By

Initials of user that blocked membership.

Community Code

A link to the membership community table

Customer No.

A link to the customer table

Membership Code

A link to membership setup table

Issued Date

Date of creation

Document ID

(Web Service) A reference to the message that created this membership




Anchor
_Toc505335470
_Toc505335470
MEMBERSHIP ROLE


This table links the membership with its members.

...

FIELD NAME

DESCRIPTION

Membership Entry No.

(Primary Key field) Foreign key to membership table

Member Role

(Primary Key field)
The role member has in this membership, options are:

  • ADMIN
  • MEMBER

Member Entry No

(Primary Key field) Foreign key to member table

Blocked

Enables blocking a membership without interrupting the membership time frame

Blocked At

When it was blocked

Blocked By

Initials of user that blocked membership.

Community Code

A link to the membership community table

User Logon ID

Credentials for 3rd party member management software

Password SHA1

Credentials for 3rd party member management software

External Member No.

(Flow field)

Member Display Name

(Flow field)

External Membership No.

(Flow field)

Membership Code

(Flow field)

Company Name

(Flow field)




Anchor
_Toc505335471
_Toc505335471
MEMBER


Represents the person in the membership.
Menu: Departments > Retail Add Ons > Members > Members

...

Anchor
_Hlk505329190
_Hlk505329190
FIELD NAME

DESCRIPTION

Entry No.

Primary Key

External Member No.

The external member identification number

First Name


Middle Name


Last Name


Blocked

Enables blocking a membership without interrupting the membership time frame

Blocked At

When it was blocked

Blocked By

Initials of user that blocked member.

Phone No.


Social Security No.


Address


Post Code Code


City


Country Code


Country


Gender

Options are:

  • NOT_SPECIFIED
  • MALE
  • FEMALE
  • OTHER

Birthday


Picture


E-Mail Address


E-Mail News Letter

Options are:

  • NOT_SPECIFIED
  • YES
  • NO

Created Datetime


Display Name


Contact No.


Document ID

(Web Service) A reference to the message that created this member


Anchor
_Toc505335472
_Toc505335472
MEMBER CARD


FIELD NAME

DESCRIPTION

Entry No.

Primary Key

External Card No.

The external member card identification number

External Card No. Last 4


Pin Code


Valid Until

When this member card is used, the valid until date is checked. Expired cards are not valid

Blocked

Enables blocking a membership without interrupting the membership time frame

Blocked At

When it was blocked

Blocked By

Initials of user that blocked member card.

Block Reason

This option to specify why card was blocked. Options are;

  • UNKNOWN
  • EXPIRED
  • USER_REQUEST
  • INTERNAL

Membership Entry No.

Foreign key to membership table

Member Entry No.

Foreign key to member table

External Member No.

(Flow field)

Member Blocked

(Flow field)

Display Name

(Flow field)

E-Mail Address

(Flow field)

External Membership No.

(Flow field)

Membership Blocked

(Flow field)

Company Name

(Flow field)

Document ID

(Web Service) A reference to the message that created this member card




Anchor
_Toc505335473
_Toc505335473
Membership Entry


This table holds the time frame entries that establishes membership validity. The entries are found in the membership card under menu Memberships.

...

FIELD NAME

DESCRIPTION

Entry No.

Primary Key

Membership Entry No.

Foreign key to membership table

Valid From Date

Time frame start date (inclusive)

Valid Until Date

Time frame end date (inclusive)

Created At


Context

The context in which this entry was created. Option are;

  • NEW
  • CANCEL
  • RENEW
  • UPGRADE
  • EXTEND

Blocked

Enables blocking a membership without interrupting the membership time frame

Blocked At

When it was blocked

Blocked By

Initials of user that blocked membership entry.

Item No.

Item used in sales

Description

Description used in sales

Membership Code

The membership code membership should have code in this time frame. The membership code on membership correctly reflects the current membership code.

Closed By Entry No.

The time frame may be altered by another entry as the consequence of RENEW, UPGRADE, EXTEND. The causing entry is linked on the CANCEL entry

Duration Dateformula

The original duration, as per entry creation

Unit Price

Unit Price (from Item Card)

Amount

Amount (discounts applied)

Amount Incl VAT

Amount Incl VAT

Receipt No.

NPR Reference. POS Receipt number of sales

Line No.

NPR Reference. POS Receipt line number of sales

Source Type

NAV reference of origin. Reserved for future use. Options are:

  • SALESORDER

Document Type

NAV reference of origin. Reserved for future use. Option mirror the type of creating document

Document No.

NAV reference of origin. Reserved for future use.

Document Line No.

NAV reference of origin. Reserved for future use.

Import Entry Document ID

(Web Service) A reference to the message that created this member card




Anchor
_Toc505335474
_Toc505335474
MEMBERSHIP NOTIFICATION


Hence, a notification may be created. The Member Notification is created preemptively and may be canceled when it is processed on the intended notification date. The entries are found in the membership card or membership list under menu Memberships.

...

FIELD NAME

DESCRIPTION

Entry No.

Primary Key

Membership Entry No.

Foreign Key to membership

Member Entry No.

Foreign Key to member.

  • May be non-zero when notification is intended to a specific membership member.
  • Target member role rule is also obeyed

Notification Code

Foreign Key to Member Notification Setup

Date To Notify

The date when notification is to be executed.

Notification Status

Process state;

  • PENDING
  • PROCESSED
  • CANCELED

Notification Processed At

Date time of last processing time

Notification Processed By User

Who executed notification

Blocked

Prevents notification from being processed

Blocked At

Date time of the block

Blocked By User

Blocked by user

Notification Trigger

From Member Notification Setup

Template Filter Value

From Member Notification Setup

Target Member Role

From Member Notification Setup




Anchor
_Toc505335475
_Toc505335475
MEMBER NOTIFICATION ENTRY


When the Membership Notification is processed, the actual member(s) to notify are resolved. That member information is stored in this entry table along with process status information. The entries are found in the membership card or membership list under menu Memberships.

...

FIELD NAME

DESCRIPTION

Notification Entry No.

Primary Key, Foreign key to Members Notification

Member Entry No.

Primary Key, Foreign key to Member

Membership Entry No.

Foreign key to Membership

Notification Code

From Member Notification

Date To Notify

From Member Notification

Notification Send Status

Process state;

  • PENDING
  • SENT
  • CANCELED
  • FAILED

Notification Sent At

Date time

Notification Sent By User

Sent by user

Blocked

Blocked

Blocked At

Blocked at

Blocked By User

Blocked by

Notification Trigger

From Member Notification

Template Filter Value

From Member Notification

Target Member Role

From Member Notification

Notification Method

Option of Notification Method (Should be inherited From Member)

  • E-MAIL

External Member No.

From Member

External Membership No.

From Membership

E-Mail Address

From Member

Phone No.

From Member

First Name

From Member

Middle Name

From Member

Last Name

From Member

Display Name

From Member

Address

From Member

Post Code Code

From Member

City

From Member

Country Code

From Member

Country

From Member

Birthday

From Member

Community Code

From Member

Membership Code

From Membership

Membership Valid From

From Membership Entry

Membership Valid Until

From Membership Entry

External Member Card No.

From Member Card

Card Valid Until

From Member Card

Pin Code

From Member Card

Failed With Message

If the send should fail, and if the send implementation returned a reason, it will be here.




Anchor
_Toc494715726
_Toc494715726
Anchor
_Toc505335476
_Toc505335476
Managing Memberships


For a membership to be active, there should be a time frame registered for that membership. The time frame entry defines the start and end date and include some information regarding the price and in which context it was created or edited.
When a membership is created, the first-time frame is created automatically – this time frame makes the membership valid.
The member management functions operate on those time frames and create new time frames and canceling part of them accordingly.
The general rule is that two time frames may not overlap. The operations Extend and Upgrade require an active time frame and will mexodify the active time frames until date does not to violate this rule.
When an Extend or Upgrade time frame is canceled, the original time frame is restored.


Anchor
_Toc505335477
_Toc505335477
POS commands


There are 5 commands to manipulate the current time frame. There general behavior is as follows;

...

  • RENEW – will add a new time frame AFTER the last time frame (back to back) when the renew action is performed while there are future time frames. Should all the time frames be valid in the past, the new time frame is added starting today.
  • EXTEND – requires that there is a time frame for the extension start date and that the duration of the new time frame, extends (is valid for a longer time) the current time frame.
  • UPGRADE – also requires that there is a time frame for the upgrade start date. Upgrade changes the membership code for the remaining time in the time frame. Upgrade must have a start date of TODAY. (This is because the POS price and discount structure does not allow changing something for the future)
  • CANCEL- ends the current time frame on the specified date (Setup).
  • REGRET – will undo the last time frame and restore the conditions of the membership to those that applied before the change that is regretted. The first time frame created for a membership may be regretted, in which case the membership cannot be reactivated again. A REGRET operation cannot be undone.


Anchor
_Toc505335478
_Toc505335478
Web Services


Two web service are available to perform the same activities as can be done from the POS;

...

The RENEW and EXTEND operates primarily on time, while UPGRADE changes the conditions of the membership. Renew and extend can be combined with upgrade functionality under the condition that new time frames start date must be from TODAY.
CANCEL will terminate the membership on the specified date.


Anchor
_Toc505335479
_Toc505335479
RENEW


Renew is used to add a new subscription period after the current period. The start date of this new period is determined when the renewal is done and the activation date formula on the setup.

Start Date of the new subscription time frame may not interfere with previously registered time frames that are not canceled.


Anchor
_Toc505335480
_Toc505335480
Price calculations


The setup allows for 3 pricing strategies, but only the Unit Price applies to renew, since overlapping time frames are not allowed.


Anchor
_Toc505335481
_Toc505335481
Stacking


With the "Stacking Allowed" option, it is possible control if multiple future renewals are allowed. When true, an unlimited number of time frames may be created.


Anchor
_Toc505335482
_Toc505335482
Grace Period


A grace period can be defined in order to define when the start date of the new period must occur in relation to the current period. This is useful when you want to limit which options should be selectable.
Grace period can be defined to be relative to either start date or end date of the subscription. There are date formulas to calculate the period before the date and after the date.


Anchor
_Toc505335483
_Toc505335483
Extend


Extend is used to add a new subscription period from the current point of time. The current point of time may be skewed using the activation date formula on the setup. The overlapping part of the currently active time frame is removed.

The membership extend functionality should be seen as a recommitment from the customer to stay a customer for full new period of time.


Anchor
_Toc505335484
_Toc505335484
Price calculations


The setup allows for 3 pricing strategies:

...

  • Unit Price – this will suggest the unit price as set on the item card.
  • Price Difference– this method will calculated the suggested unit price as value of the new time frame minus value of canceled time frame for the overlapping period plus the extended period at full price.
  • Time Difference – this method will calculate the suggested unit price as the value of the new time frame, without considering the overlapping period.


Anchor
_Toc505335485
_Toc505335485
Stacking


Not applicable.


Anchor
_Toc505335486
_Toc505335486
Grace Period


A grace period can be defined in order to define when the start date of the new period must occur in relation to the current period. This is useful when you want to limit which options should be selectable.
Grace period can be defined to be relative to either start date or end date of the subscription. There are date formulas to calculate the period before the date and after the date.

In the example, above, the membership may be expanded in the last 4 months of the subscriptions.


Anchor
_Toc505335487
_Toc505335487
Upgrade


Upgrade as opposed to renew and extend, changes the type of membership. The upgrade applies to the remaining of the time frame. Upgrade must become valid from TODAY or the change will not be possible.


Anchor
_Toc505335488
_Toc505335488
Price calculations


The setup allows for 3 pricing strategies:

...

  • Unit Price – this will suggest the unit price as set on the item card.
  • Price Difference– this method will calculated the suggested unit price as the value of the new time frame minus value of canceled time frame for the overlapping period.
  • Time Difference – not available as there is no time extension to consider


Anchor
_Toc505335489
_Toc505335489
Stacking


Not applicable.


Anchor
_Toc505335490
_Toc505335490
Grace Period


A grace period can be defined in order to define when the start date of the new period must occur in relation to the current period. This is useful when you want to limit which options should be selectable.
Grace period can be defined to be relative to either start date or end date of the subscription. There are date formulas to calculate the period before the date and after the date.
From a business case view, grace periods might not apply to upgrades when going to a more expensive product. It can however be useful when handling membership downgrades and not allowing such selections in the beginning of the membership time frame.


Anchor
_Toc505335491
_Toc505335491
CANCEL


The cancel membership function is to end the current membership. Cancel cannot be performed unless there is an alteration rule setup.


Anchor
_Toc505335492
_Toc505335492
Price calculations


The setup allows for 3 pricing strategies:

...

  • Unit Price – this will suggest the unit price as per the original unit price.
  • Price Difference– this method will calculated the suggested unit price as the value of the remaining time.
  • Time Difference – will return 0


Anchor
_Toc505335493
_Toc505335493
Stacking


Not applicable.


Anchor
_Toc505335494
_Toc505335494
Grace Period


A grace period can be defined in order to separate different types cancel rules. The cancel that applies in the beginning of the membership time frame might refund the sales price. As time progress, cancel might return refund value that is proportional to the remaining time.
Grace period can be defined to be relative to either start date or end date of the subscription. There are date formulas to calculate the period before the date and after the date.


Anchor
_Toc505335495
_Toc505335495
REGRET


The regret operation works as an undo. The current time frame will be undone and the preceding time frame will be restored.


Anchor
_Toc505335496
_Toc505335496
Price calculations


The setup allows for 3 pricing strategies:

...

  • Unit Price – this will suggest the unit price as per the original unit price.
  • Price Difference – NA
  • Time Difference – NA


Anchor
_Toc505335497
_Toc505335497
Stacking


Not applicable.


Anchor
_Toc505335498
_Toc505335498
Grace Period


Grace period applies to the regret if setup. Consumer law might require unconditional refund during the first 14 days.


Anchor
_Toc494715727
_Toc494715727
Anchor
_Toc505335499
_Toc505335499
Member Notification


The member module can communicate with its members in regards to the following events.

...

When the notification system is activated, it is preemptive, meaning that it will create a notification with a future date. When time comes, the notification is validated, and if it is deemed to be valid, then the member is notified.


Anchor
_Toc505335500
_Toc505335500
Setup example:


A sample setup for membership renewal notifications setup

...

  • First notification (R30) 30 days before expiry
    • If membership is renewed before notification is sent, it will be canceled and a new notification will be created for that membership (if applicable).
    • If notification was sent, next notification R20 is created
    • Notification is sent to the member that is First Admin
  • Second notification (R20) 20 days before expiry, unless membership was renewed
    • If notification was sent, next notification R10 is created
    • Notifications are sent all Admin members
  • Third notification (R10) 10 days before expiry, unless membership was renewed
    • If notification was sent, next notification R00 is created
    • Notifications are sent to all members
  • Fourth notification (R00) 1 day after expiry, unless membership was renewed
    • Notifications are sent to all members


Anchor
_Toc505335501
_Toc505335501
Activating


Notifications can be activated from the systems perspective on two levels.

...

When a rule was found, a notification is created.'


Anchor
_Toc505335502
_Toc505335502
Member Opt-out


Members can opt out from notifications by setting the "Notification Method" to blank on their member card.


Anchor
_Toc505335503
_Toc505335503
Email templates


To send E-Mails with NaviPartner Retail, one or more template needs to be setup.

...

  • To create a template, navigate to the "E-Mail Templates" page from the "Member Notification Setup" page
  • Click New
  • Create a template like this:
  • The values in curly brackets will be replaced with actual values when the e-mail is created.
  • For advanced setup, see the E-Mail Setup & Template documentation




Anchor
_Toc505335504
_Toc505335504
Automation


To automate sending of notifications, codeunit 6060136 should be added task queue.


Anchor
_Toc494715728
_Toc494715728
Anchor
_Toc505335505
_Toc505335505
Setup


Suggested order for setting up member


Anchor
_Toc505335506
_Toc505335506
ROLE CENTER


Anchor
_Toc505335507
_Toc505335507
Setting up the role center Profile ID.


  • Navigate Profiles (Departments/Administration/Application Setup/RoleTailored Client)
  • Add a new Profile ID for Ticket & Members
    • Role Center ID is 6060149


Anchor
_Toc505335508
_Toc505335508
Assigning a Profile ID to User ID


  • Navigate to User Personalization (Departments/Administration/Application Setup/RoleTailored Client)
  • Find the User ID and set/ change the Profile ID




Anchor
_Toc494715729
_Toc494715729
Anchor
_Toc505335509
_Toc505335509
POS Setup


Anchor
_Toc505335510
_Toc505335510
Touch Screen Setup


To add membership sales as buttons on the POS sales form, simply add them as regular sales items on the "Sales Form". Any item defined in the Membership Sales Setup will behave as a new sale of a membership.
Hence, if we want to have a button on the POS to create new members, then we will need to add it just like an item for sale.

Behind it we need to have two major set-ups:
Item Creation:

Membership Sales Setup where the parameters for the sales of the membership are set:

Note: The it is only the Business Flow Type Membership that works in Standard solution, the rest has been developed for Transcendence.
To manage member functions from the POS, several additional command buttons must be added in the POS to control what the button should do in regards to a member.
With the Line Type set to Internal and the Filter No. set to MM_SCAN_CARD, different sub-functions can be accessible in the POS by defining the field "Parameter" according to the following table.

...

Parameter

description

MEMBER_ARRIVAL

The will ask for the member card and register arrival on the default admission code associated with the item specified on the Membership Sales Setup

MEMBER_ARRIVAL:: <ADMISSIONCODE>

As above, but selection the admission code after the double colon. This requires that the ticket is valid for multiple locations and the admission code is valid for the ticket.

SET_MEMBERNUMBER

This function will ask for the member card and extract the customer number from the membership and set it in the POS. Subsequent item registrations will enjoy the benefits derived from price / discount structures defined for the customer.

EDIT_MEMBERINFO

Operates on the POS sales line. If it is a membership POS new sales item, the information may be edited.

LOOKUP_MS_ENTRIES

This function will ask for the member card and show all the time frames the membership has

REGRET_MS_ENTRY

This function will ask for the member card and regret the most recent time frame.

RENEW_MEMBERSHIP

This function will ask for the member card and show a list of the renew products that the membership is entitled to. The list contains prices and calculated dates illustrating the time frame that will result from the change.

EXTEND_MEMBERSHIP

This function will ask for the member card and show a list of the extend products that the membership is entitled to. The list contains prices and calculated dates illustrating the time frame that will result from the change.

UPGRADE_MEMBERSHIP

This function will ask for the member card and show a list of the upgrade products that the membership is entitled to. The list contains prices and calculated dates illustrating the time frame that will result from the change.

CANCEL_MEMBERSHIP

The cancel function will terminate the membership on date specified by the date formula.




Anchor
_Toc494715730
_Toc494715730
Anchor
_Toc505335511
_Toc505335511
Internal Member Registration Process


Anchor
_Toc505335512
_Toc505335512
Overview


Membership registration and alterations are split into two distinct parts - before and after payment.


Anchor
_Toc505335513
_Toc505335513
Before Audit is posted


New sales


  1. During POS item registration, the POS identifies the item as being a member item
  2. After the POS item has been created, the member info capture dialog is displayed to capture the required member information
    1. On dialog exit
      1. On confirmation, the membership structure is created, except the membership ledger entry making it valid.
      2. On cancel, the POS sales line is deleted along with the records used to capture the member information
  3. POS is ready for new action

...

  1. Teller selects some functions such as CANCEL/REGRET, EXTEND, UPGRADE, UPGRADE and scans the member card
  2. The POS may show a member confirmation dialog (setup)
  3. The POS shows a list of products the membership is eligible for.
  4. The selected products is registered.
  5. The price and receipt information is captured and the member info capture objects is updated.


Anchor
_Toc505335514
_Toc505335514
During Audit Role posting


  1. The member info capture table is searched for entries matching the sale receipt
    1. The action is finalized,
      1. NEW
        1. Adds an entry to the Membership Entry table
      2. RENEW,EXTEND,UPGRADE
        1. Adds a new entry to the Membership Entry table
        2. Updates the current entry
      3. CANCEL
        1. Updates the current entry

...

Anchor
_Toc459894732
_Toc459894732


Anchor
_Toc494715731
_Toc494715731
Anchor
_Toc505335515
_Toc505335515
Web Services


Anchor
_Toc505335516
_Toc505335516
Setup in Navision:


To setup ticket web-services, navigate to the "Web Services" page at Departments/Administration/IT Administration/Services and register codeunit 6060126 with the service name "member_services".
In a multi-tenant environment, this must be done from the default tenant.

The following member web services are available:


Anchor
_Toc505335517
_Toc505335517
Setting up memberships


The following services can be used to create memberships and members, update the member information and possibly block the membership from usage until it has been unblock.

...

Services

DESCRIPTION

CreateMembership

This web service creates an empty membership using a sales item from the membership sales setup table

AddMembershipMember

Adds members to an existing membership

UpdateMember

Updates an existing member

UpdateMemberImages

Updates an existing members picture

BlockMembership

Blocks an existing membership






Anchor
_Toc505335518
_Toc505335518
Querying Memberships and members


The following services can be used to retrieve member information

...

Services

DESCRIPTION

GetMembership

Searches and returns Membership information

GetMembershipMembers

Searches and returns the Member connected to a membership

GetMemberImage

Get the image for a member

MembershipValidation

Checks if membership is active

MemberValidation

Checks if member is blocked and membership is active

MemberCardNumberValidation

Checks if member card is valid and membership is active

MemberEmailExists

Check if the email address has been used on an already created and active member.




Anchor
_Toc505335519
_Toc505335519
Mananging the membership product and duration


Altering the memberships validity can also be performed by webservies.

...

Services

DESCRIPTION

GetMembershipChangeItemsList

This service returns a list of items that can be used to alter the membership. The membership time frame and price is calculated in context of the active membership.

ChangeMembership

This service executes the change to the membership as described by one of the items from the list in GetMembershipChangeItemsList service




Anchor
_Toc505335520
_Toc505335520
Tickets and registering member Integration


Member and tickets are integrated. It is possible to define guest tickets for members.

...

Services

DESCRIPTION

GetMembershipTicketList

This service returns a list of valid ticket items that the member can select from, to accommodate a self-service check-in for himself including guests.

(This is a 2 step process)
Second half (registering ticket and arrival) is provided by the ticket management web service

MemberCardRegisterArrival

This services is intended for handling self-service scanning of member card number, and allowing member entry.
(This is a one step process)

MemberRegisterArrival

This services is intended for handling self-service scanning of member number, and allowing member entry.
(This is a one step process)




Anchor
_Toc474324701
_Toc474324701
Anchor
_Toc494715732
_Toc494715732
Anchor
_Toc505335521
_Toc505335521
Loyalty Reward Program




"Loyalty programs are proven to increase customer lifetime value by up to 30% or more by increasing visit frequency, increasing spend per visit, and winning back lost customers," - Chris Luo, VP of Marketing of loyalty technology company FiveStars.
A Customer Loyalty Program is a marketing tool used by businesses to motivate repeat customers to come back to the shop to make frequent purchases, and beat competitions, by offering some kind of reward system.
Hence, a customer loyalty program is a structured and long-term marketing effort which offers incentives to frequent customers who demonstrate a "loyal buying behavior".
In Retail Industry, these programs generally reward loyal customers with discounts, special offers, rebates, points, or giveaways.
NP Retail has developed the tool to setup various schemes. The principle is that the customer is awarded points based on certain purchase actions and these points are then consumed by converting them into discounts, special offers, rebates, points, giveaways and so on.
All the functions for managing the Loyalty Reward Programs are found in the menu:
Departments > Retail Add Ons > Members


Anchor
_Toc505335522
_Toc505335522
Member Community


The first level of configuration will be to set up a group with a common perspective or goal. In our case, it is a "Loyalty Club". The Member Community function is used to that effect.
(Refer to section Membership Community for more details on how to set it up).
For example, we can set the following group:

...

FIELD NAME

DESCRIPTION

Code

BK - A code used to link this community with other tables

Description

Bamse Klubben - A use description of the community

External No. Search Order

CARDNO - An option to define what search term should be used when there is ambiguity

External Membership No. Series

NPR_MSHIP - Number series to generate the external membership identity

External Member No. Series

NPR_MEMBER - Number series to generate the external member identity

Member Unique Identity

EMAIL - The member value that must be used to uniquely identify a member

Create Member UI Violation

When a member is created and the unique identity is violated the system can react with in the following ways;

  • ERROR – An hard error is thrown

Member Logon Credentials

NA - Defined what term to use for logon credentials when a 3rd party member management soft is used

Membership to Cust. Rel.

Check On - This is field is used when memberships are linked with customers. This is required in the following scenarios;

  • When members have access to specific discount and price structures.
  • When members have access to their account on the web and can/must link their purchases with the membership account number.

Create Renewal Notification

Check On - Create a notification when membership requires renewal;




Anchor
_Toc505335523
_Toc505335523
Loyalty setup


The Loyalty Reward Program to collect the points will vary with different businesses. We have developed the Loyalty Reward Programs that are commonly used in the Retail System. Nevertheless, it is not an end in itself. We will develop more schemes based on the client's requirements in the future.

...

FIELD NAME

DESCRIPTION

Code

A code used to identify the scheme;
e.g. ADVANCED, PROGRESSIVE, SIMPLE

Description

Description of the scheme

Collection Period

The period which determines when the customer is eligible to accumulate points. Hence the computation of the points will be based on the period for which the point will be collected;

  • As You Go – There is no fixed period, the points will be collected as and when the purchase is done
  • Fixed – A defined period is established for collection of points

Fixed Period Start

The Date formula in NAV is used to defined the period starting point based on the purchase date.
(see table below for example of date formula in NAV)

Collection Period Length

The Date formula in NAV is used to defined the period length in which the points will be collected.
(see table below for example of date formula in NAV)

Expired Uncollected Points

This field determine if any uncollected points will have expired and not taken into the calculation of the points for collection.

Voucher Point Source

It is the basis to collect the points to use in the calculation of the reward.

  • Uncollected Points – Unused points
  • Previous Period – points from previous period

Voucher Point Threshold

The minimum number of points to start the calculation for the loyalty program.

Voucher Creation

The method to be used to create the Discount Voucher or Coupon;

  • Note: Currently we are developing the program to create the coupon – so far we have the solution to compute the points, but not the conversion of the points into coupons.

Base Point

It is the base to calculate the value for the Discount Voucher or Coupon;

  • Amount – The calculation of points to be allocated will be based on amount purchase.
  • Item Point Setup – The calculation of points will be based on a predefine points for the purchase of a particular item
  • Amount and Item Point Setup – A combination of both of the above

Amount Base

The base amount is to include or exclude VAT amount in it calculation when converting to Loyalty Currency.
For example, if the amount including 25% of VAT is 125, then the base will be on:

  • Including VAT – 125.
  • Excluding VAT – 100

Point on Discounted Sales

If the check box is ticked, then we will use discounted amount to calculate the points or else, it will not be taken into the calculation.




Anchor
_Toc505335524
_Toc505335524
Example of Date Formula in Navision


DATE FORMULA

RESULTING DATE

DESCRIPTION

NOTES

CW

9/29/13 (Sunday)

Returns the last date of the current week


CM

9/30/13 (Monday)

Returns the last date of the current month


CQ

9/30/13 (Monday)

Returns the last date of the current quarter


D15

10/15/13 (Tuesday)

Returns the next 15th of the month


D15 + 1M

11/15/13 (Friday)

Returns 1 month after the next 15th of the month

Same result as 1M + D15

1M + D15

11/15/13 (Friday)

Returns 15th day after the date is advanced 1 month

Same result as D15 + 1M

1M – 15D

10/10/13

Returns the date 15 days less than a full month after reference date


1M + 15D

11/9/2013

Returns the date 15 days more than a full month after reference date


CM +1D

10/1/13 (Tuesday)

Returns the 1st of the following month


CM+1M

10/30/13 (Wednesday)

Returns the last date of the current month advanced by one month

If the reference date had been 02/23/2013 the returned date would be 03/28/13

CM + D10 + 90D

1/8/2014 (Wednesday)

Returns a date 90 days after the next 10th of the month


1M+CM

10/31/13 (Thursday)

Returns the last date of the following month

If the reference date had been 02/23/2013 the returned date would be 03/31/13

CW+1D
or
CW+WD1

9/30/13 (Monday)

Returns the Monday of Next Week


CW+5D
or
CW+WD5

10/4/2013 (Friday)

Returns the Friday of Next Week


CW+1D+3W

10/21/2013 (Monday)

Returns 3 Weeks from Next Monday


CW-1D

9/28/2013 (Saturday)

Returns Saturday of This Week

If the reference date had been 09/29/2013 (Sunday) the returned date would still be 09/28/2013. The week starts on Monday in NAV.

D15+WD1

10/21/13 (Monday)

Returns the Monday after the next 15th of the month


WD4 + 6W

11/7/13 (Thursday)

Returns the Thursday 6 weeks after the next Thursday.

Imagine a vendor that ships only once a week with a long time in transit.




Anchor
_Toc505335525
_Toc505335525
Item Points Setup


After defining the Loyalty Reward Programs in the Loyalty Setup menu, we now need to define the method of calculation for accumulating the points. This is done in the Item Point Setup menu.

...

Note: The above rules are associated to the Loyalty Code: ADVANCE. And ADVANCE is under the Member Community: BK. Hence any member under this Member Community: BK. will benefit from ADVANCE.


Anchor
_Toc474324702
_Toc474324702
Anchor
_Toc494715733
_Toc494715733
Anchor
_Toc505335526
_Toc505335526
Members' Link to Loyalty Reward Programs


In the above paragraphs, we have seen how to set up different Loyalty Reward Programs and now we will look into how to link the member to benefit from these programs. We need to go to the Membership Setup to set up a group of members who will be associated with the Loyalty Reward Program - Code: ADVANCE under Community Code BK.


Anchor
_Toc505335527
_Toc505335527
Membership Setup


Menu: Departments > Retail Add Ons > Members > Setup > Membership Setup

Setting up the group of members, using Membership Setup menu:

...

FIELD NAME

DESCRIPTION


MEMBERSHIP SETUP


Code

CLUB-VIP - A code used to identify this community

Description

Bamse klubben - A use description of the membership

Membership Type

Controls how members and memberships are related.

  • COMMUNITY – This is simple type of membership where all members are put into one big group. This is practical when the "membership" is informal and like in email register f.ex. Members may still have a member card and there may be benefits for the individual members.
  • GROUP – Similar to the COMMUNITY mode. In this mode the membership time-frame plays a predominant role. Number of members in a group can be limited. The members can have individual roles.
  • INDIVIDUAL – One membership – one member.

Community Code

BK - A link to the community this membership belongs to

Loyalty Code

ADVANCED – This code determines which Loyalty Reward Program is attached to the Community Code.

Loyalty Card

Define whether a Loyalty Card is to be issued to the member or not. It is in this screen that we make the relationship between the Community (Member Community) & the Loyalty Reward Program (Loyalty Setup)

Customer Template Code

WEB - This code identifies a template for how the customer associated with the membership will be created. This field is required when the "Membership to Cust. Rel." field on community is checked.
Note: The customer template is defined the Configuration Template which is the new standard for Navision as from version 2016 onwards.

Member Information

How the member entity should be treated.

  • NAMED – The member must exist
  • ANONYMOUS - Membership can be anonymous – there is no member, just the card (Membership Type COMMUNITY)

Blocked

The setup is blocked from usage

Blocked At

Time of block

Perpetual

The membership validity can be perpetual (everlasting)

Member Role Assignment

How members are assigned their role in the membership

  • MEMBERS_ONLY
  • FIRST_IS_ADMIN
  • ALL_ADMINS

Create Renewal Notification

Create a notification when membership requires renewal

Create Welcome Notification

Create a notification when member is created

Membership Member Cardinality

Maximum members in a GROUP membership

Allow Membership Delete

This options allow memberships to be deleted.

Confirm Member On Card Scan

When a POS function requires the member card to be scanned, the member card will pop up for visual confirm.

Account Print Object Type

The type of object used for generating printing for the account information

Account Print Object ID

The Object ID to be developed

Receipt Print Object Type

The type of object used for generating printing for the receipt

Receipt Print Object ID

The object ID used for generating the printout.


Membership card section


The following fields defined how the member card number should be handled. The member card number is public and should not be a sequential number only.


Card Number Scheme

Who responsible of creating the member card number

  • NA
  • GENERATED
  • EXTERNAL

Card Number Prefix

Specific prefixes can be defined (or generated by the number series)

Card Number Length

The length is used to pad a number that is too short

Card Number Validation

If there should be a check digit appended to end of the generated number

Card Number No. Series

The number series used generated the base of member card number

Card Number Valid Until

For how long a member card should be valid

Card Number Pattern

A patter can be entered to control how the card number should be generated. A pattern consists of keywords that will create a number that is a bit more difficult to guess. Available keywords are listed below and must be included between [ and ].

  • MA - Member Account Number
  • MS – Membership Number
  • S – The number generated by the number series
  • N – A random number
  • A – A random character
  • X – A random alphanumeric character.


    N, A, X can be suffixed by a * and number to repeat it, that number of times.
    The default pattern is [X*4][MA][X*4][MS][S]

    Which would generate a member card number similar to:
    RQ41MM-00147VBH7MS-0013100087

Card Print Object Type

The type of object used for generating printing for the member card

Card Print Object ID

The object ID used for generating the printout.



Membership ticket section


Ticket Item Barcode

This barcode is created as a sales line in environment of Ticketing. It is not used for Loyalty purpose.
E.g 2900000311015 is an item on the POS which in a scenario where that this item can be given free to the member. It is used as a quick sales item on a specific button in the POS. When scanning the membership number, it will trigger a sales line for that ticket or item number (2900000311015).


Anchor
_Toc505335528
_Toc505335528
Membership Sales Setup


The next step is to set the parameters for the sales of the membership.

...

FIELD NAME

DESCRIPTION

Type

An option to define what type of "item" we are selling.

  • ITEM
  • ACCOUNT – This option is reserved for future use. Currently a membership sale must be an item

No.

The Item or Account used for membership sales

Membership Code

Links the Membership Setup table. The item sold will create a membership of this type.

Blocked

If parameter is not used, then it is blocked

Blocked At

Date the block was done

Valid From Base

An option to define how the membership time frame start date should be calculated.

  • SALESDATE
  • DATEFORMULA

Sales Cut-Off Date Calculation

Reserved for future use.

Valid From Date Calculation

Date formula for activation date

Valid Until Calculation

An option to define the duration of the membership. Options are;

  • DATEFORMULA
  • END_OF_TIME

Duration Formula

Date formula for duration

Assign Loyalty Points On Sale

Determine whether points should be assigned when sales are done on this membership type




Anchor
_Toc505335529
_Toc505335529
Create Membership


The member for the group will be created from the "Create membership" shortcut in the Home Tab from the Membership Sales Setup.


If in the configuration of Member Community, we have set the Membership to Customer Relation to Yes, then a customer file will be created as well as the Membership Card. We can see the display of which customer is created in the list in:
Menu: Departments > Retail Add Ons > Members > Memberships


Anchor
_Toc474324703
_Toc474324703
Anchor
_Toc494715734
_Toc494715734
Anchor
_Toc505335530
_Toc505335530
Application of the Loyalty Reward Programs


Anchor
_Toc505335531
_Toc505335531
Sale on POS to a Member


The solution Loyalty will be available under Transcendence. The process is to attached a sale to the member while doing the sale from the POS. If the member who has a Loyalty Reward Program configured.
From the POS, use the Select Membership function to set the sale to the member:

By selecting the member number, the customer attached to the member will be selected as well.

Then we can sell an item under the Loyalty Reward Program and based on the configuration, the points will be allocated accordingly.
If we have a look at the "Memberships" card in the menu: Departments > Retail Add Ons > Members > Memberships, then we can see the statistics on the Points allocated to the member.

Note:
The points are not computed on the Member Card, but it is on the Membership Card of the member which belongs to a particular Membership. The logic is that the member is allocated points due the status he or she has as being under a membership. The Loyalty Reward Programs reward the Membership as a group and consequently a member belonging to the membership.


Anchor
_Toc474324704
_Toc474324704
Anchor
_Toc494715735
_Toc494715735
Anchor
_Toc505335532
_Toc505335532
Loyalty Reports:


The reports regarding Loyalty Reward Programs are found in the Action Tab in Memberships.
Menu: Departments > Retail Add Ons > Members > Memberships


Anchor
_Toc505335533
_Toc505335533
Loyalty Points Summary


Based on table MM Membership 6060127 where you find all fields except Customer Name:

...

The content for one membership code should be something similar to this:


Anchor
_Toc505335534
_Toc505335534
Report: Loyalty Points Value


Similar to the previous report, but we will translate the Remaining Points to monetary value.
There are setup from several table required.

...

  • Date Filter (flow filter) on Membership
  • Membership Code




Anchor
_Toc505335535
_Toc505335535
Report: Loyalty Points Detail


This is a plaint list of a membership points entries

...

  • Date Filter (flow filter) on Membership



Anchor
_Toc494715736
_Toc494715736
Anchor
_Toc505335536
_Toc505335536
Earning and Redeeming points





FIELD NAME

DESCRIPTION

Issue Coupon Module

Issuing module needs to be Member_Loyalty

...


 
The coupon discount will be added in the sale and applied to the sale transaction as shown below:

Anchor
_Toc494715737
_Toc494715737
Anchor
_Toc505335537
_Toc505335537
Auto Renew Process







Membership Sales Setup


FIELD NAME

DESCRIPTION

Auto-Renew To

Item to Auto-Renew To

...