SELECT a_icitem->item, SUM(ionhand) AS ionhand, 000000000.00000 AS lonhand, 000000000.00000 AS qohand FROM a_icitem WHERE &lc_itmfilt. GROUP BY item UNION (SELECT a_iciloc->item, 0 AS ionhand, SUM(lonhand) AS lonhand, 0 AS qonhand FROM a_iciloc WHERE &lc_locfilt. GROUP BY item UNION SELECT a_iciqty->item, 0 AS ionhand, 0 AS lonhand, SUM(a_iciqty->qonhand) AS qonhand FROM a_iciqty WHERE &lc_qtyfilt. GROUP BY item) INTO DBF (gc_idrvtmp + gc_tmpf1 + gc_extdbf)
a_tmpf1/e
a_tmpf1
a_tmpf2
Item Quantity Discrepancy
syrcn1
a_tmpf1
Beginning
Ending
Calculating Location discrepancies
SELECT a_iciloc->item, a_iciloc->loctid, a_iciloc->lonhand, SUM(a_iciqty->qonhand) AS qonhand FROM a_iciloc, a_iciqty WHERE a_iciloc->item + a_iciloc->loctid = a_iciqty->item + a_iciqty->loctid .AND. &lc_locfilt. GROUP BY 1, 2 ORDER BY 2, 1 INTO CURSOR a_tmpf1