Invoices for Hay & Feed Department

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

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.
 
I understand that, however it won't allow me to mark some items taxable and
others non-taxable.
 
in message:
I understand that, however it won't allow me to mark some items taxable and
others non-taxable.
Click to expand...

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.
 
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.
 
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.
Click to expand...

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.
Click to expand...

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.
 
Donna said:
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.
Click to expand...
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.
 
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
 
Back
Top