T+12.0专业版 管理全视图和存货默认供应商

1：管理全视图7月1日-7月31日数据 应收余额应付余额现金余额和7月1日-7月31日的 应收总账 应付总账 现金银行 对不上其他数据能对上，管理全视图选7月1日-7月31日 应收 应付 总账 现金银行 选7月1日-7月30日能对上 全视图的应收 应付余额 现金银行 现金银行余额 2：存货在选默认供应商时 重复出现同一个供应商多条。

可以打最新补丁解决。补丁号为\12.000.001.0028 说明：管理权视图中，获取应收余额、应付余额、现金银行余额时，拼接的时间条件有问题，没有带时分秒，导致缺少一天的数据。 

select isnull(sum(isnull(amount,0.0)) + sum(isnull(inamount,0)) - sum(isnull(outamount,0)),0) as cashaccount from cs_cashaccount as cashaccount where ((len(cashaccount.sourcevoucherauditor) != 0 and isperiodbeginning = 0) or isperiodbeginning = 1) and 1=1 and 1=1 and 1=1 and 1=1 and sourceVoucherDate<='2015-07-31' select isnull(sum(isnull(amount,0.0)-isnull(settleamount,0.0)),0) as balanceamount from arap_detail as detail where detail.isarflag = 1 and detail.auditflag = 1 and 1=1 and 1=1 and 1=1 and 1=1 and detail.registerdate<='2015-07-31' select isnull(sum(isnull(amount,0.0)-isnull(settleamount,0.0)),0) as balanceamount from arap_detail as detail where detail.isarflag = 0 and detail.auditflag = 1 and 1=1 and 1=1 and 1=1 and 1=1 and detail.registerdate<='2015-07-31'