Share
Report
534Hi Everyone,
I am trying to add a custom Data Source to the Inventory Transactions form (InventTransNew) using a Form Extension.
My goal is to add the SettleTransId field from my custom view (XXX_InventSettlementView) to the form’s Data Grid. The important requirement is that SettleTransId users can filter and sort by this column.
I followed the approach below, but I am getting the following error:
Query missing QueryBuildDataSource for FormDataSource XXX_DataSourceSettlement.
What I have done
1. Created a custom view
I created the following view:
XXX_InventSettlementView
The view contains the SettleTransId field that I want to display on the InventTransNew form.
2. Created a custom relation
I created a custom relation on the InventTransOrigin table with the following properties:
Cardinality: ZeroOne
Related Table:
XXX_InventSettlementViewRelated Table Cardinality: ExactlyOne or ZeroOne
Relationship Type: Association
Normal Relation:
InventTransOrigin.InventTransId == XXX_InventSettlementView.InventTransId3. Added a custom Data Source to the form
I added a custom Data Source called:
XXX_DataSourceSettlement
I also configured its properties as shown in the attached screenshots.
The problem
When I run the form, I receive this error:
Query missing QueryBuildDataSource for FormDataSource XXX_DataSourceSettlement.
I am not sure what I am missing in the Form Extension Data Source or View/Relation configuration.
Form : InventTransNew
Custom Data Source property: XXX_DataSourceSettlement
Could someone please guide me on how to correctly add this custom Data Source to InventTransNew so that the SettleTransId field is available in the grid and users can filter and sort on it?
Best Reagrds
All responses (
Answers (
