Prev: Convert Text "00:00:00:00" to time format in Access 2007
Next: IIf return multiple categories
From: rickytan85 on 31 Mar 2010 18:36
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.
From: Tom van Stiphout on 31 Mar 2010 23:26
On Wed, 31 Mar 2010 15:36:50 -0700, rickytan85
<rickytan85(a)discussions.microsoft.com> wrote:

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

-Tom.
Microsoft Access MVP


>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.
From: Mark Andrews on 1 Apr 2010 09:14
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

"rickytan85" <rickytan85(a)discussions.microsoft.com> wrote in message
news:44B19BAB-9DC7-4BAF-9D66-6D72D48C8CA9(a)microsoft.com...
> 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.

From: Risse on 2 Apr 2010 02:52

"rickytan85" <rickytan85(a)discussions.microsoft.com> kirjoitti
viestiss�:44B19BAB-9DC7-4BAF-9D66-6D72D48C8CA9(a)microsoft.com...
> 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.


 | 
Pages: 1
Prev: Convert Text "00:00:00:00" to time format in Access 2007
Next: IIf return multiple categories