Jump to content
Sign in to follow this  
milky

Updating a calculation.

Recommended Posts

Hi all,

I have a problem.

How do I make the following calculation update?

If((TaxCode="GST")Invoice/11;0)

If the Tax Code previously was set for FRE as an example and then changed to GST at a later date, I would like the calculation to automically occur. It only calculates on new invoices not existing ones.

CIA

Milton.

Share this post


Link to post
Share on other sites

Well it's a calc - but it needs to reside inside an autoenter field. For autoenter values are an option box where you check if the calc' continuously evaluates, or it's a once and for all in the records lifetime - the feature you're after is also known as lookups. This means that the older invoices doesn't change if a tariff alters.

So it actually to opposite way around, data of historic value should be stored locally in each itemline, while the update of calc'fields and summary fields should be used where the issue isn't established until an event requires it.

If you were to make vat tariffs unstored values, would you as developer be called in each time the rates changes by adding new conditions into the calculations def.

Try to investigate how old women like Ralph and I would structure the task:

http://www.filemakerpros.com/joinprint.zip

...where you should pay attention to how the value of price is established in the join table as a historic fact, instead of letting all invoices flow with the price fluctations...

--sd

Edited by Guest

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.