Job Cost Report - Paid Status

SOLVED

Hello,

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.

Thanks!

Parents
  • +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.

Reply
  • +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.

Children