How to add view filed to form datasource?

(0) Share

Report

Posted on by Shooowtek

723

Hello,

The business requirement is this: I need to add some fields from SalesLine and from CustTAble, resulting from a sales order, to InventOnHandItem forms.
These fields must be sortable and filterable, so display fields are not an option.

I found an article on how this can be with views: https://14-dynamics365.com/2021/07/28/how-to-create-a-filter-on-display-method-using-view-d365-fo/

So I created a view with salesLine as the main data source and put it as an additional data source in the InventOnHandItem form and insert InventDim as join source:

I then created a relationship with my view in the InventDim table:

After adding fields from salesLine, only the value on the first record is visible. The rest are empty.
In addition, the rest of the records are duplicated. My guess is that this is the fault of a bad relationship between the table and the view.

Could someone suggest what relationship settings would be correct for my problem?

All responses (4)

Answers (0)

André Arnaud de Cal... 291,240 Super User 2024 Season 2 on at

Like (0)

Report

How to add view filed to form datasource?

Hi Shooowtek,

I do concur with Martin about a wrong technical approach. What is the reason for this requirement? You talked about a business requirement, but this only mentioned a technical approach (need to add fields) and not what the client needs to achieve. Why does the client need these fields? If it is for tracking purposes, the client can start from the serial numbers form and then go to the related inventory transactions to find the sales order and customer (party).
Martin Dráb 230,149 Most Valuable Professional on at

Like (0)

Report

How to add view filed to form datasource?

Okay, let's say you look for quantity of item A in warehouse W. There are InventSum records related to to twenty sales order lines from five customers, but they're all summarized together, because we're looking at quantity in the warehouse W regardless of serial numbers.

What customer name do you want to show in such a case?

I believe the answer is: there is nothing to show. The requirement doesn't make sense.
Shooowtek 723 on at

Like (0)

Report

How to add view filed to form datasource?

Hello Matin,

In this client, there is a modification that, when creating an InventDim entry resulting from a sales order, inserts the value of SalesLine.InventTransId in InventDim.InventSerialId.

And on this principle, I would like to add, for example, a customer name for a record whose InventSerialId exists SalesLine.InventTransId.

I can easily do this with a field of display type. But the key customer requirement is the ability to filter and sort.

I am looking for a solution to my problem. Is it possible to do this?
Martin Dráb 230,149 Most Valuable Professional on at

Like (0)

Report

How to add view filed to form datasource?

The on-hand quantity form shows inventory quantities aggregated by inventory dimension. Your attempted solution ignores the aggregation and also the fact that on-hand quantity doesn't have to be related to sales orders. Also, the Delayed link doesn't meet your requirements.

You'll need to completely rethink your approach.

An important question is: why exactly don't you use inventory dimensions? Aren't they there for this purpose?

How to add view filed to form datasource?

Helpful resources

News and Announcements

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Community AMA December 12th

Leaderboard

Featured topics

Product updates

How to add view filed to form datasource?

Helpful resources

News and Announcements

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Community AMA December 12th

Subscribe to

Leaderboard

Featured topics

Product updates