Dynamics Community Forum Thread Details

Dimension Filtering

Is there a generic extensibility point to filter Shortcut Dimension 1–8 lookups based on the current G/L Account?

I am developing a Business Central extension where Shortcut Dimension values should be filtered based on allowed values configured for the selected G/L Account.

The filtering should apply anywhere Shortcut Dimensions 1–8 are entered, including sales lines, purchase lines, general journals, and potentially other standard pages.

I can implement this using page extensions and the individual LookupShortcutDimCode logic/events available on each page, but this would require modifying a large number of pages.

Is there a more generic extensibility point in standard Business Central that can intercept or modify the lookup/filter for Shortcut Dimensions 1–8 regardless of which page initiated the lookup?

Ideally, I would like to centralize the filtering logic in a codeunit and avoid creating page extensions for every page that exposes ShortcutDimCode[1..8].

Has anyone implemented something similar, or is page-by-page extension currently the only reliable approach?

Categories:

Dynamics 365 Business Central

Hello,

As far as standard Business Central extensibility goes, there is no single generic event that lets you intercept every Shortcut Dimension 1–8 lookup and apply a filter based on the current G/L Account regardless of the calling page. The common dimension logic is centralized mainly in codeunit Dimension Management, but the actual shortcut-dimension lookup is still initiated from the specific source record/page, such as Sales Line, Purchase Line, Gen. Journal Line, etc., through their own LookupShortcutDimCode logic. So for a reliable solution, you normally need to subscribe to the available table/page events for each relevant source or extend the pages where no suitable event exists, while keeping the actual filtering rules centralized in one codeunit. Also note that standard Default Dimensions and Dimension Value Posting rules can restrict which dimension values are allowed for a G/L Account at validation/posting level, but they do not provide a universal lookup filter across every Shortcut Dimension field.

Regards,
Oussama Sabbouh

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS