Supply chain | Supply Chain Management, Commerce

Additional column to improve filtering functionality on the On-Hand screen

(2) Share

Report

Posted on by BibinTV

Hi Team,

I’m planning to add an additional column to improve filtering functionality on the On-Hand screen. Could you please suggest the best approach for implementing this? If possible, sharing some examples code or references would be greatly appreciated.

Required column is "Item Group"

Thanks in advance for your help!

Screenshot

Best regards,
Bibin TV

Categories:

Dynamics 365 Supply Chain Management

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Adis 6,686 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Moved to SCM and adjusted category.

Kind regards, Adis

If this helped, please mark it as "Verified" for others facing the same issue

Keep in mind that it is possible to mark more than one answer as verified

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 239,451 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

The best example is the actual implementation - look into addFilterPaneRanges() method to see how Microsoft added ranges from your screenshot. You can use CoC to extend the method and add your range there.

Was this reply helpful? Yes No
BibinTV 75 on at

Like (0)

Report
Copy link

Link copied!
Hi Martin,

Thank you

Following your suggestion, I've used this code, but the column isn't visible in the form. See the screenshot for reference. I tried to insert but not available.

Code

[ExtensionOf(formStr(InventOnhandItem))] final class AFZInventOnhandListPage_ItemGroup_Extension { protected void addFilterPaneRanges() { next addFilterPaneRanges(); QueryBuildDataSource inventTableQbds = InventTable_DS_DS.query().dataSourceName(InventTable_DS_DS.name()); SysQuery::findOrCreateRange(inventTableQbds, fieldNum(InventItemGroupItem,ItemGroupId)); } }

Was this reply helpful? Yes No
Martin Dráb 239,451 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You have a bug there - the field you're trying to use doesn't belong to the data source. If you want to filter by fields of InventItemGroupItem table, you need a query data source for InventItemGroupItem. You're currently using InventTable data source, therefore your code is adding a filter to a field of InventTable that has the same ID as ItemGroupId field has in InventItemGroupItem table. That's clearly not what you want.

You need to join InventItemGroupItem to InventTable and add the range to InventItemGroupItem. You can either add a regular form data source and set the join in the designer, or you can modify just the query at runtime (by using adding QueryBuildDataSource by addDataSource()).

Was this reply helpful? Yes No
BibinTV 75 on at

Like (0)

Report
Copy link

Link copied!
Hi Martin,

I have applied the change you suggested. Kindly see the below.

Code

protected void addFilterPaneRanges() { next addFilterPaneRanges(); QueryBuildDataSource inventItemGroupItemQbds = DsInventItemGroupItem_ds.query().dataSourceName(DsInventItemGroupItem_ds.name()); SysQuery::findOrCreateRange(inventItemGroupItemQbds, fieldNum(InventItemGroupItem,ItemGroupId)); }

New Data Source

Properties

Still the field is not added to the filter

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 239,451 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
It works fine for me:

I used an exists join. Using an outer join is wrong, because it wouldn't filter out anything. And we don't display any data, therefore an exists join is sufficient.

This is my code:

protected void addFilterPaneRanges() { next addFilterPaneRanges(); SysQuery::findOrCreateRange( InventItemGroupItem_ds.queryBuildDataSource(), fieldNum(InventItemGroupItem, ItemGroupId)); }

I've just simplified yours a bit.

Was this reply helpful? Yes No
BibinTV 75 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,
I attempted a full rebuild and cleared the cache, but the issue persists—the filter still doesn't appear on the form.

Was this reply helpful? Yes No
Martin Dráb 239,451 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Will you see the same if you switch to the default view?

If you can see any reason, you can debug the code to see when the range disappears from the query.

Was this reply helpful? Yes No