Can't add field to form from linked table in Advanced filter/sort

Finance and Operations/AX
1

Hi,
I am on AX 2012 (version 6.3.2000.326) and trying to add the Acquisition Price from the Asset Book table to the Fixed Asset List form (FA/Common/Fixed Assets/Fixed Assets). From the form I hit Ctrl + F3 which opens the Select Query window where I join the Fixed assets book table.

image

I then go to Personalize the form to try adding the Acquisition Price field, but the Asset book table doesn’t show as an option. What step am I missing here?

image
image742×553 81.2 KB

Since there is no AX in the category drop down I had to pick a D365 option so sorry for the confusion as this question strictly relates to AX 2012.

2

I believe that Personalization offers you fields from form data sources. The fact that you added a data source to to the query doesn’t have any impact on it.

3

You can add a table to the query behind a form and then select fields from the table you added to show on the form. I have done it before, but it was a long time ago (version AX2012) so I know it can be done and all through the front end. I didn’t have to do a thing in AOT.

4

I won’t believe it until I see it. There is no form data source that the field could bind to. QueryBuildDataSource added to a query isn’t the same thing as FormDataSource added to a form.

5

Hi, antzkool!

I agree with MartinDrab.

I’m afraid you can only add fields to form from the tables you see through personalization.

The fact that you can build more complex queries using Advanced Filter/Sort (Ctrl + F3) won’t bring more tables/fields available for adding to the form.