Change Item Description Field to long_description Field.

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

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.

@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.

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.. ♥

@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.

Hello , Mr. apmuthu

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

thank you..

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