Finance | Project Operations, Human Resources, ...

Error while opening Load planning workbench in D365 F&O

(0) Share

Report

Posted on by Rhushikesh R

758

Hi Everyone,

I am getting below error while opening Load planning workbench which is on path Warehouse management > Loads > Load planning workbench,

"Query missing QueryBuildDataSource for FormDataSource SOIntercompanyCompanyInfo."

I debugged the code and found that error has been thrown by super() call of executeQuery method of WHSInventTransSumDimSales dataSource of a form WHSLoadPlanningWorkbench

Can anyone please tell me the root cause of this error? Is it because of any missing setup?

I have the same question (0)

All responses (17)

Answers (0)

Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (1)

Report

RE: Error while opening Load planning workbench in D365 F&O

Hi,

Can you try to check if this feature is enabled?

Purchase order quantity left to load calculation using registered quantities

if yes, try to disable and check.

Was this reply helpful? Yes No
Rhushikesh R 758 on at

Like (0)

Report

RE: Error while opening Load planning workbench in D365 F&O

Hi Ramit, how can I check the feature mentioned by you? As I am a technical person, I have never done this setup anytime before.

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (1)

Report

RE: Error while opening Load planning workbench in D365 F&O

No problem, you can check this on your own.

docs.microsoft.com/.../feature-management-overview

Above is the simplified MS doc.

This is found in System admin module and from there you will see feature management workspace, check the enabled features from there and find out this one, disable and then run the process.

let me know if this helps

Was this reply helpful? Yes No
Rhushikesh R 758 on at

Like (0)

Report

RE: Error while opening Load planning workbench in D365 F&O

Hi Ramit, I just enabled 2 features,

1. Associate purchase order inventory transactions with load

2. Purchase order quantity left to load calculation using registered quantities

But that did not resolve my issue.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (1)

Report

RE: Error while opening Load planning workbench in D365 F&O

Hi Rhushikesh,

Is there any customization done here? I am not able to find any object here with a similar name. Can you go to the form and do a find reference?

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (1)

Report

RE: Error while opening Load planning workbench in D365 F&O

Hi, you need to disable this feature and then check,

Check this LCS BUG

https://fix.lcs.dynamics.com/Issue/Details?kb=4561702&bugId=445653&dbType=3&qc=ee6ce9644d433f5a0088388e65e8b2985d7c06d1e5309d7f731790f4af1061b9

Was this reply helpful? Yes No
Rhushikesh R 758 on at

Like (0)

Report

RE: Error while opening Load planning workbench in D365 F&O

Hi Gunjan, yes I just verified. There is customization on this form. May be that is causing error. Thanks. I will be verifying the answer soon.

Was this reply helpful? Yes No
Rhushikesh R 758 on at

Like (0)

Report

RE: Error while opening Load planning workbench in D365 F&O

Hi Ramit and Gunjan, can you guys help me to resolve the issue. I found the similar thread below,

https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/237026/query-missing-querybuilddatasource-for-formdatasource

In which Martin has replied that,

My scenario is same, I have added one data source into WHSLoadPlanningWorkbench named SOIntercompanyCompanyInfo which might be causing the error.

How can I resolve this?

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (1)

Report

RE: Error while opening Load planning workbench in D365 F&O

Hi Rhushkesh,

How have you joined the new datasource? Have you mentioned a link between the WHSInventTransSumDimSales datasource and this new data source?

If you haven't, you can check into modifying the linkActive method to specify the link. You can follow this post as a reference. Though it is for AX 2012, it should still work for D365 F&O.

Was this reply helpful? Yes No
Rhushikesh R 758 on at

Like (0)

Report
RE: Error while opening Load planning workbench in D365 F&O

Actually below is the data source property, Outer Join with the SalesTable,

And below are the extension classes, which have been developed by third party developer,

//CUS, SIFormRefactoring_NW, 19-06-2020, NikhilW [ExtensionOf(formDataSourceStr(WHSLoadPlanningWorkbench, SOIntercompanyCompanyInfo))] final class SIWHSLoadPlanningWorkbenchForm_SOIntCompInfoDS_Extension { public void init() { next init(); this.queryBuildDataSource().clearLinks(); this.queryBuildDataSource().clearDynalinks(); this.queryBuildDataSource().addLink(fieldNum(SalesTable, InterCompanyCompanyId), fieldNum(CompanyInfo, DataArea)); } }

//CUS, SIFormRefactoring_NW, 18-06-2020, NikhilW [ExtensionOf(formDataSourceStr(WHSLoadPlanningWorkbench, WHSInventTransSumDimSales))] final class SIWHSLoadPlanningWorkbenchForm_WHSInventTransSumDimSalesDS_Extension { public void executeQuery() { QueryBuildRange partialSalesQbr; FormCheckBoxControl ShowPartialSalesOrders = this.formRun().design().controlName('ShowPartialSalesOrders'); partialSalesQbr = element.parmPartialSalesQbr(); //Change description: Adding range for partial fulfillment of sales orders if (WHSParameters::find().CHI_DoNotAllowPartialShipment) { partialSalesQbr.value(ShowPartialSalesOrders.value() ? enum2str(NoYes::No) : enum2str(NoYes::Yes)); } next executeQuery(); } }

Was this reply helpful? Yes No