unruly MatrixBox

gulamdastagir

hi

Scenario:Filtering Item Sales By Store using a MAtrix Form.
The Main Form SourceTable being Item and MatrixBox MatrixSourceTable being Store.

F7(field Filter) and Table Filter(Ctril+F7) dont work!.

Iam trying to filter only those items that have "sales Qty"<>0 on the Form.

Thanks in Advance

gulamdastagir

hi

Where is the master of matrixboxes,Kriki?

I tried putting the following Code in the Matrix-OnAfterGetRecord trigger

SETFILTER("Store Filter",CurrForm.Matrix.MatrixRec."No.");
CALCFIELDS("Qty. Sold (POS)");

QSP:="Qty. Sold (POS)"  ;
IF QSP=0 THEN NEXT;

It works but when i scroll through the records on the form i get a Message "Item cannot be modified in this Form"

gulamdastagir

hi

How to avoid getting this message

"Item cannot be modified in this Form"?

](*,) ](*,) ](*,)

Methos

I had the same problem when modifying values on the source table of the form the matrix control is on.
I managed to get rid of the error by adding a modify to the code after the values were updated.
Still not sure why the error occurred, or if this is the best solution but after some testing it seems to work.