Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Issue with formula Post Reply Post New Topic
Author Message
absiin
Newbie
Newbie


Joined: 07 Jan 2015
Location: United Kingdom
Online Status: Offline
Posts: 7
Quote absiin Replybullet Topic: Issue with formula
    Posted: 08 Mar 2015 at 11:54pm
Hi all :)

right i'm overlysuck with a VAT issue...

I've got a VAT table on my db and a historic VAT with every date the rate has changed on.

Now my issue is - invoices are being raised and the VAT field is coming from the main VAT db which only holds the current VAT rate but if I need to re-print an invoice that was raised before the change of VAT it doesn't take in consideration the date of the invoice...

Now i've tried creating a table with start and end date but that won't be dynamic given the fact it each time VAT changes it would have to be manually changed..

Anyone has any ideas on how could i do this?

Invoice     VAT
Vat Code ---> Vat Code

Invoice       VAT Historic
Inv Date ---> Vat Date
Vat Code ---> Vat Code

I'm confused as well..!

What I'm using is a formula field with this:

IF
{INVOICE.DATE} in Date({VATHIST.STARTDATE}) to Date({VATHIST.ENDDATE})
THEN
ToText ({VATHIST.RATE}) + "%"
ELSE
ToText ({VAT.VATRATE}) + "%"

And as I would expect, it doesn't work!
Dying over here guys! Any help would be immensely appreciated!
Absiin ~
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.029 seconds.