Automotive database template.

[rickytan85]

The Sample database for service call management includes sales tax on both
parts and labor. Need help on designing sales tax on ONLY parts when creating
an invoice and workorder, there is not supposed to be sales tax on labor.

 

[Tom van Stiphout]

On Wed, 31 Mar 2010 15:36:50 -0700, rickytan85

Can you set the salestax to 0% for those items?

-Tom.
Microsoft Access MVP

 

[Mark Andrews]

I designed a similar thing and did it just like Quicken does it with a
taxable flag. You can take a look at an example at:
http://www.rptsoftware.com/products/crmtemplate/

Perhaps that will help you out?

You end up using iif() in queries and calculations based on the taxable
flag.

When you setup the products (which are parts and labor) you specify whether
they are taxable as well.
--
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com

See

 

[Risse]

The Sample database for service call management includes sales tax on both
parts and labor. Need help on designing sales tax on ONLY parts when
creating
an invoice and workorder, there is not supposed to be sales tax on labor.