Transactions in sequence in data grids

To make transactions in sequence work seamless in data grids, without displaying extra lines from the transactions you do not want to see records for, you need to configure which transaction output data should be included on the component. To configure this, open the configuration of the data service where you use transactions in sequence. Edit the transaction which output you don't want to display on the component.

On the Properties tab, select Exclude transaction data from output check box. When you open the configuration of the component the transaction is connected to, you cannot add output fields from that transaction. However, you can still use the transaction in sequence with other transactions within the same data service.

For example, you have one data grid listing agreement invoice rounds, using a data service called List_Rounds, and another data grid called DataGrid_AgrInvLines listing lines for the selected agreement invoice round. The DataGrid_AgrInvLines data grid uses a data service called List_InvRoundLines. List_InvRoundLines consists of two transactions, List_RoundHeader and List_RoundLines.

To be able to list the lines, you need to use the invoice round number from List_Rounds as input to the List_RoundHeader transaction, which gives you the order number. The order number is then used as input to the List_RoundLines transaction, which displays the data you want to see. However, you do not have to list data from theList_RoundHeader transaction in your data grid, only data from List_RoundLines.

To configure this, open the configuration of the data service List_InvRoundLines, and click the edit icon for the List_RoundHeader transaction. On the properties tab, select the Exclude transaction data from output check box. Once this is selected, the data from the List_RoundHeader transaction is not available to display as output in DataGrid_AgrInvLines, but the data is still available to use as input to List_RoundLines.

Now, when you add output fields to DataGrid_AgrInvLines, you can only add fields connected to the List_RoundLines transaction. This way, you only see data connected to List_RoundLines, and do not get empty or strange lines in the data grid from the transaction List_RoundHeader.