<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Long Description on Sales Quotation not working FrontAccounting 2.4.11]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=9788&amp;type=atom" />
	<updated>2022-09-10T16:30:18Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=9788</id>
		<entry>
			<title type="html"><![CDATA[Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=41434#p41434" />
			<content type="html"><![CDATA[<p><strong>stk_code</strong> is a valid field</p><p>It is a field in the <strong>0_sales_order_details</strong> table</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2022-09-10T16:30:18Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=41434#p41434</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=41430#p41430" />
			<content type="html"><![CDATA[<p>Hi,</p><p>Thanks for this code.</p><p>I am trying to replicate the same on a Delivery Note but not able to see the results.</p><p>Also I noticed that in Delivery Note Report 109, there is a field called stk_code where as report 107 has field stock_id.</p><p>Not sure if that could cause issue.</p><p>Any help would be greatly appreciated.<br />Regards,<br />gj</p><br /><div class="quotebox"><cite>harshadmwasule wrote:</cite><blockquote><p>Dear all,<br />I made following changes to sales/includes/db/sales_order_db.inc (line 285)</p><p>&nbsp; &nbsp; &nbsp; &nbsp; line.description AS StockDescription,<br />&nbsp; &nbsp; &nbsp; &nbsp; item.long_description AS StockLongDescription,<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />and added following code in rep111 </p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (!empty($SysPrefs-&gt;prefs[&#039;long_description_invoice&#039;]) &amp;&amp; !empty($myrow2[&#039;StockLongDescription&#039;]))<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $c--;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $rep-&gt;TextColLines($c++, $c, $myrow2[&#039;StockLongDescription&#039;], -2);<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }</p><p>it solved my concern </p><p>Thanks</p></blockquote></div>]]></content>
			<author>
				<name><![CDATA[gj6n68]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=21080</uri>
			</author>
			<updated>2022-09-09T10:42:53Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=41430#p41430</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=41105#p41105" />
			<content type="html"><![CDATA[<p>This has now been fixed and committed to stable repo.</p><p>2 fixed files, /sales/includes/db/sales_order_db.inc and /reporting/rep111.php can be downloaded for replacement <a href="http://Long%20Description%20on%20Sales%20Quotation%20not%20working%20FrontAccounting%202.4.11">here</a> and <a href="https://sourceforge.net/p/frontaccounting/git/ci/master/tree/sales/includes/db/sales_order_db.inc">here</a>.</p><p>Joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2022-05-26T14:02:59Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=41105#p41105</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=41078#p41078" />
			<content type="html"><![CDATA[<p>Well, we could implement @harshadmwasule&#039;s solution. Will ha a look at this when back in office.</p><p>Joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2022-05-21T15:29:20Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=41078#p41078</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=41075#p41075" />
			<content type="html"><![CDATA[<p>@joe?</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2022-05-21T14:19:05Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=41075#p41075</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=41024#p41024" />
			<content type="html"><![CDATA[<p>Dear all,<br />I made following changes to sales/includes/db/sales_order_db.inc (line 285)</p><p>&nbsp; &nbsp; &nbsp; &nbsp; line.description AS StockDescription,<br />&nbsp; &nbsp; &nbsp; &nbsp; item.long_description AS StockLongDescription,<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />and added following code in rep111 </p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (!empty($SysPrefs-&gt;prefs[&#039;long_description_invoice&#039;]) &amp;&amp; !empty($myrow2[&#039;StockLongDescription&#039;]))<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $c--;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $rep-&gt;TextColLines($c++, $c, $myrow2[&#039;StockLongDescription&#039;], -2);<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }</p><p>it solved my concern </p><p>Thanks</p>]]></content>
			<author>
				<name><![CDATA[harshadmwasule]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=46638</uri>
			</author>
			<updated>2022-05-09T12:29:26Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=41024#p41024</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=41012#p41012" />
			<content type="html"><![CDATA[<p>Hi,<br />The whole thing about Long Item Description started with this thread.<br />https://frontaccounting.com/punbb/viewtopic.php?id=8832<br />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. </p><p>@Joe.. can this (Long Item Description on Quotations) be implemented with ease or we need to Wait?</p><p>Thanks</p>]]></content>
			<author>
				<name><![CDATA[rafat]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=41964</uri>
			</author>
			<updated>2022-05-07T06:57:44Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=41012#p41012</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=41009#p41009" />
			<content type="html"><![CDATA[<p>Dear all,</p><p>Can some one help in this </p><p>I was using long description in the old version(2.4.9) on sales quotation.</p><p>But the same is not working in the&nbsp; FrontAccounting 2.4.11. it just adds a blank line space.</p><p>Use Long Descriptions on Invoices in settings is already checked.</p><p>Is it bug or I need to do some settings.</p>]]></content>
			<author>
				<name><![CDATA[harshadmwasule]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=46638</uri>
			</author>
			<updated>2022-05-07T05:19:24Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=41009#p41009</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=40969#p40969" />
			<content type="html"><![CDATA[<p>Thanks for your reply. </p><p>lets see if someone can help me in this. </p><p>I will also do as said by you.</p>]]></content>
			<author>
				<name><![CDATA[harshadmwasule]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=46638</uri>
			</author>
			<updated>2022-05-03T06:44:50Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=40969#p40969</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=40968#p40968" />
			<content type="html"><![CDATA[<p>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&nbsp; 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.</p>]]></content>
			<author>
				<name><![CDATA[rafat]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=41964</uri>
			</author>
			<updated>2022-05-03T05:44:09Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=40968#p40968</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=40967#p40967" />
			<content type="html"><![CDATA[<p>Thanks Rafat again for reply,</p><p>@my environment</p><p>Database server<br />Server: Localhost via UNIX socket<br />Server version: 10.1.48-MariaDB - MariaDB Server<br />Protocol version: 10<br />Server charset: cp1252 West European (latin1)<br />Web server<br />nginx/1.15.10<br />PHP version: 7.2.30<br />phpMyAdmin<br />Version information: 5.1.1, latest stable version: 5.1.3</p><p>@ language English, for both description and long description.</p><p>@ 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?</p>]]></content>
			<author>
				<name><![CDATA[harshadmwasule]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=46638</uri>
			</author>
			<updated>2022-05-03T04:48:56Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=40967#p40967</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=40964#p40964" />
			<content type="html"><![CDATA[<p>It could be a php version problem. Please mention your environment setup. I believe php8 is not yet fully supported by FA.<br />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.</p>]]></content>
			<author>
				<name><![CDATA[rafat]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=41964</uri>
			</author>
			<updated>2022-05-02T15:34:20Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=40964#p40964</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Long Description on Sales Quotation not working FrontAccounting 2.4.11]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=40963#p40963" />
			<content type="html"><![CDATA[<p>Dear all,</p><p>I was using long description in the old version(2.4.9) on sales quotation. </p><p>But the same is not working in the&nbsp; FrontAccounting 2.4.11. it just adds a blank line space.</p><p>Use Long Descriptions on Invoices in settings is already checked.</p><p>Is it bug or I need to do some settings.</p>]]></content>
			<author>
				<name><![CDATA[harshadmwasule]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=46638</uri>
			</author>
			<updated>2022-05-02T13:58:38Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=40963#p40963</id>
		</entry>
</feed>
