查询应收账款明细表时已勾稽出库单依然会显示出来
金蝶云社区-mifeng3508
mifeng3508
0人赞赏了该文章 3,016次浏览 未经作者许可,禁止转载编辑于2015年01月08日 13:21:46
金蝶KIS专业版10.0sp1,查询【应收账款明细表】发现已正常出库、勾稽的销售出库单会再次显示在应收账款明细表中,排除单据作废,退货或者红字发票的可能,确认原因为销售出库单内码跟销售发票内码重复造成,以下代码缺少单据标志判断(and fibtag=1),请出补丁更正:
注:有不清楚处请联系QQ1158005201
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Select v1.FInterID,v1.FTranType,v1.FDate,v2.FName,v1.FBillNO,t1.FNumber,t1.FShortNumber,t1.FName,v1.FExplanation,v.FConsignAmount,v.FConsignAmount,
(Case v1.FSaleStyle When 100 then v.FConsignAmount else 0 End),(Case v1.FSaleStyle When 100 then v.FConsignAmount else 0 End),
(Case v1.FSaleStyle When 100 then 0 else v.FConsignAmount End),(Case v1.FSaleStyle When 100 then 0 else v.FConsignAmount End) FROM ICStockBill v1
Join (Select tt.FInterID as FInterID,Sum(isnull(tt.FConsignAmount,0)) as FConsignAmount from ICStockBillEntry tt
Inner Join Ichookrelations z on tt.Finterid=z.FIbinterid and tt.Fentryid=z.Fentryid --此处缺少 and fibtag=1
Where z.Fyear > year('2014/9/30') or ( z.Fyear = year('2014/9/30') and z.Fperiod> month('2014/9/30'))
Group by tt.FInterID) v On v1.FInterID = v.FInterID
Join ICTransactionType v2 On v1.FTranType = v2.FID
Join t_Organization t1 On v1.FSupplyID = t1.FItemID
where v1.FCancellation=0 AND v2.FID = 21 AND v.FConsignAmount<>0 AND t1.FNumber>='02.021'
AND t1.FNumber<='02.021'
AND v1.FDate >='2010/11/1' AND v1.FDate <='2014/9/30'
AND (v1.FStatus<>0)
-----------------------------------------------------------------------------------------------------------------------------------------------

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

请选择打赏金币数 *

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