News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Monthly Purchases Cue

Business Central forum

Suggested answer

Monthly Purchases Cue

(1) Share

Report

Report

Posted on by David Tailor

751

Hello,

i have created this query to add Monthly Purchases Cue to the role page:

i got the following error from Business Central:

Notes:
1- DataRangeFilter message = "01-09-24..30-09-24".

2- if i hardcode the line: Posting Date = filter('DataRangeFilter'); -> Posting Date = filter('01-09-24..30-09-24), the cue is showing correct amounts.

3- filtering on posting date with ('CM') showed blank cue.

kindly advise,

Regards,

David

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 70,191 Super User 2024 Season 2 on at

Like (1)

Report

Monthly Purchases Cue

Hi, As far as I know, there is no way to set variables here. And what you have above is fixed text, not the variable defined below. So no value is passed in. . .

Hope the following can give you some hints.

Filtering in Query objects - Business Central | Microsoft Learn

Thanks.

ZHU
Suggested answer

gdrenteria 9,942 Most Valuable Professional on at

Like (1)

Report

Monthly Purchases Cue

Hi

I hope this can help you: Solved: Unable to Generate EFT File (dynamics.com)

Best

GR

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,570 Super User 2024 Season 2

#2

Martin Dráb 228,683 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans