<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Manufactoring]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;fid=30&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>
		<entry>
			<title type="html"><![CDATA[Item Code of Manufacturing Item in WorkOrder]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10095&amp;action=new" />
			<summary type="html"><![CDATA[<p>I am looking for to print Item_ID Item_Code, but can not find for the&nbsp; manufactured item, I have tried <br />in doctext.inc file and found only Item&#039;s description in array $aux_info as _(&quot;Manufactured Item&quot;) =&gt; $this-&gt;formData[&quot;StockItemName&quot;].<br />But I need to print Stock_Item_Code instead of description.<br />Cany somebody help to resolve the issue.</p>]]></summary>
			<author>
				<name><![CDATA[sairmalhi]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=41874</uri>
			</author>
			<updated>2022-11-26T18:41:08Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10095&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Unable to void Work Order]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=9419&amp;action=new" />
			<summary type="html"><![CDATA[<p>While voiding work order the following error comes</p><p><a href="https://prnt.sc/1oesuya">https://prnt.sc/1oesuya</a></p><p>The possible fix could be following.</p><p>&nbsp; &nbsp; @@ -161,7 +161,7 @@ function void_work_order_produce($type_no)<br />&nbsp; &nbsp; &nbsp; &nbsp; return;</p><p>&nbsp; &nbsp; // deduct the quantity of this production from the parent work order<br />&nbsp; &nbsp; -&nbsp; work_order_update_finished_quantity($prod[&quot;workorder_id&quot;], -$prod[&quot;quantity&quot;], false);<br />&nbsp; &nbsp; + work_order_update_finished_quantity($prod[&quot;workorder_id&quot;], -$prod[&quot;quantity&quot;], 0);</p>]]></summary>
			<author>
				<name><![CDATA[boxygen]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20175</uri>
			</author>
			<updated>2021-08-14T06:14:06Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=9419&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Multiple units from single BOM]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=8703&amp;action=new" />
			<summary type="html"><![CDATA[<p>Hi Everyone,<br />My scenario is I use inputs to produce an item that will be broken down and used as an input further along the manufacturing process. Eventually I produce from 1 item up to 150 units of finished product.<br />So 10 item A + 5 item B + 10 item C = 24 item D. If the BOM module is structured to produce just one unit of the item then my BOM has to look like:<br />.4166667 item A + .208333 item B + .4166667 item C = 1 item D<br />I have done this before and it is inelegant and rounding can cause errors.<br />Is there any way to make the BOM read like the actual process:</p><p>10 item A + 5 item B + 10 item C = 24 item D</p><p>Then when I use item D I may take 5 item D + item E etc to produce Item F</p><p>In the actual scenario I am doing 90 + .33 + 2.5 +11&nbsp; = 90 so the decimals are very inelegant</p>]]></summary>
			<author>
				<name><![CDATA[kurt]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=45336</uri>
			</author>
			<updated>2020-02-29T11:07:44Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=8703&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Income & Statement]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=8502&amp;action=new" />
			<summary type="html"><![CDATA[<p>I want my manufacturing income statement showing conventional way can someone helps me how to do it.</p><br /><p>&nbsp; &nbsp; &nbsp; &nbsp; INCOME &amp; STATEMENT&nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; A&nbsp; &nbsp; Sales&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XXXXXXXX<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; B&nbsp; &nbsp; Cost of Sales&nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; Opening Stock&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; xxxxxxxxx<br />&nbsp; &nbsp; Add&nbsp; &nbsp; Purchases&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; xxxxxxxxx<br />&nbsp; &nbsp; &nbsp; &nbsp; Total Purchases&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; xxxxxxxxx<br />&nbsp; &nbsp; Less&nbsp; &nbsp; Closing Stock&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; xxxxxxxxx<br />&nbsp; &nbsp; &nbsp; &nbsp; Total Cost of Sales&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; xxxxxxxxx<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; <br />C&nbsp; &nbsp; A-B&nbsp; &nbsp; Gross Profit&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; xxxxxxxxx<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />D&nbsp; &nbsp; Less&nbsp; &nbsp; Geneal Admin Expenses&nbsp; &nbsp; xxxxxxxxx<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; C-D&nbsp; &nbsp; Net Profit&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; xxxxxxxxx</p>]]></summary>
			<author>
				<name><![CDATA[Marxist]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=44356</uri>
			</author>
			<updated>2019-11-11T20:12:13Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=8502&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Locating Material Reserved After Release?]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=8323&amp;action=new" />
			<summary type="html"><![CDATA[<p>When I release an Advanced Work Order, I am looking for the view or report that would show the material, which is on the BOM, as reserved or under the Demand column or somewhere. I would like Quantity Available to indicate the result of this material not being available after I release the work order. I would assume this is how it should work from the wiki:</p><div class="quotebox"><cite>Wiki wrote:</cite><blockquote><p>Manufactured Finished Goods Sequence</p><p>&nbsp; &nbsp; The material is first taken when producing.<br />&nbsp; &nbsp; The simple assembling is taken immediately from raw material.<br />&nbsp; &nbsp; For the advanced manufacturing this happens during producing.<br />&nbsp; &nbsp; Normally we don&#039;t use the work in progress as it generally goes from raw material directly to finished goods.<br />&nbsp; &nbsp; Of course the <strong>material is reserved after the release (Advanced Manufacturing)</strong>.</p></blockquote></div>]]></summary>
			<author>
				<name><![CDATA[paul]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=44798</uri>
			</author>
			<updated>2019-08-08T12:04:47Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=8323&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Ways to manage real-life manufacturing scenario]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=8262&amp;action=new" />
			<summary type="html"><![CDATA[<p>Hello guys, I am trying to figure out how to use and manage Manufacturing module as close as it gets to real application scenario and I am kinda stuck at the moment </p><p>This maybe more of a Accounting problem rather than the FA System. But however way Accounting designs it hopefully the FA System can support it through this module</p><p>We manufacture plastic bags and they are basically mixture of main raw material of plastic granule and other additives like coloring </p><p>To create / produce 1 type of black plastic bag for example we can only set estimate of how many additives are added on each product. Let&#039;s say, the current ratio is set to 5kg of black additives per 25kg raw material plastic granule </p><p>So to have 300kg black plastic bag as output. In theory it would have at least needed 50kg of black additives and 250kg raw material plastic granule as input</p><p>But there will always be loss material in the way, materials that are still left in the machines, some operator screw up ( ie more waste generated etc etc ) so that it may actually need, say on that day 312.5kg combined raw material + additives to produce 300kg net black plastic bag. On other day, it may need 315kg input</p><p>My question is how do you book these extra 12.5 - 15 kg material loss ? </p><p>Inventory Adjustment would book them directly as cost where it should be contributing to either COGM and / or COGS </p><p>Cheers<br />Arief</p>]]></summary>
			<author>
				<name><![CDATA[aleifuuwork]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=42567</uri>
			</author>
			<updated>2019-07-08T14:52:16Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=8262&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Update Material Cost Function]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=7929&amp;action=new" />
			<summary type="html"><![CDATA[<p>I have a suggestion that the function <strong>update_material_cost</strong> in manufacturing/includes/db/work_order_costing_db.inc shall be optimized or replaced with the function <strong>update_average_material_cost</strong> in purchasing/includes/db/grn_db.inc.</p><p>The former function is not calculating correct average cost with the logic defined at Line # 107</p><div class="codebox"><pre><code>if ($qoh == 0 &amp;&amp; $avg_cost != 0)
            $avg_cost = ($avg_cost + ($unit_cost*$qty_new)/$qty)/2;</code></pre></div>]]></summary>
			<author>
				<name><![CDATA[boxygen]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20175</uri>
			</author>
			<updated>2019-01-08T05:03:52Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=7929&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Added Functionality to Manufacture Multiple Products with One WO]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=7925&amp;action=new" />
			<summary type="html"><![CDATA[<p>Currently in FA Multiple Products can&#039;t be manufactured through Advance Manufacturing. This is necessary when we have several Raw Materials and Several Finished Goods and this case can&#039;t be handled via Unassembly Or Advance Manufacturing.</p><p>Have a look at this</p><p><a href="https://pakerp.net/fa_manu">Login Here</a><br />id: admin<br />pass: Pakistan1947</p>]]></summary>
			<author>
				<name><![CDATA[boxygen]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20175</uri>
			</author>
			<updated>2019-01-06T15:42:42Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=7925&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[An Irrational Behavior in Manufacturing Advanced Manufacturing]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=7908&amp;action=new" />
			<summary type="html"><![CDATA[<p>I have taken a Very Simple Case Through Advanced Manufacturing without defining BOM.</p><p>1. Manufacturing of 400 Kg rice Bags.</p><p>Day 1: <br />a. Raw Material of 200 Kg is Issued to WO.<br />b. Labour and OH Cost is also issued to Work Order<br />c. 200 KG of Rice Bags are Produced.<br />d. No Finished Good Inventory of Rice is Added.<br />e. We needed to Sell those 200 Bags but since No STock was added to Inventory the Invoice Couldn&#039;t be made.</p><p>Day 2:<br />a. Raw Material of 100 Kg is Issued to WO.<br />b. Labour and OH Cost is also issued to Work Order<br />c. 100 KG of Rice Bags are Produced.<br />d. No Finished Good Inventory of Rice is Added.<br />e. We needed to Sell those 100 Bags but since No STock was added to Inventory the Invoice Couldn&#039;t be made.</p><p>Day 3:<br />a. Raw Material of 100 Kg is Issued to WO.<br />b. Labour and OH Cost is also issued to Work Order<br />c. 100 KG of Rice Bags are Produced.<br />d. 400 Bags of Rice are Added to inventory and WO is set to Closed.</p><br /><p>My Question is Why Stock is not Added If Partial Production is Run. Is this any irrational behavior no one could figure out yet or it is lack of my understanding?</p><p>Any Idea?</p>]]></summary>
			<author>
				<name><![CDATA[boxygen]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20175</uri>
			</author>
			<updated>2018-12-28T14:36:09Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=7908&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Can we add more overheads in Manufacturing - Work order entry]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=7876&amp;action=new" />
			<summary type="html"><![CDATA[<p>hey,</p><p>can you please tell me is that we add more overhead while creating WOE</p><p>like we have manufacture a goods which is used as </p><p>1. Direct Material<br />2. Direct Factory OH<br />3. Indirect OH</p><p>in WOE you have two option </p><p>1. Labor Cost<br />2. Overhead Cost</p><p>if we want to add e.g Indirect OH - how can we do that?</p><p>or if there is a business of CONSTRUCTION OF BUILDING / HOUSING etc after purchasing the PLOTS like REAL ESTATE than how we can use FA for this businesses.</p><p>regards<br />need help</p>]]></summary>
			<author>
				<name><![CDATA[emiangel839]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=42510</uri>
			</author>
			<updated>2018-12-10T11:56:47Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=7876&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Easy FA for manufacturing, skipping BOM / Work Order]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=7535&amp;action=new" />
			<summary type="html"><![CDATA[<p>Hi guys, </p><br /><br /><p>Following is discussion for FA team, or, I guess for accountants in general </p><p>We are loving FA as a whole system. A whole, because it&#039;s the only few open-source software that <br />covers all aspect of business that we have ( We are in manufacturing ! ). kinda like SAP level, but <br />very much less daunting and looks like way more flexible </p><p>Speaking of flexibility, is there a way to &#039;skip&#039; the usual Manufacturing process like setting up Bill <br />of Material/Work Order of the day etc to determine the COST OF GOODS SOLD / Inventory costing ? </p><p>This is, just because there are many factors that goes into manufacturing process that software may/may not <br />able to reflect real data like how we want it to be. Sure, we can have assumption and the likes but We would<br />love to know if we can &#039;skip&#039; altogether it and use other way to determine COGS/Inventory part ? <br />( via daily inventory adjustment ... For example ) </p><br /><p>Many many thanks team<br />Keep up the good work </p><p>Cheers,</p>]]></summary>
			<author>
				<name><![CDATA[aleifuuwork]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=42567</uri>
			</author>
			<updated>2018-05-31T07:28:38Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=7535&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Would i need to used BOM as recipe]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=7470&amp;action=new" />
			<summary type="html"><![CDATA[<p>I need to create Recipe using BOM but have some difficulties for below criteria </p><p>we need to manufacture 216 Bun as unit and need to add BOM for it.Please help me how to do this.</p>]]></summary>
			<author>
				<name><![CDATA[maduranga2u]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=42444</uri>
			</author>
			<updated>2018-04-16T07:16:07Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=7470&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Can not release workorder]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=7464&amp;action=new" />
			<summary type="html"><![CDATA[<p>I suddenly cannot do any manufacturing. I cannot produce, nothing happens when I press &#039;Process and Close&#039;<br />The same applies for releasing a work order, nothing happens.<br />Any ideas.</p><p>Regards</p>]]></summary>
			<author>
				<name><![CDATA[alanmi]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=42117</uri>
			</author>
			<updated>2018-04-13T09:29:21Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=7464&amp;action=new</id>
		</entry>
</feed>
