RE: StockMovements.php: wrong results when customer has several branches
@HDeriauFF
...is the custbranch JOIN your addition to get the custbranch.brname ?
I don't see that custbranch is in the repository as a part of that query.
Not saying that it is wrong, but appears to be a custom change?
This is the current query in the repository for StockMovements:
Code:
$SQL = "SELECT stockmoves.stockid,
systypes.typename,
stockmoves.stkmoveno,
stockmoves.type,
stockmoves.transno,
stockmoves.trandate,
stockmoves.userid,
stockmoves.debtorno,
stockmoves.branchcode,
stockmoves.qty,
stockmoves.reference,
stockmoves.price,
stockmoves.discountpercent,
stockmoves.newqoh,
stockmoves.narrative,
stockmaster.decimalplaces,
stockmaster.controlled,
stockmaster.serialised
FROM stockmoves
INNER JOIN systypes
ON stockmoves.type=systypes.typeid
INNER JOIN stockmaster
ON stockmoves.stockid=stockmaster.stockid
WHERE stockmoves.loccode='" . $_POST['StockLocation'] . "'
AND stockmoves.trandate >= '" . $SQLAfterDate . "'
AND stockmoves.stockid = '" . $StockID . "'
AND stockmoves.trandate <= '" . $SQLBeforeDate . "'
AND hidemovt=0
ORDER BY stkmoveno DESC";
...if it happens to have been added as part of another post, then please add a link. I'm trying to catch-up on other forum changes/submissions since December.