今天写了一个正航的报表

功能与正航内的库存明细表报表相似,主要增加了标准成本/主供应商名称/仓库名称

 

SQL语句如下:

 

select d.ID as 主供应商编码,d.ShortName as 主供应商简称,a.ProdID 产品编码,a.Quantity as 数量,b.StdPrice 标准成本,b.CurrID 币别,a.WareID 仓库编码,c.WareHouseName 仓库名称  from comWareAmount as a

left join comProduct as b on a.ProdID=b.ProdID

left join comWareHouse as c on a.WareID=c.WareHouseID

left join comCustomer as d on b.Majorsupplier=d.ID

where a.Quantity!=0  and a.WareID!=06 and a.WareID!=08 and a.WareID!=09  and a.WareID!=10  and a.WareID!=11  and a.WareID!=16 and a.WareID!=24