cancel
Showing results for 
Search instead for 
Did you mean: 

How to read system matrix

Former Member
0 Kudos
73

Sir,

A/P Invoice has 2 document type i.e Item/Service with a matrix item(38)

I am able to read all the columns of DocType Item using VB Code for data validation

" oEdit = oColumnsTemp.Item("112").Cells.Item(pVal.Row).Specific

temp = oEdit.Value "

But i am not able to real any of the columns of DocType Service using VB Code for data validation

I need ur kind help/support

Thanks & Regards

Rajesh B K

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Very very Thanks sir

Former Member
0 Kudos

Try with this as well:

For document fields

_form.DataSources.DBDataSources.Item("ORDR").GetValue("CardCode", 0);

For matrix lines

_form.DataSources.DBDataSources.Item("RDR1").GetValue("ItemCode", 0);

It's fastest way and efficient, using this.

Just let me know!

Cheers

Former Member
0 Kudos

Service Type document matirx has an itemID of 39.