  <br />
<b>Notice</b>:  Undefined index: empresa in <b>C:\xampp\htdocs\WAKOLIMA\Receiving\getReceivingListPDA.php</b> on line <b>7</b><br />
<br />
<b>Notice</b>:  Undefined index: bodega in <b>C:\xampp\htdocs\WAKOLIMA\Receiving\getReceivingListPDA.php</b> on line <b>8</b><br />
<br />
<b>Notice</b>:  Undefined index: UID in <b>C:\xampp\htdocs\WAKOLIMA\Receiving\getReceivingListPDA.php</b> on line <b>9</b><br />
Error in executing query. SELECT wms.ItemID AS 'itemID', wms.TRANSREFID AS 'UID', SUM (wms.QTY) AS 'qtyordered',ISNULL((SELECT SUM (CONFIRMDLVINVENT) FROM PURCHLINE WHERE DATAAREAID = WMS.DATAAREAID AND PURCHID = WMS.TRANSREFID
			AND ITEMID = WMS.ITEMID),0) AS 'qty', 'und' AS 'type', id.INVENTSERIALID AS 'country',
          (SELECT TOP 1 bar.ITEMBARCODE FROM dbo.InventItemBarcode bar WHERE wms.Itemid = bar.Itemid AND wms.dataareaid = bar.dataareaid) AS 'barcode',
         	wms.ITEMID AS 'Description', MAX (wms.INVENTTRANSID) AS 'Line', 1 AS 'factor' FROM dbo.INVENTTRANS wms INNER JOIN dbo.InventDim id ON wms.InventDimid = id.InventDimid
                  AND wms.dataareaid = id.dataareaid LEFT JOIN INVENTTABLEMODULE itm ON wms.itemid = itm.ITEMID AND MODULETYPE = '1' AND itm.DATAAREAID = WMS.DATAAREAID WHERE
                 	wms.TRANSREFID =  AND wms.dataareaid =  AND wms.TRANSTYPE = '3' AND id.INVENTLOCATIONID =  GROUP BY wms.itemid, wms.TRANSREFID, itm.unitid, id.INVENTSERIALID,
                         wms.DATAAREAID ORDER BY wms.itemidArray
(
    [0] => Array
        (
            [0] => 42000
            [SQLSTATE] => 42000
            [1] => 156
            [code] => 156
            [2] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'AND'.
            [message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'AND'.
        )

)