cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Community Explorer **
Solved

Inventory

Hello

We live in WI and we have difficult sales and use tax rules.  As an electrical contractor some things are taxable and some I have to pay use tax on.  We have well over 1,000 items in our inventory.   When working a project that is non taxable, we currently have to look up the cost of each item individually, record this amount on a spread sheet, calculate sales tax and add to the item, then add markup to that.  Obviously this is taking WAY too much time to create invoices.  I am wondering two things:

1.  Is it possible to put item cost on the invoice to only be seen by us.  (This would reduce the need to look up each individual item)?

2.  If not.... Can I make the item prices the item cost and create different price levels for regular markup versus sales tax plus markup?

Thanks

Best answer 11-08-2018 02:35 PM

Accepted Solutions
Established Community Backer ***

Re: Inventory

2. If not.... Can I make the item prices the item cost and create different price levels for regular markup versus sales tax plus markup?

Yes and that is the easiest way to do it, especially if you have premier or enterprise since you can do custom pricing by item rather than all of them.

 

1. Is it possible to put item cost on the invoice to only be seen by us. (This would reduce the need to look up each individual item)?

yes but it is a pain to do, you create a custom field for cost, then enter the item average cost in that field per item. On the invoice, customize data layout, column tab, enable the field for screen but not for print.

with 1K items this utility might help take some of the pain away
http://www.q2q.us/ucfOverview.htm

3 Comments
Established Community Backer ***

Re: Inventory

2. If not.... Can I make the item prices the item cost and create different price levels for regular markup versus sales tax plus markup?

Yes and that is the easiest way to do it, especially if you have premier or enterprise since you can do custom pricing by item rather than all of them.

 

1. Is it possible to put item cost on the invoice to only be seen by us. (This would reduce the need to look up each individual item)?

yes but it is a pain to do, you create a custom field for cost, then enter the item average cost in that field per item. On the invoice, customize data layout, column tab, enable the field for screen but not for print.

with 1K items this utility might help take some of the pain away
http://www.q2q.us/ucfOverview.htm

Community Explorer **

Re: Inventory

Thank you so much!  I have been going round and round with how to handle this!

Established Community Backer ***

Re: Inventory

You're Welcome