Is there a way to run a "not billable" report by Job? I cannot seem to find a report that allows me to select a status of "not billable" to be run.
Is there a way to run a "not billable" report by Job? I cannot seem to find a report that allows me to select a status of "not billable" to be run.
What data do you want to pull for a report that can be filtered by Billing Method?
Perhaps my mind is just drawing a blank... I want to be able to run a report by job all of the things we have set as "not billable", but I am not seeing an option for that in any of my reports.
Does the Sage 100 Contractor have Custom Office?
Assuming you are referring to 6-3 Job Cost records with a Billing Status of 2-Not Billable, you could do a quick modification of the existing 6-1-2-31 Job Cost Journal ~ By Job report to add a filter criteria for Billing Status, then run that report for Billing Status = 2. Instructions for adding selection criteria to a report are in this KB article. The table on the left would be the main Job Costs table, and the field on the right you would choose would be Billing Status.
There is a query available at Menu 6-3 Job Costs - Job Costs~by T&M Billing Status
You can use that query as well, but would need to edit it to subtotal by Job (current subtotal is by just billing status)
Thank you so much for that... I've got it figured out for the most part! Not the most straightforward way to do it I'm sure, but I think I have what I need. Much appreciated!!
I'm going to say no, only because I haven't heard of it...
Hi Luxury Builders, if the above suggested answer ends up helping for sure, please do mark it as verified (by clicking the "…" button next to Reply, on the response) for the benefit of others in this forum . Thank you!
*Community Hub is the new name for Sage City