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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Cue to Calculate Inventory Quantities on Role Center

(0) ShareShare
ReportReport
Posted on by 55

Dear Business Central Users

I'm looking for assistance. I want to add five cues to my Role Center. Each Cue should show the total quantity in stock of a particular item. For example

Item No. H001 --> 50 in Inventory (Display 50 in Cue)

Item No. P001 --> 100 In Inventory  (Display 100 in Cue)

What will be the most efficient way to achieve this?

  • Custom Table
  • CardPart
  • Add to Role Center Page

OR

  • Source Table = System Table Example: Sales Invoice Table
  • CardPart Page
  • Add to Role Center Page

Also the functions and filter to use in Tables / CardPart example would be appreciated. I am new to Microsoft AL and would appreciate as much information as possible. If anyone is willing to mentor or teach or possibly know of some that has a Intermediate to advanced course at a reasonable price on AL I would appreciate the recommendations / assistance. 

I have the same question (0)
  • Suggested answer
    Marco Mels Profile Picture
    on at

    Hello,

    We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

    www.yammer.com/dynamicsnavdev

    www.dynamicsuser.net/.../14

    I will open this up to the community in case they have something to add.

    Thanks.

  • Verified answer
    Amit Baru Profile Picture
    3,037 on at

    hi,

    For this, use custom table and create 5 flowfields. In Each field cal. stock qty. from ILE and Create New pages and shown same in role center.

    Regards

    Amit Sharma

  • Verified answer
    YUN ZHU Profile Picture
    95,750 Super User 2025 Season 2 on at

    Hi, the simpler way is as mentioned by Amit, using FlowField, you can refer to the following standard code.

    pastedimage1662443265767v2.png

    pastedimage1662443249467v1.png

    pastedimage1662443338229v4.png

    pastedimage1662443324448v3.png

    pastedimage1662443456529v5.png

    Hope this helps.

    Thanks.

    ZHU

  • Crystal Analyst Profile Picture
    55 on at

    Thank-you Amit for taking the time to assist. I will run a simulation on this, this afternoon.

  • Verified answer
    Crystal Analyst Profile Picture
    55 on at

    Dear ZHU

    Thank-you for taking the time to reply. This will really help allot, the screenshots you added also assist allot. If you every do bring out a Course in Microsoft AL please let me know as your knowledge of Microsoft AL is outstanding.

  • Crystal Analyst Profile Picture
    55 on at

    Dear Marco

    Thank-you for the links. www.yammer.com does not seem to be working, is the link correct or is it possibly a site problem?

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…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,132

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 675 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 665 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans