How to Track Inventory Used by a Job or Project?
The best way is to create a new customer number using the project code / control number. For example, if you have a project number of 500, setup a new customer and assign number 500 to that customer account number. Then process your invoices for that project/job using that customer number. Process an invoice or multiple invoices for all of the items (labor, material, misc. costs) used on project/job number 500, by selecting that project (customer) number for each invoice. In fact, our customer numbers are nothing more than a "grouping" control number. You can sort your reports by this number. This means that if you wanted to see all of the items for job 500 you would simply need to run your Sales Report, sorted by customer number. You can even filter your reports for "500" to see only the items charged to customer number 500.