Stock On Hand API with better performance for PowerBI

(0) Share

Report

Posted on by Samantha73

3,247

Hi All

I can create an API using item ledger entries to pull stock on hand by warehouse and lot number. However, since this table is quite large, I'm looking for options to create a better-performing API. One option is to filter at the source for ILE lines with remaining qty <> 0- is it possible to define filters at the API level?, another would be to create a flow field on the lot number but in BC there is no separate table for lot numbers. Looking for other suggestions

Thanks

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

Hi, The following info comes from AJ. I think you can add some filtering in OnOpenPage trigger.

More details: https://www.youtube.com/watch?v=5iRv0y0rVzw&t=47s

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No