使用透视表做的进销存

xpczff

提一个问题，比方说 2010-5-5 某个型号品种经过调进调出销售后库存变成了50，那么查询2010-5-5之后的记录，你的期初值会跟着变化么？ 还是说要手动输入？

如果2010-5-6 又发生了调进调出销售后库存变成了30呢？

每个品种型号最早的期初值应该只有一个吧，后续的就是加减计算了（可我发现B-4的期初值有两个日期，手动输入的？）

lanlan7107

谢谢分享{:soso_e179:}

xgphsq

select * from (select 一级分类,二级分类,日期,型号,名称,数量 as 期初数量,吊牌金额 as 期初金额 ,0 as 调入数量,0 as 调入金额 ,0 as 调出数量,0 as 调出金额,0 as 销售数量,0 as 销售金额 from [期初$] union all select 一级分类,二级分类,日期,型号,名称,0 as 期初数量,0 as 期初金额 ,数量 as 调入数量,吊牌金额 as 调入金额 ,0 as 调出数量,0 as 调出金额,0 as 销售数量,0 as 销售金额 from [调入$] union all select 一级分类,二级分类,日期,型号,名称,0 as 期初数量,0 as 期初金额 ,0 as 调入数量,0 as 调入金额 ,数量 as 调出数量,吊牌金额 as 调出金额,0 as 销售数量,0 as 销售金额 from [调出$] union all select 一级分类,二级分类,日期,型号,名称,0 as 期初数量,0 as 期初金额 ,0 as 调入数量, 0 as 调入金额 ,0 as 调出数量,0 as 调出金额,数量 as 销售数量,实收金额 as 销售金额 from [销售$]) where 日期 <=(select * from [进销存汇总表$A1:A2])想问下楼主，跨月后期初数量如何结转？如果是全年数据都在一起，如果要查询一段期间的进销存，期初数值又有什么办法得到？

jenson999

xpczff 发表于 2011-9-16 14:38
提一个问题，比方说 2010-5-5 某个型号品种经过调进调出销售后库存变成了50，那么查询2010-5-5之后的记录， ...

期初值无法自动更新，透视表还做不到此功能呢

jenson999

xgphsq 发表于 2011-9-17 19:46
select * from (select 一级分类,二级分类,日期,型号,名称,数量 as 期初数量,吊牌金额 as 期初金额 ,0 as 调 ...

同样的回复，期初值无法自动变更

gendana

谢谢，先学习一下

WBQWQ

多谢楼主分享，正在学习这一块中

lucy_0579

很不错的表格，学习一下

HJKLASDFG

谢谢楼主分享!学习了!

aa88aa

请问怎样才能把期末库存等于0的明细，找出来？ 谢谢！