<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — Manufactoring]]></title>
		<link>https://frontaccounting.com/punbb/index.php</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;fid=30&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent topics at FrontAccounting forum.]]></description>
		<lastBuildDate>Sun, 04 Aug 2024 19:45:53 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Manufacture BOM]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=10580&amp;action=new</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (tom)]]></author>
			<pubDate>Sun, 04 Aug 2024 19:45:53 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=10580&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Nothing shows up when i press the process and close order.]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=10544&amp;action=new</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (bikash.p.bp)]]></author>
			<pubDate>Sun, 23 Jun 2024 06:28:16 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=10544&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Item Code of Manufacturing Item in WorkOrder]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=10095&amp;action=new</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (sairmalhi)]]></author>
			<pubDate>Sat, 26 Nov 2022 18:41:08 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=10095&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Unable to void Work Order]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=9419&amp;action=new</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (boxygen)]]></author>
			<pubDate>Sat, 14 Aug 2021 06:14:06 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=9419&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Multiple units from single BOM]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=8703&amp;action=new</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (kurt)]]></author>
			<pubDate>Sat, 29 Feb 2020 11:07:44 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=8703&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Income & Statement]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=8502&amp;action=new</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (Marxist)]]></author>
			<pubDate>Mon, 11 Nov 2019 20:12:13 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=8502&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Locating Material Reserved After Release?]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=8323&amp;action=new</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (paul)]]></author>
			<pubDate>Thu, 08 Aug 2019 12:04:47 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=8323&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Ways to manage real-life manufacturing scenario]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=8262&amp;action=new</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (aleifuuwork)]]></author>
			<pubDate>Mon, 08 Jul 2019 14:52:16 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=8262&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Update Material Cost Function]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=7929&amp;action=new</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (boxygen)]]></author>
			<pubDate>Tue, 08 Jan 2019 05:03:52 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=7929&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Added Functionality to Manufacture Multiple Products with One WO]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=7925&amp;action=new</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (boxygen)]]></author>
			<pubDate>Sun, 06 Jan 2019 15:42:42 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=7925&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[An Irrational Behavior in Manufacturing Advanced Manufacturing]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=7908&amp;action=new</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (boxygen)]]></author>
			<pubDate>Fri, 28 Dec 2018 14:36:09 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=7908&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Can we add more overheads in Manufacturing - Work order entry]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=7876&amp;action=new</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (emiangel839)]]></author>
			<pubDate>Mon, 10 Dec 2018 11:56:47 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=7876&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Easy FA for manufacturing, skipping BOM / Work Order]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=7535&amp;action=new</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (aleifuuwork)]]></author>
			<pubDate>Thu, 31 May 2018 07:28:38 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=7535&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Would i need to used BOM as recipe]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=7470&amp;action=new</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (maduranga2u)]]></author>
			<pubDate>Mon, 16 Apr 2018 07:16:07 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=7470&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Can not release workorder]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=7464&amp;action=new</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (alanmi)]]></author>
			<pubDate>Fri, 13 Apr 2018 09:29:21 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=7464&amp;action=new</guid>
		</item>
	</channel>
</rss>
