用友u8软件销售订单统计表查询销售订单统计表查询
销售订单统计表查询原因分析:请在2007年度账套执行脚本,在执行脚本文件前请备份账套. 脚本: --更新销售订单累计出库数量 Begin --发货单更新累计发货数量和金额 Update so_sodetails Set iFHQuantity = (Select Sum(IsNull(iQuantity, 0)) From Dispatchlists bs Where bs.iSOsID = so_sodetails.iSOsID ), iFHNum = (Select Sum(IsNull(iNum, 0)) From Dispatchlists bs Where bs.iSOsID = so_sodetails.iSOsID ), iFHMoney = (Select Sum(IsNull(iSum, 0)) From Dispatchlists bs Where bs.iSOsID = so_sodetails.iSOsID ) --发票更新累计开票金额 Update SO_SODetails Set iKPQuantity = (Select Sum(IsNull(iQuantity, 0)) From SaleBillVouchs bs Where bs.iSOsID = so_sodetails.iSOsID ), iKPNum = (Select Sum(IsNull(iNum, 0)) From SaleBillVouchs bs Where bs.iSOsID = so_sodetails.iSOsID ), iKPMoney = (Select Sum(IsNull(iSum, 0)) From SaleBillVouchs bs Where bs.iSOsID = so_sodetails.iSOsID ) End 问题解答:请在2007年度账套执行脚本,在执行脚本文件前请备份账套. 脚本: --更新销售订单累计出库数量 Begin --发货单更新累计发货数量和金额 Update so_sodetails Set iFHQuantity = (Select Sum(IsNull(iQuantity, 0)) From Dispatchlists bs Where bs.iSOsID = so_sodetails.iSOsID ), iFHNum = (Select Sum(IsNull(iNum, 0)) From Dispatchlists bs Where bs.iSOsID = so_sodetails.iSOsID ), iFHMoney = (Select Sum(IsNull(iSum, 0)) From Dispatchlists bs Where bs.iSOsID = so_sodetails.iSOsID ) --发票更新累计开票金额 Update SO_SODetails Set iKPQuantity = (Select Sum(IsNull(iQuantity, 0)) From SaleBillVouchs bs Where bs.iSOsID = so_sodetails.iSOsID ), iKPNum = (Select Sum(IsNull(iNum, 0)) From SaleBillVouchs bs Where bs.iSOsID = so_sodetails.iSOsID ), iKPMoney = (Select Sum(IsNull(iSum, 0)) From SaleBillVouchs bs Where bs.iSOsID = so_sodetails.iSOsID ) End