• From: India, MH, Nagpur
  • Registered: 04/27/2022
  • Posts: 10

Topic: Long Description on Sales Quotation not working FrontAccounting 2.4.11

Dear all,

I was using long description in the old version(2.4.9) on sales quotation.

But the same is not working in the  FrontAccounting 2.4.11. it just adds a blank line space.

Use Long Descriptions on Invoices in settings is already checked.

Is it bug or I need to do some settings.

2 Reply by rafat (edited by rafat 05/02/2022 04:06:26 pm)

  • rafat
  • Senior Member
  • Offline
  • From: UAE, Dubai
  • Registered: 11/28/2017
  • Posts: 540

Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11

It could be a php version problem. Please mention your environment setup. I believe php8 is not yet fully supported by FA.
Also ..are you using the Long Description with a different Language? One thing is I have never seen Long Description used on Quotations. It is only meant to be used on Invoices.

rafat's Website

  • From: India, MH, Nagpur
  • Registered: 04/27/2022
  • Posts: 10

Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11

Thanks Rafat again for reply,

@my environment

Database server
Server: Localhost via UNIX socket
Server version: 10.1.48-MariaDB - MariaDB Server
Protocol version: 10
Server charset: cp1252 West European (latin1)
Web server
nginx/1.15.10
PHP version: 7.2.30
phpMyAdmin
Version information: 5.1.1, latest stable version: 5.1.3

@ language English, for both description and long description.

@ Long description on sales quotation, In our case we need to specify our technical specifications on our quotation, so need it. also can we increase its length?

  • rafat
  • Senior Member
  • Offline
  • From: UAE, Dubai
  • Registered: 11/28/2017
  • Posts: 540

Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11

Your environment seem OK. So what you need is a change in the code. Unfortunately I am only a user with no coding skills. Maybe  one of the gurus in this forum can help. You also can request it thru Wish List Forum and see if FA team can incorporate it.

rafat's Website

  • From: India, MH, Nagpur
  • Registered: 04/27/2022
  • Posts: 10

Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11

Thanks for your reply.

lets see if someone can help me in this.

I will also do as said by you.

  • From: India, MH, Nagpur
  • Registered: 04/27/2022
  • Posts: 10

Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11

Dear all,

Can some one help in this

I was using long description in the old version(2.4.9) on sales quotation.

But the same is not working in the  FrontAccounting 2.4.11. it just adds a blank line space.

Use Long Descriptions on Invoices in settings is already checked.

Is it bug or I need to do some settings.

  • rafat
  • Senior Member
  • Offline
  • From: UAE, Dubai
  • Registered: 11/28/2017
  • Posts: 540

Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11

Hi,
The whole thing about Long Item Description started with this thread.
https://frontaccounting.com/punbb/viewtopic.php?id=8832
The user asked for it in Invoices and later in Quotation. The invoice part was implemented but never the Quotation part. So maybe someone from your side changed the code and implemented it in your 2.4.9. But as you can see its not part of the core FA. Only invoices are.

@Joe.. can this (Long Item Description on Quotations) be implemented with ease or we need to Wait?

Thanks

rafat's Website

  • From: India, MH, Nagpur
  • Registered: 04/27/2022
  • Posts: 10

Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11

Dear all,
I made following changes to sales/includes/db/sales_order_db.inc (line 285)

        line.description AS StockDescription,
        item.long_description AS StockLongDescription,
               
and added following code in rep111

          if (!empty($SysPrefs->prefs['long_description_invoice']) && !empty($myrow2['StockLongDescription']))
          {
            $c--;
            $rep->TextColLines($c++, $c, $myrow2['StockLongDescription'], -2);
          }

it solved my concern

Thanks

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

Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11

@joe?

apmuthu's Website

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

Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11

Well, we could implement @harshadmwasule's solution. Will ha a look at this when back in office.

Joe

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

Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11

This has now been fixed and committed to stable repo.

2 fixed files, /sales/includes/db/sales_order_db.inc and /reporting/rep111.php can be downloaded for replacement here and here.

Joe

  • gj6n68
  • Senior Member
  • Offline
  • From: UK, India
  • Registered: 02/14/2016
  • Posts: 81

Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11

Hi,

Thanks for this code.

I am trying to replicate the same on a Delivery Note but not able to see the results.

Also I noticed that in Delivery Note Report 109, there is a field called stk_code where as report 107 has field stock_id.

Not sure if that could cause issue.

Any help would be greatly appreciated.
Regards,
gj


harshadmwasule wrote:

Dear all,
I made following changes to sales/includes/db/sales_order_db.inc (line 285)

        line.description AS StockDescription,
        item.long_description AS StockLongDescription,
               
and added following code in rep111

          if (!empty($SysPrefs->prefs['long_description_invoice']) && !empty($myrow2['StockLongDescription']))
          {
            $c--;
            $rep->TextColLines($c++, $c, $myrow2['StockLongDescription'], -2);
          }

it solved my concern

Thanks

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

Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11

stk_code is a valid field

It is a field in the 0_sales_order_details table

apmuthu's Website