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

Monthly Purchases Cue

(1) Share

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

Categories:

Dynamics 365 Business Central

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 74,036 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 12,290 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