| Receipt# |
Date |
Unit |
Qty |
Currency |
Cur.Rate |
Cost |
Exp.Date |
Supplier |
select
osrv.code,
osrv.odate,
c_uom.description as uom,
osrv.qty,
osrv.rate+(osrv.cost/osrv.qty) as cost,
c_suppliers.description as supplier,
osrv.edate,
cur.sform,
cur.currate
from osrv
left join c_uom on c_uom.code=osrv.uom
left join c_suppliers on c_suppliers.code=osrv.client
left join cur on cur.code=c_suppliers.currency
where osrv.item=''
group by osrv.barcode
order by osrv.odate desc limit 20