Changing Invoice from A5 to A4
Hi,
I have recently upgraded to a new laptop & installed the latest version of OpenVPMS.
I am trying to change the set up of invoices from A5 to A4 using the following instructions I had from 2008:
- If you are changing from A5 to A4 invoices you will also need to modify the Invoice Items template which is the sub-report that the invoice template uses to detail the individual charges. Select the Invoice Items temaplet frm the list and edit and upload the invoiceItems.jrxml file supplied in the openvpms installation.
I have searched my hard drive but cannot find the appropriate files. I have also searched for invoiceItemsa4.jrxml and invoiceA4.jrxml unsuccessfully.
Does anyone have any suggestions on how & where I can locate these files?
Cheers,
Ross Beatty
Re: Changing Invoice from A5 to A4
The standard 1.6 distribution contains "invoice a4.jrxml" and its line item subreport "invoiceitems.jrxml" - note the naming inconsistency - the A5 subreport is called invoiceitemsA5.jrxml but the A4 version is invoiceitems.jrxml. [Note also that the space in the middle of the file name is not really kosher on linux systems.]
I used these as a basis of a practice specific version I have done, but I won't send you that as it has no tax (its for Hong Kong) and some other tweaks. I also did a VAT version for Cahir in the UK.
I have attached the two files.
Regards, Tim G
Re: Changing Invoice from A5 to A4
Hi,
I have just stumbled across these files, I guess some of these might be the onse I need????
invoice_Ross_Beatty.bak (BAK File)
invoice_Ross_Beatty (Jrxml source file)
invoiceItems_Ross_Beatty (Jrxml source file)
invoiceItemstext (Jrxml source file)
invoiceross.bak (BAK File)
invoiceross (Jrxml source file)
invoicetext.bak (BAK File)
statementItems (Jrxml source file)
statementItemsrossbeatty (Jrxml source file)
statementrossbeatty (Jrxml source file)
Here is the link to my originl post: http://www.openvpms.org/financial-module-statementsinvoices
Cheers,
Ross Beatty
Re: Changing Invoice from A5 to A4
Ross - having read the correspondence, my guess is that in 2008 you built an A4 invoice and its name is probably invoice_Ross_Beatty.jrxml and invoiceitems_Ross_Beatty.jrxml so I suspect that these two are the ones you need.
Regards, Tim G
Re: Changing Invoice from A5 to A4
Hi Ross,
if you go to admin>templates in openVPMS you can search for and find your current templates. If you then view the template you can download the jrxml file that you are using. This can then be edited in ireport.
If you look for a template called invoice you should find them both. (probably invoiceA5 and InvoiceitemsA5 or something similar)
Matt Y.
Re: Changing Invoice from A5 to A4
Hi Tim & Matt,
Thanks for your help.
With my limits IT ability, I have hit the wall again.
I have decided not to go with my template from 2008. Tony De Keizer set the template up for me initially. I need to change the ABN on the footer of the letter head which he set up with some graphics, and that is beyond my limited abilities.
I changed the Invoice and Invoice Items file in Admin/Templates to the following files:
invoice a4.jrxml - Invoice
invoiceitems.jrxml.txt - Invoice Items
by right clicking on them in openvpmsrelease-1.6/Reports and copying and pasting them to my desktop and then uploading them.
When I try and print I get the following error message (NB uppercase "I" in "Items":
There is no sub-report named: invoiceItems.jrxml
This is needed by report: invoice a4.jrxml
Is the solution as simple as changing the "i" to uppercase in the file name, or do I have to upload a different file for the invoice items.
Thanks again for your help,
Ross Beatty
Re: Changing Invoice from A5 to A4
Ross - this answer is in two parts:
Q1 - are you running on a Linux system (because on those the case of letters in the file names is important) - on Window it does not matter fred.xyx is the same as FRED.XYZ
Q1 - the name you have provided "invoiceitems.jrxml.txt" worries me - note the extra .txt - even with case being non significant, there is no way that invoiceitems.jrxml.txt is the same as invoiceItems.jrxml
My guess is that you editted the file with notepad or something else and when you said save invoiceitems.jrxml as a text file, Notepad added the .txt
[To avoid this save as "invoiceitems.jrxml" (with the double quotes) and Notepad will not add the .txt]
So - my recommendation is to rename invoiceitems.jrxml.txt as invoiceitems.jrxml (or even invoiceItems.jrxml) and try again.
Rregards, Tim
Re: Changing Invoice from A5 to A4
Thanks Tim,
Problem solved by uploading the files directly from openvpmsrelease-1.6/Reports.
I just have a couple of final (hopefully!) tweaks I need with the invoices:
1. They are printing with "null" printed above the client's name & address. Can I get rid of this?
2. I have my ABN on my letterhead. Can I remove this from the top right of the invoices?
Cheers,
Ross
Re: Changing Invoice from A5 to A4
Ross - piece of cake - see attached. This is the standard version with two adjustments:
a) the static text field holding the "ABN: 000 000 000" text has been emptied so no ABN is printed.
b) the field showing 'null' is the company name. I just changed its 'Blank when null' attribute from False to True.
Regards, Tim G
Re: Changing Invoice from A5 to A4
Hi Tim,
That sounds great, however I can't download the file from here for some reason.
Can you either repost it or email it to me at beattyross[at]hotmail[dot]com?
Cheers,
Ross
Re: Changing Invoice from A5 to A4
Ross - done it. Regards, Tim G