Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Canadians taxes conversion…
Message
From
04/02/2002 00:42:59
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00614654
Message ID:
00614656
Views:
18
>I am looking for a formula that can give me the amount of sale before tax.
>
>I have a amount and I know the rate of Canadians taxes ( GST and PST) and I like to found out was the amount before taxes for the GST and PST.
>
>Any one did this before?

Yes, I do it all the time. However, keep in mind that it may vary by 1 cent as you can't know if rounding was applicable.

Assuming This.Value is your value:
ThisForm.Cout.Value=ROUND(This.Value/1.15025,2)
ThisForm.Tps.Value=ROUND(ROUND(This.Value/1.15025,2)*.07,2)
ThisForm.Tvq.Value=This.Value-(round(This.Value/1.075,2))
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform