API with filtering and summary

(0) Share

Report

Posted on by Samantha73

2,437

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:

Business Central

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 73,565 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