采购管理表头现存量带不出来

sdwsjeff

已经确定是V_CurrentStock_WH 视图里面为空的原因，造成表头现存量显示全部为0.但是该视图语句没有错误，请教下该如何解决呢？

解决了，该视图为空的原因 是仓库未纳入可用量计算，造成采购管理模块不能识别仓库代码无法带出相应的现存量，纳入可用量计算是默认勾选的，同事加仓库档案的时候去掉了

xmzlwyq

不明白说了什么 能否 截图说明？

一般情况表头是不会有现存量的，只有表体才有。

因为表头针对是整张单子 表体针对的是每个产品

而现存量必然也是针对每个产品的，如果你设置在表头，那么现存量到底针对的是哪个产品呢？

yzc520wyz

学习学习.......

wanshaokang

跪求大神，我是解决不了！

wozengcong

用友一个神奇的软件

syryaya

SELECT C.cWhCode, C.cInvCode, C.cFree1, C.cFree2, C.cFree3, C.cFree4, C.cFree5,
      C.cFree6, C.cFree7, C.cFree8, C.cFree9, C.cFree10, C.cBatch, C.bStopFlag,
      C.BGSPSTOP, C.dLastCheckDate, C.cCheckState, C.dLastYearCheckDate,
      C.cVMIVenCode, MAX(C.cMassUnit) AS cMassUnit, MAX(C.iMassDate) AS iMassDate,
      MAX(C.dVDate) AS dVDate, MAX(C.dMdate) AS dMdate,
      (CASE WHEN isnull(I.cSRPolicy, '') = 'LP' AND isnull(I.bspecialorder, 0)
      = 1 THEN C.iSoType ELSE 0 END) AS iSoType, (CASE WHEN isnull(I.cSRPolicy, '')
      = 'LP' AND isnull(I.bspecialorder, 0) = 1 THEN C.iSodid ELSE 0 END) AS iSodid,
      SUM(C.iQuantity) AS iQuantity, SUM(C.iNum) AS iNum, SUM(C.fOutQuantity)
      AS fOutQuantity, SUM(C.fOutNum) AS fOutNum, SUM(C.fInQuantity) AS fInQuantity,
      SUM(C.fInNum) AS fInNum, SUM(C.fTransInQuantity) AS fTransInQuantity,
      SUM(C.fTransInNum) AS fTransInNum, SUM(C.fTransOutQuantity)
      AS fTransOutQuantity, SUM(C.fTransOutNum) AS fTransOutNum, SUM(C.fPlanQuantity)
      AS fPlanQuantity, SUM(C.fPlanNum) AS fPlanNum, SUM(C.fDisableQuantity)
      AS fDisableQuantity, SUM(C.fDisableNum) AS fDisableNum, SUM(C.fAvaQuantity)
      AS fAvaQuantity, SUM(C.fAvaNum) AS fAvaNum, SUM(C.fStopQuantity)
      AS fStopQuantity, SUM(C.fStopNum) AS fStopNum
FROM dbo.CurrentStock C INNER JOIN
      dbo.Inventory I ON C.cInvCode = I.cInvCode LEFT OUTER JOIN
      dbo.Warehouse W ON C.cWhCode = W.cWhCode
WHERE (ISNULL(W.bInAvailCalcu, 0) = 1)
GROUP BY C.cWhCode, C.cInvCode, C.cFree1, C.cFree2, C.cFree3, C.cFree4, C.cFree5,
      C.cFree6, C.cFree7, C.cFree8, C.cFree9, C.cFree10, C.cBatch, C.bStopFlag,
      C.BGSPSTOP, C.dLastCheckDate, C.cCheckState, C.dLastYearCheckDate,
      C.cVMIVenCode, C.dVDate, (CASE WHEN isnull(I.cSRPolicy, '') = 'LP' AND
      isnull(I.bspecialorder, 0) = 1 THEN C.iSoType ELSE 0 END),
      (CASE WHEN isnull(I.cSRPolicy, '') = 'LP' AND isnull(I.bspecialorder, 0)
      = 1 THEN C.iSodid ELSE 0 END)
是哪个条件限制了

ksuser

把条件都去掉，再一次加上来，测试

lys2016

为空的原因是因为，你没选到对应表体的具体单项上面去。
如5楼解。

sdwsjeff

唉，不是视图的问题，是该仓库未纳入可用量计算，问题解决了