how can i update Matrix (order lines) by datasource

[Former Member]

hi,

i want to update some values in order lines (quantity and user fields).

There are many problems:

1. odbdatasource.setvalue("quantity",0,200) is not possible

2. i can change the value by using omatrix.columns.item("11").cells(irow).specific.string=200,

but the availability check is coming up.

3. if i fill user defined values in my matrix, i have to display these fields (i hoped that this would not be necessary if i can set the value by datasource)

thanks

Markus

[Former Member]

Markus,

its pitty, but you have no more possibilities on system forms.

1. odbdatasource.setvalue("quantity",0,200) is not possible

- no its not possible

2. i can change the value by using omatrix.columns.item("11").cells(irow).specific.string=200,

but the availability check is coming up.

- the check you cannot disable, because the docuemnt header values and vat, total prices on lines are recalculated eachtime you change some fields. I dont think that is other solution with UI (maybe with DI, get values from lines, create docuement with necessary changes with DI and save it as draft and show this draft in SBO, but many blinking in sbo will be visible).

3. if i fill user defined values in my matrix, i have to display these fields (i hoped that this would not be necessary if i can set the value by datasource)

- you may move to the form this UDF somewhere outside the visible area (negative x coordinate) and fill the value there