MBChB (UCT), MRCS (Ed.), F EBOPRAS, MD
Consultant Plastic and Reconstructive Surgeon
Under the providers name on the checkout for printing. I have the details in the database in the users table under info and speciality. How do I get them to show on
Cause all it displays is the providers title, names and number but no other detials like those above and email or any other items in the row taht I would like to add.
I would also like a receipt or invoice number but it doesnt seem to show one but on reports I can see there is an invoice number and encounter number is possible to have that too.
Additional lines must be retrieved from users table for insertion into the header.
If “MBChB (UCT), MRCS (Ed.), F EBOPRAS, MD” is in the title column & “Consultant Plastic and Reconstructive Surgeon” is in specialty, try removing title from line 630 & adding snippet to line 631 & 632. See attachment a.
The invoice number can be placed after patient name & address. Use the same scheme as above to pull invoice number into this section of the .php file. See attachment b.
The invoice number is the pid & the encounter, separated by a period, from ar_activity. Perhaps attachment c gives a clue.
Backup before any code change. Did not test above myself, but attempt to insert a line of text, without pulling the data, gave a white screen, so backup is vital.
Thank you epsdky , your version worked, sorry had even lost this thread and was stuck but finally found it.
I need to find out how to add the Invoice number also.
When I posted initialy I could see that there was code that added an invoice number for checkout receipts, however the question was how was it activated.
Have followed the code and discovered this…
When the (drug/product) Inventory is activated at…
Admin > Globals > Features > Drugs and Products
the drop down list “Invoice Refno Pool” appears for users…
Admin > users
selecting “Main” switches on the appearance of an invoice number for Checkout for a particlar user.
Thank you. I noted that but when printing the invoice or even checking the database tables there is no invoice number that is generated for each encounter or invoice that we print