dr("本月收入_数量") = DataTables("仓库_采购入库单明细").Compute("Sum(数量)",s1)+DataTables("仓库_成品入库单明细").Compute("Sum(数量)",s1)+DataTables("仓库_领用退回单明细").Compute("Sum(数量)",s1)+DataTables("仓库_销售退货单明细").Compute("Sum(数量)",s1)
dr("本月发出_数量") = DataTables("仓库_领用出库单明细").Compute("Sum(数量)",s2)+DataTables("仓库_成品出库单明细").Compute("Sum(数量)",s2)+DataTables("仓库_销售出库单明细").Compute("Sum(数量)",s2)+DataTables("仓库_采购退货单明细").Compute("Sum(数量)",s2)+DataTables("仓库_物品报废单明细").Compute("Sum(数量)",s2)
dr("期初库存_数量") = DataTables("仓库_采购入库单明细").Compute("Sum(数量)",s3) + DataTables("仓库_成品入库单明细").Compute("Sum(数量)", s3) + DataTables("仓库_领用退回单明细").Compute("Sum(数量)", s3)+ DataTables("仓库_销售退货单明细").Compute("Sum(数量)", s3)- DataTables("仓库_领用出库单明细").Compute("Sum(数量)", s3)- DataTables("仓库_成品出库单明细").Compute("Sum(数量)", s3)- DataTables("仓库_销售出库单明细").Compute("Sum(数量)", s3)- DataTables("仓库_采购退货单明细").Compute("Sum(数量)", s3)- DataTables("仓库_物品报废单明细").Compute("Sum(数量)", s3)
dr("期末结存_数量") = dr("期初库存_数量") + dr("本月收入_数量") - dr("本月发出_数量")
收发存报表(仓库)的生成逻辑如上