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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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