Post Reply 
 
Thread Rating:
  • 0 Votes - 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.)
Post: #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
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
Different sign for stockserialmove records for WO Issue - agaluski - 03-29-2014 06:43 AM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)