Refresh system matrix

[Former Member]

I have added a user defined field at the row level.I am performing some calculation on this udf in the goods receipt po form.I need to refresh this system matrix after performing calculations.Is it possible to refresh system matrix programatically ?

[former_member682029 · Accepted solution]

I think you cant refresh the system matrix after your calculations.

But you can do this

After calculations update the record and then restore the entire record using Find method.

If you are not looking for this, ignore this.

Thanks

Anoop

[Former Member]

Hi Dilip,

Anoop is right, there is no function for refreshing the matrix so you'll have to get around it like this:

1. Update the document

2. Freeze the form

3. Put the form in Find mode

4. Fill in the document number (docnum)

5. Programmatically click the Find button (OK button)

6. Put the form back in the mode it was before

7. Unfreeze the form

Regards,

Marnix

[Former Member]

Hi

If I'm not getting you wrong...you are doing some calculations on the udf and want to update the other columns based on this field value........

if yes then you have to do it manually by writing code on the lost focus of this new column...

Hope it helps

Thanks

[Former Member]

Hi Dilip Kumbhar,

for your convience its better to use the form freeze

Rgds

Micheal