It would be nice if a Query object could reference a Setup table eg General Ledger Setup. This would allow us to create Queries to total G/L Account by Dimension Set while showing which Dimension Values make up the Dimension Set (Shortcut 1-8 only). It would make it easy to expose this information using Web Services.

Currently this is not possible because a DataItemLink is required, meaning there must be a matching field in each record.

This could be achieved by allowing the DataItemLink to be of the format DataItemLink = "Primary Key" = Const('');

Category: Development
Needs Votes
Ideas Administrator

Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future.

Best regards,
Business Central Team