<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Manufacturing]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;fid=8&amp;type=atom" />
	<updated>2024-08-04T19:45:53Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/index.php</id>
		<entry>
			<title type="html"><![CDATA[Manufacture BOM]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10580&amp;action=new" />
			<summary type="html"><![CDATA[<p>I have ported my db from 2.4.6 to 2.4.18 </p><p>I have a number of products are are assembled with a BOM and when I have all the items required I get the following error</p><p>&lt;b&gt;DATABASE ERROR :&lt;/b&gt; The work requirements issued quantity couldn&#039;t be updated&lt;br&gt;error code : 1048&lt;br&gt;error message : Column &#039;unit_cost&#039; cannot be null&lt;br&gt;sql that failed was : UPDATE 0_wo_requirements SET <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; unit_cost = (units_issued*unit_cost+0)/(units_issued+0),<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; units_issued = units_issued + &#039;0&#039;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHERE id = &#039;8652&#039;&lt;br&gt;&lt;br&gt;&lt;br&gt;</p><p>I am am able to enter other work orders</p><p>in wo_requirements the highest id is 8616 and the SQL refers to 8652</p><p>strange</p><p>I am using PHP 7.4.33 and mysql 8.0</p>]]></summary>
			<author>
				<name><![CDATA[tom]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=331</uri>
			</author>
			<updated>2024-08-04T19:45:53Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10580&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Nothing shows up when i press the process and close order.]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10544&amp;action=new" />
			<summary type="html"><![CDATA[<p>i have already set the bom as required and enter the work order. then selected the advance manufacturing option while entering work order. all done without mistake but FA does not show any response while i hit the process or process and close order under production tab. please anyone short this problem for me. i am stuck at this point.<br />No response from the FA software.</p>]]></summary>
			<author>
				<name><![CDATA[bikash.p.bp]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=47769</uri>
			</author>
			<updated>2024-06-23T06:28:16Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10544&amp;action=new</id>
		</entry>
</feed>
