Calculation of Sales Tax with exception.

[MacMan]

I have created a database for recording sales transactions for a local bazar.

The input file consists of:
ID
Ticket_no


Consignor
Qty
Unit_Price
Unit_Total

The non-taxable items consignor is "Raffle" the rest of the consignors are 3 digit numbers

My issues is when calculation the total for the Sales Ticket sales Tax how to separate out an Non-taxable item?
Example: I have 12 items on a ticket, 2 of which are non-taxable

any help greatly appreciated.

[orange]

It seems to me you should have a location for unit_tax or some field to identify taxable/nontaxable.
You may want to do this in 2 steps:

step1;; orderitem
unitID
unitQty
unitSellingPrice

step2:

Invoice based on OrderItem
unitPurchased
unitQty
unitSellingPrice
unitIsTaxable

Summation Loop: (for concept only)

IFunitIsTaxable= True then
Total =Total + unitSellingPrice*UnitQty * Tax%
else
Total = Total + unitSellingPrice*UnitQty)
endif