Hi Team,
I’m trying to add column in FS305700 ( schedule tab) to display below TranDesc column from FS305100.
Irrespective of the entries, it should display only the first line of TranDesc. Can someone help here, how to achieve this.
Solved
Display column
Best answer by aaghaei
I assume you mean by code customizations. So, you will need to
- add a Custom string field to the target DAC Ext. If you want to be able to modify and save changes in the target DAC use DB field otherwise if it is just for display purpose then unbound field will do the work.
- add a FieldSelecting event to the Graph Ext for the new Custom Field to retrieve the data from the source table and display. If you want to always bring the first record you can append your select query by .FirstOrDefault() or .SelectWindowed(Graph, 0, 1, [params])
+10I assume you mean by code customizations. So, you will need to
- add a Custom string field to the target DAC Ext. If you want to be able to modify and save changes in the target DAC use DB field otherwise if it is just for display purpose then unbound field will do the work.
- add a FieldSelecting event to the Graph Ext for the new Custom Field to retrieve the data from the source table and display. If you want to always bring the first record you can append your select query by .FirstOrDefault() or .SelectWindowed(Graph, 0, 1, [params])
Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.