Dynamics Community Forum Thread Details

"Query has invalid datasource" error when creating production orders

Hi,

The message “Query has invalid datasource” when creating a production order is typically triggered by one of the following in D365 Supply Chain/FO:

1) Saved view / personalization conflict on the Create production order form

A saved view can inject a stale or conflicting query for the page and cause “invalid datasource” errors. Try:
- Switch to the Standard view (view selector), then try again.
- Clear personalizations for the form (User options → Personalization → Clear for this page) and re‑open.
- If your org publishes views, ask an admin to temporarily unpublish the view for this form to test.
  
  Saved views can override the default query and sometimes conflict with pages that already preload filters; Microsoft documents behavior and known caveats for saved views. [1][2]

2) Usage data or cached query corruption

Clear Usage data (User options → Usage data → Clear). Several similar list‑page query issues are resolved by resetting usage data. (Community threads frequently point to usage data when a problem reproduces only for some users.) [3]

3) Recently added form/query extensions or security differences in PROD

If you recently extended a form or added a data source to a query, ensure the form data sources match the underlying query the form/menu item uses, and that joins/links are valid. Mismatches or added data sources in extensions can throw “required/invalid datasource” errors; also check that the same extension build is deployed to this environment and compiled/synchronized. [4][5]

4) Menu item / query differences between environments

It can work in lower environments if the menu item there doesn’t carry a query, but fail in another environment where the menu item (or a cue/related menu) still references an older composite query. Compare the menu item and query artifacts across environments and refresh the form’s query binding if it was modified. [6][7]

Quick triage checklist

Open the form, select Standard view → retry. If OK, the issue is the saved view; rebuild/publish a clean view. [1]

Clear usage data and retry. [3]

Test with another user or a test account (different role) to rule out role‑published views and security differences. [1]

If you have recent customizations, verify the form/query extensions: added data sources, link types (Join vs Link), or event handlers that alter the query. Ensure the query contains the data sources the form expects. [4][5]

If this started after a platform update, install the latest quality update (PQU) for 10.0.44 or consider updating to the next version, as suggested in similar cases. [3]

If the error persists after these steps, capture a short trace of the failing action and check the infolog/exception stack in the browser developer tools; then compare the Create production order form behavior across environments with identical users/roles.

If this helps resolve the issue, please validate the reply on the thread so others can find it.

Thanks and best regards,

Daniele

Note: This response was prepared with support from Copilot to ensure clarity and completeness.

References

[1] Saved views - Finance & Operations | Dynamics 365 | Microsoft Learn

[2] The view query has been overridden because of a conflict.

[3] Dynamics Community Forum Thread Details - Dynamics 365 Community

[4] Add data sources to forms through extension - Finance & Operations ...

[5] Query missing QueryBuildDataSource for FormDataSource InventTable.

[6] axapta - The required QueryBuildDataSource was not found in the Query ...

[7] How to Update the Data Source on a ListPage in Microsoft Dynamics AX

Quick Links