终极进销存汇总表

浩宇凌云 · 发表于 2012-9-5 15:48

谢谢。拜读下

wbell26 · 发表于 2012-9-5 15:57

支持一下..
下载来看看.

Betty201005 · 发表于 2012-10-29 16:39

很复杂,是怎么做的?如果有退货呢,怎么计算?

win2009 · 发表于 2012-11-1 00:04

XLODBC
1
DSN=Excel Files;DBQ=C:\Documents and Settings\Administrator\桌面\收发存汇总-示例\收发存汇总-示例.xls
select 规格型号,机器号,数量,0 as 数量3, 0 as 数量2, 金额,0 as 金额3, 0 as 金额2 from [期初$] union all select 规格型号,机器号, 0 as 数量2, 数量,0 as 数量3, 0 as 金额2, 金额,0 as 金额3 from [入库$] union all select 规格型号,机器号, 0 as 数量3, 0 as 数量2,数量, 0 as 金额3, 0 as 金额2,金额 from [出库$]

heaven827 · 发表于 2012-11-1 16:12

多谢分享，很有用{:soso_e179:}

ilcx · 发表于 2012-11-3 13:01

非常感谢！

lmswy · 发表于 2012-11-17 20:43

monvzhilei 发表于 2009-3-14 20:17
不知道有无可能把结存数量字段也写入sql语句。这样就不用添加字段了。

select * ,数量+数量3-数量2 as 结存数量,金额+金额3-金额2 as 结存金额 from (select "期初",规格型号,机器号,数量,0 as 数量3, 0 as 数量2, 金额,0 as 金额3, 0 as 金额2 from [期初$] union all select "入库",规格型号,机器号, 0 as 数量2, 数量,0 as 数量3, 0 as 金额2, 金额,0 as 金额3 from [入库$] union all select "出库",规格型号,机器号, 0 as 数量3, 0 as 数量2,数量, 0 as 金额3, 0 as 金额2,金额 from [出库$])

楼主试试上面这个，这样对汇总的数据可能就是准确的。

plain · 发表于 2012-11-19 10:23

谢谢LZ分享

陈思妤 · 发表于 2012-11-19 10:57

谢谢分享,学习中

古为今用 · 发表于 2012-11-23 10:58

谢谢分享，学习....

		自动登录	找回密码
密码			免费注册

[分享] 终极 进销存汇总表

[分享] 终极进销存汇总表