Sam - MacAmbulance wrote on 30/11/08 at 19:07 >I had the same problem, because all the calculations were unstored and >based on a single global value. I added a field for each invoice item >and purchase order item which when created looks up the global vat rate >and copies itself in from there. The calculations remain unstored but >are then based on the value of the vat rate per invoice, which is in >turn based on the global vat rate. Changing the vat rate only applies >to new invoices.
I was going to suggest using the tick box for storing calculations. If that doesn't work or you don't trust it, you could possibly create two separate calculation fields one for the old value and one to the new and select it by whatever date the invoice is sent (or whatever). That's the trouble with distant database management -- you have to know the other fields to see what the options are. (This small change in VAT is probably going to cost everybody millions in work hours, pulping catalogues, arguments at the checkout... they could at least have made a decent cut in it!) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Sussex Mac User Group" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/smug?hl=en-GB -~----------~----~----~----~------~----~------~--~---
