SalesTableListPage Form in Insert column on grid i will be not getting a custom field from a child table(custom) of salesTable

(0) Share

Report

Posted on by Yogesh G

how we can add custome data source so that user can get it on insert column option, I have already added that data source on salestable form also tried with checking salestable list page query please suggest something

Categories:

Development / Customization / SDK

All responses (13)

Answers (1)

GirishS 27,799 Moderator on at

Like (0)

Report

RE: SalesTableListPage Form in Insert column on grid i will be not getting a custom field from a child table(custom) of salesTable

Definition of Outer join will return all rows from the 1st table irrespective of matching records in the second table.

Records will be displayed in the form from the 1st table even if there is no matching records in the second table.

Thanks,

Girish S.
Yogesh G 20 on at

Like (0)

Report

RE: SalesTableListPage Form in Insert column on grid i will be not getting a custom field from a child table(custom) of salesTable

Hi Girish, Its showing on insert column grid by making it outer join, initially it is active does it make any other impact by changing this property?

Thank you
Verified answer

GirishS 27,799 Moderator on at

Like (0)

Report

RE: SalesTableListPage Form in Insert column on grid i will be not getting a custom field from a child table(custom) of salesTable

Hi Yogesh,

Try setting the join source of custom table on form datasource to "Outer join" and check whether its showing custom fields in insert column grid.

Thanks,

Girish S.
Yogesh G 20 on at

Like (0)

Report

RE: SalesTableListPage Form in Insert column on grid i will be not getting a custom field from a child table(custom) of salesTable

Sales Ledger -- Plan Order -- All Plan Order
Komi Siabi 12,364 Moderator on at

Like (0)

Report

RE: SalesTableListPage Form in Insert column on grid i will be not getting a custom field from a child table(custom) of salesTable

[quote user="Yogesh G"]the form is plan order only but when we go to plan order form it indicates to salestable list page[/quote]
I do not seem to understand this please. Can you tell me how to navigate to the plan order form you are referring to? I went through master planning and it is quite different from your screenshot.
Yogesh G 20 on at

Like (0)

Report

RE: SalesTableListPage Form in Insert column on grid i will be not getting a custom field from a child table(custom) of salesTable

yes
Arunraj Rajasekar 1,729 on at

Like (1)

Report

RE: SalesTableListPage Form in Insert column on grid i will be not getting a custom field from a child table(custom) of salesTable

Does the custom child table have a proper label?
Yogesh G 20 on at

Like (0)

Report

RE: SalesTableListPage Form in Insert column on grid i will be not getting a custom field from a child table(custom) of salesTable

Yes, Personalisation we looking on salesTable form and that child table is part of that form datasource
Yogesh G 20 on at

Like (0)

Report

RE: SalesTableListPage Form in Insert column on grid i will be not getting a custom field from a child table(custom) of salesTable

On SalesTable form the fields are refllecting correct only but we need that on grid control insert column option So looking for that
Yogesh G 20 on at

Like (0)

Report

RE: SalesTableListPage Form in Insert column on grid i will be not getting a custom field from a child table(custom) of salesTable

yes its correctly linked but it not showing