Help save net neutrality! Learn more.
Close

Sales by Provider/Practitioner

Wilson
2013-09-24
2013-09-25
  • Wilson

    Wilson - 2013-09-24

    Is there a report where we can see the sales groups by Provider/Practitioner? There's a generic sales report but it does not have this column like the cash report has. Thanks.

     
  • fsgl

    fsgl - 2013-09-25

    Describe in more detail the required elements of the report that you are seeking.

    What is the purpose of the report?

     
  • ViSolve

    ViSolve - 2013-09-25

    There is no sales report with the Provider filter anywhere.

    But the Sales Report under Reports->Financial->Sales section can be customized to include a Provider Filter similar to the Cash Report.

    You need to include the Queries to filter by provider in the file

    interface/reports/sales_by_item.php
    

    Thanks
    OpenEMR Customization/Support provider,
    ViSolve,Inc
    services@visolve.com

     
  • ViSolve

    ViSolve - 2013-09-25

    From our understanding, this can be done by inserting the following lines in the file (interafce/reports/sales_by_item.php)

    at line:161:

    $form_provider=$_POST['form_provider'];
    

    at line 240:

     <td class='label'>
     <?php xl('Provider','e'); ?>:
     </td>
     <td>
     <?php $query = "select id, lname, fname from users where authorized = 1 order by lname, fname";
          $res = sqlStatement($query);
          echo "   &nbsp;<select name='form_provider'>\n";
          echo "    <option value=''>-- " . xl('All Providers', 'e') . " --\n";
          while ($row = sqlFetchArray($res)) {
          $provid = $row['id'];
          echo "    <option value='$provid'";
          if ($provid == $_POST['form_doctor']) echo " selected";
          echo ">" . $row['lname'] . ", " . $row['fname'] . "\n";
          }
          echo "   </select>\n";
     ?>
     </td>
     </tr>
     <tr>
    

    at line 384:

     //If a Provider is specified.
        if($form_provider){
           $query .= " AND fe.provider_id ='$form_provider'";
        }
    

    Hope it Helps

    Thanks
    OpenEMR Customization/Support provider,
    ViSolve,Inc
    services@visolve.com

     
  • Wilson

    Wilson - 2013-09-25

    Great! This helps tremendously. Thank you. Since I'll be making changes to the file, it is possible for it to be overwritten in other releases, correct?

     
  • ViSolve

    ViSolve - 2013-09-25

    We provided this fix based on the latest version (openEMR 4.1.2). We assume that this will work fine for openEMR version 4.1.0 onwards(since it is not changed from last couple of versions).

    Thanks
    OpenEMR Customization/Support provider,
    ViSolve,Inc
    services@visolve.com

     

Log in to post a comment.