Add FKV Columns to List (Grid)

Dear experts, Please let me know how to add FKV columns in list (grid) view (i.e. without needing to write C# code) and which aren’t hidden in the collection.

For Example : In Bank Statement Processing how we have to add Bank Transfer “Tran Reference” column value in grid list which is not exist in the collection refer to below screen

This restriction makes this request Impossible.

Please let me know, how it is possible then.

There are some good forum posts on re-creating the grid with your additional columns using BAQ Views. That could get you started, and is pretty easy. Jose even made a video!

Grid views that add missing (not hidden) columns will have some level of code needed.

Also, have you read the Epicor ICE Customization User Guide? It’s invaluable, and you can download it from EpicWeb.

Follow an example, get it to work, then tweak it for your changes. Hope this helps!

1 Like

We have added the below mentioned code in script editor

EpiUltraGrid ugTransactions;
private BOReaderImpl _boReader;

public void InitializeCustomCode()
	ugTransactions = (EpiUltraGrid)csm.GetNativeControlReference("8100810c-d3ff-4d7b-acde-a12e8d4335ea");
	ugTransactions.DisplayLayout.Bands[0].Columns.Add("TranReference" ,"Tran Reference");
	ugTransactions.InitializeRow += new InitializeRowEventHandler(this.ugTransactions_InitializeRow);
	//_boReader = new BOReaderImpl (((Session)oTrans.Session).ConnectionPool);
	_boReader = WCFServiceSupport.CreateImpl<BOReaderImpl>((Ice.Core.Session)oTrans.Session, Epicor.ServiceModel.Channels.ImplBase<Ice.Contracts.BOReaderSvcContract>.UriPath);

public void DestroyCustomCode()
	ugTransactions.InitializeRow -= new InitializeRowEventHandler(this.ugTransactions_InitializeRow);
	_boReader = null;

private void ugTransactions_InitializeRow(object sender, InitializeRowEventArgs e)
		DataSet ds = _boReader.GetRows("Ice.BO.BankTran","TranNum ='" + e.Row.Cells["InternalNumber"].Value.ToString()+ "'","TranReference");
		if(ds.Tables[0].Rows.Count > 0 )
			e.Row.Cells["TranRef"].Value = ds.Tables[0].Rows[0]["TranRef"];

but system is throwing error

Anyone can suggest how to get TranRef column value from Erp.BankTran table using BOReeader

_boReader.GetRows(“Erp:BO:BankFundTranEntry”,“TranNum = '” + e.Row.Cells[“InternalNumber”].Value.ToString() + “’”, “TranRef”);