These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Expense Form

Forum Index > Forms: LiveCycle Designer > Expense Form
2009-12-07 12:21:12
gplans
Registered: Dec 7 2009
Posts: 13
Answered

I am trying to create an expense for for my company and the LiceCycle formcalc is very new to me. I am not sure what method to use the Java script or the calc method. Anyway I cannot get either to work.

I would like the form to automatically calculate the amount before the tax. So the user needs to insert the Total amount of the receipt, and add the 5% GST if the item will be taxed GST.

I would like all the Total amount to be added at the bottom of the form.

I have attached a link to the form if anyone would like to have a look.

http://www.4shared.com/file/167463346/497b456a/Expense_form_V10.php

gplans [at] gmail [dot] com

My Product Information:
LiveCycle Designer, Windows
Top
2009-12-07 13:26:00
#1
pforms
Registered: Nov 17 2009
Posts: 87
Check the sample purchase order template that ships with LiveCycle. It's exactly what you need. I looked at your sample and you have a number of issues that the sample will resolve
Top
2009-12-07 15:40:18
#2
gplans
Registered: Dec 7 2009
Posts: 13
I tried again but I am new at this and it is not working for me. Thanks for looking

http://www.4shared.com/file/167590791/3e01edc2/Expense_V11.php
Top
2009-12-08 11:34:16
#3
xrum
Registered: Feb 25 2009
Posts: 124
i don't really understand what you want to be done.

but, if your amount is pre-tax, GST is the 5% tax and the total is everything together, then the form is attached.....

http://www.gigasize.com/get.php?d=m545yywbygd
Top
2009-12-08 13:08:51
#4
gplans
Registered: Dec 7 2009
Posts: 13
That is just about right except that sometimes an item will be charged with GST and sometimes it will be exempt. So the only way I can see it working is if I put the total amount in first then if there is GST I type that in. So the amount (first box) would = Total - GST. The total would be added up below.

Thanks for helping.
Top
2009-12-08 13:13:23
#5
pforms
Registered: Nov 17 2009
Posts: 87
The Purchase Order sample handles sales tax in a manner that'll work for GST. When GST is included, the user checks a box that triggers the 5%.
Top
2009-12-08 13:26:57
#6
gplans
Registered: Dec 7 2009
Posts: 13
Ya that would work but I unfortunately would not know how to build that into the form.

G
Top
2009-12-08 13:55:36
#7
xrum
Registered: Feb 25 2009
Posts: 124
see the checkbox on the very right, if it's checked, GST is included.

http://www.gigasize.com/get.php?d=kpx64tsg0hb
Top
2009-12-08 14:13:42
#8
gplans
Registered: Dec 7 2009
Posts: 13
Hay thats great! Thanks guys
Top
2009-12-10 10:55:32
#9
gplans
Registered: Dec 7 2009
Posts: 13
xrum wrote:
see the checkbox on the very right, if it's checked, GST is included.http://www.gigasize.com/get.php?d=kpx64tsg0hb
I was a bit too hasty when I thought it might work. It has to work backwards, the total has to be inputed first. This being because the employee then has to decide if there is GST or not. The amount has to be calculated using formulas because this amount will include PST or it will not. If you look at receipts in British Columbia it has the amount, GST (If applicable), PST (If applicable), then Total. The finance department is only concerned with the total amount owed to you and the GST that they can claim back from the government.

Also the totals at the bottom were not totalling.

Cheers

http://www.4shared.com/file/168514700/d … e_V12.php
Top