Invoices for Hay & Feed Department

[Guest]

I am trying to set up a data base in access using the templates on my
computer. The only problem I'm having is most of my items are not taxable.
When I input the orders, it automatically charges sales tax on all items. I
am unable to locate any area to mark a product taxable or non-taxable.

Is there a way I can fix this problem.

 

[Lynn Trapp]

Which template are you using?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

Microsoft Access 2003, Order Entry
--
Donna

Which template are you using?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[UpRider]

Sales tax rate is on the "My Company Information" form.

HTH, UpRider

 

[Guest]

I understand that, however it won't allow me to mark some items taxable and
others non-taxable.

 

[Jeff Conrad]

in message:

I understand that, however it won't allow me to mark some items taxable and
others non-taxable.

On the actual order form just enter 0.00 for the Sales Tax for any orders
you do not want to charge sales tax. The field will default to displaying
the current sales tax, however, you can enter anything you desire into that
control. Enter a zero for the invoices you do not wish to have sales tax.
Worked OK for me.

 

[Guest]

Would I have to enter two different invoices if someone purchased a taxable
item and a non-table item. That may be the only way I can accomplish what I
need to do.

Thank you for any help you can give me. I'm trying to use Access, which I
really don't have to much experience in.

 

[Jeff Conrad]

in message:

Would I have to enter two different invoices if someone purchased a taxable
item and a non-table item. That may be the only way I can accomplish what I
need to do.

Yes, that would be the easiest way to go for simplicity.
The other option is to make some design and coding modifications to the
form itself and possibly some table changes as well.

Thank you for any help you can give me. I'm trying to use Access, which I
really don't have to much experience in.

No problem. If you do not have much experience with Access than you might
want to go the easier route and just create separate invoices for taxable and
non-taxable items.

 

[Mike Painter]

I am trying to set up a data base in access using the templates on my
computer. The only problem I'm having is most of my items are not
taxable. When I input the orders, it automatically charges sales tax
on all items. I am unable to locate any area to mark a product
taxable or non-taxable.

Is there a way I can fix this problem.

It will take a bit of work.
You can add a "Taxable" field to your inventory, then total taxable and non
taxable on the form and just tax the taxable total.

 

[UpRider]

Donna, I have made some mods to the database tables, code, forms and reports
so that it will handle sales tax on a per product basis. If you want to take
a look, let me know and I'll either email it to you or you can download it
from my website.

UpRider