FrontAccounting forum — Info line on Invoices

Re: Info line on Invoices

null@example.com (apmuthu) — Fri, 16 Nov 2012 17:24:52 +0000

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.

Re: Info line on Invoices

null@example.com (carmelr) — Fri, 16 Nov 2012 16:57:59 +0000

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

ALTER TABLE 0_sys_prefs MODIFY value TEXT;

Regards
Carmelo

Re: Info line on Invoices

null@example.com (apmuthu) — Fri, 16 Nov 2012 16:27:07 +0000

Wikiied it.

Re: Info line on Invoices

null@example.com (carmelr) — Fri, 16 Nov 2012 15:21:54 +0000

Thanks.
You guys find solutions for everything

Regards
Carmelo

Re: Info line on Invoices

null@example.com (itronics) — Fri, 16 Nov 2012 14:32:14 +0000

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

Re: Info line on Invoices

null@example.com (carmelr) — Fri, 16 Nov 2012 06:13:07 +0000

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

Re: Info line on Invoices

null@example.com (joe) — Thu, 15 Nov 2012 22:35:31 +0000

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

Joe

Info line on Invoices

null@example.com (carmelr) — Thu, 15 Nov 2012 22:26:08 +0000

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