non taxable items

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi i have spent many hours on a design and when i took it to the end user he
tells me that he as items that are not VAT chargabe, (Sales Tax) how can i go
about this without changeing to much code.
 
You probably have an Order table (the order header) and an OrderDetail table
(the line items), like Northwind.

If some items are not taxable, then the TaxRate field must go into the
OrderDetail table, not the Order table. You will then create a query with
calculated fields such as:
AmountEx: [Quantity] * [UnitPrice]
TaxAmount: CCur(Nz(Round([Quantity] * [UnitPrice] * [TaxRate],2),0))

You will base your subform (for the line times) on this query.
No code is needed.
 
Also, if you don't already have one, you need a flag on the customer record
since some customers may be exempt from tax entirely.

Allen Browne said:
You probably have an Order table (the order header) and an OrderDetail
table (the line items), like Northwind.

If some items are not taxable, then the TaxRate field must go into the
OrderDetail table, not the Order table. You will then create a query with
calculated fields such as:
AmountEx: [Quantity] * [UnitPrice]
TaxAmount: CCur(Nz(Round([Quantity] * [UnitPrice] * [TaxRate],2),0))

You will base your subform (for the line times) on this query.
No code is needed.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

andy t said:
hi i have spent many hours on a design and when i took it to the end user
he
tells me that he as items that are not VAT chargabe, (Sales Tax) how can
i go
about this without changeing to much code.
Click to expand...
Click to expand...
 
And of course the customer record flag would have to override the
individual products. So wether or not to add tax would be based on the
logic
ynCustomerTaxExempt = True AND ynProductTaxable = True

Also, if you don't already have one, you need a flag on the customer record
since some customers may be exempt from tax entirely.

You probably have an Order table (the order header) and an OrderDetail
table (the line items), like Northwind.

If some items are not taxable, then the TaxRate field must go into the
OrderDetail table, not the Order table. You will then create a query with
calculated fields such as:
AmountEx: [Quantity] * [UnitPrice]
TaxAmount: CCur(Nz(Round([Quantity] * [UnitPrice] * [TaxRate],2),0))

You will base your subform (for the line times) on this query.
No code is needed.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

hi i have spent many hours on a design and when i took it to the end user
he
tells me that he as items that are not VAT chargabe, (Sales Tax) how can
i go
about this without changeing to much code.
Click to expand...
Click to expand...
Click to expand...
 
Actually make that

ynCustomerTaxExempt = False AND ynProductTaxable = True

since you want all Customers that are taxable.
Also, if you don't already have one, you need a flag on the customer record
since some customers may be exempt from tax entirely.

You probably have an Order table (the order header) and an OrderDetail
table (the line items), like Northwind.

If some items are not taxable, then the TaxRate field must go into the
OrderDetail table, not the Order table. You will then create a query with
calculated fields such as:
AmountEx: [Quantity] * [UnitPrice]
TaxAmount: CCur(Nz(Round([Quantity] * [UnitPrice] * [TaxRate],2),0))

You will base your subform (for the line times) on this query.
No code is needed.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

hi i have spent many hours on a design and when i took it to the end user
he
tells me that he as items that are not VAT chargabe, (Sales Tax) how can
i go
about this without changeing to much code.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top