M
Meredith9053
Quick one - for those of you who know what to do that is!
Calculating report totals for an Invoice.
General stuff. Got Page Header, Order id header and detail all working as
planned. Need to work out order id footer.
What I would like is Subtotal of the body of order - which I have done. Text
box control source =Sum[ExtendedPrice]
Then would like to:
Add Freight of 10% (say $10 - order total is $100) Want to see just $10 in
this box.
Add Subtotal (want to see $110)
Add GST (australian tax) 10% (showing again just the 10% value of the second
subtotal amount ie $11
Then Grand total of $121.
example of finished product:
Subtotal $100
Freight $10
Subtotal $110
GST $11
Grand Total $121.
sure it is way easy for most of you, but please help me.
also, if i may can i ask another question.
If, for example I have a list of clients and each of them have a set
percentage discount over a main list price of products. how do i have that
particular percentage, automatically apply within my invoice. ie, want to
select customer and when i fill out products purchased, it will automaticall
show the product not at the list price of say $100, but at the set discount
price of 10% off, being $90.
I would prefer if this was applied when customer selected, as i dont want to
have to select 10% each time i enter an item purchased.
Thanks so much.
Meredith
Calculating report totals for an Invoice.
General stuff. Got Page Header, Order id header and detail all working as
planned. Need to work out order id footer.
What I would like is Subtotal of the body of order - which I have done. Text
box control source =Sum[ExtendedPrice]
Then would like to:
Add Freight of 10% (say $10 - order total is $100) Want to see just $10 in
this box.
Add Subtotal (want to see $110)
Add GST (australian tax) 10% (showing again just the 10% value of the second
subtotal amount ie $11
Then Grand total of $121.
example of finished product:
Subtotal $100
Freight $10
Subtotal $110
GST $11
Grand Total $121.
sure it is way easy for most of you, but please help me.
also, if i may can i ask another question.
If, for example I have a list of clients and each of them have a set
percentage discount over a main list price of products. how do i have that
particular percentage, automatically apply within my invoice. ie, want to
select customer and when i fill out products purchased, it will automaticall
show the product not at the list price of say $100, but at the set discount
price of 10% off, being $90.
I would prefer if this was applied when customer selected, as i dont want to
have to select 10% each time i enter an item purchased.
Thanks so much.
Meredith