web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Ls retail User authent...
Microsoft Dynamics NAV (Archived)

Ls retail User authentication

(0) ShareShare
ReportReport
Posted on by Community Member

Hi To all,

I'm new to LS RETAIL and microsoft nav, My question is there a way for me to create third party application specifically PHP(Web Based) to create simple login(Username, Password) customer could use to see their points and other loyalty rewards. 

I was able to connect  PHP and Nav and view particular information using web services (SOAP). But

for Login or Authentication is the hard part for me on how to do. Thank you 

If you have any blog, code, or any resources to use please help me. Thank you

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi,

    1) Loyalty Web Portal is already available with LS Retail and you can see all the relevant functionalities available in standard.

    Check Demo Version at following link.

    lsretail.cloudapp.net/loyalty.web

    2) In case, if you do not want standard functionality and need to build your own web page, I would suggest following.

    1) Create Staging Database (ex. LoyaltyWebDB) in SQL

    2) Create Loyalty Points Table

    3) Replicate the Points data from NAV "Member Point Entry" Table to Staging Database Loyalty Point Table on periodic basis

    4) Access LoyaltyWebDB with proper authentication and build the required Web Portal.

    The reason of creating the separate database and table is to avoid having direct access to NAV database (over internet)  which can cause security & Performance related issues.

    If you still want standard NAV Table, let us know.

    Hope this helps.

  • Community Member Profile Picture
    Community Member on at

    Hi Vishal Salot,

    Thanks for the quick reply.

    I think your suggestion about create separate database and doing it for periodic basis is ok, But my concern we want a realtime points update. In this case periodic basis would be not good.

    The concept of of our WebApp is

    1. customer login

    2. customer view points

    3. customer view voucher

    Do you have any idea on how to login authentication works in LS RETAIL?

    base on customer info and be able to see points? assuming customer is already in Ls Nav database. Thank you

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Refer this link.

    msdn.microsoft.com/.../dd339004(v=nav.90).aspx

    You can create separate codeunit and publish to fetch the customer points from Member Point Entry Table.

  • Community Member Profile Picture
    Community Member on at

    Ok thanks i will look into this option. Thanks for helping

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans