U8财务软件常用审计SQL查询语句(2)

U8财务软件常用审计SQL查询语句

r by max(inatunitprice)/min(inatunitprice) desc

5、计算出各月通过赊销方式实现的销售收入。

select a.iperiod, sum(a.mc) 赊销收入 from gl_accvouch a inner join gl_accvouch b
on a.iperiod = b.iperiod and a.csign = b.csign and a.ino_id = b.ino_id
where ode like '501%' and a.mc<>0 and ode like '113%' and b.md<>0
group by a.iperiod

6、从gl_accvouch表中检索计算出各月的销售收入、销售成本、税金（504产品销售税金及附加）,
并计算各月的销售毛利率销售毛利率。毛利率＝（销售收入－销售成本－税金）/销售收入

create view v6
as
select iperiod, sum(mc) mc from gl_accvouch where ccode like '501%' and mc<>0 group by iperiod

create view v7
as
select iperiod ,sum(md) md from gl_accvouch where ccode like '502%' and md<>0 group by iperiod


create view v8
as
select iperiod ,sum(md) md from gl_accvouch where ccode like '504%' and md<>0 group by iperiod

--当月只有收入没有转结成本和税金的不考虑，只考虑收入，成本，税金都有的月份，否则没有意义。

select a.iperiod 月份, a.mc 销售收入 , b.md 销售成本 , c.md 税金
, (a.mc - b.md - c.md)/a.mc 毛利率 from
v6 a inner join v7 b
on a.iperiod = b.iperiod
inner join v8 c
on c.iperiod = b.iperiod