Flowfield Lookup Calculation

madm

I want to create a "second" standard cost against the item. This will be made up as :

"standard cost" - A - B

I have set up a new table which contains a and b with appropiate values.

On the item card, i have assigned 2 new field looking upto the new table, so that the user can select the entries. Rather than insert the rate, I have added lookup flowfields to find the rate (which = the selected entry in a / b). This way, if a/b values change, this can be done in the table and this will be reflected on the item card. This works fine. However, I am a little confused of how to do the new standard cost calculation..

I can put the formula in on the validate sections of standard cost, a, b which *does* work, however, if we were to change the value of a/b, then although the item fields update, the calculation does not. What is the best way to enter the new standard cost calcuation so that the field always shows correctly?!

ara3n

Add a new text box to the card for sourceexp add a "standard cost" - A - B

Miklos_Hollender

Or rather a new function in the table, because then you can just call it on a form, report, whatever as Item.NewStandardCost.