|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?注册账号
×
本帖最后由 yudong118 于 2013-2-20 13:55 编辑
此问题的解决方法在底楼,语句中没考虑核算的年份。
U8V10.0在存货核算---业务核算---正常单据记账中有些仓库看不到.有73个仓库的,但是过滤到后只有44个仓库。
请各位大大帮忙看下怎么解决这个问题。
以下是追踪到的数据- set nocount on
- Create Table #tmp052E4D0A3FCB458DBADA5BD39443ECED(fld1 nvarchar(300),fld2 nvarchar(300))
- Insert into #tmp052E4D0A3FCB458DBADA5BD39443ECED
- SELECT distinct WareHouse.cWhCode as 仓库编码 ,WareHouse.cWhName as 仓库名称 FROM WareHouse left join ia_summary on ia_summary.cwhcode=warehouse.cwhcode and ia_summary.imonth = 1 where isnull(warehouse.bincost,0)<>0 and isnull(ia_summary.iperiod,0)<> 1 AND (( WareHouse.cWhCode IN (Select cWhCode From Warehouse Where bInCost = 1)) or WareHouse.cWhCode is null) ORDER BY WareHouse.cWhCode
- Select cast(0 As bit) as bRefSelectColumn, * from #tmp052E4D0A3FCB458DBADA5BD39443ECED
复制代码 |
|