• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 559
  • Last Modified:

Taxable and Non-Taxable Items on Invoice

I am using the stock "Order Entry" database that ships with Access. It works for my situation. The only thing I need is to beable to choose whether or not the items in the products table are taxable or non-taxable. I am not a programmer but can follow instructions well. I have added a taxable (yes/no) field to the products table. How do I get this information to properly calculate in the Order Details sub-form and ultimately on the Invoice report?
0
kegragg
Asked:
kegragg
  • 2
2 Solutions
 
DarkMorCommented:
kegragg,
     The calculated field on the subform, I assume you already have the field calculating the total, what you need to use is the IIF() function to decide on the correct version of calculation to use:

IIF(tblCustomer.Taxable = Yes, <<Calcwithtax>>,<<CalcNoTax>>)

This statement will look at your yes/no feild setting and THEN / ELSE based on the logic.  Not seeing the form and tables I can not give actual equations.  If you provide more details such as Form/Field Names and location of certain controls like the checkbox for taxable, where your item cost sum is and whatnot I am sure we can give better instructions

D
0
 
jadedataMS Access Systems CreatorCommented:
Hey kegragg!

  If your system is going to work correctly for taxation purposes you will need to do a subtotal of the taxable items BEFORE setting the tax amount.  If you don't you can find yourself over/under applying tax charges on orders.

  in the footer of the form you need a control that sum()'s up the taxable lines to a subtotal

  I do this with a separate Calculated column in the recordsource query.
  TaxableSubT: IIf([taxable]=true,[Cost],0)

  Then you form footer control controlsource property can be
   =Sum([TaxableSubT])

   Sum(TaxableSubT])*[Taxrate] will generally be very close to the correct tax amount (within 1%)  This is as close as you can get without looking up the tax in a tax table. (which would be the most accurate)
   
regards
Jack
0
 
kegraggAuthor Commented:
I have posted the database on my website. The tables and fields are more complicated than what I can explain in a short space here. The address is www.wilkes.net/access. As you will see, this is the generic database that is created when you choose "New", "Databases Tab", "Order Entry."

The only thing I have done is to re-position items on the Invoice report and to add a "taxable" field to the Products table. I have also populated some of the tables with our information.
0
 
jadedataMS Access Systems CreatorCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Split: DarkMor {http:#9898744} & jadedata {http:#9899512}

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

jadedata
EE Cleanup Volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now