12

We wanted to use an entity InventWarehouseInventoryStatusOnHandEntity to expose data for our EDI solution however the entity exports 0 rows. Upon investigation and a lot of wasted time on customer and Microsoft side it was found/logged by Microsoft that Symptom: When exporting the data entity InventWarehouseInventoryStatusOnHandEntity from the Data Management Workspace, the entity exports 0 rows. Cause: This occurs when "Warehouse and Transportation" or "Catch Weight" keys are disabled. According to the Product group, If a data entity is composed of multiple data sources and one of them is disabled through a config key the entire data entity becomes disabled. The intent around entities is that they be used for integration scenarios with external applications. Those applications have no concept of, or business logic for, what to do when portions of a data entity are missing. Hence the entities are built with restrictions that require the configuration keys to be enabled. Suggestions are a warning or info message is displayed when an entity is exported and one of it's data sources has a configuration key that is disabled (therefore entity is disabled). This will save a lot of time investigating why this is happening/exporting no data. i.e. Configuration keys are disabled for a data source within this entity, no data will be displayed’ something like that. We are not the first people to have come across this, as it's previously logged by another business.

Category: Data Management
STATUS DETAILS
Needs Votes
Ideas Administrator

Thank you for your feedback.

We are not considering the suggestion at this time due to the following reason:

There is only one vote for this idea. Although, this is a fair ask, due to several competing work items, we will not be able to consider this until there is a larger ask. 

Sincerely,

Sunil Garg

Microsoft.

Comments

S

I have projects where we'd also like to turn off CW, because the workload for hiding/disabling CW fields system-wide is considerably larger than disabling CW configuration key is

Category: Data Management

S

Having a list of entities that return 0 due to configuration keys would be useful. CatchWeight is a horrible burden to have activated if you dont need it, is there no alternative for InventWarehouseInventoryStatusOnHandEntity and if not why would you activate that entity on CW, it makes no sense.

Category: Data Management

S

This is indeed a valid request. Have faced the exact same issue for the exact same entity and found this idea. Voting for it to be implemented please.

Category: Data Management