July 2, 2012 at 3:42 pm #31323clinicoffice_userParticipant
When raising an invoice from the ‘Pending Charges’ function/screen, is it possible to add the ‘Charge Date’ to the invoice in order to distinguish multiple items of the same Item Code/Description ? I can’t see that this field is available in the source data for any invoice report template for use within Report Designer. I have tried using the Invoice Date, but this just replicates a single date for each line.
Perhaps you could suggest the SQL that needs to be added to capture the data for this new functionality?
QuentinJuly 3, 2012 at 10:45 am #33039WilliamKeymaster
Thanks for the post. It is possible to add the ‘Appointment Details’ so that the appointent date that the charge was raised on will appear up on an invoice line. In order to do this please follow the steps below.
1) Open the ‘Raise Invoices from Charges’ window
2) Towards the bottom right there is a small blue link which says “More Options“, click on on this
3) Tick the option for Appointment Details
Now when you raise an invoice the appointment details, which includes the appointment, date will appear on the invoice line. This will help to distinguish the multiple items you may have on an invoice.
Please let us know if this is not quite what you are looking for.July 3, 2012 at 9:27 pm #33040clinicoffice_userParticipant
Thanks William, that works fine and gives the necessary detail I need.
QuentinJuly 23, 2014 at 10:14 pm #33041
hello, I am designing invoice templates and I need:
– The date in full (23rd July 2014)
– The appointment date (without the time)
Which fields /options do I have to use?
thanks in advance,July 24, 2014 at 10:24 am #33042
Thanks for your post.
If you want the date in full, you need to right click the report you wish to edit and go into DESIGN TEMPLATE. Then you need to find the field where the data is being pulled to, click the arrow over the field and change the format string to display the date in a different format.
To seperate the date and time of an appointment – We would need to do some work back here as in the database table the date and time are as one.
I can look into this for you and see if it is possible to do. Depending on the complexity of doing this, there may be a charge.
Again, if you want us to edit the report for you, we are more than happy to do this, however there would be a charge involved.
ThanksJuly 24, 2014 at 11:19 am #33043
Thank you Matt, that worked.
What is the name of the field for “appointment date” ?July 24, 2014 at 11:25 am #33044
There are two
There is APPSTART and APPFINISH.
If your intention is to let them know the date and time of the appointment, I would suggest using the APPSTART.
ThanksJuly 24, 2014 at 12:41 pm #33045
Thanks for that. Unfortunately this field is not on my list and I don’t seem to be able to type it in.November 11, 2015 at 11:23 am #33046SupportKeymaster
In fact, the appointment date field is not available as standard on an invoice report, so you will need to add it to the SQL using the SQL builder. Please let us know if you need assistance with that – many thanks.
- You must be logged in to reply to this topic.