分期收款发出模式下，查询截止日期前的发出商品明细

供应链-仓库管理-查询分析-查询分析工具-新建-直接sql报表，建立关键字：@enddate@  标题：出库日期小于   数据类型：日期型  数据来源：手工录入；sql语句如下：

--删除临时表

if OBJECT_ID('tempdb..#kehu') is not null drop table #kehu;

if OBJECT_ID('tempdb..#xiaoshou') is not null drop table #xiaoshou;

if OBJECT_ID('tempdb..#fachu') is not null drop table #fachu;

--根据基础资料建立客户临时表

select * into #kehu from t_Item where FItemClassID='1';

--根据出库单、基础资料表建临时表

select ICStockBill.FBillNo as 'FBillNo',

#kehu.fnumber as 'khfnumber',

#kehu.fname as 'khfname',

CONVERT(varchar(10), ICStockBill.FDate, 23) as 'FDate',

t_Item.FName as 'wlFName',

ICStockBillEntry.FQty as'FQty',

ICStockBillEntry.FPrice as'FPrice',

ICStockBillEntry.FAmount as 'FAmount',

ICStockBill.fhookinterid as'fhookinterid',

icstockbillentry.fentryid as'fentryid'

into #xiaoshou

from ICStockBillEntry

left join ICStockBill on ICStockBill.FInterID=ICStockBillEntry.FInterID

left join #kehu on #kehu.fitemid=ICStockBill.FSupplyID

left join t_Item on t_Item.FItemID=ICStockBillEntry.FItemID

where ICStockBill.FTranType=21;

--根据勾稽单据查询发出商品明细，建立临时表

select #xiaoshou.fbillno as'出库单号',

 #xiaoshou.khfnumber as'客户代码',

 #xiaoshou.khfname a