Bind data in Outgoing Payment matrix

[Former Member]

Hi everybody,

I placed a user field (combo type) in the matrix of Outgoing Payments form.

When i select a Bussiness partner, this field must be completed with the value of the table in fact (may be OPCH or ORPC).

I try to bind the field in the ChooseFromList event (Before Action = False), but the problem is that the invoice are not load yet and nothing happens.

In which event can i put the code to bind this data??

Edited by: Rui Pereira on Dec 23, 2008 2:57 PM

[Former Member]

Hi Again,

I found how to do this with a Formatted search:

SELECT U_TGV_ACC_SAL_LIQ From OPCH Where docnum = $[$20.1.0] and 18 = $[$20.45.0]

union

SELECT U_TGV_ACC_SAL_LIQ From ORPC Where docnum = $[$20.1.0]

and 19 = $[$20.45.0]

but i can`t do the refresh of each cell of the column...can anybody tell me how can i refresh the data!!

Thanks!!

Edited by: Rui Pereira on Dec 23, 2008 2:53 PM