Job Cost Report - Paid Status



What is the best way to produce a report that shows the job costs that have been paid on a job? I would think you could produce a Job Cost Journal (6-1-2) and filter by the job and by status ("paid"), but it does not allow me to choose a status.


  • +1
    verified answer

    Hi Ralls. The reason you can't do this is because is there no Paid status for 6-3 job cost records. If you are billing these costs through Time & Materials billing, you could modify one of the 6-1-2 reports to add a criteria for the Invoice Record# field, which is the record# of the AR Invoice the cost was billed on when posted in T&M billing. It won't be able to show you if it has actually been paid, just billed.

  • 0 in reply to ghollister

    Okay that is good to know. We do not use T&M billing, but I just wanted to make sure I was not missing any potential reports. 

    Right now we have a custom Job Cash Flow report that. I can use data off it to back into what has been paid since it has Total Job Costs and Total balance of A/P, so that difference can tell me how much has been paid. And there is also a breakdown detail for each of those columns. Just thought there may be a more direct way to find it. Thank you!

  • 0 in reply to Ralls Pennington

    Hi  , if the above suggested answer helped, please do mark it as verified White check mark (by clicking the "…" button next to Reply, on the response) for the benefit of others in this forum Slight smile. Thank you!

Reply Children
No Data