FrontAccounting forum — Change Item Description Field to long_description Field.

Re: Change Item Description Field to long_description Field.

null@example.com (rafat) — Sat, 07 May 2022 09:57:25 +0000

Sorry Guys I am bringing this up as another user is asking for the same (Long Item Description) on Quotations.
https://frontaccounting.com/punbb/viewtopic.php?id=9788

Hope you can help them.

Re: Change Item Description Field to long_description Field.

null@example.com (apmuthu) — Sun, 23 Jan 2022 15:44:50 +0000

@joe: Any changes, if minor, can be accommodated for 2 languages in Quotations into the core.

Re: Change Item Description Field to long_description Field.

null@example.com (hananah) — Sat, 22 Jan 2022 21:10:52 +0000

joe wrote:

@apmuthu,
All done. Committed to repo, 2.4.8.
The fixed Invoice Document, rep107.php, can be downloaded here.
/Joe

Can you please also add the same in Quotations..?
This will be good for any one use 2 language..

thank you..

Re: Change Item Description Field to long_description Field.

null@example.com (hananah) — Sat, 22 Jan 2022 11:29:34 +0000

Hello , Mr. apmuthu

Can you please also add the same in Quotations..?
This will be good for any one use 2 language..

thank you..

Re: Change Item Description Field to long_description Field.

null@example.com (joe) — Sun, 14 Jun 2020 07:24:14 +0000

@apmuthu,

All done. Committed to repo, 2.4.8.

The fixed Invoice Document, rep107.php, can be downloaded here.

/Joe

Re: Change Item Description Field to long_description Field.

null@example.com (apmuthu) — Sat, 13 Jun 2020 18:48:07 +0000

@joe: Can update the sys_prefs data in the default chart sqls with:

,('long_description_invoice', 'setup.company', 'tinyint', '1', '0')

Also, see if the attached patch for reporting/rep107.php can be incorporated.

Re: Change Item Description Field to long_description Field.

null@example.com (joe) — Sat, 13 Jun 2020 07:37:01 +0000

Hello Guys,

This has now been committed to stable 2.4.8 repo. A new Company flag, Use Long Description on Invoices, has been created in the left pane at the bottom.
If this checkbox is set, the Long Item Description lines will be printed as well on Sales Invoices.

The following 3 files were changed and can be downloaded here:

https://sourceforge.net/p/frontaccounti … rences.php
https://sourceforge.net/p/frontaccounti … ils_db.inc
https://sourceforge.net/p/frontaccounti … rep107.php.

@apmuthu

Please update the Wiki with these important features. Thanks in advance.

/Joe

/apmuthu: Done.

Re: Change Item Description Field to long_description Field.

null@example.com (hananah) — Fri, 12 Jun 2020 18:46:55 +0000

Dear Mr. @apmuthu

I don't know what I have to say to you more than Thank You very very very much...
I really appreciate your efforts, It's work for me very well...

I don't know how attache the output image to share with you...

Thank You again.. ♥

Re: Change Item Description Field to long_description Field.

null@example.com (joe) — Fri, 12 Jun 2020 11:51:45 +0000

Will have a look at this.

Joe

Re: Change Item Description Field to long_description Field.

null@example.com (apmuthu) — Fri, 12 Jun 2020 08:52:49 +0000

@rafat: Thanks for the feedback. Hence no utf8_encode() was necessary if the necessary fonts are installed and called upon.

@joe: This can be implemented in the core for 2 line item in invoice with a SysPrefs flag for a company-wise choice.

Re: Change Item Description Field to long_description Field.

null@example.com (rafat) — Fri, 12 Jun 2020 07:33:37 +0000

Apmuth
It works nicely. I get the attached results.

Re: Change Item Description Field to long_description Field.

null@example.com (apmuthu) — Fri, 12 Jun 2020 02:35:35 +0000

First, enable the availability of the long_description field in the function get_customer_trans_details in sales/includes/db/cust_trans_details_db.inc by inserting the following line as line 23:

        item.long_description As StockLongDescription,

** @joe: the above can be implemented now **

Then put in these lines at line 166 in reporting/rep107.php:

                $c--;
                $rep->TextColLines($c++, $c, $myrow2['StockLongDescription'], -2);

If you have your Arabic fonts correctly setup to print Arabic characters in reports, all should be well.

Without Arabic Reporting fonts, some testing snapshots are attached.

Re: Change Item Description Field to long_description Field.

null@example.com (hananah) — Thu, 11 Jun 2020 22:25:04 +0000

can you guide me, please..

Because I want to put it in a two line, not one line.

Just if you can let me know what i have to edit in rep107.php ..?

and Thank You very much..

Re: Change Item Description Field to long_description Field.

null@example.com (apmuthu) — Thu, 11 Jun 2020 18:23:05 +0000

Try to put in both languages in the name itself or alter the rep107.php accordingly.

Change Item Description Field to long_description Field.

null@example.com (hananah) — Wed, 10 Jun 2020 14:07:26 +0000

hey,

I am trying to change the template of the invoice , I want to print the (long_description of the Items) instead of (Item Description Name), why..? Because I want to put a two lines of Item name, one line for Englishand another one for the Arabic language.

Please let me know about how to do it, I need to print two languages in the name of items.

Regards.