Edit Report:Vendor Price Compare
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Vendor Price Compare
-- HOLDING REPORT NEEDS FILTERS
-- ^sales
--
select stockid, description,
(select name from manufacturer where manufacturer_id = (
(select manufacturer_id from product_to_manufacturer where product_to_manufacturer.stockid = stockmaster.stockid )
)) as brand,
(select price from purchdata where stockid = stockmaster.stockid and supplierno='FKL') as fklprice,
(select price from purchdata where stockid = stockmaster.stockid and supplierno='ATD') as atdprice
from stockmaster where stockid in (select stockid from remotestock)