<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Purchase order delivery changes purch_data table]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=9834&amp;type=atom" />
	<updated>2022-05-30T18:47:39Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=9834</id>
		<entry>
			<title type="html"><![CDATA[Re: Purchase order delivery changes purch_data table]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=41111#p41111" />
			<content type="html"><![CDATA[<p>purchasing/includes/purchasing_db.inc</p><p>Line 113<br /></p><div class="codebox"><pre><code>    if ($description != &quot;&quot;)
        $sql .= &quot;,supplier_description=&quot;.db_escape($description);
    $sql .= &quot; WHERE stock_id=&quot;.db_escape($stock_id).&quot; AND supplier_id=&quot;.db_escape($supplier_id);</code></pre></div><p>Why???</p><p>This means if the description is not empty e.g. already has data, change the supplier description.</p><p>If there is a reason for this, it does not work for me, as every time I receive an order my supplier description changes.</p><p>If I change the first line to&nbsp; <br /></p><div class="codebox"><pre><code>if ($description = &quot;&quot;)</code></pre></div><p>then the supplier data remains intact.</p><p>I think it would make more sense to scrap this section of code and simply check that the description is not empty when creating a product, which I&#039;m pretty sure FA does already.</p>]]></content>
			<author>
				<name><![CDATA[ckrosco]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=1158</uri>
			</author>
			<updated>2022-05-30T18:47:39Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=41111#p41111</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Purchase order delivery changes purch_data table]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=41106#p41106" />
			<content type="html"><![CDATA[<p>FA 2.4.11 default theme</p><p>When I enter a new purchase order, then click the Purchase Order Delivery link the data in the purch_data table changes.</p><p>Specifically the supplier_description data changes from e.g. </p><p>梨山武陵頂級烏龍茶 - 75 g - Wu Ling</p><p>to:</p><p>Wu Ling 75 grams</p><p>This shorter English description matches the description column of the item_codes table.</p><p>I would appreciate some ideas on why this is happening and how to prevent it.</p>]]></content>
			<author>
				<name><![CDATA[ckrosco]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=1158</uri>
			</author>
			<updated>2022-05-26T14:53:04Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=41106#p41106</id>
		</entry>
</feed>
