会员登陆会员名 密码免费注册
网站首页    用友资料    用友问题    用友工具    用友培训    用友产品    财务知识    业务知识    工具软件    成功案例    行业动态   

使用记账宝转T3工具无数量核算解决方法

时间:2020-02-28  来源:本站  责任编辑:管理员  阅读:1

记账宝升级T3无数量核算更新语句

--select * from gl_accvouch where ccode like '1211%'

--select * from jzb_002_2015..g_pvouchs  where ccode  like '1211%'

--select * from gl_accsum where ccode like '1211%'

--select * from jzb_002_2015..g_accsum where ccode like '1211%'

--select * from jzb_002_2015..g_pvouchs  where ccode  like '1211%'

--select * from  jzb_002_2015..g_pvouch  
--说明:jzb_002_2015为记账宝ACCess 导入SQL中的数据库,此语句是更新T3账套对应记账宝数据库凭证表的数量
use ufdata_002_2015
go
--更改科目数量核算及单位,帐页格式
update a
set a.cbook_type=b.cbook_type,a.cmeasure=b.cmeasure
from code a,jzb_002_2015..g_code b
where a.ccode=b.ccode

--创建一张临时表把记账宝凭证主子表合并成一张
select * into pzmx from jzb_002_2015..g_pvouchs 
go
ALTER TABLE pzmx
ADD pzh varchar(20)
go
ALTER TABLE pzmx
ADD pzrq datetime 
go

select * from pzmx  where ccode like '1211%'
select * from gl_accvouch where ino_id='65' and dbill_date='2016-12-31'

go
update a
set a.pzh=b.ino_id,a.pzrq=b.dbill_date
from pzmx a,jzb_002_2015..g_pvouch b
where a.isid=b.isid
go
--更改凭证明细账借方数量
go

update a
set a.nd_s=b.namount
from gl_accvouch a,pzmx b
where a.ccode=b.ccode and a.ino_id=b.pzh and a.dbill_date=b.pzrq and a.inid=b.snid and a.cdigest=b.cdigest
and b.cd_c=1 and b.namount is not null

go

--更改凭证明细账贷方数量
update a
set a.nc_s=b.namount
from gl_accvouch a,pzmx b
where a.ccode=b.ccode and a.ino_id=b.pzh and a.dbill_date=b.pzrq and a.inid=b.snid and a.cdigest=b.cdigest 
and b.cd_c=0 and b.namount is not null

go

改完后要重新恢复记账 再重新记账

————————————————
 

文章评论
用户名:    查看全部评论
内 容: