'Field # must be filled in.' Issue when joining InventNonConformanceTable to additional form data sources

(0) Share

Report

Posted on by Cody M

Hi All,

I am attempting to add Vendor name to the InventNonConformanceTable form. I add VendTable as a data source to the form with 'join source' set as InventNonConformanceTable, and 'Link Type' as OuterJoin. I then add DirPartyTable as a Reference Data Source on VendTable.

This setup shows all the correct records and info that I expect. The issue is on records in InventNonConformanceTable that have no corresponding records in VendTable. When editing and saving these InventNonConformanceTable lines, I get errors on required fields in VendTable.

"Field 'Group' must be filled in."
"Field 'Currency' must be filled in."
"Field 'Vendor account' must be filled in."

From searching around, I think this has to do with Optional Record Mode being set to 'ImplicitCreate' on the VendTable data source. When I edit a row in InventNonConformanceTable and save, it is running some validation from VendTable, even though I have AllowCreate and AllowEdit set to No for VendTable. This property is greyed out and not able to be changed.

Some of our non-conformances will not have associated vendor accounts/names, and for those records we just expect those fields to be blank, which is achieved with the outer join above. Due to the validation above, however, we can't edit these lines.

Is there a proper way to skip the validations from VendTable, or am I joining incorrectly? Any help or suggestions are greatly appreciated. Thank you!

I have the same question (0)

All responses (7)

Answers (1)

GirishS 27,825 Moderator on at

Like (0)

Report

RE: 'Field # must be filled in.' Issue when joining InventNonConformanceTable to additional form data sources

Hi Cody,

Instead of adding a vend table as a datasource to the form, add a display method for vendor name which will avoid the above issue you mentioned.

Thanks,

Girish S.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

nunomaia 23 Moderator on at

Like (0)

Report

RE: 'Field # must be filled in.' Issue when joining InventNonConformanceTable to additional form data sources

If you need to only display information, you need to make data source as readonly to avoid inserting records when adding records to table InventNonConformanceTable.

If performance is not an issue, you use can a display method.

1 people found this reply helpful.

Was this reply helpful? Yes No
Cody M 55 on at

Like (0)

Report

RE: 'Field # must be filled in.' Issue when joining InventNonConformanceTable to additional form data sources

The reason I didn't do a display method was so that the field could be searched on and sorted.

The non-conformance records and fields should be able to be edited/created/deleted, but the fields from the joined VendTable I have set to read only because we don't want the records in VendTable to be changed or added.

Is this possible, to allow editing records on InventNonConformanceTable without inserting records into the joined VendTable or facing the validation logic on VendTable?

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

GirishS 27,825 Moderator on at

Like (1)

Report

RE: 'Field # must be filled in.' Issue when joining InventNonConformanceTable to additional form data sources

Create a new view with Vendtable as a datasource.

Add the newly created view as a datasource to the InventNonCoformanceTable - Add the relation between non conformance table and the view in the init method of view datasource using add link.

Try to add the vendor name from the view and check whether the error is throwing for your scenario.

This is just a workaround for your issue.

Thanks,

Girish S.

1 people found this reply helpful.

Was this reply helpful? Yes No
Martin Dráb 236,289 Most Valuable Professional on at

Like (2)

Report

RE: 'Field # must be filled in.' Issue when joining InventNonConformanceTable to additional form data sources

You can override validateWrite() and write() methods of VendTable data source to avoid saving. Don't call super(); write() should be empty and validateWrite() should always return true.

1 people found this reply helpful.

Was this reply helpful? Yes No
nunomaia 23 Moderator on at

Like (0)

Report

RE: 'Field # must be filled in.' Issue when joining InventNonConformanceTable to additional form data sources

Martin suggestion, you can find several references in standard code.

For example, in Sales Order avoiding to save in inventory dimensions.

1 people found this reply helpful.

Was this reply helpful? Yes No
Cody M 55 on at

Like (0)

Report

RE: 'Field # must be filled in.' Issue when joining InventNonConformanceTable to additional form data sources

I followed this suggestion from Girish using views and adding the relations and it worked great. Thank you!

1 people found this reply helpful.

Was this reply helpful? Yes No