SELECT part_no, revision, whno, qtyisu, date, issuedto , transref;
FROM invt_isu, inventor;
WHERE invt_isu.uniq_key = inventor.uniq_key;
INTO CURSOR seeissues
BROWSE last
SELECT part_no, revision, warehouse, qtyrec, date, commrec , transref;
FROM invt_rec, inventor;
WHERE invt_rec.uniq_key = inventor.uniq_key;
INTO CURSOR seereceipts
BROWSE last
SELECT part_no, revision, qtyxfer, date, reason , transref;
FROM invttrns, inventor;
WHERE invttrns.uniq_key = inventor.uniq_key;
INTO CURSOR seetransfers
BROWSE last
Once you have this information setup , you can expand it to include serial numbers, lot codes, initials, etc.
|