Discount, VAT and GrandTotal...

[CyberMind]

So I have a report created from a query and in this report there are many different items that have quantities, unit prices and totals. Then it is summed up to another total (Sum of all totals of individual items). Then I have Discount, VAT (15%) and Grand Total. I managed to create the first sum of all individual item totals. How am i going to enter a certain amount to discount and then VAT and then sum up all that to create a Grand Total? Screenshot below:

 

[GaryPanic]

Quite simple really


Total 100
discount 5
VAT 15%
Amount Due 109.25


So your Amount due must be 100(being the total) less discountfield =net due time VAT 15%)
then add net + Vat up

 

[CyberMind]

yes i know that but I need a way to input that value to discount!

 

[neileg]

I assume you have two tables, one for the quotation header and one for the detailed lines. Since you are applying the discount to the total, you need to hold the discount and the VAT details in the header. You can either holdthe monetary value of these or you can hold the information needed to calculate this. On what basis are you applying the discount? Is it a lump sum or is it a percentage? Is this a fixed discount or will it be varied at the time of input?

 

[CyberMind]

Yes I have two tables. Exactly as you mentioned. And the discount is a variable value that the user defines after viewing the report. Mostly used to round up the grand total...

 

[neileg]

Ok. You need a field in the header table for the discount. And a VAT field.

You need a form and a subform. The form holds the header data and the continuous subform holds the detail lines. Calculate the sum of the amounts in the subform and show this on the main form as Value. Add a text box bound to the Discount field for the user input amount. Then I would strike a subtotal with a text box set to value minus discount. Then your VAT textbox is set the subtotal times the VAT rate. Set these values in the After Update event of your discount control.