I noticed that in WorkOrderIssue.php when issuing Controlled items and Serialised items the sign on the qty in the stockserialmoves table is different based on the type of item it is.
Since I want to use this in some paperwork I am creating I need it to be consistent.
Is there a reason for this or is it a bug?
If it is a bug which one should be correct so I can fix my code base?
Thanks,
Andrew
I issued 2 serial#'s of Item:6000001 and 500 of Batch for Item: 1000001
This is what my W/O Status looks like:
Code:
Material Requirements For this Work Order
Item Qty Required Qty Issued
Manual Issue 1000001 - ResMart Ultra POM Natural 10,000.00 500.00
Manual Issue 5000001 - Box Bottom 7 4
Manual Issue 5000002 - Box Liner 7 0
Manual Issue 5000003 - Box Cap 7 0
Additional Issue 6000001 - Serialised Item for testing 0 2
If controlled but NOT Serialised:
Code:
$SQL = "INSERT INTO stockserialmoves (stockmoveno,
stockid,
serialno,
moveqty)
VALUES ('" . $StkMoveNo . "',
'" . $_POST['IssueItem'] . "',
'" . $_POST['BatchRef'.$i] . "',
'" . filter_number_format($_POST['Qty'.$i]) . "')";
If Serialised:
Code:
$SQL = "INSERT INTO stockserialmoves (stockmoveno,
stockid,
serialno,
moveqty)
VALUES ('" . $StkMoveNo . "',
'" . $_POST['IssueItem'] . "',
'" . $SerialNo . "',
-1)";
So My table of data looks like this
Code:
stkitmmoveno stockmoveno stockid serialno moveqty
245 42 6000001 10001 -1
246 42 6000001 10002 -1
247 44 1000001 ABC123 500