Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Canadians taxes conversion…
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00614654
Message ID:
00614656
Vues:
19
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform