Q. Where is the report that displays taxable and non-taxable products?
A. There is currently no report that provides this information. A request has been entered to create a new report for this purpose. The current workaround is to run the following query at Hub / Utilities / Queries:
select a.departid as 'Department ID', a.prodid as 'Product ID', a.prodname as 'Product Name'
from product a
inner join prodacct b
on a.departid = b.deptid
and a.prodid = b.prodid
where b.salestaxable = 0
Paste the query into the box at the bottom of the screen and click the Show Results button. These results can then be printed or saved to your hard drive.
