News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Custom Role Center Til...

Small and medium business | Business Central, N...

Suggested answer

Custom Role Center Tile not showing the Correct Count

(0) Share

Report

Report

Posted on by Brett F

191

I have this tile that is supposed to show inventory picks that have a shipment date of today. The tile shows the wrong number, but when the tile is clicked to go the the list, the list correctly displays them. All of the other tiles show the correct counts. I'm at a loss as to what is wrong.

My code:

The tile in question:

The list, clearly showing more than 3:

Any ideas? Thank you

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Kamal Khakhkhar 299 on at

Like (0)

Report

Custom Role Center Tile not showing the Correct Count

Hii There.

As per your question you need to add below code in Table & Page as per requirement.

For page..

trigger OnOpenPage()

begin

Rec.Reset();

if not Rec.Get() then begin

Rec.Init();

Rec.Insert();

end;

Rec.SetRange("Date Filter", 0D, WorkDate());

Rec.SetRange("Date Filter2", WorkDate(), WorkDate());

Rec.SetRange("User ID Filter", UserId());

end;

---

For Table.

field(2; "Invt Pick Today"; Integer)

{

AccessByPermission = TableData "Warehouse Activity Header" = R;

CalcFormula = count("Warehouse Activity Header" where(Type = filter("Invt. Pick"),"Shipment Date" = field("Date Filter")

);

Caption = 'Invt Pick Today';

Editable = false;

FieldClass = FlowField;

}

- -

as per your page not getting any filter of 'Today' string.

Try as per this.

Thank You.

Kamal Khakhkhar.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2

Martin Dráb 230,188 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans