<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — Purchase order delivery changes purch_data table]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=9834</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=9834&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in Purchase order delivery changes purch_data table.]]></description>
		<lastBuildDate>Mon, 30 May 2022 18:47:39 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: Purchase order delivery changes purch_data table]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=41111#p41111</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (ckrosco)]]></author>
			<pubDate>Mon, 30 May 2022 18:47:39 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=41111#p41111</guid>
		</item>
		<item>
			<title><![CDATA[Purchase order delivery changes purch_data table]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=41106#p41106</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (ckrosco)]]></author>
			<pubDate>Thu, 26 May 2022 14:53:04 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=41106#p41106</guid>
		</item>
	</channel>
</rss>
