<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — how to extract some info for sales invoice report]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=5573</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=5573&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in how to extract some info for sales invoice report.]]></description>
		<lastBuildDate>Mon, 23 Feb 2015 13:19:37 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[how to extract some info for sales invoice report]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=22683#p22683</link>
			<description><![CDATA[<p>Hi all.<br />I am trying to include some additional info into rep107 (sales invoice).</p><p>in a modified&nbsp; rep107.php file that was posted in this forum, I find (around line 107) the following code:</p><p>****<br />$Net = round2($sign * ((1 - $myrow2[&quot;discount_percent&quot;]) * $myrow2[&quot;unit_price&quot;] * $myrow2[&quot;quantity&quot;]),<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; user_price_dec());<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $SubTotal += $Net;<br />&nbsp; &nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; $DisplayPrice = number_format2($myrow2[&quot;unit_price&quot;],$dec);<br />&nbsp; &nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; $DisplayQty = number_format2($sign*$myrow2[&quot;quantity&quot;],get_qty_dec($myrow2[&#039;stock_id&#039;]));<br />&nbsp; &nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; $DisplayTaxRate = number_format2($myrow2[&quot;unit_tax&quot;] * 100 / $myrow2[&quot;unit_price&quot;],user_percent_dec()) . &quot;%&quot;;<br />&nbsp; &nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; $DisplayNet = number_format2($Net,$dec);<br />&nbsp; &nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; if ($myrow2[&quot;discount_percent&quot;]==0)<br />****</p><p>What I actually need is to show, instead of <br />number_format2($myrow2[&quot;unit_tax&quot;] * 100 / $myrow2[&quot;unit_price&quot;],user_percent_dec()) . &quot;%&quot;;</p><p>the field &#039;name&#039; of table &#039;item_tax_type&#039; which is associated to each item sold.</p><p>The purpose is to show per each item sold the code of the tax associated with the item as required by accounting here in Italy.<br />I cannot use the percentage as in the example but the name given to such tax, because some tax types need to be identified correctly: e.g. 0 VAT can depend on many reasons, export (a code), special VAT rate (another code), etc. </p><p>Is it feasible?<br />Any suggestions?</p><p>Thanks for the great job you are doing with FA!</p><p>Regards,</p><p>Carlo</p>]]></description>
			<author><![CDATA[null@example.com (carlo)]]></author>
			<pubDate>Mon, 23 Feb 2015 13:19:37 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=22683#p22683</guid>
		</item>
	</channel>
</rss>
