<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — Print Item Description on Invoices]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=6020</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=6020&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in Print Item Description on Invoices.]]></description>
		<lastBuildDate>Thu, 12 Nov 2015 11:25:09 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: Print Item Description on Invoices]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=24697#p24697</link>
			<description><![CDATA[<p>All these fields you stated are in the <strong>stock_master</strong> table:<br />Item Code =&gt; stock_id<br />Name =&gt; description<br />Description =&gt; long_description</p><p>On invoice creation, the last field above does not find a place in the <strong>debtor_trans_details</strong>.</p><p>The report <strong>rep107.php</strong> prints the invoices and uses the <strong><em>function</em> get_customer_trans_details()</strong> to fetch the transaction details and is defined in <strong>sales/includes/db/cust_trans_details_db.inc</strong>. The said function returns all fields of the <strong>debtor_trans_details</strong> table for the chosen transactions, along with an aliased field <strong>debtor_trans_details.description As StockDescription</strong> among others. In <strong>rep107.php</strong>, the variable <strong>$myrow2</strong> has the details of the current transaction being sent to the print output stream. </p><p>It is possible that this was a mistake and the real intention was to obtain the <strong>stock_master.long_description AS StockDescription</strong> which would sate your need. This will however need an extra join of the requisite table - stock_master - in the sql.</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Thu, 12 Nov 2015 11:25:09 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=24697#p24697</guid>
		</item>
		<item>
			<title><![CDATA[Print Item Description on Invoices]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=24695#p24695</link>
			<description><![CDATA[<p>I have an item with the following information (not the real information but close to it) attributed to it in the &quot;items&quot; tab:</p><p>Item Code: 0277654<br />Name: 0277654 - Very Large Thing For Very Little Money<br />Description: This thing is too large to be used by a human.</p><p>The invoices that I create using &quot;Direct Invoice&quot; show the following information:</p><p>Printed Under &quot;Item Code&quot; is 0277654<br />Printed under &quot;Item Description&quot; is 0277654</p><p>I&#039;d like either the contents of the &quot;Name&quot; field or the contents of the &quot;Description&quot; field or both fieds to to be displayed under &quot;Item Description&quot; on the invoice.</p><p>Is there an easy way to do this?</p><p>Thanks in advance,<br />Jack</p>]]></description>
			<author><![CDATA[null@example.com (kidzstang)]]></author>
			<pubDate>Thu, 12 Nov 2015 01:16:53 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=24695#p24695</guid>
		</item>
	</channel>
</rss>
