News and Announcements icon

Dynamics 365 CommunityForums Business Central forum API with filtering and...

Business Central forum

Suggested answer

API with filtering and summary

(0) Share

Report

Report

Posted on by Samantha73

2,216

Hi All

I want extract item ledger entries where the quantity is summarized by the item. However the summary should happen after filtering the posting date to end of last month. I know Query object has SUM method however the issue is we need another filter for the date. Assume we only have 2 items then total quantity as at EOM last month :

Item Qty Tot

Chair A 100

Chair B 200

Thanks

Categories:

Reports and Business Intelligence

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 68,395 Super User 2024 Season 2 on at

Like (0)

Report

API with filtering and summary

Hi, hope the following helps.

Dynamics 365 Business Central: Using the Date Method to retrieve only the Day, Month, and Year Data in Queries [Group by Year-month]

https://yzhums.com/14547/

Thanks.

ZHU

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 228,089 Super User 2024 Season 2

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans