Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Internal Stock Request - Many Issues
02-11-2018, 12:30 AM, (This post was last modified: 02-11-2018, 05:49 AM by VortecCPI.)
#2
RE: Internal Stock Request - No Sort / Bad Qty
Quantity issue is due to error on Line 685:

$sql = "SELECT SUM(purchorderdetails.quantityord-purchorderdetails.quantityrecd)*purchorderdetails.conversionfactor AS dem

Should be:

$sql = "SELECT SUM(purchorderdetails.quantityord-purchorderdetails.quantityrecd) AS dem

Reference DeliveryDetails.php and includes/SQL_CommonFunctions.inc.

Attached is my hack job for review which also includes an attempt to make the table look more like those in other scripts...

No luck with Prev / Next buttons though...


Attached Files
.php   InternalStockRequest.php (Size: 27.45 KB / Downloads: 3)
https://www.linkedin.com/in/eclipsepaulbecker
Reply


Messages In This Thread
RE: Internal Stock Request - No Sort / Bad Qty - by VortecCPI - 02-11-2018, 12:30 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)