• From: Malta
  • Registered: 04/06/2012
  • Posts: 123

Topic: Info line on Invoices

Hi,
I have several companies using one FA. We need to place a message on the invoices at the bottom just around the Bank Details. Is it possible to have one field in the setup of each company that would allow the user of the company to type anything they want to print on the invoice?

Some users want to put advertising messages, others seasonal messages and yet others some other information.

I geuss this change would go in 2.4 as it would require a database change ... additional column.

Thanks
Carmelo

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,085

Re: Info line on Invoices

You can use the 'Legal Text' field in Company setup for this.

Joe

  • From: Malta
  • Registered: 04/06/2012
  • Posts: 123

Re: Info line on Invoices

Thanks Joe.
The 'Legal Text' is too short. We need to include the following text on each invoice:

Unless payment is received in full within the agreed credit terms, interest shall be charged in accordance with the Late Payments in Commercial Transactions Legislation LN272 of 2012. The current rate of interest as stipulated by law is 8% above the ECB intervention rate.
The Company shall process the Personal Data found herein according to the Data Protection Act and according to the principles, ethics and guidelines of The Malta Association of Credit Management (MACM), of which the Company is a member.
In case of any default by the Client in the fulfilment of any terms of this agreement, the Company has the right to pass on any information or references contained herein to MACM as well as to any third party legally entitled to receive such information.

Any ideas?

Thanks
Carmelo

  • Registered: 12/25/2007
  • Posts: 2,446

Re: Info line on Invoices

The sys_prefs table where is stored legal_text has tinytext type of 'value' field. This is changed in forthgoing 2.4 version, and you can safely change it on your setup too. This should remove the 255 chars constraint also on legal text setting.

Janusz

  • From: Malta
  • Registered: 04/06/2012
  • Posts: 123

Re: Info line on Invoices

Thanks.
You guys find solutions for everything smile

Regards
Carmelo

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Info line on Invoices

Wikiied it.

apmuthu's Website

  • From: Malta
  • Registered: 04/06/2012
  • Posts: 123

Re: Info line on Invoices

Thanks apmuthu, but the SQL command should be like the one below:

ALTER TABLE 0_sys_prefs MODIFY value TEXT;

Regards
Carmelo

8 Reply by apmuthu (edited by apmuthu 11/16/2012 05:26:14 pm)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Info line on Invoices

Thanks carmelr, changed it in the Wiki as:

ALTER TABLE `0_sys_prefs` CHANGE `value` `value` TEXT NULL;

The code was taken from SQLyog's standard history output.

apmuthu's Website