成本计算单 查询报错
金蝶云社区-139xxxx8724
139xxxx8724
0人赞赏了该文章 564次浏览 未经作者许可,禁止转载编辑于2016年12月08日 12:00:18

系统版本:K3 Cloud 5.0
-----------------------------------------
如下图所示:

成本计算单就2016年11月份烟具单据没法查询和导出,查询报错如下图所示:


------------------------------------------------------------------------
跟踪数据 SQL 语句如下:
exec sp_executesql
N'INSERT INTO #TM_CB_COSTCALBILLRPT (
FID, FYearPeriod, FYearPeriodSeq, FOrderBillNo, FOrderBillSeq, FPRODUCTEDTYPE, FCOSTCENTERID,FPRODUCTID, FProductDimeId, FPRODUCTNO, FBillNoSeq, FBILLSeq, FPRODUCTID_FNUMBER, FPRODUCTID_FNAME, FSPECIFICATION, FCOSTCENTERNUMBER, FCOSTCENTERNAME, FBATCHFIELD_FNAME, FMTONO, FBOMNUMBERFIELD_FNUMBER, FAuxPropId, FBASICUNITFIELD_FNAME, FQTYDIGITS, FAMOUNTDIGITS, FPlanQty, FBeginQty, FBeginAmount, FCurrInputQty, FCurrInputAmount, FAdjCurrInputQty, FAdjCurrInputAmount, FSumCurrInputQty, FSumCurrInputAmount, FSumInputQty, FSumInputAmount, FEndQty, FEndAmount, FCompleteQty, FProductUseCost, FCompleteAmount, FSumQualifiedInQty, FSumQualifiedInAmount, FSumDysInQty,
FSumDysInAmount, FSumWasteInQty, FSumWasteInAmount, FSumCompleteQty, FSumProductUseCost, FSumCompleteAmount)
SELECT product.FID, ((CONVERT(VARCHAR(8000), acctg.FYear) + N''年'') + CONVERT(VARCHAR(8000), acctg.FPeriod)) + N''期'', (acctg.FYear * 100) + acctg.FPeriod, product.FORDERBILLNO, CASE WHEN product.FOrderBillSeq = 0 THEN '' '' ELSE CONVERT(VARCHAR(8000), product.FOrderBillSeq) END, CASE WHEN productDime.FPROORDERTYPE = ''PO'' THEN N''普通生产'' WHEN productDime.FPROORDERTYPE = ''SPO'' THEN N''简单生产'' WHEN productDime.FPROORDERTYPE = ''REM'' THEN N''重复生产'' ELSE N''委外生产'' END, CONVERT(VARCHAR(8000), productDime.FCOSTCENTERID), CONVERT(VARCHAR(8000), productDime.FPRODUCTID), product.FPRODUCTDIMEID, productDime.FPRODUCTNO, '' '', CASE WHEN productDime.FBILLSeq = 0 THEN '' '' ELSE CONVERT(VARCHAR(8000), productDime.FBILLSeq) END, product_M.FNUMBER, ISNULL(material_L.FName, '' ''), ISNULL(material_L.FSpecification, '' ''), ISNULL(center.FNumber, '' ''), ISNULL(center_L.FName, '' ''), ISNULL(lot.FNumber, '' ''), ISNULL(productDime.FMTONO, N'' ''), ISNULL(bom.FNumber, '' ''), product.FAuxPropId, ISNULL(unit_L.FName, '' ''), unit.FPrecision, @FAMOUNTDIGITS, product.FPlanQty, masResult.FBeginQty, masResult.FBeginAmount, masResult.FCurrInputQty, masResult.FCurrInputAmount, masResult.FAdjCurrInputQty, masResult.FAdjCurrInputAmount, masResult.FCurrInputQty + masResult.FAdjCurrInputQty, masResult.FCurrInputAmount + masResult.FAdjCurrInputAmount, masResult.FSumCurrInputQty, masResult.FSumCurrInputAmount, masResult.FEndQty, masResult.FEndAmount, masResult.FQualifiedInQty + masResult.FDysInQty + masResult.FWasteInQty, CASE WHEN (masResult.FQualifiedInQty + masResult.FDysInQty + masResult.FWasteInQty) = 0 THEN 0 ELSE ROUND(((masResult.FQualifiedInAmount + masResult.FDysInAmount + masResult.FWasteInAmount) / (masResult.FQualifiedInQty + masResult.FDysInQty + masResult.FWasteInQty)), 10) END, masResult.FQualifiedInAmount + masResult.FDysInAmount + masResult.FWasteInAmount, masResult.FSumQualifiedInQty, masResult.FSumQualifiedInAmount, masResult.FSumDysInQty, masResult.FSumDysInAmount, masResult.FSumWasteInQty, masResult.FSumWasteInAmount, masResult.FSumQualifiedInQty + masResult.FSumDysInQty + masResult.FSumWasteInQty, CASE WHEN (masResult.FSumQualifiedInQty + masResult.FSumDysInQty + masResult.FSumWasteInQty) = 0 THEN 0 ELSE ROUND(((masResult.FSumQualifiedInAmount + masResult.FSumDysInAmount + masResult.FSumWasteInAmount) / (masResult.FSumQualifiedInQty + masResult.FSumDysInQty + masResult.FSumWasteInQty)), 10) END, masResult.FSumQualifiedInAmount + masResult.FSumDysInAmount + masResult.FSumWasteInAmount
FROM T_CB_PROORDERINFO_H product
INNER JOIN T_CB_CostCalExpense_H masResult ON product.FID = masResult.FID
INNER JOIN T_CB_PROORDERDIME productDime ON product.FProductDimeId = productDime.FProductDimeId
INNER JOIN T_HS_OUTACCTG acctg ON product.FACCTGID = acctg.FId
INNER JOIN t_bd_Material product_M ON productDime.FPRODUCTID = product_M.FMATERIALID
LEFT OUTER JOIN t_bd_Material_l material_L ON (material_L.FMaterialId = product_M.FMATERIALID AND material_L.FLOCALEID = 2052)
INNER JOIN T_BD_MATERIALBASE baseunit ON baseunit.FMaterialId = product_M.FMATERIALID
INNER JOIN T_BD_UNIT unit ON baseunit.FBaseUnitId = unit.FUNITID
LEFT OUTER JOIN T_BD_UNIT_L unit_L ON (unit.FUNITID = unit_L.FUNITID AND unit_L.FLOCALEID = 2052)
LEFT OUTER JOIN T_CB_COSTCENTER center ON productDime.FCOSTCENTERID = center.FCOSTCENTERID
LEFT OUTER JOIN T_CB_COSTCENTER_L center_L ON (center_L.FCOSTCENTERID = center.FCOSTCENTERID AND center_L.FLOCALEID = 2052)
LEFT OUTER JOIN t_eng_bom bom ON product.FBOMId = bom.FID
LEFT OUTER JOIN T_BD_LOTMASTER lot ON product.FLOT = lot.FLOTID
WHERE (((((product.FENDINITKEY = ''1'' AND acctg.FDIMENSIONID = @FDIMEID)
AND (product.FACCTGID >= @FSTARTACCTGID)) AND (product.FACCTGID <= @FENDACCTGID))
AND (center.FNumber >= @FStartCostCenterNo))
AND (center.FNumber <= @FEndCostCenterNo))',N'@FAMOUNTDIGITS int,@FDIMEID bigint,@FSTARTACCTGID bigint,@FENDACCTGID bigint,
@FStartCostCenterNo nvarchar(10),@FEndCostCenterNo nvarchar(10)',@FAMOUNTDIGITS=2,@FDIMEID=4,@FSTARTACCTGID=100043,
@FENDACCTGID=100043,@FStartCostCenterNo=N'CBZX000003',@FEndCostCenterNo=N'CBZX000003'

您的鼓励与嘉奖将成为创作者们前进的动力,如果觉得本文还不错,可以给予作者创作打赏哦!

请选择打赏金币数 *

10金币20金币30金币40金币50金币60金币
可用金币: 0