In South Africa our VatRate increases from 14% to 15% on the 1st April. In my Vat table there are 9 Vat Codes or Catagories. 4 which will have rates and 5 that will have a zero rate since it is Zero rated items and Exempted items. It is the first time since VAT came in 24 years ago that there is a change. Developers are scrambling right now. I want to learn how my application can do what I want it to. I want:
a. Invoices up to now is connected to those records, I cant see changing those records.
b. 4 records is going to be added to the 9 there. The Vatcode is going to be the same for the 4 that change.
c. But the rate will change from 14% to 15% and there is a "StartDate11" field.
d. For my customers using my app I want them to simply enter another record in Table t02VatRate and things must be right if there is a change in future again.
e. It would have been a solution if I could find the way to filter a query to show 9 records with the newest in Startdate11 against Vatcode. Pbaly has given me a way to result in a query with the needed records, but the query is not updatable, and I can not use that for the invoices. A few of you guys has tried to help me, but no luck yet. I am trying again.