User Tools

Site Tools


support:13_operations_reports:04_driver_reconciliation_report

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
support:13_operations_reports:04_driver_reconciliation_report [2013/02/08 14:46]
edmondsj created
support:13_operations_reports:04_driver_reconciliation_report [2013/02/08 15:03] (current)
edmondsj
Line 1: Line 1:
 ====== Description of report ====== ====== Description of report ======
  
-This report lists all jobs cleared by the selected driver in the given time period. ​ It will list all invoice and payment detail for each cleared job.+This report lists all jobs cleared by the selected driver in the given time period. ​ It will list all invoice and payment detail for each cleared job.  It is a job-centric report that lists associated invoices and payments when available.
  
 ====== Format ====== ====== Format ======
  
 <​code>​ <​code>​
-    Job  Driver No  Truck No  Reason ​       Job type  Job created +    Job  Driver No  Truck No  Reason ​       Job type  Job created ​ Job cleared day  Quickclear? ​ Job total  Invoice ​     Inv amt  Bill to     ​Ticket ​   Payment time      Type      Cash  Check  Credit 
-------- ​ --------- ​ -------- ​ ------------ ​ -------- ​ ----------- +------- ​ --------- ​ -------- ​ ------------ ​ -------- ​ ----------- ​ --------------- ​ ----------- ​ --------- ​ --------- ​ --------- ​ ---------- ​ -------- ​ ---------------- ​ ------ ​ ------ ​ -----  ​------ 
-1101600 ​ driver1 ​   101       ​Accident ​     Tow  ​+1101600 ​ driver1 ​   101       ​Accident ​     Tow       01/03 12:28  01/​03/​2013 ​          ​X ​         $105.00 ​ 1101600-1 ​    ​$50.00 ​ CCAS        008765 ​      
 +1101600 ​ driver1 ​   101       ​Accident ​     Tow       01/03 12:28  01/​03/​2013 ​          ​X ​         $105.00 ​ 1101600-2 ​    ​$55.00 ​ CASH        008766 ​   01/03/2013 12:26  cash     ​$5.00 
 +1101600 ​ driver1 ​   101       ​Accident ​     Tow       01/03 12:28  01/​03/​2013 ​          ​X ​         $105.00 ​ 1101600-2 ​    ​$55.00 ​ CASH        008766 ​   01/03/2013 12:26  check   ​$50.00 
 +1101601 ​ driver1 ​   101       ​Accident ​     Tow       01/03 15:03  01/​03/​2013 ​                     $125.00 ​ 1101601-1 ​   $125.00 ​ DEALER ​     008767
 </​code>​ </​code>​
 +
 +  * Job cleared day is provided so that jobs can be grouped by day during which job is cleared
 +  * If a job has multiple invoices, each invoice will be listed on a separate line
 +  * If an invoice has one or more payments, each payment is listed on a separate line, which means that invoice information might be duplicated on multiple payment lines (as shown above)
 +====== Example ======
 +
 +{{:​support:​13_operations_reports:​reports_driver_reconciliation_1.gif|}}
support/13_operations_reports/04_driver_reconciliation_report.1360352802.txt.gz · Last modified: 2013/02/08 14:46 by edmondsj