Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Different sign for stockserialmove records for WO Issue
03-29-2014, 06:43 AM, (This post was last modified: 03-29-2014, 06:43 AM by agaluski.)
#1
Different sign for stockserialmove records for WO Issue
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
Reply
03-29-2014, 07:24 AM,
#2
RE: Different sign for stockserialmove records for WO Issue
Hi Andrew, looks like the sign on the batches is wrong to me. Should be -500

Thanks
Tim
Reply
03-31-2014, 11:38 PM,
#3
RE: Different sign for stockserialmove records for WO Issue
Work Order Issue allows negative batches as well meaning you can issue a Lot you do NOT have in stock regardless of the allow negative flag as long as total QOH stays positive
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)