Re: [WebERP-developers] Inventory in Manufacturing

[webERP D. <web...@li...>]

Phil,

I think that changing the work order receive code is the way to proceed. 
The following scenario might possibly work:

1) Remove the material issue function.  It is only a means to allow for
tracking inventory location and issuing whole batches.  There are too many
problems with the batch issue to make it a viable solution.  If one needs to
keep batches isolated, the existing method might be somehow forced to work,
but the shop discipline is too difficult to implement.  One can only manage
one batch at a time.  The users must keep track to the side on the usage and
then issue the next batch.  Scrap is not handled at all.

2) If batch or serial numbered items are in the BOM, a special receiving
function is needed.  In the receiving function, the user would enter the
serial number or batch of the components used in the new serial/batch
controlled item.

3) A check should be made when creating a BOM that the item being created
matches the control type of the strictest component in the BOM, i.e. an
uncontrolled item can't require a controlled and a batch controlled item
can't require a serial numbered item.

Bob Thomas

P.S. I had submitted a simple change to item issue to code to insure that
only items that existed are available for issue.  The system always keeps a
record of where serial numbered items have been stored.  When an item is
removed, the location/serial number pair is set to quantity zero.

4.10.1 WorkOrderIssue.php

			$SerialNoResult = DB_query("SELECT serialno
										FROM stockserialitems
										WHERE stockid='" . $_POST['IssueItem'] . "'
										AND loccode='" . $_POST['FromLocation'] . "'",

Corrected Code:

			$SerialNoResult = DB_query("SELECT serialno
										FROM stockserialitems
										WHERE stockid='" . $_POST['IssueItem'] . "'
										AND loccode='" . $_POST['FromLocation'] . "'
										AND quantity > 0",



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Inventory-in-Manufacturing-tp4656561p4656581.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.