Patient Bill ( probably for Rod )

okhra wrote on Thursday, September 08, 2005:

1) When patient bills are printed after posting EOB’s etc, we see only the Net Charge( after deducting O & A allowances) and Paid columns. The people in the office would also like to see the original charges also , as an additional column.

I looked around in the code, and seems like this adjustment is not kept around in the ‘ar’ table and is somehow lost. The atrributes - amount and netamount - in the table ‘ar’ are the same. I am suggesting that we keep the original charge in ‘amount’ and the contractual amount in ‘netamount’.

Do I have the go ahead from Rod , for these changes ?

2) The name in the Addresse is the patient’s name, and being a pediatric office, our patients are 2 year olds. So, I have changed my code to the insurance subscriber’s name. If the subscriber is the patient, I am still introuble. I’ll take care that later.

Thanks,
braman at world dor std dot com

sunsetsystems wrote on Thursday, September 08, 2005:

I don’t think you need to do anything with the ar table.  The invoice line items are in the “invoice” table and amounts for these, as well as payment information, are in the “acc_trans” table.  This detail information includes all the original charges.  I don’t know what will happen if you start messing with amount and netamount in the ar table, and I don’t see any need to do that.

Also if you have not already done so, see sl_eob_search.php and sl_eob_invlice.php which extract all kinds of information from the above-mentioned SQL-Ledger tables.

– Rod (http://www.sunsetsystems.com/)

okhra wrote on Thursday, September 08, 2005:

Thanks for the fast reply. I knew I would be wrong :slight_smile: I am looking at both sl_eob_search.php and sl_eob_invoice.php and let me see if I can grab the original fee.

Thanks,
braman at world dot std dot com

okhra wrote on Thursday, September 08, 2005:

Here is my hack for grabbing the original fee.
The changes are in sl_eob_search.php :
In there, there’s a call to get_invoice_summary() without the 2nd parameter. I added the 2nd parameter ‘true’ to get a ‘dtl’ array. The 3rd element of the ‘dtl’ array contains the original fee.

I added $line[‘ourcharge’] = <original fee>.

All I have to do is the printing part now, which I know how to do.

Thanks,
braman at world dot std dot com

sunsetsystems wrote on Thursday, September 08, 2005:

Well done!

– Rod (http://www.sunsetsystems.com/)