Auto Calculation Issue

[Questions King]

Hi all ,

I just make the [color:blue]Goods Receiving to my client, what I want to do is when they key in the [color:red]Cost or [color:red]Selling Price in GR, can I automatically update into my [color:blue]Stock Keeper Record field [color:red]Cost and [color:red]Selling Price?

Hope your understand, Thank for help!

test.zip

Edited October 19, 2006 by Guest

[John Mark Osborne]

It's a little confusing to me why you want to enter the same record in two different tables. Regardless, you are going to need a script to do this, not an auto-enter calculation. Look into using script parameters along with Set Field, Go to Layout and probably a few other script steps.

[Questions King]

John, first thank for reply!

What I mean is when I key in the cost field or selling price field, both of them can automatically update the last value into my stock keeper cost field and selling price field.

On my stock keeper cost and selling price field value still can make the change.

I try to use calculation:

Last(GRItem::Cost) - Can get the Last Price but I can't change the value at Stock Keeper because of caculation field.

Any way to go? Thank for reply....

[John Mark Osborne]

It is unlikely you wil be able to get an auto-enter calculation based on related fields to update properly when the related field is updated. Again, I would suggest a script.