et_matrix_load event

[Former Member]

Hi all,

I would like to initialize a UDF in Matrix in A/P Invoice (Form 141),

Here is my code in ItemEvent:

If pVal.FormType = 141 and pVal.EventType = SAPbouiCOM.BoEventTypes.et_MATRIX_LOAD Then

oMatrix = SBO_Application.Forms.Item(pVal.FormUID).Items.Item(pVal.ItemUID).Specific

For i As Integer = 1 To oMatrix.RowCount

oEditText = oMatrix.Columns.Item("14").Cells.Item(i).Specific

Dim Price As Double = oEditText.Value

oEditText = oMatrix.Columns.Item("NewPrice").Cells.Item(pVal.Row).Specific

oEditText.Value = Price

Next i

End if

But it didn't work, anyone can help?

Thanks

[Nussi · Accepted solution]

Hi,

et_MATRIX_LOAD is for Userdefined Objects and not for System Forms

you can try to use the

et_FORM_DATA_LOAD

event

lg David

[Former Member]

hi,

why dont u use FMS in GRPO so, that what ever the quantity given in Col"11" will be placed in your new quantity column.

now if you use "CopyFrom" from GRPO to A/P Invoice even user fields fills automatically.

this helps you.

regards,

varma

[Former Member]

thanks for your reply.

I've already used the FMS for lookup purpose, so I need to achieve this through coding.

[Former Member]

Hi,

please explain about your requirement in detail. do you want copy of price details in another user defined column? in which stage? apart from Add mode all matrix details are non editable in A/P invoice..

hi folks, if am not correct let me know..

Regards,

Ganesh k

[Former Member]

thanks for your reply.

In A/P Invoice, select "Copy From - Goods Receipt PO'.

In the matrix row, I added a UDF named "New Quantity", now I want to default the value to "PCH1.Quantity" when the matrix data load.

I have tried et_matrix_load and et_form_data_load, but didn't work.

thanks