|
- 可用量: IIf([初始库存]![物料编号]=[入库总量]![物料编号] And [初始库存]![物料编号]=[出库总量]![厂商料号] And [初始库存]![物料编号]=[采购在外量汇总]![物料编号] And [初始库存]![物料编号]=[业务未交量汇总]![厂商料号],[初始库存]![期初库存]+[入库总量]![入库总量]+[采购在外量汇总]![在外总量]-[出库总量]![出库总量]-[业务未交量汇总]![未交总量],IIf([初始库存]![物料编号]=[入库总量]![物料编号] And [初始库存]![物料编号]=[采购在外量汇总]![物料编号] And [初始库存]![物料编号]<>[出库总量]![厂商料号] And [初始库存]![物料编号]<>[业务未交量汇总]![厂商料号],[初始库存]![期初库存]+[入库总量]![入库总量]+[采购在外量汇总]![在外总量],IIf([初始库存]![物料编号]=[入库总量]![物料编号] And [初始库存]![物料编号]=[采购在外量汇总]![物料编号] And [初始库存]![物料编号]<>[出库总量]![厂商料号] And [初始库存]![物料编号]=[业务未交量汇总]![厂商料号],[初始库存]![期初库存]+[入库总量]![入库总量]+[采购在外量汇总]![在外总量]-[业务未交量汇总]![未交总量],IIf([初始库存]![物料编号]=[出库总量]![厂商料号] And [初始库存]![物料编号]=[业务未交量汇总]![厂商料号] And [初始库存]![物料编号]<>[入库总量]![物料编号] And [初始库存]![物料编号]<>[采购在外量汇总]![物料编号],[初始库存]![期初库存]-[出库总量]![出库总量]-[业务未交量汇总]![未交总量],IIf([初始库存]![物料编号]=[出库总量]![厂商料号] And [初始库存]![物料编号]=[业务未交量汇总]![厂商料号] And [初始库存]![物料编号]<>[入库总量]![物料编号] And [初始库存]![物料编号]=[采购在外量汇总]![物料编号],[初始库存]![期初库存]+[采购在外量汇总]![在外总量]-[出库总量]![出库总量]-[业务未交量汇总]![未交总量],[初始库存]![期初库存])))))
复制代码 这原来就是你写的么?
|
|